Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


OERP v6.0, how can I start importing my current ERP data?

on 2/15/13, 6:14 PM 1,335 views

Hi, we had start our current learning curve with OERP, we setup OERP 6.0.4, but we need to know how to align our data, we want to import our customer to OERP tables, exist a modulo or a guide to make this easy, cvs will be good.

Any tip about will be appreciated.


Ahmet Altinisik

--Ahmet Altinisik--
| 8 7 10
ANKARA, Turkey
--Ahmet Altinisik--


Ahmet Altinisik
On 2/16/13, 5:36 AM

From my experience,

If you are making initial import and your data is big,

  • Kettle (Pentaho/ETL) runs very slow (4-5 items/sec), if you try to do a an import of 10k items it would take hours. It is better for daily import jobs.

  • There is a module named ea_import it is user friendly and much faster than ETL bu have some bugs with importing one2many fields. I overcome this problem by adding some fields and did some import.

    • CSV import enhanced very much during 6.1. For initial data import I recommend you to use csv import. It is the fastest method I tried. They made even many enhancements to the csv import functions in V7.0. However I did not used V6.

I search for that module, but doesn't appear for v6.0.

on 2/16/13, 1:55 PM
On 2/15/13, 7:45 PM

I think u meant: Pentaho Data Integration?

On 2/15/13, 7:27 PM

IMHO, the best way to import data into OpenERP is with Python scripts and web-services. If you have some programming background you will be able to do that. Otherwise, there are ETL tools like Pentaho that have connectors for loading data into OpenERP. You can also upload data with the import methods available in OpenERP

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

1 follower(s)


Asked: 2/15/13, 6:14 PM
Seen: 1335 times
Last updated: 3/16/15, 8:10 AM