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 <droin...@gmail.com> 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 <pierre.sm...@gmail.com>: > > > And how much time did it take you to get everything prepared? > > > > Pierre Smits > > > > ORRTIZ.COM <http://www.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 <droin...@gmail.com> wrote: > > > > > 10 minutes, much less than understanding it. > > > > > > 2017-11-22 18:26 GMT+00:00 Pierre Smits <pierre.sm...@gmail.com>: > > > > > > > Hi Javier, > > > > > > > > How much time did this import take? > > > > > > > > Best regards, > > > > > > > > Pierre Smits > > > > > > > > ORRTIZ.COM <http://www.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 <mz4whee...@gmail.com> 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 <droin...@gmail.com> > 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 <droin...@gmail.com>: > > > > > > > > > > > > > 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.<init>(BigDecimal.java:494) > > ~[?:1.8.0_151] > > > > > > > at java.math.BigDecimal.<init>(BigDecimal.java:383) > > ~[?:1.8.0_151] > > > > > > > at java.math.BigDecimal.<init>(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 <droin...@gmail.com>: > > > > > > > > > > > > > >> 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 <droin...@gmail.com>: > > > > > > >> > > > > > > >>> 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 <droin...@gmail.com>: > > > > > > >>> > > > > > > >>>> 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 <mz4whee...@gmail.com>: > > > > > > >>>> > > > > > > >>>>> Regarding: > > > > > > >>>>> > > > > > > >>>>> <Product productID="JR119" productName="CONECTOR SOCKET > > 3POS > > > > IDC" > > > > > > >>>>> 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" signifies > the > > > > > > "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 | 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 | character varying(255) | > > > > > > >>>>> lot_id_filled_in | character varying(255) | > > > > > > >>>>> order_decimal_quantity | character(1) | > > > > > > >>>>> last_updated_stamp | timestamp with time zone | > > > > > > >>>>> last_updated_tx_stamp | timestamp with time zone | > > > > > > >>>>> created_stamp | timestamp with time zone | > > > > > > >>>>> created_tx_stamp | timestamp with time zone | > > > > > > >>>>> > > > > > > >>>>> For postgres, the column names have "_", but for the ofbiz > > XML, > > > > > they > > > > > > >>>>> are > > > > > > >>>>> camel cased. So "created_by_user_login" becomes > > > > > "CreatedByUserLogin" > > > > > > >>>>> (in > > > > > > >>>>> the XML). For mysql, you can use the command "describe > > > product;" > > > > > to > > > > > > >>>>> get a > > > > > > >>>>> similar output. Obviously, you don't need every single > > column, > > > > but > > > > > > >>>>> you'll > > > > > > >>>>> need images, right? So you'll want the insert the URLs > into > > > your > > > > > > seed > > > > > > >>>>> data. > > > > > > >>>>> > > > > > > >>>>> Not sure xmlstarlet is the right tool, but I think you are > on > > > the > > > > > > right > > > > > > >>>>> track. Start with the categories... > > > > > > >>>>> > > > > > > >>>>> > > > > > > >>>>> > > > > > > >>>>> On Wed, Nov 22, 2017 at 5:46 AM, pierre.gaudin < > > > > > > >>>>> pierre.gau...@nereide.fr> > > > > > > >>>>> 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 <droin...@gmail.com>: > > > > > > >>>>> >> > > > > > > >>>>> >> 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 > > > > > > >>>>> >>> > > > > > > >>>>> >>> <Product productID="JR119" productName="CONECTOR > > > SOCKET > > > > > 3POS > > > > > > >>>>> IDC" > > > > > > >>>>> >>> 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"/> > > > > > > >>>>> >>> > > > > > > >>>>> >>> <Product productID="JR120" productName="CONECTOR > > > SOCKET > > > > > 2POS > > > > > > >>>>> IDC" > > > > > > >>>>> >>> PRICE="0,49" 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"/> > > > > > > >>>>> >>> > > > > > > >>>>> >>> > > > > > > >>>>> >>> ProductPrice.xml > > > > > > >>>>> >>> > > > > > > >>>>> >>> <ProductPrice productID="JR119" price="0,6" > > > > > > taxPercentage="7" > > > > > > >>>>> >>> 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"/> > > > > > > >>>>> >>> > > > > > > >>>>> >>> <ProductPrice productID="JR120" price="0,49" > > > > > > taxPercentage="7" > > > > > > >>>>> >>> 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 <mz4whee...@gmail.com > >: > > > > > > >>>>> >>> > > > > > > >>>>> >>> 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 < > > > > droin...@gmail.com> > > > > > > >>>>> 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 < > mz4whee...@gmail.com > > >: > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>> 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... "10000" is top level, > > "10001" > > > is > > > > > > first > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> category. > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> <?xml version="1.0" encoding="UTF-8"?> > > > > > > >>>>> >>>>>> <entity-engine-xml> > > > > > > >>>>> >>>>>> <ProdCatalog prodCatalogId="10000" > > catalogName="Gallery" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> useQuickAdd="N" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> viewAllowPermReqd="N" purchaseAllowPermReqd="N" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> createdStamp="2017-11-05 > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductCategory productCategoryId="10000" > > > > > > >>>>> >>>>>> productCategoryTypeId="CATALOG_CATEGORY" > > > > > > categoryName="Gallery" > > > > > > >>>>> >>>>>> description="Gallery" createdStamp="2017-11-05 > > > 10:59:43"/> > > > > > > >>>>> >>>>>> <ProdCatalogCategory prodCatalogId="10000" > > > > > > >>>>> productCategoryId="10000" > > > > > > >>>>> >>>>>> prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" > > > > > > >>>>> fromDate="2017-11-05 > > > > > > >>>>> >>>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductCategory productCategoryId="Gallery_SEARCH" > > > > > > >>>>> >>>>>> productCategoryTypeId="SEARCH_CATEGORY" > > > > > categoryName="Gallery > > > > > > >>>>> Search" > > > > > > >>>>> >>>>>> description="Gallery Search" > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <ProdCatalogCategory prodCatalogId="10000" > > > > > > >>>>> >>>>>> productCategoryId="Gallery_SEARCH" > > > > > > prodCatalogCategoryTypeId=" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> PCCT_SEARCH" > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> fromDate="2017-11-05 10:59:43" > > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductStoreCatalog productStoreId="Gallery" > > > > > > >>>>> prodCatalogId="10000" > > > > > > >>>>> >>>>>> fromDate="2017-11-05 10:59:43" > > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="PROD_DESCRIPTION" > > > > > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> contentName="Product Description" > > > createdDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductCategory productCategoryId="10001" > > > > > > >>>>> >>>>>> productCategoryTypeId="CATALOG_CATEGORY" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> primaryParentCategoryId="10000" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> description="Games & Entertainment" > > > > > > createdStamp="2017-11-05 > > > > > > >>>>> >>>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductCategoryRollup productCategoryId="10001" > > > > > > >>>>> >>>>>> parentProductCategoryId="10000" sequenceNum="1" > > > > > > >>>>> fromDate="2017-11-05 > > > > > > >>>>> >>>>>> 10:59:43" createdStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <DataResource dataResourceId="10001Den" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="10001Den" > > textData="Games > > > > > & > > > > > > >>>>> >>>>>> Entertainment" createdStamp="2017-11-05 10:59:43" > > > > > > >>>>> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="10001Den" > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductCategoryContent productCategoryId="10001" > > > > > > >>>>> contentId="10001Den" > > > > > > >>>>> >>>>>> prodCatContentTypeId="CATEGORY_NAME" > > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43" > > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="10001Den" > > contentIdTo="10001Den" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <DataResource dataResourceId="10001Aen" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="10001Aen" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> textData="games-entertainment" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> createdStamp="2017-11-05 10:59:43" > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <Content contentId="10001Aen" > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ProductCategoryContent productCategoryId="10001" > > > > > > >>>>> contentId="10001Aen" > > > > > > >>>>> >>>>>> prodCatContentTypeId="ALTERNATIVE_URL" > > > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43" > > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="10001Aen" > > contentIdTo="10001Aen" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> </entity-engine-xml> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>> "one product" example: > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>> <?xml version="1.0" encoding="UTF-8"?> > > > > > > >>>>> >>>>>> <entity-engine-xml> > > > > > > >>>>> >>>>>> <Product productId="798936836182" > > > > > > productTypeId="FINISHED_GOOD" > > > > > > >>>>> >>>>>> primaryProductCategoryId="10002" > > > > > internalName="798936836182" > > > > > > >>>>> >>>>>> brandName="SELECTSOFT GAMES" comments="JEWEL CASE > > > > EVERYONE" > > > > > > >>>>> >>>>>> smallImageUrl="/images/products/10000/1001MINIGOLF/ > > > > > small.jpg" > > > > > > >>>>> >>>>>> mediumImageUrl="/images/ > products/10000/1001MINIGOLF/ > > > > > > medium.jpg" > > > > > > >>>>> >>>>>> largeImageUrl="/images/products/10000/1001MINIGOLF/ > > > > > large.jpg" > > > > > > >>>>> >>>>>> originalImageUrl="/images/ > > products/10000/1001MINIGOLF/ > > > > > origin > > > > > > >>>>> al.jpg" > > > > > > >>>>> >>>>>> detailImageUrl="/images/ > products/10000/1001MINIGOLF/ > > > > > > detail.jpg" > > > > > > >>>>> >>>>>> inventoryMessage="Ships from NashVille" > > > > requireInventory="N" > > > > > > >>>>> >>>>>> weightUomId="WT_lb" weight=".350000" > > > > productWeight=".350000" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductCategoryMember productCategoryId="10002" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductCategoryMember productCategoryId="Gallery_ > > > SEARCH" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductPrice productId="798936836182" > > > > > > >>>>> productPriceTypeId="DEFAULT_ > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductPrice productId="798936836182" > > > > > > >>>>> productPriceTypeId="LIST_PRICE > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> " > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductPrice productId="798936836182" > > > > > > >>>>> productPriceTypeId="WHOLESALE_ > > > > > > >>>>> >>>>>> PRICE" > > > > > > >>>>> >>>>>> productPricePurposeId="PURCHASE" > currencyUomId="USD" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> termUomId="OTH_ea" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> productStoreGroupId="_NA_" price="2.75" > > > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdDate="2017-11-05 10:59:43" > > > > > createdByUserLogin="admin"/> > > > > > > >>>>> >>>>>> <SupplierProduct productId="798936836182" > > > > partyId="Gallery" > > > > > > >>>>> >>>>>> availableFromDate="2017-11-05 10:59:43" > > > > > > >>>>> supplierPrefOrderId="10_MAIN_ > > > > > > >>>>> >>>>>> SUPPL" > > > > > > >>>>> >>>>>> standardLeadTimeDays="1" minimumOrderQuantity="1" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <GoodIdentification productId="798936836182" > > > > > > >>>>> >>>>>> goodIdentificationTypeId="UPCA" > > idValue="798936836182" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <ProductFacility productId="798936836182" > > > > > facilityId="Gallery" > > > > > > >>>>> >>>>>> lastInventoryCount="9.000000" > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <DataResource dataResourceId="798936836182Den" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="798936836182Den" > > > > > > textData="1001 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> MINIGOLF > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> CHALLENGE" createdStamp="2017-11-05 10:59:43" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> createdTxStamp="2017-11-05 > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="798936836182Den" > > > > > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> dataResourceId="798936836182Den" > > > description="DESCRIPTION > > > > > en > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 798936836182" > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductContent productId="798936836182" > > > > > > >>>>> contentId="798936836182Den" > > > > > > >>>>> >>>>>> productContentTypeId="DESCRIPTION" > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43" > > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="798936836182Den" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Den" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Den" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> contentAssocTypeId="SUB_CONTENT" > 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <DataResource dataResourceId="798936836182Aen" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="798936836182Aen" > > > > > > >>>>> >>>>>> textData="1001-minigolf-challenge" > > > > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="798936836182Aen" > > > > > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> dataResourceId="798936836182Aen" > description="ALT_URL > > > en > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 798936836182" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductContent productId="798936836182" > > > > > > >>>>> contentId="798936836182Aen" > > > > > > >>>>> >>>>>> productContentTypeId="ALTERNATIVE_URL" > > > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43" > > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="798936836182Aen" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Aen" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <DataResource dataResourceId="798936836182Len" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="798936836182Len" > > > > > > >>>>> textData="Welcome to > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> the > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> largest mini-golf course ever" > > createdStamp="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="798936836182Len" > > > > > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> dataResourceId="798936836182Len" > > > description="DESCRIPTION > > > > > en > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 798936836182" > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductContent productId="798936836182" > > > > > > >>>>> contentId="798936836182Len" > > > > > > >>>>> >>>>>> productContentTypeId="LONG_DESCRIPTION" > > > > > fromDate="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> createdStamp="2017-11-05 10:59:43" > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="798936836182Len" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Len" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Len" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> contentAssocTypeId="SUB_CONTENT" > 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <DataResource dataResourceId="798936836182Nen" > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ElectronicText dataResourceId="798936836182Nen" > > > > > > textData="1001 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> MINIGOLF > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> CHALLENGE" createdStamp="2017-11-05 10:59:43" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> createdTxStamp="2017-11-05 > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>>>> <Content contentId="798936836182Nen" > > > > > contentTypeId="DOCUMENT" > > > > > > >>>>> >>>>>> dataResourceId="798936836182Nen" > > > description="DESCRIPTION > > > > > en > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 798936836182" > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> 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"/> > > > > > > >>>>> >>>>>> <ProductContent productId="798936836182" > > > > > > >>>>> contentId="798936836182Nen" > > > > > > >>>>> >>>>>> productContentTypeId="PRODUCT_NAME" > > > fromDate="2017-11-05 > > > > > > >>>>> 10:59:43" > > > > > > >>>>> >>>>>> createdStamp="2017-11-05 10:59:43" > > > > > createdTxStamp="2017-11-05 > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> 10:59:43"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="798936836182Nen" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Nen" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>> contentIdTo="798936836182Nen" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> contentAssocTypeId="SUB_CONTENT" > 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"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> </entity-engine-xml> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>> On Fri, Nov 17, 2017 at 1:43 AM, Javier < > > > > droin...@gmail.com > > > > > > > > > > > > >>>>> 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 > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> <data-file name="Product" > separator-style="delimited" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> type-code="UTF-8" > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> delimiter="	" text-delimiter="" > > > > > > >>>>> >>>>>>> description="this takes the product data from > > doba > > > > > file" > > > > > > >>>>> >>>>>>> has-header="true"> > > > > > > >>>>> >>>>>>> <record name="Product"> > > > > > > >>>>> >>>>>>> <field name="productId" ignored="false" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="primaryProductCategoryId" > > > > > > >>>>> expression="true" > > > > > > >>>>> >>>>>>> default-value="dropShip" > type="String"/> > > > > > > >>>>> >>>>>>> <field name="productTypeId" > > expression="true" > > > > > > >>>>> >>>>>>> default-value="FINISHED_GOOD" > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="sku" ignored="true" > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="description" ignored="false" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="categories" ignored="true" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="image_url" ignored="true" > > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="brandName" ignored="false" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="longDescription" > > ignored="false" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> type="String"/> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> <field name="details" ignored="true" > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="weight" ignored="false" > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="weightUomId" > expression="true" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> default-value="WT_lb" > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="dimensions" ignored="true" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="going" ignored="true" > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="refurb" ignored="true" > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="freight" ignored="true" > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="productName" ignored="false" > > > > > > >>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="map" ignored="true" > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="price" ignored="true" > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="msrp" ignored="true" > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="quantityIncluded" > > > expression="true" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> default-value="1" > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="quantity" ignored="true" > > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="est_avail" ignored="true" > > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="expected_shipping_cost" > > > > > ignored="true" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> type="String"/> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>>> <field name="expected_drop_ship_fee" > > > > > ignored="true" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> type="String"/> > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>>> <field name="upc" ignored="true" > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="item_id" ignored="true" > > > > > type="String"/> > > > > > > >>>>> >>>>>>> <field name="isVirtual" expression="true" > > > > > > >>>>> default-value="N" > > > > > > >>>>> >>>>>>> type="String"/> > > > > > > >>>>> >>>>>>> <field name="isVariant" expression="true" > > > > > > >>>>> default-value="N" > > > > > > >>>>> >>>>>>> type="String"/> > > > > > > >>>>> >>>>>>> </record> > > > > > > >>>>> >>>>>>> </data-file> > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>>> but always I get this error "No <data-file> > elements > > > > found > > > > > > in > > > > > > >>>>> >>>>>>> file:/home/user/data-file.xml" > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>>> Best regards > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>>> 2017-11-17 9:30 GMT+00:00 Jacques Le Roux < > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>> jacques.le.r...@les7arts.com> > > > > > > >>>>> >>>>> > > > > > > >>>>> >>>>>> : > > > > > > >>>>> >>>>>> > > > > > > >>>>> >>>>>>> Le 17/11/2017 à 09:43, Javier H. a écrit : > > > > > > >>>>> >>>>>>>> > > > > > > >>>>> >>>>>>>> On 2017-11-17 08:05, Michael Brohl < > > > > > > michael.br...@ecomify.de> > > > > > > >>>>> >>>>>>>>> > > > > > > >>>>> >>>>>>>> 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."< > > droin...@gmail.com > > > > > > > > > > wrote: > > > > > > >>>>> >>>>>>>>>>> > > > > > > >>>>> >>>>>>>>>>> On 2017-11-14 08:02, "pierre.gaudin" < > > > > > > >>>>> >>>>>>>>>>>> > > > > > > >>>>> >>>>>>>>>>> pierre.gau...@nereide.fr> > > > > > > >>>>> >>>> > > > > > > >>>>> >>>>> 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: > > > > > > >>>>> >>>>>>>>>>> > > > > > > >>>>> >>>>>>>>>>> <?xml version="1.0" encoding="UTF-8" > > > > standalone="yes"?> > > > > > > >>>>> >>>>>>>>>>> <RECORDS> > > > > > > >>>>> >>>>>>>>>>> <RECORD> > > > > > > >>>>> >>>>>>>>>>> <ROW > > > > > > >>>>> >>>>>>>>>>> CODE="1308051" > > > > > > >>>>> >>>>>>>>>>> DESCR="DEMO PRODUCT" > > > > > > >>>>> >>>>>>>>>>> PRICE="5,50" > > > > > > >>>>> >>>>>>>>>>> TAX="21" > > > > > > >>>>> >>>>>>>>>>> QUANTITY="40" > > > > > > >>>>> >>>>>>>>>>> LASTPRICE="4,9" > > > > > > >>>>> >>>>>>>>>>> TAXCODE="3" > > > > > > >>>>> >>>>>>>>>>> PROVIDER="87" > > > > > > >>>>> >>>>>>>>>>> CATEGORY="00099" > > > > > > >>>>> >>>>>>>>>>> DATE="01012015" > > > > > > >>>>> >>>>>>>>>>> /> > > > > > > >>>>> >>>>>>>>>>> </RECORD> > > > > > > >>>>> >>>>>>>>>>> ..... > > > > > > >>>>> >>>>>>>>>>> </RECORDS> > > > > > > >>>>> >>>>>>>>>>> > > > > > > >>>>> >>>>>>>>>>> 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 <data-file> 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/confl > > > > > > >>>>> uence/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 > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>>>>>> > > > > > > >>>>> >>> > > > > > > >>>>> > > > > > > > >>>>> > > > > > > >>>> > > > > > > >>>> > > > > > > >>> > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > >