Hello Vince,Data file tool is very effective for fulfilling your requirement if you have a record which provides primary key as well. On the other hand I couldn't find it suitable if you don't have primary key in your record, in this case custom code is needed to handle the situation.
Thanks !
Regards, -- Vivek Mishra Vince Clark wrote:
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
smime.p7s
Description: S/MIME Cryptographic Signature
