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?
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 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.
- 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
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
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.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/21/13, 1:05 AM|
|Seen: 7392 times|
|Last updated: 3/16/15, 8:10 AM|