Ask Your Question

How to export and import contacts and products back?

asked 2013-02-10 15:24:57 +0200

ton123 gravatar image ton123 flag of Netherlands
1476 12 39 57

updated 2013-05-04 10:16:23 +0200

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:

  • Use a clean database with demo data.
  • Export all the contacts with all the fields to a csv.
  • Modify some data.
  • (Re-) import all the contacts with all the fields back.
  • It fails.
  • Even if you don't modify any data.

A second common example is with a clean database with demo data and export and (re) import products.

It fails also.

delete close flag offensive retag edit

6 Answers

Sort by » oldest newest most voted

answered 2013-02-11 06:40:07 +0200

Abner Galeno Jr. gravatar image Abner Galeno Jr. flag of Philippines
186 1 4 11

updated 2013-02-11 06:49:47 +0200

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


Settings->configuration->general settings

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..

link publish delete flag offensive edit


Hello, unfortunatly in the More tab, I see no export option... in the modules Base import is installed, no export module available...

Pascal de Clarens ( 2013-03-31 09:09:28 +0200 )edit

Hmmm... I just tried creating a new/fresh company and installed just one additional module, the Warehouse module. No other settings were changed too. The user "Administrator" doesn't even have access rights to "Technical Settings" but I was able to see the Export button under the "More" dropdown button. Is your openerp version7 too? Even the online openerp demo behaves the same way, there is always an Export button visible under "More" ...

Abner Galeno Jr. ( 2013-03-31 14:07:00 +0200 )edit

answered 2013-05-04 12:57:51 +0200

Martin H. Bramwell gravatar image Martin H. Bramwell flag of Canada
1536 6 20 28

updated 2013-05-04 12:59:58 +0200

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?

Where to document import structures as a community?

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.

link publish delete flag offensive edit



@Martin Bramwell I have read it before and I am very interested in this method. I think the idea is very good and you are working hard to make it a succes. Unfortunately I am working with 6.1.1 . This is because for me v7 is not ok at this moment because the lack of additional modules I need. I have no idea but is it possible to install this in v6.1.1 . If have tried to load the zip file with v6.1.1 Import Module. I received the message has been loaded. But I do not see your module in the module list. I see two modules from Swing Entwicklung without version numbers are these yours?

ton123 ( 2013-05-04 15:38:44 +0200 )edit

Oh! No! Sorry if it is not clear. Mine is not a module at all. Because I am interested in DevOps tools (cloud management stuff) I'm designing it to run completely independently from OpenERP. For development, I use two of my rented VPS machines somewhere out there in the cloud, one with OpenERP and the other running the pump. The whole point is to be able to feed data into any one of the OpenERP sites I manage, without needing to go through the user interface at all. I'm editing the overview diagram to show that, right now.

Martin H. Bramwell ( 2013-05-04 15:59:10 +0200 )edit

Done. overview diagram

Martin H. Bramwell ( 2013-05-04 16:06:00 +0200 )edit

@Martin OK I thought this because your github site says: "A tool for organizing, managing and pumping libraries of raw data from Google Spreadsheets into OpenERP V7's XMLRPC channel." I assume now it is also not specific for OpenERP V7. Is this correct and can I test it with v6.1.1?

ton123 ( 2013-05-04 16:20:19 +0200 )edit

@Martin I will start asking specific questions about your datapump in this forum. This will give more attention. I will try to find a way the will not be closed because of off topic ....

ton123 ( 2013-05-04 16:39:36 +0200 )edit

answered 2013-02-10 20:48:13 +0200

Yohanes Iwan Sugiarto gravatar image Yohanes Iwan Sugiarto flag of Indonesia
271 1 2 7

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).

link publish delete flag offensive edit


Migration service is to expensive for what I need / want. I do not have a complete working system. The only things I have done up to know is: 1. only partner contact data including categories. I use OpenERP as an adress book. 2 product basic data including prices and categories. I use OpenERP as a pricebook. I don't use the rest of the system because up to now the rest is not working ok for me at this moment.

ton123 ( 2013-03-27 09:18:54 +0200 )edit

answered 2014-01-12 18:15:24 +0200

Fabio gravatar image Fabio
11 4

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.

link publish delete flag offensive edit

answered 2013-03-26 15:51:49 +0200

Asif Iqbal Sheikh gravatar image Asif Iqbal Sheikh
1 1

updated 2013-03-26 15:52:44 +0200

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 with C#. Also confirm me if it is not possible.

Please reply ASAP.

link publish delete flag offensive edit



If an answer on the question is important for you it is best to upvote the original question. Questions with more votes get more attention!

ton123 ( 2013-03-27 15:05:17 +0200 )edit

answered 2013-03-27 23:53:53 +0200

Josse Colpaert gravatar image Josse Colpaert
490 3 9 18 You could use the create method to create new partners and use an XMLRPCstruct for the field values like street, city, ...

link publish delete flag offensive edit

Login/Signup to Answer


You can download ebooks on Facebook or buy paper book

You can read the online documentation

Question tools


subscribe to rss feed


Asked: 2013-02-10 15:24:57 +0200

Seen: 3,577 times

Last updated: Jan 12