You can refer to applications/ecommerce/data/DemoProduct.xml. It has Demo Data for Facility, Catalog, ProductCategories, Variety of Products (Physical, Digital, Virtual and Varient, Subscription, Fin Account etc.) and the association between them. I think this will help you to understand the database structure as well.
On Tue, Mar 18, 2008 at 9:10 AM, Grahame Jordan <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for your replies, they are of great help. > > So far I have written some functions in perl to take the data from the > original database and write it all in xml. > This looks good so far however I am not familiar with the requirements > of the database structure etc. > > Am I taking the right approach by creating Product_Categories -> > Products -> Price. > > > Cheers > > > Grahame > > > [EMAIL PROTECTED] wrote: > > 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 > > > > > > -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __________________________________ Office : 509.855.4113 Mobile : +919425926892
