How do I batch Load Products

[Alex Melnik]

Is there a way to load existing products from a legacy system without
doing it manually (through webtools) or inserting it directly into the
database through an ETL.  In other words is there a UI where I can
upload a list or is there an API that I can use to write a simple JAVA
driver to read from a list and insert into the OFBIZ back-end?

Thanks for the help,
Alex

[Jacques Le Roux]

This could interest you
http://www.nabble.com/Need-help-in-import-or-export-in-csv-and-xls-format-in-ofbiz-application.-tt17316714.html#a17320547

Jacques

From: "Alex Melnik" <[hidden email]>
> Is there a way to load existing products from a legacy system without
> doing it manually (through webtools) or inserting it directly into the
> database through an ETL.  In other words is there a UI where I can
> upload a list or is there an API that I can use to write a simple JAVA
> driver to read from a list and insert into the OFBIZ back-end?
>
> Thanks for the help,
> Alex
>

[Alex Melnik]

Jacques, thanks for the quick reply.  It almost seems like something I
could use.  I pretty much need an API where I can just call insert on
the catalogue and pass a product to it, or some UI type of thing shere I
can map file fields to various product fiels on OFBIZ side and then just
insert the whole file.  Something a little bit easier than trying to
decipher the Schema behind OFBIZ product storage.  Is  there any info on
that Data File library that I can take a look at?

Thanks,
Alex

>>> [hidden email] 5/27/2008 3:16 PM >>>

This could interest you
http://www.nabble.com/Need-help-in-import-or-export-in-csv-and-xls-format-in-ofbiz-application.-tt17316714.html#a17320547


Jacques

From: "Alex Melnik" <[hidden email]>
> Is there a way to load existing products from a legacy system
without
> doing it manually (through webtools) or inserting it directly into
the
> database through an ETL.  In other words is there a UI where I can
> upload a list or is there an API that I can use to write a simple
JAVA
> driver to read from a list and insert into the OFBIZ back-end?
>
> Thanks for the help,
> Alex
>

[Jacques Le Roux]

Maybe you could have a look at the examples in
applications\order\script\org\ofbiz\order\thirdparty

Jacques

From: "Alex Melnik" <[hidden email]>

> Jacques, thanks for the quick reply.  It almost seems like something I
> could use.  I pretty much need an API where I can just call insert on
> the catalogue and pass a product to it, or some UI type of thing shere I
> can map file fields to various product fiels on OFBIZ side and then just
> insert the whole file.  Something a little bit easier than trying to
> decipher the Schema behind OFBIZ product storage.  Is  there any info on
> that Data File library that I can take a look at?
>
> Thanks,
> Alex
>
>>>> [hidden email] 5/27/2008 3:16 PM >>>
>
> This could interest you
> http://www.nabble.com/Need-help-in-import-or-export-in-csv-and-xls-format-in-ofbiz-application.-tt17316714.html#a17320547
>
>
> Jacques
>
> From: "Alex Melnik" <[hidden email]>
>> Is there a way to load existing products from a legacy system
> without
>> doing it manually (through webtools) or inserting it directly into
> the
>> database through an ETL.  In other words is there a UI where I can
>> upload a list or is there an API that I can use to write a simple
> JAVA
>> driver to read from a list and insert into the OFBIZ back-end?
>>
>> Thanks for the help,
>> Alex
>>
>

[Bruno Busco]

Hi Alex,
I have done something similar to what you want to do. I try to explain how I
did the job.

First of all I made OFBiz able to access the legacy database defining a
couple of entities and a view-entity (so called ArticoloAndGiacenza) to have
all information I needed collected from various legacy database tables in
one unique OFBiz view-entity.

Using OFBiz WebTools I exported the view-entity in an XML file. In order to
do this I needed to change a file in OFBiz (xmldsdump.bsh) because OOTB
OFBiz does not export view-entities as XML files (view-entities are normally
skipped).

In this way I got an XML file where each node contains all information about
product, category, price and quantity.

Then I wrote an XSL fransformation file to make a XML transformation from
the legacy database export XML file to an XML file that could be imported in
OFBiz.

Basically what is needed to do in the transformation is to create for every
source XML file node like this:
<ArticoloAndGiacenza code="..." description="..." group="..." price="..."
giac="..." store="..." param1="..." param2="..."   etc. />

