BJ - I have a question about the link you provided: http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data
Specifically the section about connecting to a legacy database. Do you need to define another delegator in entityengine.xml? Vince Clark [email protected] (303) 493-6723 ----- Original Message ----- From: "BJ Freeman" <[email protected]> To: [email protected] Sent: Monday, June 8, 2009 12:31:58 PM GMT -07:00 US/Canada Mountain Subject: Re: Importing data: best tools with CSV, XML simpler is subjective.:D if the xml is in entity format then you can use the webtool import screen. Either the file or copy and paste into the textarea. for CSV i suggest having it tab delimited instead of comma. it only matters when there is a lot of " in the file and it has not been escaped, like in the description. the Datafile is the best way to convert a CSV into entities. I have one import file that took 12 table definitions to created the entity files to import through the webtools. Not all the data can be imported this way. things like images, categories need to be done by code, using the table defs you created for the datafile import. the other option is to hook up your legacy db to ofbiz create the entities thru the webtools then write some code to import into ofbiz. http://docs.ofbiz.org/display/OFBIZ/Handling+of+External+data Dan Dodd sent the following on 6/8/2009 9:19 AM: > I need to do a import from another system. I want to demo using existing > data. > > I can get the data in XML and csv formats. > What are the tools to use? > Which is simpler? > I'll have Products (5500) and Customers (2500) > > Thanks for some hints. > > Dan Dodd > > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
