Re: File format to import products

[pierre.gaudin]

On 14/11/2017 08:55, Javier H. wrote:

Hello,

I have to import about 95.000 products into Ofbiz (mysql database).

I can import it to TXT or SQL formats, also to XLS but I get a error because 
max is 65.000 rows.

What format do you recommend for import, TXT or SQL?

Best regards


Hi Javier

We used to import about 700 000 article for a customer.

We used XML import via XSLT transformation to do so. I don't think there 
is a limit with xml import.



Pierre

Re: File format to import products

[Javier H.]

On 2017-11-14 08:02, "pierre.gaudin"  wrote: 
> On 14/11/2017 08:55, Javier H. wrote:
> > Hello,
> >
> > I have to import about 95.000 products into Ofbiz (mysql database).
> >
> > I can import it to TXT or SQL formats, also to XLS but I get a error 
> > because max is 65.000 rows.
> >
> > What format do you recommend for import, TXT or SQL?
> >
> > Best regards
> >
> Hi Javier
> 
> We used to import about 700 000 article for a customer.
> 
> We used XML import via XSLT transformation to do so. I don't think there 
> is a limit with xml import.
> 
> 
> Pierre
> 
> Thank you Pierre,

I think that I can to export to XML, I have to check it.

Best regards

Re: File format to import products

[Javier H.]

On 2017-11-14 08:21, "Javier H." wrote: 
> 
> 
> On 2017-11-14 08:02, "pierre.gaudin"  wrote: 
> > On 14/11/2017 08:55, Javier H. wrote:
> > > Hello,
> > >
> > > I have to import about 95.000 products into Ofbiz (mysql database).
> > >
> > > I can import it to TXT or SQL formats, also to XLS but I get a error 
> > > because max is 65.000 rows.
> > >
> > > What format do you recommend for import, TXT or SQL?
> > >
> > > Best regards
> > >
> > Hi Javier
> > 
> > We used to import about 700 000 article for a customer.
> > 
> > We used XML import via XSLT transformation to do so. I don't think there 
> > is a limit with xml import.
> > 
> > 
> > Pierre
> > 
> > Thank you Pierre,
> 
> I think that I can to export to XML, I have to check it.
> 
> Best regards
> Hello,

I have exported the data to an XML file.

Something similar to this:



  

  
  .


How can I make the definition file for this?  

And how can I ignore the fields that I do not want to import? (For example 
DATE).

Best regards

Re: File format to import products

[Michael Brohl]

Hi Javier,

why not directly export to the OFBiz datafile format?

Regards,

Michael


Am 17.11.17 um 09:03 schrieb Javier H.:


On 2017-11-14 08:21, "Javier H." wrote:


On 2017-11-14 08:02, "pierre.gaudin"  wrote:

On 14/11/2017 08:55, Javier H. wrote:

Hello,

I have to import about 95.000 products into Ofbiz (mysql database).

I can import it to TXT or SQL formats, also to XLS but I get a error because 
max is 65.000 rows.

What format do you recommend for import, TXT or SQL?

Best regards


Hi Javier

We used to import about 700 000 article for a customer.

We used XML import via XSLT transformation to do so. I don't think there
is a limit with xml import.


Pierre

Thank you Pierre,

I think that I can to export to XML, I have to check it.

Best regards
Hello,

I have exported the data to an XML file.

Something similar to this:



   
 
   
   .


How can I make the definition file for this?

And how can I ignore the fields that I do not want to import? (For example 
DATE).

Best regards





smime.p7s
Description: S/MIME Cryptographic Signature

Re: File format to import products

[Javier H.]

On 2017-11-17 08:05, Michael Brohl  wrote: 
> Hi Javier,
> 
> why not directly export to the OFBiz datafile format?
> 
> Regards,
> 
> Michael
> 
> 
> Am 17.11.17 um 09:03 schrieb Javier H.:
> >
> > On 2017-11-14 08:21, "Javier H." wrote:
> >>
> >> On 2017-11-14 08:02, "pierre.gaudin"  wrote:
> >>> On 14/11/2017 08:55, Javier H. wrote:
>  Hello,
> 
>  I have to import about 95.000 products into Ofbiz (mysql database).
> 
>  I can import it to TXT or SQL formats, also to XLS but I get a error 
>  because max is 65.000 rows.
> 
>  What format do you recommend for import, TXT or SQL?
> 
>  Best regards
> 
> >>> Hi Javier
> >>>
> >>> We used to import about 700 000 article for a customer.
> >>>
> >>> We used XML import via XSLT transformation to do so. I don't think there
> >>> is a limit with xml import.
> >>>
> >>>
> >>> Pierre
> >>>
> >>> Thank you Pierre,
> >> I think that I can to export to XML, I have to check it.
> >>
> >> Best regards
> >> Hello,
> > I have exported the data to an XML file.
> >
> > Something similar to this:
> >
> > 
> > 
> >
> >   >CODE="1308051"
> >DESCR="DEMO PRODUCT"
> >PRICE="5,50"
> >TAX="21"
> >QUANTITY="40"
> >LASTPRICE="4,9"
> >TAXCODE="3"
> >PROVIDER="87"
> >CATEGORY="00099"
> >DATE="01012015"
> >  />
> >
> >.
> > 
> >
> > How can I make the definition file for this?
> >
> > And how can I ignore the fields that I do not want to import? (For example 
> > DATE).
> >
> > Best regards
> 
> 
> Hi Michael,

Because I have no idea.

https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Data+File+Tools

I'm testing Data File Tools, I added this 
"/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd" to Definition 
Filename or URL" but I get this error:

No  elements found in 
file:/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd

Best regards

Re: File format to import products

[Jacques Le Roux]

Le 17/11/2017 à 09:43, Javier H. a écrit :


On 2017-11-17 08:05, Michael Brohl  wrote:

Hi Javier,

why not directly export to the OFBiz datafile format?

Regards,

Michael


Am 17.11.17 um 09:03 schrieb Javier H.:

On 2017-11-14 08:21, "Javier H." wrote:

On 2017-11-14 08:02, "pierre.gaudin"  wrote:

On 14/11/2017 08:55, Javier H. wrote:

Hello,

I have to import about 95.000 products into Ofbiz (mysql database).

I can import it to TXT or SQL formats, also to XLS but I get a error because 
max is 65.000 rows.

What format do you recommend for import, TXT or SQL?

Best regards


Hi Javier

We used to import about 700 000 article for a customer.

We used XML import via XSLT transformation to do so. I don't think there
is a limit with xml import.


Pierre

Thank you Pierre,

I think that I can to export to XML, I have to check it.

Best regards
Hello,

I have exported the data to an XML file.

Something similar to this:




  

.


How can I make the definition file for this?

And how can I ignore the fields that I do not want to import? (For example 
DATE).

Best regards


Hi Michael,

Because I have no idea.

https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+Data+File+Tools

I'm testing Data File Tools, I added this 
"/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd" to Definition 
Filename or URL" but I get this error:

No  elements found in 
file:/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd

Best regards


Hi Javier,

Did you follow 
https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz's+Data+File+Tools ?
Did you have a look at 
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data ?

HTH

Jacques

Re: File format to import products

[Javier]

Hi Jacques,

Yes, both, but I have problems in step 4:


   1. connect to the Webtools application
   2. go to the "Work With Data Files" screen
   3. enter the path to the your definition file in the "Definition
   Filename or URL" input field
   4. click on the submit button


I have used this file
/opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd and this



































but always I get this error  "No  elements found in
file:/home/user/data-file.xml"

Best regards

2017-11-17 9:30 GMT+00:00 Jacques Le Roux :

> Le 17/11/2017 à 09:43, Javier H. a écrit :
>
>>
>> On 2017-11-17 08:05, Michael Brohl  wrote:
>>
>>> Hi Javier,
>>>
>>> why not directly export to the OFBiz datafile format?
>>>
>>> Regards,
>>>
>>> Michael
>>>
>>>
>>> Am 17.11.17 um 09:03 schrieb Javier H.:
>>>
 On 2017-11-14 08:21, "Javier H." wrote:

> On 2017-11-14 08:02, "pierre.gaudin"  wrote:
>
>> On 14/11/2017 08:55, Javier H. wrote:
>>
>>> Hello,
>>>
>>> I have to import about 95.000 products into Ofbiz (mysql database).
>>>
>>> I can import it to TXT or SQL formats, also to XLS but I get a error
>>> because max is 65.000 rows.
>>>
>>> What format do you recommend for import, TXT or SQL?
>>>
>>> Best regards
>>>
>>> Hi Javier
>>
>> We used to import about 700 000 article for a customer.
>>
>> We used XML import via XSLT transformation to do so. I don't think
>> there
>> is a limit with xml import.
>>
>>
>> Pierre
>>
>> Thank you Pierre,
>>
> I think that I can to export to XML, I have to check it.
>
> Best regards
> Hello,
>
 I have exported the data to an XML file.

 Something similar to this:

 
 
 
   >>> CODE="1308051"
 DESCR="DEMO PRODUCT"
 PRICE="5,50"
 TAX="21"
 QUANTITY="40"
 LASTPRICE="4,9"
 TAXCODE="3"
 PROVIDER="87"
 CATEGORY="00099"
 DATE="01012015"
   />
 
 .
 

 How can I make the definition file for this?

 And how can I ignore the fields that I do not want to import? (For
 example DATE).

 Best regards

>>>
>>> Hi Michael,
>>>
>> Because I have no idea.
>>
>> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+
>> Data+File+Tools
>>
>> I'm testing Data File Tools, I added this "/opt/apache-ofbiz-16.11.03/fr
>> amework/datafile/dtd/datafiles.xsd" to Definition Filename or URL" but I
>> get this error:
>>
>> No  elements found in file:/opt/apache-ofbiz-16.11.0
>> 3/framework/datafile/dtd/datafiles.xsd
>>
>> Best regards
>>
>> Hi Javier,
>
> Did you follow https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz's+
> Data+File+Tools ?
> Did you have a look at https://cwiki.apache.org/confl
> uence/display/OFBIZ/Handling+of+External+data ?
>
> HTH
>
> Jacques
>
>


-- 
Saludos

Re: File format to import products

[Mike]

Nothing is simple in ofbiz.  There are a butt load of tables that have to
be imported in ofbiz... for ONE category, and for ONE product, IN THE
CORRECT ORDER!!!

First, you have to pre-populate your categories. (example below)

Then you can add the products.  (one product example below)

All this takes a lot of time organizing and analyzing in order to
understand the ofbiz schema.

For the XML you posted, you have to create a custom script (i.e.
perl/python/java) that reads each XML "row", and creates ofbiz XML
compatible "seed"  file(s).

If you write your own script, vice relying on ofbiz tools, you have
absolute control over what exactly is imported, and no data limits.  Want
alternate URLs?  What multi language support?  Change your script.

In addition, when you are setting up a new ofbiz instance, you WILL be
importing the same seed (store) data (example below), over and over
again...  This is why you must create ofbiz compatible "seed" data for your
store.  All the experts here know that.

"one category" example... "1" is top level, "10001" is first category.
























"one product" example:







































On Fri, Nov 17, 2017 at 1:43 AM, Javier  wrote:

