BJ, thanks for the reply. I did a tab delimited import with a few fields and it worked. I can expand that to include all the fields.
My XML file is output from the existing system and not in entity format. What is the tool of choice to convert it to an entity format, if any? Dan Dodd -----Original Message----- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: Monday, June 08, 2009 1:32 PM To: user@ofbiz.apache.org 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&tr k=tab_pro Systems Integrator.