Odoo Help

1

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

By
hdr
on 4/16/14, 8:12 AM 2,743 views

Hi

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

Mouad

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

GOOD QUESTION !

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

ON BOTH SIDES (SAGE and OpenERP)

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

Terminatooor

Anybox migration

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

Thank you so much for your helpful response!!

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

Register

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)

Stats

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