> Hi Jacques,
>
> Yes, both, but I have problems in step 4:
>
>
>1. connect to the Webtools application
>2. go to the "Work With Data Files" screen
>3. enter the path to the your definition file in the "Definition
>Filename or URL" input field
>4. click on the submit button
>
>
> I have used this file
> /opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd and this
>
>  delimiter="	" text-delimiter=""
> description="this takes the product data from doba file"
> has-header="true">
> 
> 
>  default-value="dropShip" type="String"/>
>  default-value="FINISHED_GOOD" type="String"/>
> 
> 
> 
> 
> 
> 
> 
> 
>  type="String"/>
> 
> 
> 
> 
> 
> 
> 
> 
>  type="String"/>
> 
> 
> 
> 
> 
> 
>  type="String"/>
>  type="String"/>
> 
> 
>
> but always I get this error  "No  elements found in
> file:/home/user/data-file.xml"
>
> Best regards
>
> 2017-11-17 9:30 GMT+00:00 Jacques Le Roux :
>
> > Le 17/11/2017 à 09:43, Javier H. a écrit :
> >
> >>
> >> On 2017-11-17 08:05, Michael Brohl  wrote:
> >>
> >>> Hi Javier,
> >>>
> >>> why not directly export to the OFBiz datafile format?
> >>>
> >>> Regards,
> >>>
> >>> Michael
> >>>
> >>>
> >>> Am 17.11.17 um 09:03 schrieb Javier H.:
> >>>
>  On 2017-11-14 08:21, "Javier H." wrote:
> 
> > On 2017-11-14 08:02, "pierre.gaudin" 
> wrote:
> >
> >> On 14/11/2017 08:55, Javier H. wrote:
> >>
> >>> Hello,
> >>>
> >>> I have to import about 95.000 products into Ofbiz (mysql database).
> >>>
> >>> I can import it to TXT or SQL formats, also to XLS but I get a
> error
> >>> because max is 65.000 rows.
> >>>
> >>> What format do you recommend for import, TXT or SQL?
> >>>
> >>> Best regards
> >>>
> >>> Hi Javier
> >>
> >> We used to import about 700 000 article for a customer.
> >>
> >> We used XML import via XSLT transformation to do so. I don't think
> >> there
> >> is a limit with xml import.
> >>
> >>
> >> Pierre
> >>
> >> Thank you Pierre,
> >>
> > I think that I can to export to XML, I have to check it.
> >
> > Best regards
> > Hello,
> >
>  I have exported the data to an XML file.
> 
>  Something similar to this:
> 
>  
>  
>  
>  CODE="1308051"
>  DESCR="DEMO PRODUCT"
>  PRICE="5,50"
>  TAX="21"
>  QUANTITY="40"
>  LASTPRICE="4,9"
>  TAXCODE="3"
>  PROVIDER="87"
>  CATEGORY="00099"
>  DATE="01012015"
>    />
>  
>  .
>  
> 
>  How can I make the definition file for this?
> 
>  And how can I ignore the fields that I do not want to import? (For
>  example DATE).
> 
>  Best regards
> 
> >>>
> >>> Hi Michael,
> >>>
> >> Because I have no idea.
> >>
> >> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+
> >> Data+File+Tools
> >>
> >> I'm testing Data File Tools, I added this "/opt/apache-ofbiz-16.11.03/fr
> >> amework/datafile/dtd/datafiles.xsd" to Definition Filename or URL" but
> I
> >> get this error:
> >>
> >> No  elements found in file:/opt/apache-ofbiz-16.11.0
> >> 3/framework/datafile/dtd/datafiles.xsd
> >>
> >> Best regards
> >>
> >> Hi Javier,
> >
> > Did you follow https://cwiki.apache.org/confluence/display/OFBIZ/
> OFBiz's+
> > Data+File+Tools ?
> > Did you h

Re: File format to import products

[Javier]

Thanks Mike,

One of the biggest problems in my current program is that it does not
support SubCategories.

So I have to reorganize all the Categories.

So at the moment it would be enough for me to load all the products in a
category (for example, the Uncategorised family) and then I would be
organizing it from Ofbiz.

I have to familiarize myself with the schema of the database. I have been
studying a bit the OfbizDataModelBook.

Best regards.

2017-11-17 18:31 GMT+00:00 Mike :

> Nothing is simple in ofbiz.  There are a butt load of tables that have to
> be imported in ofbiz... for ONE category, and for ONE product, IN THE
> CORRECT ORDER!!!
>
> First, you have to pre-populate your categories. (example below)
>
> Then you can add the products.  (one product example below)
>
> All this takes a lot of time organizing and analyzing in order to
> understand the ofbiz schema.
>
> For the XML you posted, you have to create a custom script (i.e.
> perl/python/java) that reads each XML "row", and creates ofbiz XML
> compatible "seed"  file(s).
>
> If you write your own script, vice relying on ofbiz tools, you have
> absolute control over what exactly is imported, and no data limits.  Want
> alternate URLs?  What multi language support?  Change your script.
>
> In addition, when you are setting up a new ofbiz instance, you WILL be
> importing the same seed (store) data (example below), over and over
> again...  This is why you must create ofbiz compatible "seed" data for your
> store.  All the experts here know that.
>
> "one category" example... "1" is top level, "10001" is first category.
>
> 
> 
>  viewAllowPermReqd="N" purchaseAllowPermReqd="N" createdStamp="2017-11-05
> 10:59:43"/>
>  productCategoryTypeId="CATALOG_CATEGORY" categoryName="Gallery"
> description="Gallery" createdStamp="2017-11-05 10:59:43"/>
>  prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" fromDate="2017-11-05
> 10:59:43"
> createdStamp="2017-11-05 10:59:43"/>
>  productCategoryTypeId="SEARCH_CATEGORY" categoryName="Gallery Search"
> description="Gallery Search" createdStamp="2017-11-05 10:59:43"/>
>  productCategoryId="Gallery_SEARCH" prodCatalogCategoryTypeId="PCCT_SEARCH"
> fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
>  fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
>  contentName="Product Description" createdDate="2017-11-05 10:59:43"
> createdStamp="2017-11-05 10:59:43"/>
>  productCategoryTypeId="CATALOG_CATEGORY" primaryParentCategoryId="1"
> description="Games & Entertainment" createdStamp="2017-11-05
> 10:59:43"/>
>  parentProductCategoryId="1" sequenceNum="1" fromDate="2017-11-05
> 10:59:43" createdStamp="2017-11-05 10:59:43"/>
>  dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  createdTxStamp="2017-11-05 10:59:43"/>
>  dataResourceId="10001Den" description="DESCRIPTION en 10001"
> localeString="en" createdDate="2017-11-05 10:59:43"
> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> createdTxStamp="2017-11-05 10:59:43"/>
>  prodCatContentTypeId="CATEGORY_NAME" fromDate="2017-11-05 10:59:43"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  dataResourceId="10001Aen" description="ALT_URL en 10001" localeString="en"
> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  prodCatContentTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 10:59:43"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
>  contentAssocTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 10:59:43"
> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> 
>
> "one product" example:
>
> 
> 
>  primaryProductCategoryId="10002" internalName="798936836182"
> brandName="SELECTSOFT GAMES" comments="JEWEL CASE EVERYONE"
> smallImageUrl="/images/products/1/1001MINIGOLF/small.jpg"
> mediumImageUrl="/images/products/1/1001MINIGOLF/medium.jpg"
> largeImageUrl="/images/products/1/1001MINIGOLF/large.jpg"
> originalImageUrl="/images/products/1/1001MINIGOLF/original.jpg"
> detailImageUrl="/images/products/1/1001MINIGOLF/detail.jpg"
> inventoryMessage="Ships from NashVille" requireInventory="N"
> weightUomId="WT_lb" weight=".35" productWeight=".35" ret

Re: File format to import products

[Mike]

It is a two step process as I outlined in my previous email.  From your
source XML/CSV, you create (via an external utility) the
catalog/categories/sub-categories into an ofbiz-compatible "catalog" XML
file.

You then test import the "catalog" XML file, OVER and OVER again until it
looks proper. Why do you do this?  Because it will require tweaking.  Doing
this in the ofbiz GUI would be tedious and error prone.

You have to create "seed" compatible data.  After the catalog looks good,
you repeat the same process (create an ofbiz-compatible "product" XML file)
with the products.

You really don't need the OfbizDataModelBook at this point, my previous
email showed you the tables and the order.

Good luck.

On Mon, Nov 20, 2017 at 10:54 PM, Javier  wrote:

> Thanks Mike,
>
> One of the biggest problems in my current program is that it does not
> support SubCategories.
>
> So I have to reorganize all the Categories.
>
> So at the moment it would be enough for me to load all the products in a
> category (for example, the Uncategorised family) and then I would be
> organizing it from Ofbiz.
>
> I have to familiarize myself with the schema of the database. I have been
> studying a bit the OfbizDataModelBook.
>
> Best regards.
>
> 2017-11-17 18:31 GMT+00:00 Mike :
>
> > Nothing is simple in ofbiz.  There are a butt load of tables that have to
> > be imported in ofbiz... for ONE category, and for ONE product, IN THE
> > CORRECT ORDER!!!
> >
> > First, you have to pre-populate your categories. (example below)
> >
> > Then you can add the products.  (one product example below)
> >
> > All this takes a lot of time organizing and analyzing in order to
> > understand the ofbiz schema.
> >
> > For the XML you posted, you have to create a custom script (i.e.
> > perl/python/java) that reads each XML "row", and creates ofbiz XML
> > compatible "seed"  file(s).
> >
> > If you write your own script, vice relying on ofbiz tools, you have
> > absolute control over what exactly is imported, and no data limits.  Want
> > alternate URLs?  What multi language support?  Change your script.
> >
> > In addition, when you are setting up a new ofbiz instance, you WILL be
> > importing the same seed (store) data (example below), over and over
> > again...  This is why you must create ofbiz compatible "seed" data for
> your
> > store.  All the experts here know that.
> >
> > "one category" example... "1" is top level, "10001" is first
> category.
> >
> > 
> > 
> >  > viewAllowPermReqd="N" purchaseAllowPermReqd="N" createdStamp="2017-11-05
> > 10:59:43"/>
> >  > productCategoryTypeId="CATALOG_CATEGORY" categoryName="Gallery"
> > description="Gallery" createdStamp="2017-11-05 10:59:43"/>
> >  > prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" fromDate="2017-11-05
> > 10:59:43"
> > createdStamp="2017-11-05 10:59:43"/>
> >  > productCategoryTypeId="SEARCH_CATEGORY" categoryName="Gallery Search"
> > description="Gallery Search" createdStamp="2017-11-05 10:59:43"/>
> >  > productCategoryId="Gallery_SEARCH" prodCatalogCategoryTypeId="
> PCCT_SEARCH"
> > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> >  > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> >  > contentName="Product Description" createdDate="2017-11-05 10:59:43"
> > createdStamp="2017-11-05 10:59:43"/>
> >  > productCategoryTypeId="CATALOG_CATEGORY" primaryParentCategoryId="1"
> > description="Games & Entertainment" createdStamp="2017-11-05
> > 10:59:43"/>
> >  > parentProductCategoryId="1" sequenceNum="1" fromDate="2017-11-05
> > 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> >  > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > createdTxStamp="2017-11-05 10:59:43"/>
> >  > dataResourceId="10001Den" description="DESCRIPTION en 10001"
> > localeString="en" createdDate="2017-11-05 10:59:43"
> > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > createdTxStamp="2017-11-05 10:59:43"/>
> >  > prodCatContentTypeId="CATEGORY_NAME" fromDate="2017-11-05 10:59:43"
> > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > dataResourceId="10001Aen" description="ALT_URL en 10001"
> localeString="en"
> > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 10:59:43"/>
> >  > prodC

