Odoo Help


is it normal that csv import almost never is working?

on 4/21/13, 1:05 AM 9,720 views

I am playing around with csv import since a while and have not even once managed to import anything successfully. Current example is trying to import products. I have taken an existing product and exported it to a csv with the following fields:


I take this csv and change the values. importing that back in gives me

Missing required value for the field 'name'. This might be 'Name' in the current model, or a field of the same name in an o2m. at row 2

Even if I import the exact csv that I have exported earlier results in a similar error message. just that the error is spotted in line 4. Even if I deselect the field 'name' (which wouldn't be a workaround of course) I get the same error

At present I feel I am missing some sort of 'touch' to do this successfully. On the other hand I guess a certain 'touch' shouldn't be necessary. Is this just not working yet?

found out for my specific example: if I import back the csv there are two 'name' fields you can map the name to. One of them would work, the other one wouldn't. Whether I used comma or semicolon as separator didn't seem to make any difference.

on 4/21/13, 9:29 PM

I also noticed that the name "item" appears twice within the list of selection; only the second one does work. I mentionned this to the support (with a screen capture) and received an answer that "NO there is only one "name"". Comma or semicolon does work; You must also select the UTF-8 encoding. When you save your csv file, always verify that the encoding is UTF-8.

AD LIBITOM, michel Guénard
on 4/22/13, 5:10 AM



| 5 6 9
Lisse, Netherlands
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
On 4/21/13, 6:41 AM

Yes it is normal that csv import almost never is working.

I am struggling this for almost a year now.

The causes are in different area's:

Business Model:

  • Business model is based on paid migrations
  • Business model is based on paid consultancy

Note: There is nothing wrong with this. Software is free but the development and maintenance need a financial basis and there has been made a choice for this model.

Complexity of the database:

  • The database has very very much tables
  • The tables are complex related not only 1-1 but also 1-many, may-1 and many to many

Note: This is a fact that cannot be changed. Software like this need this by definition.


  • The database is not enough documented
  • The import / export function is not enough documented

Note: This is because of the business model and also because of the rapid development. I hope this new forum will be of help to improve the documentation.

Technicalities and tips:

  • There are some bugs, registered or not registered.
  • Before you import always set the language on English, when you use other languages, you are in trouble.
  • Before you import always use data from the database and make a small export both in quantities and field to start with.
  • Always start with flat data. E.g. no products import / export with already defined product categories.
  • When you have exported the data be carefull to save according the original format.
  • If the export fails try to change the seperator to ;
  • If the import failed it can be needed to add or change header fields.

OK, I am aware this is not all. I am still struggling myself with import / export.

But I hope this is a littlebit helpful.

By the way a lot of people are struggling with import / export. And there are also a lot of movements to use other methods.

Other methods:

  • ea_import
  • SQL export / import
  • Direct database import / export via pgAdmin
  • Bramwell's method via Google documents
  • XML scripting
  • ETL Tools
  • Other modules
  • Workarounds (partly) like mass_editing

The biggest problem I encountered, except for lack of documentation, are for the multilanguage items. You cannot import this with CSV, you have to do this directly into the database. (You can see all translation fine via Settings > Translations > Application Terms > Translated Terms and export there, but you cannot import)

on 4/21/13, 11:15 AM

Yeah, but the products export / imports are works. That's a basic option. The other thinks. you need to see the model, and you have to do the sql injection, or you buy the support. I think this is one of the method, how to pay the service if something is free :-)

on 4/21/13, 1:19 PM

Try to import multilanguage product descriptions, it is also a basic requirement and it is not possible with csv. The translation for OpenERP itself is no problem to import, I do not understand the difference between this and product translations. It's the same translation table.

on 4/21/13, 2:30 PM

@ton: you mean basically in order to create a demand for (paid) help it was made complicated to use on purpose? Not sure whether this made sense for a long term strategy (if it is true what you imply). I'd say the better the product OpenERP is the more successful it might get. But that is just an opinion of course.

on 4/22/13, 12:21 AM

@ton: alright. thanks for clarifying

on 4/22/13, 4:45 AM

@gunnar If my answer is the answer on your question I appreciate if you marked it as answered. If you find my answer is useful and interesting for others you can best vote it up.

on 4/22/13, 7:12 AM
On 4/21/13, 2:44 AM

Please try this.

Change the separator the bottom of import page form "," to ";" and set the product_tmpl_id column to product_tmpl_id if necessary. And just Execute. Must be read, under 6.1, if not you have a problem vith csv structure, check by some table editor like excell, or Libre...

active;purchase_ok;sale_ok;product_tmpl_id/id ;product_tmpl_id/name;company_id/id;standard_price;cost_method;sale_delay;uom_id/id;property_stock_inventory/id;valuation;produce_delay;mes_type;name;property_stock_procurement/id;procure_method;type;property_stock_production/id;uom_po_id/id;default_code;list_price;supply_method;track_incoming;track_production;track_outgoing;uos_coeff;price_margin
True;True;True;;;base.main_company;40.0;Standard Price;7.0;product.product_uom_unit;stock.location_inventory;Periodical (manual);1.0;fixed;Your product name;stock.location_procurement;Make to Stock;Stockable Product;stock.location_production;product.product_uom_unit;Your_product_def_code;50.0;Buy;False;False;False;1.0;1.0

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 4/23/13, 8:00 PM

@ton123, @gunnar

I am presenting an OpenERP webinar next week - May 1st at 10am PDT / 5pm UTC.

Among other things is a section where I will cover the foolproof 'steps for a successful import'.

I invite anyone who is having problems to attend. If you can't make it, the slides will be posted after the webinar (I'll update this post with the link when they are available).

