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.comStrategic 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<
[hidden email]> wrote:
>
>>
>>
>> ---------- Forwarded message ----------
>> From: BJ Freeman<
[hidden email]>
>> Date: Mon, Jun 21, 2010 at 8:32 PM
>> Subject: Re: Question - Bulk upload of catalog
>> To:
[hidden email]
>>
>>
>> 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.
>>>
>>>
>>
>
Locked