Re: File format to import products

[Javier]

Thanks Mike,

I used xmlstarlet and this is the result for 2 products, I made 2 files
Product.xml and ProductPrice.xml. Do you think it can work?

Best regards

Product.xml






ProductPrice.xml






2017-11-21 15:49 GMT+00:00 Mike :

> It is a two step process as I outlined in my previous email.  From your
> source XML/CSV, you create (via an external utility) the
> catalog/categories/sub-categories into an ofbiz-compatible "catalog" XML
> file.
>
> You then test import the "catalog" XML file, OVER and OVER again until it
> looks proper. Why do you do this?  Because it will require tweaking.  Doing
> this in the ofbiz GUI would be tedious and error prone.
>
> You have to create "seed" compatible data.  After the catalog looks good,
> you repeat the same process (create an ofbiz-compatible "product" XML file)
> with the products.
>
> You really don't need the OfbizDataModelBook at this point, my previous
> email showed you the tables and the order.
>
> Good luck.
>
> On Mon, Nov 20, 2017 at 10:54 PM, Javier  wrote:
>
> > Thanks Mike,
> >
> > One of the biggest problems in my current program is that it does not
> > support SubCategories.
> >
> > So I have to reorganize all the Categories.
> >
> > So at the moment it would be enough for me to load all the products in a
> > category (for example, the Uncategorised family) and then I would be
> > organizing it from Ofbiz.
> >
> > I have to familiarize myself with the schema of the database. I have been
> > studying a bit the OfbizDataModelBook.
> >
> > Best regards.
> >
> > 2017-11-17 18:31 GMT+00:00 Mike :
> >
> > > Nothing is simple in ofbiz.  There are a butt load of tables that have
> to
> > > be imported in ofbiz... for ONE category, and for ONE product, IN THE
> > > CORRECT ORDER!!!
> > >
> > > First, you have to pre-populate your categories. (example below)
> > >
> > > Then you can add the products.  (one product example below)
> > >
> > > All this takes a lot of time organizing and analyzing in order to
> > > understand the ofbiz schema.
> > >
> > > For the XML you posted, you have to create a custom script (i.e.
> > > perl/python/java) that reads each XML "row", and creates ofbiz XML
> > > compatible "seed"  file(s).
> > >
> > > If you write your own script, vice relying on ofbiz tools, you have
> > > absolute control over what exactly is imported, and no data limits.
> Want
> > > alternate URLs?  What multi language support?  Change your script.
> > >
> > > In addition, when you are setting up a new ofbiz instance, you WILL be
> > > importing the same seed (store) data (example below), over and over
> > > again...  This is why you must create ofbiz compatible "seed" data for
> > your
> > > store.  All the experts here know that.
> > >
> > > "one category" example... "1" is top level, "10001" is first
> > category.
> > >
> > > 
> > > 
> > >  useQuickAdd="N"
> > > viewAllowPermReqd="N" purchaseAllowPermReqd="N"
> createdStamp="2017-11-05
> > > 10:59:43"/>
> > >  > > productCategoryTypeId="CATALOG_CATEGORY" categoryName="Gallery"
> > > description="Gallery" createdStamp="2017-11-05 10:59:43"/>
> > >  > > prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" fromDate="2017-11-05
> > > 10:59:43"
> > > createdStamp="2017-11-05 10:59:43"/>
> > >  > > productCategoryTypeId="SEARCH_CATEGORY" categoryName="Gallery Search"
> > > description="Gallery Search" createdStamp="2017-11-05 10:59:43"/>
> > >  > > productCategoryId="Gallery_SEARCH" prodCatalogCategoryTypeId="
> > PCCT_SEARCH"
> > > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> > >  > > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> > >  > > contentName="Product Description" createdDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43"/>
> > >  > > productCategoryTypeId="CATALOG_CATEGORY" primaryParentCategoryId="
> 1"
> > > description="Games & Entertainment" createdStamp="2017-11-05
> > > 10:59:43"/>
> > >  > > parentProductCategoryId="1" sequenceNum="1" fromDate="2017-11-05
> > > 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> > >  > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > >  > > createdTxStamp="2017-11-05 10:59:43"/>
> > >  > > dataResourceId="10001Den" description="DESCRIPTION en 10001"
> > > localeString="en" createdDate="2017-11-05 10:59:43"
> > > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > >  > > prodCatContentTypeId="CATEGORY_NAME" fromDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > >  > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > >  > > dataR

Re: File format to import products

[Javier]

There is a error, is productId not ProductID, sorry.

2017-11-22 8:32 GMT+00:00 Javier :

> Thanks Mike,
>
> I used xmlstarlet and this is the result for 2 products, I made 2 files
> Product.xml and ProductPrice.xml. Do you think it can work?
>
> Best regards
>
> Product.xml
>
>  PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
> 16:32:57.0"/>
>
>  PRICE="0,49" TAX="7" primaryProductCategoryId="10001"
> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
> 16:32:57.0"/>
>
>
> ProductPrice.xml
>
>  createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
> 07:15:53.0" productPricePurposeId="PURCHASE" 
> productPriceTypeId="DEFAULT_PRICE"
> taxInPrice="Y"/>
>
>  createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
> 07:15:53.0" productPricePurposeId="PURCHASE" 
> productPriceTypeId="DEFAULT_PRICE"
> taxInPrice="Y"/>
>
>
> 2017-11-21 15:49 GMT+00:00 Mike :
>
>> It is a two step process as I outlined in my previous email.  From your
>> source XML/CSV, you create (via an external utility) the
>> catalog/categories/sub-categories into an ofbiz-compatible "catalog" XML
>> file.
>>
>> You then test import the "catalog" XML file, OVER and OVER again until it
>> looks proper. Why do you do this?  Because it will require tweaking.
>> Doing
>> this in the ofbiz GUI would be tedious and error prone.
>>
>> You have to create "seed" compatible data.  After the catalog looks good,
>> you repeat the same process (create an ofbiz-compatible "product" XML
>> file)
>> with the products.
>>
>> You really don't need the OfbizDataModelBook at this point, my previous
>> email showed you the tables and the order.
>>
>> Good luck.
>>
>> On Mon, Nov 20, 2017 at 10:54 PM, Javier  wrote:
>>
>> > Thanks Mike,
>> >
>> > One of the biggest problems in my current program is that it does not
>> > support SubCategories.
>> >
>> > So I have to reorganize all the Categories.
>> >
>> > So at the moment it would be enough for me to load all the products in a
>> > category (for example, the Uncategorised family) and then I would be
>> > organizing it from Ofbiz.
>> >
>> > I have to familiarize myself with the schema of the database. I have
>> been
>> > studying a bit the OfbizDataModelBook.
>> >
>> > Best regards.
>> >
>> > 2017-11-17 18:31 GMT+00:00 Mike :
>> >
>> > > Nothing is simple in ofbiz.  There are a butt load of tables that
>> have to
>> > > be imported in ofbiz... for ONE category, and for ONE product, IN THE
>> > > CORRECT ORDER!!!
>> > >
>> > > First, you have to pre-populate your categories. (example below)
>> > >
>> > > Then you can add the products.  (one product example below)
>> > >
>> > > All this takes a lot of time organizing and analyzing in order to
>> > > understand the ofbiz schema.
>> > >
>> > > For the XML you posted, you have to create a custom script (i.e.
>> > > perl/python/java) that reads each XML "row", and creates ofbiz XML
>> > > compatible "seed"  file(s).
>> > >
>> > > If you write your own script, vice relying on ofbiz tools, you have
>> > > absolute control over what exactly is imported, and no data limits.
>> Want
>> > > alternate URLs?  What multi language support?  Change your script.
>> > >
>> > > In addition, when you are setting up a new ofbiz instance, you WILL be
>> > > importing the same seed (store) data (example below), over and over
>> > > again...  This is why you must create ofbiz compatible "seed" data for
>> > your
>> > > store.  All the experts here know that.
>> > >
>> > > "one category" example... "1" is top level, "10001" is first
>> > category.
>> > >
>> > > 
>> > > 
>> > > > useQuickAdd="N"
>> > > viewAllowPermReqd="N" purchaseAllowPermReqd="N"
>> createdS

Re: File format to import products

[pierre.gaudin]

Hi Javier

 - The decimal seprator should be '.'
 - no need to set lastUpdatedStamp createdTxStamp ...
 - ProductCategory should be imported first

Pierre
On 22/11/2017 09:37, Javier wrote:

There is a error, is productId not ProductID, sorry.

2017-11-22 8:32 GMT+00:00 Javier :


Thanks Mike,

I used xmlstarlet and this is the result for 2 products, I made 2 files
Product.xml and ProductPrice.xml. Do you think it can work?

Best regards

Product.xml

 

 


ProductPrice.xml

 

 


2017-11-21 15:49 GMT+00:00 Mike :


It is a two step process as I outlined in my previous email.  From your
source XML/CSV, you create (via an external utility) the
catalog/categories/sub-categories into an ofbiz-compatible "catalog" XML
file.

You then test import the "catalog" XML file, OVER and OVER again until it
looks proper. Why do you do this?  Because it will require tweaking.
Doing
this in the ofbiz GUI would be tedious and error prone.

You have to create "seed" compatible data.  After the catalog looks good,
you repeat the same process (create an ofbiz-compatible "product" XML
file)
with the products.

You really don't need the OfbizDataModelBook at this point, my previous
email showed you the tables and the order.

Good luck.

On Mon, Nov 20, 2017 at 10:54 PM, Javier  wrote:


Thanks Mike,

One of the biggest problems in my current program is that it does not
support SubCategories.

So I have to reorganize all the Categories.

So at the moment it would be enough for me to load all the products in a
category (for example, the Uncategorised family) and then I would be
organizing it from Ofbiz.

I have to familiarize myself with the schema of the database. I have

been

studying a bit the OfbizDataModelBook.

Best regards.

2017-11-17 18:31 GMT+00:00 Mike :


Nothing is simple in ofbiz.  There are a butt load of tables that

have to

be imported in ofbiz... for ONE category, and for ONE product, IN THE
CORRECT ORDER!!!

First, you have to pre-populate your categories. (example below)

Then you can add the products.  (one product example below)

All this takes a lot of time organizing and analyzing in order to
understand the ofbiz schema.

For the XML you posted, you have to create a custom script (i.e.
perl/python/java) that reads each XML "row", and creates ofbiz XML
compatible "seed"  file(s).

If you write your own script, vice relying on ofbiz tools, you have
absolute control over what exactly is imported, and no data limits.

Want

alternate URLs?  What multi language support?  Change your script.

In addition, when you are setting up a new ofbiz instance, you WILL be
importing the same seed (store) data (example below), over and over
again...  This is why you must create ofbiz compatible "seed" data for

your

store.  All the experts here know that.

"one category" example... "1" is top level, "10001" is first

category.




useQuickAdd="N"

viewAllowPermReqd="N" purchaseAllowPermReqd="N"

createdStamp="2017-11-05

10:59:43"/>




PCCT_SEARCH"

fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>



primaryParentCategoryId="1"

