yes copy a database source and name it something. that is what you will use to export the entities. in web tools. then assign a delegator to it which will read the entities you created, and you map then over to ofbiz entities and create new records. you can do this in java or mini language.
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 >> >> >> -- 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.
