Adding more to this: This is how you load an XML file from the command line:
./ant run-install-file -Ddata-file=[XML_FILE] Can be done from a running system. On Sat, Dec 13, 2014 at 1:46 PM, Mike Z <[email protected]> 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" <[email protected]> > *To:* "[email protected]" <[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 > >
