I am looking for an easy method to export contacts and products and re-import them in the same OpenERP. With the standard import export function I receive all kinds of errors.
I need this to easy change and add contacts and change and add products in excell. I also need this to start all over again with 7.0 with the already buildup contacts and products in 6.1. How to import in 7.0 from an export from 6.1.
Added: 4 May 2013
I have seen all the answers and comments here. For me they all stay on the surface and give no solutions.
I know how to find the export and import function.
It doesn't work as expected.
I need this type of function and I am not a programmer to escape to other functions and methods.
As a common example with contacts:
A second common example is with a clean database with demo data and export and (re) import products.
It fails also.
answered 2013-02-11 06:40:07 +0100Abner Galeno Jr.
I only have experience with v7, but here is my input:
First, to enable import/export, you must check the option
[✓] Allow users to import data from csv files
I think the best way to do this would be to
(1) Create a sample product in v7, (2) Go to the products LIST VIEW, check(or create first) a sample product(s) and click **[More]** button, then click **Export** to download your csv file, (3) Open the .csv file in excel, and edit or add products, (4) Go to products LIST VIEW again, Import the csv file back to OpenERP7
The import/export interface is not that intuitive but you can always ask additional questions..
answered 2013-05-04 12:57:51 +0100Martin H. Bramwell
I understand your frustration. Importing data to OpenERP is remarkably easy . . . but it is nowhere near easy enough. I am a programmer and for my own security with my clients I realized I had to make it easier. With my still shallow knowledge of OpenERP, I might make some incorrect and irreversible change, and face having to manually export and re-import everything, under time pressure.
Have you seen this discussion?
The pump should allow you to do most of what you need without programming. If you run into difficulty with anything at all, feel free to ask about it here or by email. It is still early beta stage, so throw all the problems you want at me.
I do hope you find it to be more than just a superficial solution.
I believe this would be part of the migration service which OpenERP sell/provide.
But if I were asked to export and import product and contact data from 6.1 to 7.0, I would write a small Python script which copies data between them (with many2one fields or relationship problems to solve of course).
answered 2014-01-12 18:15:24 +0100Fabio
I use OpenERP 6.1.1 and it has been driving me crazy for import/export in the last 2 years. Each time I tried I had to give up and do it manually. I just could not believe that exporting a list (i.e. products) with all "import compatible" fields and importing it back would simply not work. In addition to that most answer would just state "blah blah... it's very simple!" which is far from being a useful comment ;-)
Today I discovered that, at least in my case, the problem was that the administrator user I was using had the default language NOT set to english. I changed it to English, and now I can do, at least, the basic import /export I described before. I hope this helps someone.
I am looking for the same thing with auto import/export from my ecommerce website to OpenERP, using open ERP API. If it is possible, please answer this question with some link or sample using Asp.net with C#. Also confirm me if it is not possible.
Please reply ASAP.
You can read the online documentation
Asked: 2013-02-10 15:24:57 +0100
Seen: 3,169 times
Last updated: Jan 12