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
