Normally with an ETL you would use it to read an xml/CSV file (I.e from a supplier ) and directly update the DB, rather than create an intermediary xml file. Interesting option though.
Sent from my BlackBerry® PlayBook™ www.blackberry.com ------------------------------ *From:* "Ron Wheeler" <[email protected]> *To:* "[email protected]" <[email protected]> *Sent:* December 13, 2014 2:45 PM *Subject:* Re: Data File Tools and Hierarchical Flat Files I have an ETL program and would be happy to work in configuring it to produce XML files suitable for OFBiz. It currently has a plug-in that produces HTML output of tables to HTML with attributes that make it easy to style with css. I need to remove the HTML prologue,HTML epilogue and the attributes to have just the table in XML to make a new plug-in to output a simpler XML structure suitable for OFBiz. It currently reads CSV and Excel so it would be a good front-end for OFBiz integrations where data is extracted from other systems and needs to be fed to the OFBiz It also has a lot of transformation and validation plug-ins if you need to do things to alter the data (rename columns, set defaults, add new columns, reformat dates, map data using mapping files, etc) and validate the output (table lookups, field length, uniqueness, etc.) It produces an audit report of the actions done and an error log that writes error messages in a format that makes sense to non-technical people ( "while validating products found duplicate ids in row 7 and 167" ) who have to fix the original system and don't want to decipher SQL errors "Constraint violation while creating record". It was developed to support the transfer of HRIS (payroll data) to LMS (Learning Management Systems). Ron Ron On 13/12/2014 4:46 PM, Mike Z wrote: > Take the csv, convert it to xml, and just manually load it from the command > line. > > Of course, order is significant. You have to load in catalog and > categories prior to loading products. Each of these can be a separate xml > (recommended) or you can create one gigantic xml that does it all. > > If you want top speed then this is how to do it. How to convert from csv > to xml? Hopefully you are handy with Perl, shell, or another language to > convert. Take a typical product, create a template with variables, and > use it to mass create the xml file. The beauty of this method is once you > are done creating the xml files, you can reload them over and over. > > Another option is to use an ETL like talons which can automate the whole > process, but you must be familiar with the entities. This would take > expertise in using both the ETL and ofbiz entities and order. > > Sent from my BlackBerry® PlayBook™ > www.blackberry.com > > ------------------------------ > *From:* "Forrest Rae" > *To:* "[email protected]" > *Sent:* December 12, 2014 1:20 PM > *Subject:* Re: Data File Tools and Hierarchical Flat Files > > Heya Jacques, > > I did read the pages, actually studied them extensively and read the > source code to the tool. I wouldn't bother the list otherwise. :) > > Adrian, that's a good suggestion, thanks! > > -Forrest > > On 12/12/2014 12:27 PM, Jacques Le Roux wrote: >> I did not read these pages again (a long time now), but they might help, >> and you may give us your opinion: >> >> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data >> https://cwiki.apache.org/confluence/display/OFBIZ/Import+Data+Using+Apache+POI+api >> >> >> Jacques >> >> Le 12/12/2014 18:02, Adrian Crum a écrit : >>> The easiest way to use the tool is to import the CSV file into a >>> specialized table to contain the data. After the import, invoke a >>> service that processes the data in the table. >>> >>> Adrian Crum >>> Sandglass Software >>> www.sandglass-software.com -- Ron Wheeler President Artifact Software Inc email: [email protected] skype: ronaldmwheeler phone: 866-970-2435, ext 102