description="Games & Entertainment" createdStamp="2017-11-05
10:59:43"/>


10:59:43"/>




10:59:43"/>


10:59:43"/>


10:59:43"/>


textData="games-entertainment"

createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05

10:59:43"/>


localeString="en"

createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05

10:59:43"/>


10:59:43"/>


10:59:43"/>



"one product" example:




returnable="Y"

taxable="Y" chargeShipping="Y" isVirtual="N" isVariant="N"
requirementMethodEnumId="PRODRQM_DS" billOfMaterialLevel="0"
introductionDate="2007-06-14 00:00:00" salesDiscontinuationDate="
2038-01-01
00:00:00" createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
autoCreateKeywords="Y"/>

productId="798936836182"

fromDate="2007-06-14 00:00:00" thruDate="2038-01-01 00:00:00"
sequenceNum="0" quantity="0" createdStamp="2017-11-05 10:59:43"/>


PRICE"

productPricePurposeId="PURCHASE" currencyUomId="USD"

termUomId="OTH_ea"

productStoreGroupId="_NA_" price="3.85" fromDate="2017-11-05 10:59:43"
createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>

"

productPricePurposeId="PURCHASE" currencyUomId="USD"

termUomId="OTH_ea"

productStoreGroupId="_NA_" price="9.95" fromDate="2017-11-05 10:59:43"
createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>

termUomId="OTH_ea"

productStoreGroupId="_NA_" price="2.75" fromDate="2017-11-05 10:59:43"
createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>

orderQtyIncrements="1"

unitsIncluded="1" quantityUomId="OTH_ea" currencyUomId="USD"
supplierProductName="1001 MINIGOLF CHALLENGE"
supplierProductId="1001MINIGOLF" canDropShip="Y" comments="Supplier
Comment" createdStamp="2017-11-05 10:59:43" lastPrice="3.85"/>



10:59:43"/>


MINIGOLF

CHALLENGE" createdStamp="2017-11-05 10:59:43"

createdTxStamp="2017-11-05

10:59:43"/>

Re: File format to import products

[Mike]

Regarding:

  

Right off the bat I see that "productID" is not "productId".  I'm pretty
sure that won't work.  The beginning "
wrote:

> Hi Javier
>
>  - The decimal seprator should be '.'
>  - no need to set lastUpdatedStamp createdTxStamp ...
>  - ProductCategory should be imported first
>
> Pierre
>
> On 22/11/2017 09:37, Javier wrote:
>
>> There is a error, is productId not ProductID, sorry.
>>
>> 2017-11-22 8:32 GMT+00:00 Javier :
>>
>> Thanks Mike,
>>>
>>> I used xmlstarlet and this is the result for 2 products, I made 2 files
>>> Product.xml and ProductPrice.xml. Do you think it can work?
>>>
>>> Best regards
>>>
>>> Product.xml
>>>
>>>  >> PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
>>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
>>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
>>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
>>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
>>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
>>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
>>> 16:32:57.0"/>
>>>
>>>  >> PRICE="0,49" TAX="7" primaryProductCategoryId="10001"
>>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
>>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
>>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
>>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
>>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
>>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
>>> 16:32:57.0"/>
>>>
>>>
>>> ProductPrice.xml
>>>
>>>  >> createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
>>> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
>>> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
>>> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
>>> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
>>> 07:15:53.0" productPricePurposeId="PURCHASE"
>>> productPriceTypeId="DEFAULT_PRICE"
>>> taxInPrice="Y"/>
>>>
>>>  >> createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
>>> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
>>> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
>>> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
>>> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
>>> 07:15:53.0" productPricePurposeId="PURCHASE"
>>> productPriceTypeId="DEFAULT_PRICE"
>>> taxInPrice="Y"/>
>>>
>>>
>>> 2017-11-21 15:49 GMT+00:00 Mike :
>>>
>>> It is a two step process as I outlined in my previous email.  From your
 source XML/CSV, you create (via an external utility) the
 catalog/categories/sub-categories into an ofbiz-compatible "catalog"
 XML
 file.

 You then test import the "catalog" XML file, OVER and OVER again until
 it
 looks proper. Why do you do this?  Because it will require tweaking.
 Doing
 this in the ofbiz GUI would be tedious and error prone.

 You have to create "seed" compatible data.  After the catalog looks
 good,
 you repeat the same process (create an ofbiz-compatible "product" XML
 file)
 with the products.

 You really don't need the OfbizDataModelBook at this point, my previous
 email showed you the tables and the order.

 Good luck.

 On Mon, Nov 20, 2017 at 10:54 PM, Javier  wrote:

 Thanks Mike,
>
> One of the biggest problems in my current program is that it does not
> support SubCategories.
>
> So I have to reorganize all the Categories.
>
> So at the moment it would be enough for me to load all the products in
> a
> category (for example, the Uncategorised family) and then I would be
> organizing it from Ofbiz.
>
> I have to familiarize myself with the schema of the database. I have
>
 been

> studying a bit the OfbizDataModelBook.
>
> Best regards.
>
> 2017-11-17 18:31 GMT+00:00 Mike :
>
> Nothing is simple in ofbiz.  There are a butt load of tables that
>>
> have to

> be imported in ofbiz... for ONE category, and for ONE product, IN THE
>> CORRECT ORDER!!!
>>
>> First, you have to pre-populate your categories. (example below)
>>
>> Then you can add the products.  (one product example below)
>>
>> All this takes a lot of time organizing and analyzing in order to
>> understand the ofbiz schema.
>>
>> For the XML you posted, you have to create a custom script (i.e.
>> perl/python/java) that reads each XML "row", and creates ofbiz XML
>> compatible "seed"  file(s).
>>
>> If you write your own script, vice relying on ofbiz tools, you have
>> absolute control over what exactly is imported, and no data limits.
>>
> 

Re: File format to import products

[Javier]

Hello Mike,

I have changed in mail of  22 de noviembre de 2017, 8:32

The Category is already created from Ofbiz web interface (manually).

Now, I'm loading.

Best regards

2017-11-22 14:54 GMT+00:00 Mike :

> Regarding:
>
>PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
> 16:32:57.0"/>
>
> Right off the bat I see that "productID" is not "productId".  I'm pretty
> sure that won't work.  The beginning " table, and ONLY the columns in that table are legal for each of the lines
> in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...  Neither
> "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId"
> should be "productTypeId".  It also looks like "inShippingBox" does not
> exist in the product table.  You must be precise with all the table names
> and column names.
>
> This is why I said you must become very familiar with the ofbiz schema.
> When creating seed data, you can log into the database and list all the
> legal columns (i.e. for the product table).  Here is an example for
> postgresql:
>
> ofbiz=# \d product
>  primary_product_category_id  | character varying(255)   |
>  manufacturer_party_id| character varying(255)   |
>  facility_id  | character varying(255)   |
>  introduction_date| timestamp with time zone |
>  release_date | timestamp with time zone |
>  support_discontinuation_date | timestamp with time zone |
>  sales_discontinuation_date   | timestamp with time zone |
>  sales_disc_when_not_avail| character(1) |
>  internal_name| text |
>  brand_name   | character varying(255)   |
>  comments | text |
>  product_name | character varying(255)   |
>  description  | text |
>  long_description | text |
>  price_detail_text| text |
>  small_image_url  | character varying(2000)  |
>  medium_image_url | character varying(2000)  |
>  large_image_url  | character varying(2000)  |
>  detail_image_url | character varying(2000)  |
>  original_image_url   | character varying(2000)  |
>  detail_screen| character varying(255)   |
>  inventory_message| text |
>  require_inventory| character(1) |
>  inventory_item_type_id   | character varying(255)   |
>  quantity_uom_id  | character varying(255)   |
>  quantity_included| numeric(18,6)|
>  pieces_included  | numeric(20,0)|
>  require_amount   | character(1) |
>  fixed_amount | numeric(18,2)|
>  amount_uom_type_id   | character varying(255)   |
>  weight_uom_id| character varying(255)   |
>  weight   | numeric(18,6)|
>  product_weight   | numeric(18,6)|
>  diameter_uom_id  | character varying(255)   |
>  product_diameter | numeric(18,6)|
>  product_rating   | numeric(18,6)|
>  rating_type_enum | character varying(255)   |
>  returnable   | character(1) |
>  taxable  | character(1) |
>  charge_shipping  | character(1) |
>  auto_create_keywords | character(1) |
>  include_in_promotions| character(1) |
>  is_virtual   | character(1) |
>  is_variant   | character(1) |
>  virtual_variant_method_enum  | character varying(255)   |
>  origin_geo_id| character varying(255)   |
>  requirement_method_enum_id   | character varying(255)   |
>  bill_of_material_level   | numeric(20,0)|
>  reserv_max_persons   | numeric(18,6)|
>  reserv2nd_p_p_perc   | numeric(18,6)|
>  reserv_nth_p_p_perc  | numeric(18,6)|
>  config_id| character varying(255)   |
>  created_date | timestamp with time zone |
>  created_by_user_login| character varying(255)   |
>  last_modified_date   | timestamp with time zone |
>  last_modified_by_user_login  | character varying(255)   |
>  in_shipping_box  | character(1) |
>  default_shipment_box_type_id | c

Re: File format to import products

[Javier]

It's not over yet, but I made a query to the Products table, and surprise,
there are products :)

select * from PRODUCT;

2017-11-22 17:03 GMT+00:00 Javier :

> Hello Mike,
>
> I have changed in mail of  22 de noviembre de 2017, 8:32
>
> The Category is already created from Ofbiz web interface (manually).
>
> Now, I'm loading.
>
> Best regards
>
> 2017-11-22 14:54 GMT+00:00 Mike :
>
>> Regarding:
>>
>>   > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
>> 16:32:57.0"/>
>>
>> Right off the bat I see that "productID" is not "productId".  I'm pretty
>> sure that won't work.  The beginning "> table, and ONLY the columns in that table are legal for each of the lines
>> in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
>> Neither
>> "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId"
>> should be "productTypeId".  It also looks like "inShippingBox" does not
>> exist in the product table.  You must be precise with all the table names
>> and column names.
>>
>> This is why I said you must become very familiar with the ofbiz schema.
>> When creating seed data, you can log into the database and list all the
>> legal columns (i.e. for the product table).  Here is an example for
>> postgresql:
>>
>> ofbiz=# \d product
>>  primary_product_category_id  | character varying(255)   |
>>  manufacturer_party_id| character varying(255)   |
>>  facility_id  | character varying(255)   |
>>  introduction_date| timestamp with time zone |
>>  release_date | timestamp with time zone |
>>  support_discontinuation_date | timestamp with time zone |
>>  sales_discontinuation_date   | timestamp with time zone |
>>  sales_disc_when_not_avail| character(1) |
>>  internal_name| text |
>>  brand_name   | character varying(255)   |
>>  comments | text |
>>  product_name | character varying(255)   |
>>  description  | text |
>>  long_description | text |
>>  price_detail_text| text |
>>  small_image_url  | character varying(2000)  |
>>  medium_image_url | character varying(2000)  |
>>  large_image_url  | character varying(2000)  |
>>  detail_image_url | character varying(2000)  |
>>  original_image_url   | character varying(2000)  |
>>  detail_screen| character varying(255)   |
>>  inventory_message| text |
>>  require_inventory| character(1) |
>>  inventory_item_type_id   | character varying(255)   |
>>  quantity_uom_id  | character varying(255)   |
>>  quantity_included| numeric(18,6)|
>>  pieces_included  | numeric(20,0)|
>>  require_amount   | character(1) |
>>  fixed_amount | numeric(18,2)|
>>  amount_uom_type_id   | character varying(255)   |
>>  weight_uom_id| character varying(255)   |
>>  weight   | numeric(18,6)|
>>  product_weight   | numeric(18,6)|
>>  diameter_uom_id  | character varying(255)   |
>>  product_diameter | numeric(18,6)|
>>  product_rating   | numeric(18,6)|
>>  rating_type_enum | character varying(255)   |
>>  returnable   | character(1) |
>>  taxable  | character(1) |
>>  charge_shipping  | character(1) |
>>  auto_create_keywords | character(1) |
>>  include_in_promotions| character(1) |
>>  is_virtual   | character(1) |
>>  is_variant   | character(1) |
>>  virtual_variant_method_enum  | character varying(255)   |
>>  origin_geo_id| character varying(255)   |
>>  requirement_method_enum_id   | character varying(255)   |
>>  bill_of_material_level   | numeric(20,0)|
>>  reserv_max_persons   | numeric(18,6)|
>>  reserv2nd_p_p_perc   | numeric(18,6)|
>>  reserv_nth_p_p_perc  | numeric(18,6)|
>>  config_id| character varying(255)   |
>>  created_date | timestamp with time zone |
>>  created_by_user_