A set of destination XML file nodes like these:
<Product      productId="..." productTypeId="..."
primaryProductCategoryId="..." productName="..." description="..."    etc.
/>
<ProductPrice productId="..." productPricePurposeId="PURCHASE"
productPriceTypeId="DEFAULT_PRICE" currencyUomId="EUR"
productStoreGroupId="_NA_" fromDate="..." price="..." createdDate="..."
createdByUserLogin="admin" lastModifiedDate="..."
lastModifiedByUserLogin="admin" />
<ProductCategoryMember productId="..." productCategoryId="..."
fromDate="..." />
<ProductFeatureAppl productId="..." productFeatureId="..."
productFeatureApplTypeId="STANDARD_FEAT" fromDate="..."
lastUpdatedStamp="..." lastUpdatedTxStamp="..." createdStamp="..."
createdTxStamp="..." />
<ProductFeatureAppl productId="..." productFeatureId="..."
productFeatureApplTypeId="STANDARD_FEAT" fromDate="..."
lastUpdatedStamp="..." lastUpdatedTxStamp="..." createdStamp="..."
createdTxStamp="..." />
<ProductFeatureAppl productId="..." productFeatureId="..."
productFeatureApplTypeId="STANDARD_FEAT" fromDate="..."
lastUpdatedStamp="..." lastUpdatedTxStamp="..." createdStamp="..."
createdTxStamp="..." />
<ProductFacility    productId="..." facilityId="..." minimumStock="..."
reorderQuantity="..." daysToShip="..." />
<InventoryItem      inventoryItemId="..." facilityId="..."
inventoryItemTypeId="NON_SERIAL_INV_ITEM" productId="..." ownerPartyId="..."
currencyUomId="EUR" unitCost="..." />
<InventoryItemDetail inventoryItemId="..." inventoryItemDetailSeqId="1"
effectiveDate="..." availableToPromiseDiff="..." quantityOnHandDiff="..." />

Of course what is reported here is only an example related to my entities
fields.
The generated XML can then be imported in OFBiz using the WebTools XML
import command.

Hope this helps,

-Bruno



2008/5/27 Jacques Le Roux <[hidden email]>:

> Maybe you could have a look at the examples in
> applications\order\script\org\ofbiz\order\thirdparty
> Jacques
>
> From: "Alex Melnik" <[hidden email]>
>
>> Jacques, thanks for the quick reply.  It almost seems like something I
>> could use.  I pretty much need an API where I can just call insert on
>> the catalogue and pass a product to it, or some UI type of thing shere I
>> can map file fields to various product fiels on OFBIZ side and then just
>> insert the whole file.  Something a little bit easier than trying to
>> decipher the Schema behind OFBIZ product storage.  Is  there any info on
>> that Data File library that I can take a look at?
>>
>> Thanks,
>> Alex
>>
>>  [hidden email] 5/27/2008 3:16 PM >>>
>>>>>
>>>>
>> This could interest you
>>
>> http://www.nabble.com/Need-help-in-import-or-export-in-csv-and-xls-format-in-ofbiz-application.-tt17316714.html#a17320547
>>
>>
>> Jacques
>>
>> From: "Alex Melnik" <[hidden email]>
>>
>>> Is there a way to load existing products from a legacy system
>>>
>> without
>>
>>> doing it manually (through webtools) or inserting it directly into
>>>
>> the
>>
>>> database through an ETL.  In other words is there a UI where I can
>>> upload a list or is there an API that I can use to write a simple
>>>
>> JAVA
>>
>>> driver to read from a list and insert into the OFBIZ back-end?
>>>
>>> Thanks for the help,
>>> Alex
>>>
>>>
>>

[BJ Freeman]

take a look at the /framework/datafile folder
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools

Alex Melnik sent the following on 5/27/2008 12:55 PM:

> Is there a way to load existing products from a legacy system without
> doing it manually (through webtools) or inserting it directly into the
> database through an ETL.  In other words is there a UI where I can
> upload a list or is there an API that I can use to write a simple JAVA
> driver to read from a list and insert into the OFBIZ back-end?
>
> Thanks for the help,
> Alex
>
>
>

[Alex Melnik]

I think this section covers the import of the data.  So let's say I can
import the list of products into OFBIZ.  How can I associate it to a
catalogue, browsing category, etc.   In other words how can I make my
data play like a real product?

>>> [hidden email] 5/28/2008 6:17 AM >>>

