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. http://docs.ofbiz.org/display/~jacopoc/OFBiz%27s+Data+File+Tools http://ofbizwiki.go-integral.com/Wiki.jsp?page=ImportingData http://ofbizwiki.go-integral.com/Wiki.jsp?page=DataFile http://mail-archives.apache.org/mod_mbox/incubator-ofbiz-user/200610.mbox/[EMAIL PROTECTED] (Please see the discussion on this thread.Jacopo has explained it in a very good way) Let us know your findings. On 12/24/06, Hugh O'Donnell <[EMAIL PROTECTED]> 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
-- Regards Ashish Vijaywargiya Aditisoft Technology Laboratory
