Re: POI excel data import - need example from old wiki

[Rupinder <ru...@voltix.com>]

Hi George,
I want to import product items through excel rather then adding products one
by one. Could you tell the procedure for this.


George Hayter wrote:
> 
> Thanks, I got it to work from the example you sent me. But I agree it will
> probably be better to call services directly to import data. The product
> list I want to import is a bit complicated for this approach. It has
> Categories and Subcategories in the same column as the product name.
> 
> I have decided to process the list in Access first and then export to .csv
> and use the data file tools to create the xml seed data. In future I would
> like to create an Excel import contribution that could handle complicated
> Excel product lists and call the entity engine directly to insert the
> data. 
> 
> I wonder if the old wiki will come back online again. Once again there is
> a data file tools example I would like to look at. But I could probably
> figure that out. I am still new to Ofbiz, and am impressed by all the
> features. Thanks to all those who contributed.
> 
> 
> BJ Freeman wrote:
>> 
>> The example used PIO to read an excel and make xml files.
>> the the xml files were read read in.
>> for some imports, like raw data, this is good.
>> but for some imports it is better to actually call services.
>> IMHO.
>> so it depends on the data you importing.
>> 
>> I am sending the example to you directly since the ML does not support
>> attachments.
>> Please ask question on this ML though.
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/POI-excel-data-import---need-example-from-old-wiki-tp15285288p18235578.html
Sent from the OFBiz - User mailing list archive at Nabble.com.