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

If you want a solution to export and import contacts then use the  ToolsBaer Address Book Manager Tool with the help of this tool you can easily import and export Contacts (VCF) files. Through this tool, users can Import all VCF contacts into Outlook file format and others like PST, OST, MSG, EML, and CSV formats, with no changes made to any of their components. This application can All contact information is completely protected throughout the conversion of a VCF file to Outlook format. This software is capable of working with Outlook, Lotus Notes, VCF, and Windows versions operating systems.

Read More: https://www.toolsbaer.com/address-book-manager/

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.

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.

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

HI Ton, 

You can check below apps which will export fields of data for any application into excel format 

https://apps.odoo.com/apps/modules/10.0/dev_export_excel/

Hope it Helps !

Thanks ,

Devintelle : Odoo Support Service Provider '

Mail: Devintelle@gmail.com

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

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.