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" <f...@14x.net> *To:* "user@ofbiz.apache.org" <user@ofbiz.apache.org> *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
