The hard part is getting the external data into an xml format and then into the ofbiz schema. Two of the approaches that work well is to make use of Microsoft Access. I am not a big fan, but it is fairly easy to use. What I did was to write a custom java program that generated the xml files, used the Web Tools - Import to import the data into temporary tables, then run a service to move the data from the temporary tables into Ofbiz. I used the data import tools from Opentaps as a starting point and spent probably a month fine tuning them. I did it this way because I had three businesses to do. For a one off, I think the Access tools are a better choice.
Quickbooks has a developers toolset that can help you. Skip -----Original Message----- From: Brajesh Patel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 11:08 PM To: user@ofbiz.apache.org Subject: Re: Import Data hi Grahame, In web tools there's a section for Entity XML Tools for importing and exporting data from files. For importing data from files you can use "XML Data Import" option. Here you'll have to specify the absolute path of the data file and check the options as per your requirements (we've used create "Dummy" FKs). Thanks & Regards On Mon, Mar 17, 2008 at 8:12 AM, Grahame Jordan <[EMAIL PROTECTED]> wrote: > Hi, > > Being a noob I am just wondering how to import existing data into the > application. > > I have an existing product/pricelist, the sales guys are using Goldmine > and accounts are using Quickbooks. > > Initially I want to be using the pricelist ASAP. > I have the svn trunk checked out and running. > Many Thanks > > Grahame Jrodan > -- Brajesh Patel HotWax Media Indore(MP) 09926276854 hotwaxmedia.com No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
