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-tp15285288p15306502.html Sent from the OFBiz - User mailing list archive at Nabble.com.
