Welcome!

This community is for professionals and enthusiasts of our products and services.

Register
4

How to export and import contacts and products back?

By
ton123
on 2/10/13, 10:24 AM8657 views

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.


1
Fabio
On 1/12/14, 1:15 PM

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.



1
Abner Galeno Jr.
On 2/11/13, 1:40 AM

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

Under

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


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
on 3/31/13, 5:09 AM

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.
on 3/31/13, 10:07 AM

0
Yohanes Iwan Sugiarto
On 2/10/13, 3:48 PM

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


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
on 3/27/13, 5:18 AM

0
Martin
On 5/4/13, 8:57 AM

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.


@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
on 5/4/13, 11:38 AM

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
on 5/4/13, 11:59 AM
Martin
on 5/4/13, 12:06 PM

@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
on 5/4/13, 12:20 PM

@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
on 5/4/13, 12:39 PM

0
Fabio
On 1/12/14, 1:06 PM

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.



0
Josse Colpaert (jco)
On 3/27/13, 7:53 PM

http://forum.openerp.com/forum/topic34763.html You could use the create method to create new partners and use an XMLRPCstruct for the field values like street, city, ...



0
Asif Iqbal Sheikh
On 3/26/13, 11:51 AM

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.


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
on 3/27/13, 11:05 AM

Your Answer

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

This community is for professionals and enthusiasts of our products and services.

Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 2/10/13, 10:24 AM
Seen: 8657 times
Last updated: 3/16/15, 8:10 AM