if you look at ImportProductServices.java it will show you the columns
it expects from the excel.
look at line 133 to see how the prepareInventoryItem() is used
the prepare methods adds data that is default in each entity.
if you wish to add those columns to your excel so you can define them
then you would need to change the ImportProductServices.java to read
those columns and change the prepare methods to pass that data in and
assign it to each field.
=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
mike isaacs sent the following on 6/23/2010 2:59 AM:
Hi all,
Thanks for your insight.
Viewing the the code (ImportProductHelper.java) I see two maps ( in the
prepareProduct( ) and prepareInventoryItem( ) methods).
Looks like the excel then has to have all the fields in the two methods,
with some default values as shown, correct?
Kind Regards,
Mike
On 22 June 2010 10:34, Irene Kiragu<[email protected]> wrote:
---------- Forwarded message ----------
From: BJ Freeman<[email protected]>
Date: Mon, Jun 21, 2010 at 8:32 PM
Subject: Re: Question - Bulk upload of catalog
To: [email protected]
there is an spreadsheet import of products.
look at \applications\product\src\org\ofbiz\product\spreadsheetimport
your excel has to be in the column format of the code or you have to modify
it.
you have to place the file you want imported in a certain folder.
this is as of 9.04.
I also provide a service to code for manual or remote automatied importing
from suppliers
Irene Kiragu sent the following on 6/21/2010 7:15 AM:
=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation<
http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com<http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Linkedin<
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Hi all,
I'm new to ofbiz and was wondering if i can upload catalog data in bulk
rather than go through the individual item setup. The data is in excel.
Any
help is greatly appreciated.
Kind Regards,
Irene.
