Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: Multistage imports best practices and examples.

by
manuel
- 09/24/2014 10:52:16
Though I was asking for multi-stage import wizards done *inside* 
OpenERP, this may help with my actual case: A one-time-only importing of 
QuickBooks exported account entries into our accounting system in OpenERP.

We have experience with Pentaho Spoon for doing ETL from our extended 
spreadsheets to a legacy system our clients still uses. Do you know if 
Spoon is equally a good fit?  Kettle is currenty a 600+ MB download that 
with my connection would be prohibitive (200kbps ~ 20KB/s).

Thanks and best regards,
Manuel.


Side note:

We can't do the usual "Opening ..." cause we need to have our entries.  
The main goal is to validate the reports before going into production 
with accounting.  I say this just avoid the answers that point that "you 
could just do an opening of accounts and the go...".  After validation 
we might just do the opening with the current state of accounts.


Le 24/09/14 04:39, Daniel Reis a écrit :
> > 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
>
> _______________________________________________
> 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
>