Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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 -

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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"

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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 >

Re: File format to import products

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

Re: File format to import products

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.

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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.

Re: File format to import products

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

Re: File format to import products

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

Re: File format to import products

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

File format to import products

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