Posted by
Iain Fogg on
URL: http://ofbiz.116.s1.nabble.com/Importing-data-from-Excel-CSV-tp143155p143156.html
Hugh,
I had a similar problem, although my data was in XML format. I ended up
writing a custom perl script to insert my data directly into the SQL
tables of my Postgres DB. Maybe a better method would have been to split
my original data into XML records digestable by OFBiz. However, I often
need to download and install new records in real-time (with a customer
in front of me) and having to run a script to format the data for
OFBiz, and then go to WebTools to import the data is too time-consuming.
In any case, I found the hardest part was simply working out which piece
of data needed to go to which part of the OFBiz data model. The flip
side is that you get to know the OFBiz data model pretty well :-)
Cheers, Iain
Hugh O'Donnell wrote:
> Hi all,
>
> I'm quite new to ofbiz, but an experienced Java Developer. I have a
> catalog I want to import into the database, but the Excel/CSV file
> I've been given contains columns that need to be inserted into
> different tables. I have looked through the Wiki and other pages on
> Data Import, but I can't seem to find any straightforward exmaples. I
> would do it manually, but there are over 2500 records to enter. Does
> anyone know of a good tutorial on this?
>
> Thanks,
>
> Hugh
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.15.27/602 - Release Date: 25/12/2006