Re: Importing data from Excel, CSV

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

I'm not sure where there is a tutorial, and i haven't
been keeping up with the various efforts around
importing, but if it's a one time thing that doesn't
generally automated, I would suggest simply using
excel's various functions to create the
entity-engine-xml element for your data.

concatenate(), right(), left(), trim() etc

or if you have MS Access and have an odbc for your
database to import it using linked tables in Access.


--- Hugh O'Donnell <[hidden email]> 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
>