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 <[email protected]>: > 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 <[email protected]>: > >> 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 <[email protected]>: >> >>> 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 <[email protected]>: >>> >>>> Regarding: >>>> >>>> <Product productID="JR119" productName="CONECTOR SOCKET 3POS IDC" >>>> PRICE="0,6" TAX="7" primaryProductCategoryId="10001" >>>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM" >>>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21 >>>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0" >>>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21 >>>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin" >>>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21 >>>> 16:32:57.0"/> >>>> >>>> Right off the bat I see that "productID" is not "productId". I'm pretty >>>> sure that won't work. The beginning "<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 < >>>> [email protected]> >>>> 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 <[email protected]>: >>>> >> >>>> >> 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 <[email protected]>: >>>> >>> >>>> >>> 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 <[email protected]> >>>> 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 <[email protected]>: >>>> >>>>> >>>> >>>>> 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 <[email protected]> >>>> 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 < >>>> >>>>>>> >>>> >>>>>> [email protected]> >>>> >>>>> >>>> >>>>>> : >>>> >>>>>> >>>> >>>>>>> Le 17/11/2017 à 09:43, Javier H. a écrit : >>>> >>>>>>>> >>>> >>>>>>>> On 2017-11-17 08:05, Michael Brohl <[email protected]> >>>> >>>>>>>>> >>>> >>>>>>>> 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."<[email protected]> wrote: >>>> >>>>>>>>>>> >>>> >>>>>>>>>>> On 2017-11-14 08:02, "pierre.gaudin" < >>>> >>>>>>>>>>>> >>>> >>>>>>>>>>> [email protected]> >>>> >>>> >>>> >>>>> 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 >>>> >>>>>>> >>>> >>>>>>> >>>> >>> >>>> > >>>> >>> >>> >> >
