POI excel data import - need example from old wiki

[George Hayter]

Hi,

I really need a quick guide to importing Excel data into OFBiz with POI. I know there is an example on the old wiki, but the old wiki has been down for the last few days and I really need to get data imported. If someone has a copy of the example please post it here.

[hans_bakker]

If i remember well, you have to create new columns between the
datacolumns where you enter the xml data content.

so if you have:

234567 this_is_a text

then you have to make it:
(entering the xml fieldnames in the between columns)

<entity-engine-xml>
<Product productId="234567" description="this_is_a text"/>
</entity-engine-xml>



On Tue, 2008-02-05 at 00:12 -0800, GeorgeHayter wrote:
> Hi,
>
> I really need a quick guide to importing Excel data into OFBiz with POI. I
> know there is an example on the old wiki, but the old wiki has been down for
> the last few days and I really need to get data imported. If someone has a
> copy of the example please post it here.
--
AntWebsystems.com: Quality OFBiz services for competitive rates.....

[BJ Freeman]

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.


GeorgeHayter sent the following on 2/5/2008 12:12 AM:
> Hi,
>
> I really need a quick guide to importing Excel data into OFBiz with POI. I
> know there is an example on the old wiki, but the old wiki has been down for
> the last few days and I really need to get data imported. If someone has a
> copy of the example please post it here.

[George Hayter]

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.

[BJ Freeman]

by using services then the appropriate SECAS are fired.
this also will keep you programming more up todate as changes are made.
I used the services from the UI to accomplish input.
I use a worker class to prepare the data for calling the services.


George Hayter sent the following on 2/6/2008 4:00 AM:

> 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.
>>
>

[Rupinder]

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.