Re: File format to import products

[Javier]

It's finished.

Showing 1 - 20 of 95.094

Now I going to load ProducPrice.xml, let's see if I have the same luck.

Thanks very much to alls!

Best regards.

2017-11-22 17:09 GMT+00:00 Javier :

> It's not over yet, but I made a query to the Products table, and surprise,
> there are products :)
>
> select * from PRODUCT;
>
> 2017-11-22 17:03 GMT+00:00 Javier :
>
>> Hello Mike,
>>
>> I have changed in mail of  22 de noviembre de 2017, 8:32
>>
>> The Category is already created from Ofbiz web interface (manually).
>>
>> Now, I'm loading.
>>
>> Best regards
>>
>> 2017-11-22 14:54 GMT+00:00 Mike :
>>
>>> Regarding:
>>>
>>>   >> PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
>>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
>>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
>>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
>>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
>>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
>>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
>>> 16:32:57.0"/>
>>>
>>> Right off the bat I see that "productID" is not "productId".  I'm pretty
>>> sure that won't work.  The beginning ">> table, and ONLY the columns in that table are legal for each of the lines
>>> in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
>>> Neither
>>> "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId"
>>> should be "productTypeId".  It also looks like "inShippingBox" does not
>>> exist in the product table.  You must be precise with all the table names
>>> and column names.
>>>
>>> This is why I said you must become very familiar with the ofbiz schema.
>>> When creating seed data, you can log into the database and list all the
>>> legal columns (i.e. for the product table).  Here is an example for
>>> postgresql:
>>>
>>> ofbiz=# \d product
>>>  primary_product_category_id  | character varying(255)   |
>>>  manufacturer_party_id| character varying(255)   |
>>>  facility_id  | character varying(255)   |
>>>  introduction_date| timestamp with time zone |
>>>  release_date | timestamp with time zone |
>>>  support_discontinuation_date | timestamp with time zone |
>>>  sales_discontinuation_date   | timestamp with time zone |
>>>  sales_disc_when_not_avail| character(1) |
>>>  internal_name| text |
>>>  brand_name   | character varying(255)   |
>>>  comments | text |
>>>  product_name | character varying(255)   |
>>>  description  | text |
>>>  long_description | text |
>>>  price_detail_text| text |
>>>  small_image_url  | character varying(2000)  |
>>>  medium_image_url | character varying(2000)  |
>>>  large_image_url  | character varying(2000)  |
>>>  detail_image_url | character varying(2000)  |
>>>  original_image_url   | character varying(2000)  |
>>>  detail_screen| character varying(255)   |
>>>  inventory_message| text |
>>>  require_inventory| character(1) |
>>>  inventory_item_type_id   | character varying(255)   |
>>>  quantity_uom_id  | character varying(255)   |
>>>  quantity_included| numeric(18,6)|
>>>  pieces_included  | numeric(20,0)|
>>>  require_amount   | character(1) |
>>>  fixed_amount | numeric(18,2)|
>>>  amount_uom_type_id   | character varying(255)   |
>>>  weight_uom_id| character varying(255)   |
>>>  weight   | numeric(18,6)|
>>>  product_weight   | numeric(18,6)|
>>>  diameter_uom_id  | character varying(255)   |
>>>  product_diameter | numeric(18,6)|
>>>  product_rating   | numeric(18,6)|
>>>  rating_type_enum | character varying(255)   |
>>>  returnable   | character(1) |
>>>  taxable  | character(1) |
>>>  charge_shipping  | character(1) |
>>>  auto_create_keywords | character(1) |
>>>  include_in_promotions| character(1) |
>>>  is_virtual   | character(1) |
>>>  is_variant   | character(1) |
>>>  virtual_variant_method_enum  | character varying(255)   |
>>>  origin_geo_id| character varying(255)   |
>>>  requirement_method_enum_id   | character varying(255)   |
>>>  bill_of_material_level   | numeric(20,0)|
>>>  reserv_max_persons   | n

Re: File format to import products

[Javier]

As Pierre said, the price has to be with a '.' for decimals.


2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
 |W| Could not set field ProductPrice.price to the value 8,99
java.lang.NumberFormatException
at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
at org.apache.ofbiz.entity.GenericEntity.setString(GenericEntity.java:574)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:579)
[ofbiz.jar:?]
> Buildiat org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown
Source) [xercesImpl-2.9.1.jar:?]
> Buildiat
org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
Source) [xercesImpl-2.9.1.jar:?]
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
Source) [xercesImpl-2.9.1.jar:?]


2017-11-22 17:14 GMT+00:00 Javier :

> It's finished.
>
> Showing 1 - 20 of 95.094
>
> Now I going to load ProducPrice.xml, let's see if I have the same luck.
>
> Thanks very much to alls!
>
> Best regards.
>
> 2017-11-22 17:09 GMT+00:00 Javier :
>
>> It's not over yet, but I made a query to the Products table, and
>> surprise, there are products :)
>>
>> select * from PRODUCT;
>>
>> 2017-11-22 17:03 GMT+00:00 Javier :
>>
>>> Hello Mike,
>>>
>>> I have changed in mail of  22 de noviembre de 2017, 8:32
>>>
>>> The Category is already created from Ofbiz web interface (manually).
>>>
>>> Now, I'm loading.
>>>
>>> Best regards
>>>
>>> 2017-11-22 14:54 GMT+00:00 Mike :
>>>
 Regarding:

   >>> PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
 productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
 isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
 lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
 lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
 16:32:57.0"/>

 Right off the bat I see that "productID" is not "productId".  I'm pretty
 sure that won't work.  The beginning ">>> table, and ONLY the columns in that table are legal for each of the
 lines
 in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
 Neither
 "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId"
 should be "productTypeId".  It also looks like "inShippingBox" does not
 exist in the product table.  You must be precise with all the table
 names
 and column names.

 This is why I said you must become very familiar with the ofbiz schema.
 When creating seed data, you can log into the database and list all the
 legal columns (i.e. for the product table).  Here is an example for
 postgresql:

 ofbiz=# \d product
  primary_product_category_id  | character varying(255)   |
  manufacturer_party_id| character varying(255)   |
  facility_id  | character varying(255)   |
  introduction_date| timestamp with time zone |
  release_date | timestamp with time zone |
  support_discontinuation_date | timestamp with time zone |
  sales_discontinuation_date   | timestamp with time zone |
  sales_disc_when_not_avail| character(1) |
  internal_name| text |
  brand_name   | character varying(255)   |
  comments | text |
  product_name | character varying(255)   |
  description  | text |
  long_description | text |
  price_detail_text| text |
  small_image_url  | character varying(2000)  |
  medium_image_url | character varying(2000)  |
  large_image_url  | character varying(2000)  |
  detail_image_url | character varying(2000)  |
  original_image_url   | character varying(2000)  |
  detail_screen| character varying(255)   |
  inventory_message| text |
  require_inventory| character(1) |
  inventory_item_type_id   | character varying(255)   |
  quantity_uom_id  | character varying(255)   |
  quantity_included| numeric(18,6)|
  pieces_included  | numeric(20,0)|
  require_amount   | character(1) |
  fixed_amount | numeric(18,2)|
  amount_uom_type_id   | character varying(255)   |
  weight_uom_id| character varying(255)   |
  weight

Re: File format to import products

[Javier]

Sorry Mike, you were right.

I forgot to remove PRICE and TAX from Product.xml file, but they were still
imported.

2017-11-22 17:21 GMT+00:00 Javier :

> As Pierre said, the price has to be with a '.' for decimals.
>
>
> 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
>|W| Could not set field ProductPrice.price to the value 8,99
> java.lang.NumberFormatException
> at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
> at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
> at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
> at org.apache.ofbiz.entity.GenericEntity.setString(GenericEntity.java:574)
> ~[ofbiz.jar:?]
> at 
> org.apache.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:579)
> [ofbiz.jar:?]
> > Buildiat org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown
> Source) [xercesImpl-2.9.1.jar:?]
> > Buildiat 
> > org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown
> Source) [xercesImpl-2.9.1.jar:?]
> at 
> org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown
> Source) [xercesImpl-2.9.1.jar:?]
>
>
> 2017-11-22 17:14 GMT+00:00 Javier :
>
>> It's finished.
>>
>> Showing 1 - 20 of 95.094
>>
>> Now I going to load ProducPrice.xml, let's see if I have the same luck.
>>
>> Thanks very much to alls!
>>
>> Best regards.
>>
>> 2017-11-22 17:09 GMT+00:00 Javier :
>>
>>> It's not over yet, but I made a query to the Products table, and
>>> surprise, there are products :)
>>>
>>> select * from PRODUCT;
>>>
>>> 2017-11-22 17:03 GMT+00:00 Javier :
>>>
 Hello Mike,

 I have changed in mail of  22 de noviembre de 2017, 8:32

 The Category is already created from Ofbiz web interface (manually).

 Now, I'm loading.

 Best regards

 2017-11-22 14:54 GMT+00:00 Mike :

> Regarding:
>
>    PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> D_INV_ITEM"
> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
> lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> createdStamp="2017-11-21
> 16:32:57.0"/>
>
> Right off the bat I see that "productID" is not "productId".  I'm
> pretty
> sure that won't work.  The beginning " table, and ONLY the columns in that table are legal for each of the
> lines
> in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
> Neither
> "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId"
> should be "productTypeId".  It also looks like "inShippingBox" does not
> exist in the product table.  You must be precise with all the table
> names
> and column names.
>
> This is why I said you must become very familiar with the ofbiz schema.
> When creating seed data, you can log into the database and list all the
> legal columns (i.e. for the product table).  Here is an example for
> postgresql:
>
> ofbiz=# \d product
>  primary_product_category_id  | character varying(255)   |
>  manufacturer_party_id| character varying(255)   |
>  facility_id  | character varying(255)   |
>  introduction_date| timestamp with time zone |
>  release_date | timestamp with time zone |
>  support_discontinuation_date | timestamp with time zone |
>  sales_discontinuation_date   | timestamp with time zone |
>  sales_disc_when_not_avail| character(1) |
>  internal_name| text |
>  brand_name   | character varying(255)   |
>  comments | text |
>  product_name | character varying(255)   |
>  description  | text |
>  long_description | text |
>  price_detail_text| text |
>  small_image_url  | character varying(2000)  |
>  medium_image_url | character varying(2000)  |
>  large_image_url  | character varying(2000)  |
>  detail_image_url | character varying(2000)  |
>  original_image_url   | character varying(2000)  |
>  detail_screen| character varying(255)   |
>  inventory_message| text |
>  require_inventory| character(1) |
>  inventory_item_type_id   | character varying(255)   |
>  quantity_uom_id  | character varying(255)   |
>  quantity_included| numeric(18,6)|
>  pieces_included 