take a look at the /framework/datafile folder
http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools 

Alex Melnik sent the following on 5/27/2008 12:55 PM:
> Is there a way to load existing products from a legacy system
without
> doing it manually (through webtools) or inserting it directly into
the
> database through an ETL.  In other words is there a UI where I can
> upload a list or is there an API that I can use to write a simple
JAVA
> driver to read from a list and insert into the OFBIZ back-end?
>
> Thanks for the help,
> Alex
>
>
>

[Bruno Busco]

Alex,
may be you did not read my mail....or may be I was not so clear....
-Bruno

2008/5/28 Alex Melnik <[hidden email]>:

> I think this section covers the import of the data.  So let's say I can
> import the list of products into OFBIZ.  How can I associate it to a
> catalogue, browsing category, etc.   In other words how can I make my
> data play like a real product?
>
> >>> [hidden email] 5/28/2008 6:17 AM >>>
>
> take a look at the /framework/datafile folder
> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>
> Alex Melnik sent the following on 5/27/2008 12:55 PM:
> > Is there a way to load existing products from a legacy system
> without
> > doing it manually (through webtools) or inserting it directly into
> the
> > database through an ETL.  In other words is there a UI where I can
> > upload a list or is there an API that I can use to write a simple
> JAVA
> > driver to read from a list and insert into the OFBIZ back-end?
> >
> > Thanks for the help,
> > Alex
> >
> >
> >
>
>

[Jacques Le Roux]

Hi Bruno,

I read it, and it's interesting. I even wonder if I would not put in the tips. Before it disappears  in the depth of the ML...

Jacques

From: "Bruno Busco" <[hidden email]>

> Alex,
> may be you did not read my mail....or may be I was not so clear....
> -Bruno
>
> 2008/5/28 Alex Melnik <[hidden email]>:
>
>> I think this section covers the import of the data.  So let's say I can
>> import the list of products into OFBIZ.  How can I associate it to a
>> catalogue, browsing category, etc.   In other words how can I make my
>> data play like a real product?
>>
>> >>> [hidden email] 5/28/2008 6:17 AM >>>
>>
>> take a look at the /framework/datafile folder
>> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>>
>> Alex Melnik sent the following on 5/27/2008 12:55 PM:
>> > Is there a way to load existing products from a legacy system
>> without
>> > doing it manually (through webtools) or inserting it directly into
>> the
>> > database through an ETL.  In other words is there a UI where I can
>> > upload a list or is there an API that I can use to write a simple
>> JAVA
>> > driver to read from a list and insert into the OFBIZ back-end?
>> >
>> > Thanks for the help,
>> > Alex
>> >
>> >
>> >
>>
>>
>

[Bruno Busco]

If you think it could be a tip usefull for someone else...why not.
-Bruno

2008/5/29 Jacques Le Roux <[hidden email]>:

> Hi Bruno,
>
> I read it, and it's interesting. I even wonder if I would not put in the
> tips. Before it disappears  in the depth of the ML...
>
> Jacques
>
> From: "Bruno Busco" <[hidden email]>
>
>> Alex,
>> may be you did not read my mail....or may be I was not so clear....
>> -Bruno
>>
>> 2008/5/28 Alex Melnik <[hidden email]>:
>>
>>  I think this section covers the import of the data.  So let's say I can
>>> import the list of products into OFBIZ.  How can I associate it to a
>>> catalogue, browsing category, etc.   In other words how can I make my
>>> data play like a real product?
>>>
>>> >>> [hidden email] 5/28/2008 6:17 AM >>>
>>>
>>> take a look at the /framework/datafile folder
>>> http://docs.ofbiz.org/display/~jacopoc/OFBiz's+Data+File+Tools<http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>>> <http://docs.ofbiz.org/display/%7Ejacopoc/OFBiz%27s+Data+File+Tools>
>>>
>>> Alex Melnik sent the following on 5/27/2008 12:55 PM:
>>> > Is there a way to load existing products from a legacy system
>>> without
>>> > doing it manually (through webtools) or inserting it directly into
>>> the
>>> > database through an ETL.  In other words is there a UI where I can
>>> > upload a list or is there an API that I can use to write a simple
>>> JAVA
>>> > driver to read from a list and insert into the OFBIZ back-end?
>>> >
>>> > Thanks for the help,
>>> > Alex
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>
>