Posted by Ashish Vijaywargiya-3 on URL: http://ofbiz.116.s1.nabble.com/Importing-data-from-Excel-CSV-tp143155p143159.html
Hugh,
I would like to suggest you to convert your Excel files into CSV format and
then play with Data file tool present in the Webtools --> Work With Data
File Tool.
These links will help you to understand the concept behind Data File tool
and to import external data into ofbiz entities.
>
> 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
>