Re: File format to import products

[Mike]

Javier.  Study my original post of one category and one product.  I gave
away the keys to the kingdom there [grin].  I would ditch the idea of one
category.  That is not realistic.  Do it right and create seed data that
reflects the true tree structure of the categories, and then import the
products with the correctly assigned categories.  Also, other content (like
images) should be filled in.  Good luck.


On Wed, Nov 22, 2017 at 9:42 AM, Javier  wrote:

> Sorry Mike, you were right.
>
> I forgot to remove PRICE and TAX from Product.xml file, but they were still
> imported.
>
> 2017-11-22 17:21 GMT+00:00 Javier :
>
> > As Pierre said, the price has to be with a '.' for decimals.
> >
> >
> > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> >|W| Could not set field ProductPrice.price to the value 8,99
> > java.lang.NumberFormatException
> > at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
> > at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
> > at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
> > at org.apache.ofbiz.entity.GenericEntity.setString(
> GenericEntity.java:574)
> > ~[ofbiz.jar:?]
> > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> EntitySaxReader.java:579)
> > [ofbiz.jar:?]
> > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> startElement(Unknown
> > Source) [xercesImpl-2.9.1.jar:?]
> > > Buildiat org.apache.xerces.parsers.AbstractXMLDocumentParser.
> emptyElement(Unknown
> > Source) [xercesImpl-2.9.1.jar:?]
> > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> .scanStartElement(Unknown
> > Source) [xercesImpl-2.9.1.jar:?]
> >
> >
> > 2017-11-22 17:14 GMT+00:00 Javier :
> >
> >> It's finished.
> >>
> >> Showing 1 - 20 of 95.094
> >>
> >> Now I going to load ProducPrice.xml, let's see if I have the same luck.
> >>
> >> Thanks very much to alls!
> >>
> >> Best regards.
> >>
> >> 2017-11-22 17:09 GMT+00:00 Javier :
> >>
> >>> It's not over yet, but I made a query to the Products table, and
> >>> surprise, there are products :)
> >>>
> >>> select * from PRODUCT;
> >>>
> >>> 2017-11-22 17:03 GMT+00:00 Javier :
> >>>
>  Hello Mike,
> 
>  I have changed in mail of  22 de noviembre de 2017, 8:32
> 
>  The Category is already created from Ofbiz web interface (manually).
> 
>  Now, I'm loading.
> 
>  Best regards
> 
>  2017-11-22 14:54 GMT+00:00 Mike :
> 
> > Regarding:
> >
> >> PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> > D_INV_ITEM"
> > isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
> > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> > 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="
> admin"
> > lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> > createdStamp="2017-11-21
> > 16:32:57.0"/>
> >
> > Right off the bat I see that "productID" is not "productId".  I'm
> > pretty
> > sure that won't work.  The beginning " "product"
> > table, and ONLY the columns in that table are legal for each of the
> > lines
> > in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
> > Neither
> > "Price" or "Tax" are in the product table. Also,
> "inventoryItemTypeId"
> > should be "productTypeId".  It also looks like "inShippingBox" does
> not
> > exist in the product table.  You must be precise with all the table
> > names
> > and column names.
> >
> > This is why I said you must become very familiar with the ofbiz
> schema.
> > When creating seed data, you can log into the database and list all
> the
> > legal columns (i.e. for the product table).  Here is an example for
> > postgresql:
> >
> > ofbiz=# \d product
> >  primary_product_category_id  | character varying(255)   |
> >  manufacturer_party_id| character varying(255)   |
> >  facility_id  | character varying(255)   |
> >  introduction_date| timestamp with time zone |
> >  release_date | timestamp with time zone |
> >  support_discontinuation_date | timestamp with time zone |
> >  sales_discontinuation_date   | timestamp with time zone |
> >  sales_disc_when_not_avail| character(1) |
> >  internal_name| text |
> >  brand_name   | character varying(255)   |
> >  comments | text |
> >  product_name | character varying(255)   |
> >  description  | text |
> >  long_description | text |
> >  price_detail_text| text |
> >  small_image_url  | characte

Re: File format to import products

[Pierre Smits]

Hi Javier,

How much time did this import take?

Best regards,

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OEM - The OFBiz Extensions Marketplace1
http://oem.ofbizci.net/oci-2/
1 not affiliated to (and not endorsed by) the OFBiz project

On Wed, Nov 22, 2017 at 6:57 PM, Mike  wrote:

> Javier.  Study my original post of one category and one product.  I gave
> away the keys to the kingdom there [grin].  I would ditch the idea of one
> category.  That is not realistic.  Do it right and create seed data that
> reflects the true tree structure of the categories, and then import the
> products with the correctly assigned categories.  Also, other content (like
> images) should be filled in.  Good luck.
>
>
> On Wed, Nov 22, 2017 at 9:42 AM, Javier  wrote:
>
> > Sorry Mike, you were right.
> >
> > I forgot to remove PRICE and TAX from Product.xml file, but they were
> still
> > imported.
> >
> > 2017-11-22 17:21 GMT+00:00 Javier :
> >
> > > As Pierre said, the price has to be with a '.' for decimals.
> > >
> > >
> > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> > >|W| Could not set field ProductPrice.price to the value 8,99
> > > java.lang.NumberFormatException
> > > at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
> > > at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
> > > at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
> > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > GenericEntity.java:574)
> > > ~[ofbiz.jar:?]
> > > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> > EntitySaxReader.java:579)
> > > [ofbiz.jar:?]
> > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > startElement(Unknown
> > > Source) [xercesImpl-2.9.1.jar:?]
> > > > Buildiat org.apache.xerces.parsers.AbstractXMLDocumentParser.
> > emptyElement(Unknown
> > > Source) [xercesImpl-2.9.1.jar:?]
> > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > .scanStartElement(Unknown
> > > Source) [xercesImpl-2.9.1.jar:?]
> > >
> > >
> > > 2017-11-22 17:14 GMT+00:00 Javier :
> > >
> > >> It's finished.
> > >>
> > >> Showing 1 - 20 of 95.094
> > >>
> > >> Now I going to load ProducPrice.xml, let's see if I have the same
> luck.
> > >>
> > >> Thanks very much to alls!
> > >>
> > >> Best regards.
> > >>
> > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > >>
> > >>> It's not over yet, but I made a query to the Products table, and
> > >>> surprise, there are products :)
> > >>>
> > >>> select * from PRODUCT;
> > >>>
> > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > >>>
> >  Hello Mike,
> > 
> >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > 
> >  The Category is already created from Ofbiz web interface (manually).
> > 
> >  Now, I'm loading.
> > 
> >  Best regards
> > 
> >  2017-11-22 14:54 GMT+00:00 Mike :
> > 
> > > Regarding:
> > >
> > >> > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > > productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> > > D_INV_ITEM"
> > > isVirtual="N" isVariant="N" inShippingBox="N"
> createdDate="2017-11-21
> > > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > > lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
> > > 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="
> > admin"
> > > lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> > > createdStamp="2017-11-21
> > > 16:32:57.0"/>
> > >
> > > Right off the bat I see that "productID" is not "productId".  I'm
> > > pretty
> > > sure that won't work.  The beginning " > "product"
> > > table, and ONLY the columns in that table are legal for each of the
> > > lines
> > > in your ofbiz XML.  For instance, you have "PRICE="0,6" TAX="7"...
> > > Neither
> > > "Price" or "Tax" are in the product table. Also,
> > "inventoryItemTypeId"
> > > should be "productTypeId".  It also looks like "inShippingBox" does
> > not
> > > exist in the product table.  You must be precise with all the table
> > > names
> > > and column names.
> > >
> > > This is why I said you must become very familiar with the ofbiz
> > schema.
> > > When creating seed data, you can log into the database and list all
> > the
> > > legal columns (i.e. for the product table).  Here is an example for
> > > postgresql:
> > >
> > > ofbiz=# \d product
> > >  primary_product_category_id  | character varying(255)   |
> > >  manufacturer_party_id| character varying(255)   |
> > >  facility_id  | character varying(255)   |
> > >  introduction_date| timestamp with time zone |
> > >  release_date | timestamp with time zone |
> > >  support_discontinuation_date | timestamp with time zone |
> > >  sales_discontinuation_date   | timestamp with time zone |
> > >  s

Re: File format to import products

[Javier]

10 minutes, much less than understanding it.

2017-11-22 18:26 GMT+00:00 Pierre Smits :

