Re: Importing data from Excel, CSV

Posted by Andrew Zeneski on
URL: http://ofbiz.116.s1.nabble.com/Importing-data-from-Excel-CSV-tp143155p143157.html

There are built in routines to import delimited text files into OFBiz  
much like the XML files. Each table gets its own file and the first  
line of the file should be the names of the entity fields (not the  
SQL table fields).

Check out the entityext component.

Andrew

On Dec 25, 2006, at 5:27 PM, Iain Fogg wrote:

> 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
>