Importing is easy, when you know how. I hope to teach anyone who is struggling.

@Ray Carnes This is a very good initiative. Thank you. Unfortunately I don't know If a can join, because I will be on a business trip that day, I hope it fits in my schedule. Slides are nice to have. I hope somebody can record the webinar and post it on Youtube. But I looked at the url and see: "US Accounting on OpenERP V7.0". How about that?

on 4/24/13, 8:00 AM

That is the webinar with a topic on Importing. I will turn that topic into a blog post so if you miss the webcast you can still learn about it. I will add the link here when it is done.

Ray Carnes
on 4/25/13, 2:06 PM

that's great, thanks. I think csv import can be a very powerful chop if you master that. Will try to drag me into it at 1 am (which will be my local time)

on 4/29/13, 12:27 AM

With our rehearsal today, it was agreed that this topic is too complex to be part of our webcast. I will still show importing, but the 'how to do it' part will be only on the blog. (At least you both get to sleep now!). I will post the link when it is done.

Ray Carnes
on 4/30/13, 5:51 PM

Any word on that blog post?

on 7/11/13, 1:26 PM

I am working on it. Many of the problems I and others have had with exporting are addressed by a bug fix at https://bugs.launchpad.net/openobject-server/+bug/1194893 - I suggest you apply that bug (the same fix works for 6.1 and 7.0). Then any export of a model that is related to another model will get the correct ID's even if the related model has not already been exported.

Ray Carnes
on 7/17/13, 5:22 PM
On 5/26/14, 4:17 PM

@gunnar I do not imply and I do not meant to imply it is made complicated on purpose. The database is complicated because it can't be simple for such a feature rich software package.


Fabien Pinckaers (fp)

--Fabien Pinckaers (fp)--
| 6 8 8
fsdsdfsdf, Belgium
--Fabien Pinckaers (fp)--

Odoo Founder & CEO

Fabien Pinckaers (fp)
On 5/23/14, 9:17 AM
On 4/21/13, 11:13 AM

Previously, when importing back you have two fields called "Name" (on the top row, where you can select to which field your data has to be imported to). You need to select the second one to import to, then it's fine.

With one of the last updates of v7, this problem was solved. You have to check you versions.

yes, I have figured out that double name filed issue (see comment above).

on 4/22/13, 12:13 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 4/21/13, 1:05 AM
Seen: 9720 times
Last updated: 3/16/15, 8:10 AM