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