Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: Migration tools from another ERP?

by
Michael Watchorn
- 10/20/2015 00:14:09
Thanks Nick,
I subscribed to Greg's site for a while and enjoyed many great videos he posted, including the one you mentioned. Indeed his examples for using vs bypassing the ORM were very enlightening!

My tables will be available in csv format so your idea of pushing them in with my own script would be doable.
Would any of your python scripts be available on Github (or elsewhere)? I'm sure they would provide a big jump start.

I'm also quite taken with the migration module created by Anybox ( https://bitbucket.org/anybox/anybox.migration.openerp ). They use csv files as an intermediate step in their transition.
 I'm thinking a bit of R&D into the Anybox code might help others who are moving to Odoo with many csv files. My hope is that they'd would only have to define their yaml files and the "From" tables would just be the various csv files.

Thanks,
Michael Watchorn



--- Original Message ---

From: "Nicholas Burdick" <nick@aptoworks.com>
Sent: October 19, 2015 11:06 PM
To: "Odoo S.A. Community: Framework" <expert-framework@mail.odoo.com>, "Michael Watchorn" <m_watchorn@hotmail.com>
Subject: Re: Migration tools from another ERP?

Michael,

While doing our migration, we ran a combination of using the CSV imports (for things like Chart of Accounts, Units of Measure, Product Categories, etc.) and also a heavy use of XML-RPC python scripts.  I will say, when I first starting migrating to Odoo, I had grand schemes of bringing all the history with Orders, Order lines, Invoices, etc… but that proved to be really unruly to link everything up.  In the end, we made a solid break from our old system and just brought in what we needed to create new orders (things like Customers, Suppliers and Products).  

Greg Moss over at First Class Computer Consulting has a video on writing an XML-RPC Python script that I recommend you check out.  It’s from a few years ago, but still pertinent. 

I haven’t used an ETL personally, but I know there are a lot of folks out there who integrate them with Odoo.

Best of luck,
Nick



On October 19, 2015 at 4:27:37 PM, Michael Watchorn (m_watchorn@hotmail.com) wrote:

Hello
We currently have a closed source ERP.  I'm wondering what tools my fellow community members use to migrate from existing ERP systems? (Talend? Odoo's web Import? Custom modules?)
During our transition phase I hope to replicate from the closed-source ERP to Odoo each night to help with training. The manual web import screens make that almost impossible (too slow, and manual) so I'm hoping for other "tried and true" options.
Does anyone have a list of the order of dependencies for all main apps?
Thanks Michael Watchorn

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-framework-62
Post to: mailto:expert-framework@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe