Odoo Help


data migration from sage Line 100 comptabilite to openERP 6.1 using Talend?

on 4/16/14, 8:12 AM 2,870 views


My problem is that i have to migrate data from sage to openerp using Talend Open Studio.

For example i don't know how to transfer data from one table to another especially they don't have the same number of columns, one more thing is how to automatize and synchronize between th two tables?

Best Regards


Med Said BARA
On 4/16/14, 3:19 PM


For such operations, you have to deal with more than one table at a time.


1_ You have to identify the DATA you need to migrate

2_ You have to identify, in which tables, and which columns, those DATA are recorded.

most often, if not always, the data in one table had to be spread on more than one table.

3_ How to deal with Foreign Keys and constraints ?

This is a big job. The kind of job that each computer scientist must do at least one time in his life.

You can find many responses to your questions in the following links:

dreis open-erp-data-integration20130704


Anybox migration

Good luck, and keep us informed of the work progress.

Thank you so much for your helpful response!!

on 4/19/14, 6:19 PM

Excuse me, I completely forgot to mention this link: http://bazaar.launchpad.net/~openerp-sage50/openerp-sage-50/6.1/files . Export from OpenERP to Sage, this can help in how to reverse this operation from sage to OpenERP (see the docs folder). there is also a MP for V7.0 http://bazaar.launchpad.net/~savoirfairelinux-openerp/openerp-sage-50/7.0-exportsage50/files

Med Said BARA
on 4/19/14, 8:13 PM

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

0 follower(s)


Asked: 4/16/14, 8:12 AM
Seen: 2870 times
Last updated: 3/16/15, 8:10 AM