Odoo Help


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

on 2/15/13, 6:14 PM 1,908 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

About This Community

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


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


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