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="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"/> >>> >>> <Product productID="JR120" productName="CONECTOR SOCKET 2POS IDC" >>> PRICE="0,49" 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"/> >>> >>> >>> 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/original.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/confluence/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 >>>>>>> >>>>>>> >>> >
