Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: Multistage imports best practices and examples.

by
Daniel Reis
- 09/24/2014 04:26:40
> Is there's any best practice example about this kind of import that
> takes several "wizards" passing data between them.  Data that would
> ultimately be deleted and only remain the effect the last wizard window.
Looks like the perfect job for an ETL tool:
Your data is read by an "input" step, from whatever source you need, and 
flows through a series of "transformation" steps, until it's in the 
proper form to "load" into the destination.

You might want to try Pentaho Kettle: it's quite user friendly and 
includes OpenERP input and output steps out of the box: see 
http://openerpmanagementsystem.blogspot.pt/2012/12/openerp-steps-for-pentaho-kettlepdi.html

For version 8.0 there is a currently a regression bug with the load() 
method, but you can find a fix here: https://github.com/odoo/odoo/pull/2258

Only disadvantage is that it isn't able to handle ExternalIDs, so I 
wrote a "polyfill" to overcome that. I should write a blog post 
explaining with a friendly explanation on it, but you can find the 
module here: https://github.com/dreispt/odoo-addons/tree/8.0/import_loader

Regards
Daniel Reis