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