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 <[email protected]>: > 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="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 < >>>>> [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 >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>> >>>>> > >>>>> >>>> >>>> >>> >> >