> Hi Javier,
>
> How much time did this import take?
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OEM - The OFBiz Extensions Marketplace1
> http://oem.ofbizci.net/oci-2/
> 1 not affiliated to (and not endorsed by) the OFBiz project
>
> On Wed, Nov 22, 2017 at 6:57 PM, Mike  wrote:
>
> > Javier.  Study my original post of one category and one product.  I gave
> > away the keys to the kingdom there [grin].  I would ditch the idea of one
> > category.  That is not realistic.  Do it right and create seed data that
> > reflects the true tree structure of the categories, and then import the
> > products with the correctly assigned categories.  Also, other content
> (like
> > images) should be filled in.  Good luck.
> >
> >
> > On Wed, Nov 22, 2017 at 9:42 AM, Javier  wrote:
> >
> > > Sorry Mike, you were right.
> > >
> > > I forgot to remove PRICE and TAX from Product.xml file, but they were
> > still
> > > imported.
> > >
> > > 2017-11-22 17:21 GMT+00:00 Javier :
> > >
> > > > As Pierre said, the price has to be with a '.' for decimals.
> > > >
> > > >
> > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> > > >|W| Could not set field ProductPrice.price to the value 8,99
> > > > java.lang.NumberFormatException
> > > > at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
> > > > at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
> > > > at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
> > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > GenericEntity.java:574)
> > > > ~[ofbiz.jar:?]
> > > > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> > > EntitySaxReader.java:579)
> > > > [ofbiz.jar:?]
> > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > startElement(Unknown
> > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > Buildiat org.apache.xerces.parsers.AbstractXMLDocumentParser.
> > > emptyElement(Unknown
> > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > .scanStartElement(Unknown
> > > > Source) [xercesImpl-2.9.1.jar:?]
> > > >
> > > >
> > > > 2017-11-22 17:14 GMT+00:00 Javier :
> > > >
> > > >> It's finished.
> > > >>
> > > >> Showing 1 - 20 of 95.094
> > > >>
> > > >> Now I going to load ProducPrice.xml, let's see if I have the same
> > luck.
> > > >>
> > > >> Thanks very much to alls!
> > > >>
> > > >> Best regards.
> > > >>
> > > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > > >>
> > > >>> It's not over yet, but I made a query to the Products table, and
> > > >>> surprise, there are products :)
> > > >>>
> > > >>> select * from PRODUCT;
> > > >>>
> > > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > > >>>
> > >  Hello Mike,
> > > 
> > >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > > 
> > >  The Category is already created from Ofbiz web interface
> (manually).
> > > 
> > >  Now, I'm loading.
> > > 
> > >  Best regards
> > > 
> > >  2017-11-22 14:54 GMT+00:00 Mike :
> > > 
> > > > Regarding:
> > > >
> > > >> > > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > > > productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> > > > D_INV_ITEM"
> > > > isVirtual="N" isVariant="N" inShippingBox="N"
> > createdDate="2017-11-21
> > > > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > > > lastUpdatedStamp="2017-11-21 16:33:21.0"
> createdTxStamp="2017-11-21
> > > > 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="
> > > admin"
> > > > lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> > > > createdStamp="2017-11-21
> > > > 16:32:57.0"/>
> > > >
> > > > Right off the bat I see that "productID" is not "productId".  I'm
> > > > pretty
> > > > sure that won't work.  The beginning " > > "product"
> > > > table, and ONLY the columns in that table are legal for each of
> the
> > > > lines
> > > > in your ofbiz XML.  For instance, you have "PRICE="0,6"
> TAX="7"...
> > > > Neither
> > > > "Price" or "Tax" are in the product table. Also,
> > > "inventoryItemTypeId"
> > > > should be "productTypeId".  It also looks like "inShippingBox"
> does
> > > not
> > > > exist in the product table.  You must be precise with all the
> table
> > > > names
> > > > and column names.
> > > >
> > > > This is why I said you must become very familiar with the ofbiz
> > > schema.
> > > > When creating seed data, you can log into the database and list
> all
> > > the
> > > > legal columns (i.e. for the product table).  Here is an example
> for
> > > > postgresql:
> > > >
> > > > ofbiz=# \d product
> > > >  primary_product_category_id  | character varying(255)   |
> > > >  manufacturer_party_id| character 

Re: File format to import products

[Pierre Smits]

And how much time did it take you to get everything prepared?

Pierre Smits

ORRTIZ.COM 
OFBiz based solutions & services

OEM - The OFBiz Extensions Marketplace1
http://oem.ofbizci.net/oci-2/
1 not affiliated to (and not endorsed by) the OFBiz project

On Wed, Nov 22, 2017 at 8:35 PM, Javier  wrote:

> 10 minutes, much less than understanding it.
>
> 2017-11-22 18:26 GMT+00:00 Pierre Smits :
>
> > Hi Javier,
> >
> > How much time did this import take?
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > ORRTIZ.COM 
> > OFBiz based solutions & services
> >
> > OEM - The OFBiz Extensions Marketplace1
> > http://oem.ofbizci.net/oci-2/
> > 1 not affiliated to (and not endorsed by) the OFBiz project
> >
> > On Wed, Nov 22, 2017 at 6:57 PM, Mike  wrote:
> >
> > > Javier.  Study my original post of one category and one product.  I
> gave
> > > away the keys to the kingdom there [grin].  I would ditch the idea of
> one
> > > category.  That is not realistic.  Do it right and create seed data
> that
> > > reflects the true tree structure of the categories, and then import the
> > > products with the correctly assigned categories.  Also, other content
> > (like
> > > images) should be filled in.  Good luck.
> > >
> > >
> > > On Wed, Nov 22, 2017 at 9:42 AM, Javier  wrote:
> > >
> > > > Sorry Mike, you were right.
> > > >
> > > > I forgot to remove PRICE and TAX from Product.xml file, but they were
> > > still
> > > > imported.
> > > >
> > > > 2017-11-22 17:21 GMT+00:00 Javier :
> > > >
> > > > > As Pierre said, the price has to be with a '.' for decimals.
> > > > >
> > > > >
> > > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> > > > >|W| Could not set field ProductPrice.price to the value 8,99
> > > > > java.lang.NumberFormatException
> > > > > at java.math.BigDecimal.(BigDecimal.java:494) ~[?:1.8.0_151]
> > > > > at java.math.BigDecimal.(BigDecimal.java:383) ~[?:1.8.0_151]
> > > > > at java.math.BigDecimal.(BigDecimal.java:806) ~[?:1.8.0_151]
> > > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > > GenericEntity.java:574)
> > > > > ~[ofbiz.jar:?]
> > > > > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> > > > EntitySaxReader.java:579)
> > > > > [ofbiz.jar:?]
> > > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > > startElement(Unknown
> > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > Buildiat org.apache.xerces.parsers.AbstractXMLDocumentParser.
> > > > emptyElement(Unknown
> > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > > .scanStartElement(Unknown
> > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > >
> > > > >
> > > > > 2017-11-22 17:14 GMT+00:00 Javier :
> > > > >
> > > > >> It's finished.
> > > > >>
> > > > >> Showing 1 - 20 of 95.094
> > > > >>
> > > > >> Now I going to load ProducPrice.xml, let's see if I have the same
> > > luck.
> > > > >>
> > > > >> Thanks very much to alls!
> > > > >>
> > > > >> Best regards.
> > > > >>
> > > > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > > > >>
> > > > >>> It's not over yet, but I made a query to the Products table, and
> > > > >>> surprise, there are products :)
> > > > >>>
> > > > >>> select * from PRODUCT;
> > > > >>>
> > > > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > > > >>>
> > > >  Hello Mike,
> > > > 
> > > >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > > > 
> > > >  The Category is already created from Ofbiz web interface
> > (manually).
> > > > 
> > > >  Now, I'm loading.
> > > > 
> > > >  Best regards
> > > > 
> > > >  2017-11-22 14:54 GMT+00:00 Mike :
> > > > 
> > > > > Regarding:
> > > > >
> > > > >> > > > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > > > > productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> > > > > D_INV_ITEM"
> > > > > isVirtual="N" isVariant="N" inShippingBox="N"
> > > createdDate="2017-11-21
> > > > > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > > > > lastUpdatedStamp="2017-11-21 16:33:21.0"
> > createdTxStamp="2017-11-21
> > > > > 16:33:21.0" createdByUserLogin="admin"
> lastModifiedByUserLogin="
> > > > admin"
> > > > > lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> > > > > createdStamp="2017-11-21
> > > > > 16:32:57.0"/>
> > > > >
> > > > > Right off the bat I see that "productID" is not "productId".
> I'm
> > > > > pretty
> > > > > sure that won't work.  The beginning " > > > "product"
> > > > > table, and ONLY the columns in that table are legal for each of
> > the
> > > > > lines
> > > > > in your ofbiz XML.  For instance, you have "PRICE="0,6"
> > TAX="7"...
> > > > > Neither
> > > > > "Price" or "Tax" are in the product table. Also,
> > > > "inventoryItemTypeId"
> > > > > should be "productTypeId".  It also looks like "inShippingBox"
> > does
> > > > not

Re: File format to import products

[Javier]

One or Two hours, I don't know to use xmlstarlet, but it's funny.

2017-11-23 14:15 GMT+00:00 Pierre Smits :

> And how much time did it take you to get everything prepared?
>
> Pierre Smits
>
> ORRTIZ.COM 
> OFBiz based solutions & services
>
> OEM - The OFBiz Extensions Marketplace1
> http://oem.ofbizci.net/oci-2/
> 1 not affiliated to (and not endorsed by) the OFBiz project
>
> On Wed, Nov 22, 2017 at 8:35 PM, Javier  wrote:
>
> > 10 minutes, much less than understanding it.
> >
> > 2017-11-22 18:26 GMT+00:00 Pierre Smits :
> >
> > > Hi Javier,
> > >
> > > How much time did this import take?
> > >
> > > Best regards,
> > >
> > > Pierre Smits
> > >
> > > ORRTIZ.COM 
> > > OFBiz based solutions & services
> > >
> > > OEM - The OFBiz Extensions Marketplace1
> > > http://oem.ofbizci.net/oci-2/
> > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > >
> > > On Wed, Nov 22, 2017 at 6:57 PM, Mike  wrote:
> > >
> > > > Javier.  Study my original post of one category and one product.  I
> > gave
> > > > away the keys to the kingdom there [grin].  I would ditch the idea of
> > one
> > > > category.  That is not realistic.  Do it right and create seed data
> > that
> > > > reflects the true tree structure of the categories, and then import
> the
> > > > products with the correctly assigned categories.  Also, other content
> > > (like
> > > > images) should be filled in.  Good luck.
> > > >
> > > >
> > > > On Wed, Nov 22, 2017 at 9:42 AM, Javier  wrote:
> > > >
> > > > > Sorry Mike, you were right.
> > > > >
> > > > > I forgot to remove PRICE and TAX from Product.xml file, but they
> were
> > > > still
> > > > > imported.
> > > > >
> > > > > 2017-11-22 17:21 GMT+00:00 Javier :
> > > > >
> > > > > > As Pierre said, the price has to be with a '.' for decimals.
> > > > > >
> > > > > >
> > > > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> > > > > >|W| Could not set field ProductPrice.price to the value 8,99
> > > > > > java.lang.NumberFormatException
> > > > > > at java.math.BigDecimal.(BigDecimal.java:494)
> ~[?:1.8.0_151]
> > > > > > at java.math.BigDecimal.(BigDecimal.java:383)
> ~[?:1.8.0_151]
> > > > > > at java.math.BigDecimal.(BigDecimal.java:806)
> ~[?:1.8.0_151]
> > > > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > > > GenericEntity.java:574)
> > > > > > ~[ofbiz.jar:?]
> > > > > > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> > > > > EntitySaxReader.java:579)
> > > > > > [ofbiz.jar:?]
> > > > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > > > startElement(Unknown
> > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > Buildiat org.apache.xerces.parsers.AbstractXMLDocumentParser.
> > > > > emptyElement(Unknown
> > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > > > .scanStartElement(Unknown
> > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > >
> > > > > >
> > > > > > 2017-11-22 17:14 GMT+00:00 Javier :
> > > > > >
> > > > > >> It's finished.
> > > > > >>
> > > > > >> Showing 1 - 20 of 95.094
> > > > > >>
> > > > > >> Now I going to load ProducPrice.xml, let's see if I have the
> same
> > > > luck.
> > > > > >>
> > > > > >> Thanks very much to alls!
> > > > > >>
> > > > > >> Best regards.
> > > > > >>
> > > > > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > > > > >>
> > > > > >>> It's not over yet, but I made a query to the Products table,
> and
> > > > > >>> surprise, there are products :)
> > > > > >>>
> > > > > >>> select * from PRODUCT;
> > > > > >>>
> > > > > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > > > > >>>
> > > > >  Hello Mike,
> > > > > 
> > > > >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > > > > 
> > > > >  The Category is already created from Ofbiz web interface
> > > (manually).
> > > > > 
> > > > >  Now, I'm loading.
> > > > > 
> > > > >  Best regards
> > > > > 
> > > > >  2017-11-22 14:54 GMT+00:00 Mike :
> > > > > 
> > > > > > Regarding:
> > > > > >
> > > > > >> > > > > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > > > > > productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE
> > > > > > D_INV_ITEM"
> > > > > > isVirtual="N" isVariant="N" inShippingBox="N"
> > > > createdDate="2017-11-21
> > > > > > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > > > > > lastUpdatedStamp="2017-11-21 16:33:21.0"
> > > createdTxStamp="2017-11-21
> > > > > > 16:33:21.0" createdByUserLogin="admin"
> > lastModifiedByUserLogin="
> > > > > admin"
> > > > > > lotIdFilledIn="Allowed" billOfMaterialLevel="0"
> > > > > > createdStamp="2017-11-21
> > > > > > 16:32:57.0"/>
> > > > > >
> > > > > > Right off the bat I see that "productID" is not "productId".
> > I'm
> > > > > > pretty
> > > > > > sure that won't work.  The beginning " > > > > "product"
> > 

Re: File format to import products

[Mike]

Javier.  I'd recommend you reduce your sample set to just 2-3 products (to
save time) until all the tables/columns are importing proper.

On Thu, Nov 23, 2017 at 7:08 AM, Javier  wrote:

> One or Two hours, I don't know to use xmlstarlet, but it's funny.
>
> 2017-11-23 14:15 GMT+00:00 Pierre Smits :
>
> > And how much time did it take you to get everything prepared?
> >
> > Pierre Smits
> >
> > ORRTIZ.COM 
> > OFBiz based solutions & services
> >
> > OEM - The OFBiz Extensions Marketplace1
> > http://oem.ofbizci.net/oci-2/
> > 1 not affiliated to (and not endorsed by) the OFBiz project
> >
> > On Wed, Nov 22, 2017 at 8:35 PM, Javier  wrote:
> >
> > > 10 minutes, much less than understanding it.
> > >
> > > 2017-11-22 18:26 GMT+00:00 Pierre Smits :
> > >
> > > > Hi Javier,
> > > >
> > > > How much time did this import take?
> > > >
> > > > Best regards,
> > > >
> > > > Pierre Smits
> > > >
> > > > ORRTIZ.COM 
> > > > OFBiz based solutions & services
> > > >
> > > > OEM - The OFBiz Extensions Marketplace1
> > > > http://oem.ofbizci.net/oci-2/
> > > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > > >
> > > > On Wed, Nov 22, 2017 at 6:57 PM, Mike  wrote:
> > > >
> > > > > Javier.  Study my original post of one category and one product.  I
> > > gave
> > > > > away the keys to the kingdom there [grin].  I would ditch the idea
> of
> > > one
> > > > > category.  That is not realistic.  Do it right and create seed data
> > > that
> > > > > reflects the true tree structure of the categories, and then import
> > the
> > > > > products with the correctly assigned categories.  Also, other
> content
> > > > (like
> > > > > images) should be filled in.  Good luck.
> > > > >
> > > > >
> > > > > On Wed, Nov 22, 2017 at 9:42 AM, Javier 
> wrote:
> > > > >
> > > > > > Sorry Mike, you were right.
> > > > > >
> > > > > > I forgot to remove PRICE and TAX from Product.xml file, but they
> > were
> > > > > still
> > > > > > imported.
> > > > > >
> > > > > > 2017-11-22 17:21 GMT+00:00 Javier :
> > > > > >
> > > > > > > As Pierre said, the price has to be with a '.' for decimals.
> > > > > > >
> > > > > > >
> > > > > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8 |EntitySaxReader
> > > > > > >|W| Could not set field ProductPrice.price to the value 8,99
> > > > > > > java.lang.NumberFormatException
> > > > > > > at java.math.BigDecimal.(BigDecimal.java:494)
> > ~[?:1.8.0_151]
> > > > > > > at java.math.BigDecimal.(BigDecimal.java:383)
> > ~[?:1.8.0_151]
> > > > > > > at java.math.BigDecimal.(BigDecimal.java:806)
> > ~[?:1.8.0_151]
> > > > > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > > > > GenericEntity.java:574)
> > > > > > > ~[ofbiz.jar:?]
> > > > > > > at org.apache.ofbiz.entity.util.EntitySaxReader.startElement(
> > > > > > EntitySaxReader.java:579)
> > > > > > > [ofbiz.jar:?]
> > > > > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > > > > startElement(Unknown
> > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > > Buildiat org.apache.xerces.parsers.
> AbstractXMLDocumentParser.
> > > > > > emptyElement(Unknown
> > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > > > > .scanStartElement(Unknown
> > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > >
> > > > > > >
> > > > > > > 2017-11-22 17:14 GMT+00:00 Javier :
> > > > > > >
> > > > > > >> It's finished.
> > > > > > >>
> > > > > > >> Showing 1 - 20 of 95.094
> > > > > > >>
> > > > > > >> Now I going to load ProducPrice.xml, let's see if I have the
> > same
> > > > > luck.
> > > > > > >>
> > > > > > >> Thanks very much to alls!
> > > > > > >>
> > > > > > >> Best regards.
> > > > > > >>
> > > > > > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > > > > > >>
> > > > > > >>> It's not over yet, but I made a query to the Products table,
> > and
> > > > > > >>> surprise, there are products :)
> > > > > > >>>
> > > > > > >>> select * from PRODUCT;
> > > > > > >>>
> > > > > > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > > > > > >>>
> > > > > >  Hello Mike,
> > > > > > 
> > > > > >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > > > > > 
> > > > > >  The Category is already created from Ofbiz web interface
> > > > (manually).
> > > > > > 
> > > > > >  Now, I'm loading.
> > > > > > 
> > > > > >  Best regards
> > > > > > 
> > > > > >  2017-11-22 14:54 GMT+00:00 Mike :
> > > > > > 
> > > > > > > Regarding:
> > > > > > >
> > > > > > >> > > > > > PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
> > > > > > > productTypeId="FINISHED_GOOD"
> inventoryItemTypeId="SERIALIZE
> > > > > > > D_INV_ITEM"
> > > > > > > isVirtual="N" isVariant="N" inShippingBox="N"
> > > > > createdDate="2017-11-21
> > > > > > > 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
> > > > > > > lastUpdatedStamp="2017-11-21 16:33:21.0"

Re: File format to import products

[Javier]

Thank you!

2017-11-23 16:47 GMT+00:00 Mike :

> Javier.  I'd recommend you reduce your sample set to just 2-3 products (to
> save time) until all the tables/columns are importing proper.
>
> On Thu, Nov 23, 2017 at 7:08 AM, Javier  wrote:
>
> > One or Two hours, I don't know to use xmlstarlet, but it's funny.
> >
> > 2017-11-23 14:15 GMT+00:00 Pierre Smits :
> >
> > > And how much time did it take you to get everything prepared?
> > >
> > > Pierre Smits
> > >
> > > ORRTIZ.COM 
> > > OFBiz based solutions & services
> > >
> > > OEM - The OFBiz Extensions Marketplace1
> > > http://oem.ofbizci.net/oci-2/
> > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > >
> > > On Wed, Nov 22, 2017 at 8:35 PM, Javier  wrote:
> > >
> > > > 10 minutes, much less than understanding it.
> > > >
> > > > 2017-11-22 18:26 GMT+00:00 Pierre Smits :
> > > >
> > > > > Hi Javier,
> > > > >
> > > > > How much time did this import take?
> > > > >
> > > > > Best regards,
> > > > >
> > > > > Pierre Smits
> > > > >
> > > > > ORRTIZ.COM 
> > > > > OFBiz based solutions & services
> > > > >
> > > > > OEM - The OFBiz Extensions Marketplace1
> > > > > http://oem.ofbizci.net/oci-2/
> > > > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > > > >
> > > > > On Wed, Nov 22, 2017 at 6:57 PM, Mike 
> wrote:
> > > > >
> > > > > > Javier.  Study my original post of one category and one
> product.  I
> > > > gave
> > > > > > away the keys to the kingdom there [grin].  I would ditch the
> idea
> > of
> > > > one
> > > > > > category.  That is not realistic.  Do it right and create seed
> data
> > > > that
> > > > > > reflects the true tree structure of the categories, and then
> import
> > > the
> > > > > > products with the correctly assigned categories.  Also, other
> > content
> > > > > (like
> > > > > > images) should be filled in.  Good luck.
> > > > > >
> > > > > >
> > > > > > On Wed, Nov 22, 2017 at 9:42 AM, Javier 
> > wrote:
> > > > > >
> > > > > > > Sorry Mike, you were right.
> > > > > > >
> > > > > > > I forgot to remove PRICE and TAX from Product.xml file, but
> they
> > > were
> > > > > > still
> > > > > > > imported.
> > > > > > >
> > > > > > > 2017-11-22 17:21 GMT+00:00 Javier :
> > > > > > >
> > > > > > > > As Pierre said, the price has to be with a '.' for decimals.
> > > > > > > >
> > > > > > > >
> > > > > > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8
> |EntitySaxReader
> > > > > > > >|W| Could not set field ProductPrice.price to the value
> 8,99
> > > > > > > > java.lang.NumberFormatException
> > > > > > > > at java.math.BigDecimal.(BigDecimal.java:494)
> > > ~[?:1.8.0_151]
> > > > > > > > at java.math.BigDecimal.(BigDecimal.java:383)
> > > ~[?:1.8.0_151]
> > > > > > > > at java.math.BigDecimal.(BigDecimal.java:806)
> > > ~[?:1.8.0_151]
> > > > > > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > > > > > GenericEntity.java:574)
> > > > > > > > ~[ofbiz.jar:?]
> > > > > > > > at org.apache.ofbiz.entity.util.
> EntitySaxReader.startElement(
> > > > > > > EntitySaxReader.java:579)
> > > > > > > > [ofbiz.jar:?]
> > > > > > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > > > > > startElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > > > Buildiat org.apache.xerces.parsers.
> > AbstractXMLDocumentParser.
> > > > > > > emptyElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > > > > > .scanStartElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > >
> > > > > > > >
> > > > > > > > 2017-11-22 17:14 GMT+00:00 Javier :
> > > > > > > >
> > > > > > > >> It's finished.
> > > > > > > >>
> > > > > > > >> Showing 1 - 20 of 95.094
> > > > > > > >>
> > > > > > > >> Now I going to load ProducPrice.xml, let's see if I have the
> > > same
> > > > > > luck.
> > > > > > > >>
> > > > > > > >> Thanks very much to alls!
> > > > > > > >>
> > > > > > > >> Best regards.
> > > > > > > >>
> > > > > > > >> 2017-11-22 17:09 GMT+00:00 Javier :
> > > > > > > >>
> > > > > > > >>> It's not over yet, but I made a query to the Products
> table,
> > > and
> > > > > > > >>> surprise, there are products :)
> > > > > > > >>>
> > > > > > > >>> select * from PRODUCT;
> > > > > > > >>>
> > > > > > > >>> 2017-11-22 17:03 GMT+00:00 Javier :
> > > > > > > >>>
> > > > > > >  Hello Mike,
> > > > > > > 
> > > > > > >  I have changed in mail of  22 de noviembre de 2017, 8:32
> > > > > > > 
> > > > > > >  The Category is already created from Ofbiz web interface
> > > > > (manually).
> > > > > > > 
> > > > > > >  Now, I'm loading.
> > > > > > > 
> > > > > > >  Best regards
> > > > > > > 
> > > > > > >  2017-11-22 14:54 GMT+00:00 Mike :
> > > > > > > 
> > > > > > > > Regarding:
> > > > > > > >
> > > > > > > >> > > > > > > PRICE="0,6" TAX="7" primaryProductCategoryI