It's not over yet, but I made a query to the Products table, and surprise, there are products :)
select * from PRODUCT; 2017-11-22 17:03 GMT+00:00 Javier <[email protected]>: > Hello Mike, > > I have changed in mail of 22 de noviembre de 2017, 8:32 > > The Category is already created from Ofbiz web interface (manually). > > Now, I'm loading. > > Best regards > > 2017-11-22 14:54 GMT+00:00 Mike <[email protected]>: > >> Regarding: >> >> <Product productID="JR119" productName="CONECTOR SOCKET 3POS IDC" >> PRICE="0,6" TAX="7" primaryProductCategoryId="10001" >> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM" >> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21 >> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0" >> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21 >> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin" >> lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21 >> 16:32:57.0"/> >> >> Right off the bat I see that "productID" is not "productId". I'm pretty >> sure that won't work. The beginning "<Product" signifies the "product" >> table, and ONLY the columns in that table are legal for each of the lines >> in your ofbiz XML. For instance, you have "PRICE="0,6" TAX="7"... >> Neither >> "Price" or "Tax" are in the product table. Also, "inventoryItemTypeId" >> should be "productTypeId". It also looks like "inShippingBox" does not >> exist in the product table. You must be precise with all the table names >> and column names. >> >> This is why I said you must become very familiar with the ofbiz schema. >> When creating seed data, you can log into the database and list all the >> legal columns (i.e. for the product table). Here is an example for >> postgresql: >> >> ofbiz=# \d product >> primary_product_category_id | character varying(255) | >> manufacturer_party_id | character varying(255) | >> facility_id | character varying(255) | >> introduction_date | timestamp with time zone | >> release_date | timestamp with time zone | >> support_discontinuation_date | timestamp with time zone | >> sales_discontinuation_date | timestamp with time zone | >> sales_disc_when_not_avail | character(1) | >> internal_name | text | >> brand_name | character varying(255) | >> comments | text | >> product_name | character varying(255) | >> description | text | >> long_description | text | >> price_detail_text | text | >> small_image_url | character varying(2000) | >> medium_image_url | character varying(2000) | >> large_image_url | character varying(2000) | >> detail_image_url | character varying(2000) | >> original_image_url | character varying(2000) | >> detail_screen | character varying(255) | >> inventory_message | text | >> require_inventory | character(1) | >> inventory_item_type_id | character varying(255) | >> quantity_uom_id | character varying(255) | >> quantity_included | numeric(18,6) | >> pieces_included | numeric(20,0) | >> require_amount | character(1) | >> fixed_amount | numeric(18,2) | >> amount_uom_type_id | character varying(255) | >> weight_uom_id | character varying(255) | >> weight | numeric(18,6) | >> product_weight | numeric(18,6) | >> diameter_uom_id | character varying(255) | >> product_diameter | numeric(18,6) | >> product_rating | numeric(18,6) | >> rating_type_enum | character varying(255) | >> returnable | character(1) | >> taxable | character(1) | >> charge_shipping | character(1) | >> auto_create_keywords | character(1) | >> include_in_promotions | character(1) | >> is_virtual | character(1) | >> is_variant | character(1) | >> virtual_variant_method_enum | character varying(255) | >> origin_geo_id | character varying(255) | >> requirement_method_enum_id | character varying(255) | >> bill_of_material_level | numeric(20,0) | >> reserv_max_persons | numeric(18,6) | >> reserv2nd_p_p_perc | numeric(18,6) | >> reserv_nth_p_p_perc | numeric(18,6) | >> config_id | character varying(255) | >> created_date | timestamp with time zone | >> created_by_user_login | character varying(255) | >> last_modified_date | timestamp with time zone | >> last_modified_by_user_login | character varying(255) | >> in_shipping_box | character(1) | >> default_shipment_box_type_id | character varying(255) | >> lot_id_filled_in | character varying(255) | >> order_decimal_quantity | character(1) | >> last_updated_stamp | timestamp with time zone | >> last_updated_tx_stamp | timestamp with time zone | >> created_stamp | timestamp with time zone | >> created_tx_stamp | timestamp with time zone | >> >> For postgres, the column names have "_", but for the ofbiz XML, they are >> camel cased. So "created_by_user_login" becomes "CreatedByUserLogin" (in >> the XML). For mysql, you can use the command "describe product;" to get a >> similar output. Obviously, you don't need every single column, but you'll >> need images, right? So you'll want the insert the URLs into your seed >> data. >> >> Not sure xmlstarlet is the right tool, but I think you are on the right >> track. Start with the categories... >> >> >> >> On Wed, Nov 22, 2017 at 5:46 AM, pierre.gaudin <[email protected]> >> wrote: >> >> > Hi Javier >> > >> > - The decimal seprator should be '.' >> > - no need to set lastUpdatedStamp createdTxStamp ... >> > - ProductCategory should be imported first >> > >> > Pierre >> > >> > On 22/11/2017 09:37, Javier wrote: >> > >> >> There is a error, is productId not ProductID, sorry. >> >> >> >> 2017-11-22 8:32 GMT+00:00 Javier <[email protected]>: >> >> >> >> Thanks Mike, >> >>> >> >>> I used xmlstarlet and this is the result for 2 products, I made 2 >> files >> >>> Product.xml and ProductPrice.xml. Do you think it can work? >> >>> >> >>> Best regards >> >>> >> >>> Product.xml >> >>> >> >>> <Product productID="JR119" productName="CONECTOR SOCKET 3POS IDC" >> >>> PRICE="0,6" TAX="7" primaryProductCategoryId="10001" >> >>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE >> D_INV_ITEM" >> >>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21 >> >>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0" >> >>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21 >> >>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin >> " >> >>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" >> createdStamp="2017-11-21 >> >>> 16:32:57.0"/> >> >>> >> >>> <Product productID="JR120" productName="CONECTOR SOCKET 2POS IDC" >> >>> PRICE="0,49" TAX="7" primaryProductCategoryId="10001" >> >>> productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZE >> D_INV_ITEM" >> >>> isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21 >> >>> 16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0" >> >>> lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21 >> >>> 16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin >> " >> >>> lotIdFilledIn="Allowed" billOfMaterialLevel="0" >> createdStamp="2017-11-21 >> >>> 16:32:57.0"/> >> >>> >> >>> >> >>> ProductPrice.xml >> >>> >> >>> <ProductPrice productID="JR119" price="0,6" taxPercentage="7" >> >>> createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21 >> >>> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0" >> >>> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin" >> >>> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0" >> >>> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22 >> >>> 07:15:53.0" productPricePurposeId="PURCHASE" >> >>> productPriceTypeId="DEFAULT_PRICE" >> >>> taxInPrice="Y"/> >> >>> >> >>> <ProductPrice productID="JR120" price="0,49" taxPercentage="7" >> >>> createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21 >> >>> 16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0" >> >>> createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin" >> >>> lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0" >> >>> currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22 >> >>> 07:15:53.0" productPricePurposeId="PURCHASE" >> >>> productPriceTypeId="DEFAULT_PRICE" >> >>> taxInPrice="Y"/> >> >>> >> >>> >> >>> 2017-11-21 15:49 GMT+00:00 Mike <[email protected]>: >> >>> >> >>> It is a two step process as I outlined in my previous email. From >> your >> >>>> source XML/CSV, you create (via an external utility) the >> >>>> catalog/categories/sub-categories into an ofbiz-compatible "catalog" >> >>>> XML >> >>>> file. >> >>>> >> >>>> You then test import the "catalog" XML file, OVER and OVER again >> until >> >>>> it >> >>>> looks proper. Why do you do this? Because it will require tweaking. >> >>>> Doing >> >>>> this in the ofbiz GUI would be tedious and error prone. >> >>>> >> >>>> You have to create "seed" compatible data. After the catalog looks >> >>>> good, >> >>>> you repeat the same process (create an ofbiz-compatible "product" XML >> >>>> file) >> >>>> with the products. >> >>>> >> >>>> You really don't need the OfbizDataModelBook at this point, my >> previous >> >>>> email showed you the tables and the order. >> >>>> >> >>>> Good luck. >> >>>> >> >>>> On Mon, Nov 20, 2017 at 10:54 PM, Javier <[email protected]> wrote: >> >>>> >> >>>> Thanks Mike, >> >>>>> >> >>>>> One of the biggest problems in my current program is that it does >> not >> >>>>> support SubCategories. >> >>>>> >> >>>>> So I have to reorganize all the Categories. >> >>>>> >> >>>>> So at the moment it would be enough for me to load all the products >> in >> >>>>> a >> >>>>> category (for example, the Uncategorised family) and then I would be >> >>>>> organizing it from Ofbiz. >> >>>>> >> >>>>> I have to familiarize myself with the schema of the database. I have >> >>>>> >> >>>> been >> >>>> >> >>>>> studying a bit the OfbizDataModelBook. >> >>>>> >> >>>>> Best regards. >> >>>>> >> >>>>> 2017-11-17 18:31 GMT+00:00 Mike <[email protected]>: >> >>>>> >> >>>>> Nothing is simple in ofbiz. There are a butt load of tables that >> >>>>>> >> >>>>> have to >> >>>> >> >>>>> be imported in ofbiz... for ONE category, and for ONE product, IN >> THE >> >>>>>> CORRECT ORDER!!! >> >>>>>> >> >>>>>> First, you have to pre-populate your categories. (example below) >> >>>>>> >> >>>>>> Then you can add the products. (one product example below) >> >>>>>> >> >>>>>> All this takes a lot of time organizing and analyzing in order to >> >>>>>> understand the ofbiz schema. >> >>>>>> >> >>>>>> For the XML you posted, you have to create a custom script (i.e. >> >>>>>> perl/python/java) that reads each XML "row", and creates ofbiz XML >> >>>>>> compatible "seed" file(s). >> >>>>>> >> >>>>>> If you write your own script, vice relying on ofbiz tools, you have >> >>>>>> absolute control over what exactly is imported, and no data limits. >> >>>>>> >> >>>>> Want >> >>>> >> >>>>> alternate URLs? What multi language support? Change your script. >> >>>>>> >> >>>>>> In addition, when you are setting up a new ofbiz instance, you >> WILL be >> >>>>>> importing the same seed (store) data (example below), over and over >> >>>>>> again... This is why you must create ofbiz compatible "seed" data >> for >> >>>>>> >> >>>>> your >> >>>>> >> >>>>>> store. All the experts here know that. >> >>>>>> >> >>>>>> "one category" example... "10000" is top level, "10001" is first >> >>>>>> >> >>>>> category. >> >>>>> >> >>>>>> <?xml version="1.0" encoding="UTF-8"?> >> >>>>>> <entity-engine-xml> >> >>>>>> <ProdCatalog prodCatalogId="10000" catalogName="Gallery" >> >>>>>> >> >>>>> useQuickAdd="N" >> >>>> >> >>>>> viewAllowPermReqd="N" purchaseAllowPermReqd="N" >> >>>>>> >> >>>>> createdStamp="2017-11-05 >> >>>> >> >>>>> 10:59:43"/> >> >>>>>> <ProductCategory productCategoryId="10000" >> >>>>>> productCategoryTypeId="CATALOG_CATEGORY" categoryName="Gallery" >> >>>>>> description="Gallery" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProdCatalogCategory prodCatalogId="10000" >> productCategoryId="10000" >> >>>>>> prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" fromDate="2017-11-05 >> >>>>>> 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductCategory productCategoryId="Gallery_SEARCH" >> >>>>>> productCategoryTypeId="SEARCH_CATEGORY" categoryName="Gallery >> Search" >> >>>>>> description="Gallery Search" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProdCatalogCategory prodCatalogId="10000" >> >>>>>> productCategoryId="Gallery_SEARCH" prodCatalogCategoryTypeId=" >> >>>>>> >> >>>>> PCCT_SEARCH" >> >>>>> >> >>>>>> fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductStoreCatalog productStoreId="Gallery" prodCatalogId="10000" >> >>>>>> fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <Content contentId="PROD_DESCRIPTION" contentTypeId="DOCUMENT" >> >>>>>> contentName="Product Description" createdDate="2017-11-05 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductCategory productCategoryId="10001" >> >>>>>> productCategoryTypeId="CATALOG_CATEGORY" >> >>>>>> >> >>>>> primaryParentCategoryId="10000" >> >>>> >> >>>>> description="Games & Entertainment" createdStamp="2017-11-05 >> >>>>>> 10:59:43"/> >> >>>>>> <ProductCategoryRollup productCategoryId="10001" >> >>>>>> parentProductCategoryId="10000" sequenceNum="1" >> fromDate="2017-11-05 >> >>>>>> 10:59:43" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <DataResource dataResourceId="10001Den" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="10001Den" textData="Games & >> >>>>>> Entertainment" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <Content contentId="10001Den" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="10001Den" description="DESCRIPTION en 10001" >> >>>>>> localeString="en" createdDate="2017-11-05 10:59:43" >> >>>>>> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductCategoryContent productCategoryId="10001" >> contentId="10001Den" >> >>>>>> prodCatContentTypeId="CATEGORY_NAME" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="10001Den" contentIdTo="10001Den" >> >>>>>> contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <DataResource dataResourceId="10001Aen" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="10001Aen" >> >>>>>> >> >>>>> textData="games-entertainment" >> >>>> >> >>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <Content contentId="10001Aen" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="10001Aen" description="ALT_URL en 10001" >> >>>>>> >> >>>>> localeString="en" >> >>>>> >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ProductCategoryContent productCategoryId="10001" >> contentId="10001Aen" >> >>>>>> prodCatContentTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="10001Aen" contentIdTo="10001Aen" >> >>>>>> contentAssocTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> </entity-engine-xml> >> >>>>>> >> >>>>>> "one product" example: >> >>>>>> >> >>>>>> <?xml version="1.0" encoding="UTF-8"?> >> >>>>>> <entity-engine-xml> >> >>>>>> <Product productId="798936836182" productTypeId="FINISHED_GOOD" >> >>>>>> primaryProductCategoryId="10002" internalName="798936836182" >> >>>>>> brandName="SELECTSOFT GAMES" comments="JEWEL CASE EVERYONE" >> >>>>>> smallImageUrl="/images/products/10000/1001MINIGOLF/small.jpg" >> >>>>>> mediumImageUrl="/images/products/10000/1001MINIGOLF/medium.jpg" >> >>>>>> largeImageUrl="/images/products/10000/1001MINIGOLF/large.jpg" >> >>>>>> originalImageUrl="/images/products/10000/1001MINIGOLF/origin >> al.jpg" >> >>>>>> detailImageUrl="/images/products/10000/1001MINIGOLF/detail.jpg" >> >>>>>> inventoryMessage="Ships from NashVille" requireInventory="N" >> >>>>>> weightUomId="WT_lb" weight=".350000" productWeight=".350000" >> >>>>>> >> >>>>> returnable="Y" >> >>>>> >> >>>>>> taxable="Y" chargeShipping="Y" isVirtual="N" isVariant="N" >> >>>>>> requirementMethodEnumId="PRODRQM_DS" billOfMaterialLevel="0" >> >>>>>> introductionDate="2007-06-14 00:00:00" salesDiscontinuationDate=" >> >>>>>> 2038-01-01 >> >>>>>> 00:00:00" createdDate="2017-11-05 10:59:43" >> createdByUserLogin="admin" >> >>>>>> autoCreateKeywords="Y"/> >> >>>>>> <ProductCategoryMember productCategoryId="10002" >> >>>>>> >> >>>>> productId="798936836182" >> >>>> >> >>>>> fromDate="2007-06-14 00:00:00" thruDate="2038-01-01 00:00:00" >> >>>>>> sequenceNum="0" quantity="0" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductCategoryMember productCategoryId="Gallery_SEARCH" >> >>>>>> productId="798936836182" fromDate="2007-06-14 00:00:00" >> >>>>>> thruDate="2038-01-01 00:00:00" sequenceNum="0" quantity="0" >> >>>>>> createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductPrice productId="798936836182" productPriceTypeId="DEFAULT_ >> >>>>>> >> >>>>> PRICE" >> >>>>> >> >>>>>> productPricePurposeId="PURCHASE" currencyUomId="USD" >> >>>>>> >> >>>>> termUomId="OTH_ea" >> >>>> >> >>>>> productStoreGroupId="_NA_" price="3.85" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/> >> >>>>>> <ProductPrice productId="798936836182" >> productPriceTypeId="LIST_PRICE >> >>>>>> >> >>>>> " >> >>>> >> >>>>> productPricePurposeId="PURCHASE" currencyUomId="USD" >> >>>>>> >> >>>>> termUomId="OTH_ea" >> >>>> >> >>>>> productStoreGroupId="_NA_" price="9.95" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/> >> >>>>>> <ProductPrice productId="798936836182" >> productPriceTypeId="WHOLESALE_ >> >>>>>> PRICE" >> >>>>>> productPricePurposeId="PURCHASE" currencyUomId="USD" >> >>>>>> >> >>>>> termUomId="OTH_ea" >> >>>> >> >>>>> productStoreGroupId="_NA_" price="2.75" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/> >> >>>>>> <SupplierProduct productId="798936836182" partyId="Gallery" >> >>>>>> availableFromDate="2017-11-05 10:59:43" >> supplierPrefOrderId="10_MAIN_ >> >>>>>> SUPPL" >> >>>>>> standardLeadTimeDays="1" minimumOrderQuantity="1" >> >>>>>> >> >>>>> orderQtyIncrements="1" >> >>>> >> >>>>> unitsIncluded="1" quantityUomId="OTH_ea" currencyUomId="USD" >> >>>>>> supplierProductName="1001 MINIGOLF CHALLENGE" >> >>>>>> supplierProductId="1001MINIGOLF" canDropShip="Y" >> comments="Supplier >> >>>>>> Comment" createdStamp="2017-11-05 10:59:43" lastPrice="3.85"/> >> >>>>>> <GoodIdentification productId="798936836182" >> >>>>>> goodIdentificationTypeId="UPCA" idValue="798936836182" >> >>>>>> createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductFacility productId="798936836182" facilityId="Gallery" >> >>>>>> lastInventoryCount="9.000000" createdStamp="2017-11-05 10:59:43"/> >> >>>>>> <DataResource dataResourceId="798936836182Den" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="798936836182Den" textData="1001 >> >>>>>> >> >>>>> MINIGOLF >> >>>> >> >>>>> CHALLENGE" createdStamp="2017-11-05 10:59:43" >> >>>>>> >> >>>>> createdTxStamp="2017-11-05 >> >>>> >> >>>>> 10:59:43"/> >> >>>>>> <Content contentId="798936836182Den" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="798936836182Den" description="DESCRIPTION en >> >>>>>> >> >>>>> 798936836182" >> >>>>> >> >>>>>> localeString="en" createdDate="2017-11-05 10:59:43" >> >>>>>> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductContent productId="798936836182" >> contentId="798936836182Den" >> >>>>>> productContentTypeId="DESCRIPTION" fromDate="2017-11-05 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="798936836182Den" >> >>>>>> >> >>>>> contentIdTo="798936836182Den" >> >>>> >> >>>>> contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" >> >>>>>> >> >>>>> contentIdTo="798936836182Den" >> >>>> >> >>>>> contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <DataResource dataResourceId="798936836182Aen" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="798936836182Aen" >> >>>>>> textData="1001-minigolf-challenge" createdStamp="2017-11-05 >> 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <Content contentId="798936836182Aen" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="798936836182Aen" description="ALT_URL en >> >>>>>> >> >>>>> 798936836182" >> >>>> >> >>>>> localeString="en" createdDate="2017-11-05 10:59:43" >> >>>>>> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductContent productId="798936836182" >> contentId="798936836182Aen" >> >>>>>> productContentTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="798936836182Aen" >> >>>>>> >> >>>>> contentIdTo="798936836182Aen" >> >>>> >> >>>>> contentAssocTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <DataResource dataResourceId="798936836182Len" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="798936836182Len" textData="Welcome >> to >> >>>>>> >> >>>>> the >> >>>>> >> >>>>>> largest mini-golf course ever" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <Content contentId="798936836182Len" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="798936836182Len" description="DESCRIPTION en >> >>>>>> >> >>>>> 798936836182" >> >>>>> >> >>>>>> localeString="en" createdDate="2017-11-05 10:59:43" >> >>>>>> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductContent productId="798936836182" >> contentId="798936836182Len" >> >>>>>> productContentTypeId="LONG_DESCRIPTION" fromDate="2017-11-05 >> >>>>>> >> >>>>> 10:59:43" >> >>>> >> >>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="798936836182Len" >> >>>>>> >> >>>>> contentIdTo="798936836182Len" >> >>>> >> >>>>> contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" >> >>>>>> >> >>>>> contentIdTo="798936836182Len" >> >>>> >> >>>>> contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <DataResource dataResourceId="798936836182Nen" >> >>>>>> dataResourceTypeId="ELECTRONIC_TEXT" localeString="en" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ElectronicText dataResourceId="798936836182Nen" textData="1001 >> >>>>>> >> >>>>> MINIGOLF >> >>>> >> >>>>> CHALLENGE" createdStamp="2017-11-05 10:59:43" >> >>>>>> >> >>>>> createdTxStamp="2017-11-05 >> >>>> >> >>>>> 10:59:43"/> >> >>>>>> <Content contentId="798936836182Nen" contentTypeId="DOCUMENT" >> >>>>>> dataResourceId="798936836182Nen" description="DESCRIPTION en >> >>>>>> >> >>>>> 798936836182" >> >>>>> >> >>>>>> localeString="en" createdDate="2017-11-05 10:59:43" >> >>>>>> createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43" >> >>>>>> createdTxStamp="2017-11-05 10:59:43"/> >> >>>>>> <ProductContent productId="798936836182" >> contentId="798936836182Nen" >> >>>>>> productContentTypeId="PRODUCT_NAME" fromDate="2017-11-05 10:59:43" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="798936836182Nen" >> >>>>>> >> >>>>> contentIdTo="798936836182Nen" >> >>>> >> >>>>> contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 >> 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> <ContentAssoc contentId="PROD_DESCRIPTION" >> >>>>>> >> >>>>> contentIdTo="798936836182Nen" >> >>>> >> >>>>> contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43" >> >>>>>> createdDate="2017-11-05 10:59:43" createdByUserLogin="admin" >> >>>>>> createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05 >> >>>>>> >> >>>>> 10:59:43"/> >> >>>> >> >>>>> </entity-engine-xml> >> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> On Fri, Nov 17, 2017 at 1:43 AM, Javier <[email protected]> >> wrote: >> >>>>>> >> >>>>>> Hi Jacques, >> >>>>>>> >> >>>>>>> Yes, both, but I have problems in step 4: >> >>>>>>> >> >>>>>>> >> >>>>>>> 1. connect to the Webtools application >> >>>>>>> 2. go to the "Work With Data Files" screen >> >>>>>>> 3. enter the path to the your definition file in the >> "Definition >> >>>>>>> Filename or URL" input field >> >>>>>>> 4. click on the submit button >> >>>>>>> >> >>>>>>> >> >>>>>>> I have used this file >> >>>>>>> /opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd >> and >> >>>>>>> >> >>>>>> this >> >>>>> >> >>>>>> <data-file name="Product" separator-style="delimited" >> >>>>>>> >> >>>>>> type-code="UTF-8" >> >>>> >> >>>>> delimiter="	" text-delimiter="" >> >>>>>>> description="this takes the product data from doba file" >> >>>>>>> has-header="true"> >> >>>>>>> <record name="Product"> >> >>>>>>> <field name="productId" ignored="false" type="String"/> >> >>>>>>> <field name="primaryProductCategoryId" expression="true" >> >>>>>>> default-value="dropShip" type="String"/> >> >>>>>>> <field name="productTypeId" expression="true" >> >>>>>>> default-value="FINISHED_GOOD" type="String"/> >> >>>>>>> <field name="sku" ignored="true" type="String"/> >> >>>>>>> <field name="description" ignored="false" type="String"/> >> >>>>>>> <field name="categories" ignored="true" type="String"/> >> >>>>>>> <field name="image_url" ignored="true" type="String"/> >> >>>>>>> <field name="brandName" ignored="false" type="String"/> >> >>>>>>> <field name="longDescription" ignored="false" >> >>>>>>> >> >>>>>> type="String"/> >> >>>> >> >>>>> <field name="details" ignored="true" type="String"/> >> >>>>>>> <field name="weight" ignored="false" type="String"/> >> >>>>>>> <field name="weightUomId" expression="true" >> >>>>>>> >> >>>>>> default-value="WT_lb" >> >>>>> >> >>>>>> type="String"/> >> >>>>>>> <field name="dimensions" ignored="true" type="String"/> >> >>>>>>> <field name="going" ignored="true" type="String"/> >> >>>>>>> <field name="refurb" ignored="true" type="String"/> >> >>>>>>> <field name="freight" ignored="true" type="String"/> >> >>>>>>> <field name="productName" ignored="false" type="String"/> >> >>>>>>> <field name="map" ignored="true" type="String"/> >> >>>>>>> <field name="price" ignored="true" type="String"/> >> >>>>>>> <field name="msrp" ignored="true" type="String"/> >> >>>>>>> <field name="quantityIncluded" expression="true" >> >>>>>>> >> >>>>>> default-value="1" >> >>>>>> >> >>>>>>> type="String"/> >> >>>>>>> <field name="quantity" ignored="true" type="String"/> >> >>>>>>> <field name="est_avail" ignored="true" type="String"/> >> >>>>>>> <field name="expected_shipping_cost" ignored="true" >> >>>>>>> >> >>>>>> type="String"/> >> >>>>>> >> >>>>>>> <field name="expected_drop_ship_fee" ignored="true" >> >>>>>>> >> >>>>>> type="String"/> >> >>>>>> >> >>>>>>> <field name="upc" ignored="true" type="String"/> >> >>>>>>> <field name="item_id" ignored="true" type="String"/> >> >>>>>>> <field name="isVirtual" expression="true" >> default-value="N" >> >>>>>>> type="String"/> >> >>>>>>> <field name="isVariant" expression="true" >> default-value="N" >> >>>>>>> type="String"/> >> >>>>>>> </record> >> >>>>>>> </data-file> >> >>>>>>> >> >>>>>>> but always I get this error "No <data-file> elements found in >> >>>>>>> file:/home/user/data-file.xml" >> >>>>>>> >> >>>>>>> Best regards >> >>>>>>> >> >>>>>>> 2017-11-17 9:30 GMT+00:00 Jacques Le Roux < >> >>>>>>> >> >>>>>> [email protected]> >> >>>>> >> >>>>>> : >> >>>>>> >> >>>>>>> Le 17/11/2017 à 09:43, Javier H. a écrit : >> >>>>>>>> >> >>>>>>>> On 2017-11-17 08:05, Michael Brohl <[email protected]> >> >>>>>>>>> >> >>>>>>>> wrote: >> >>>>> >> >>>>>> Hi Javier, >> >>>>>>>>>> >> >>>>>>>>>> why not directly export to the OFBiz datafile format? >> >>>>>>>>>> >> >>>>>>>>>> Regards, >> >>>>>>>>>> >> >>>>>>>>>> Michael >> >>>>>>>>>> >> >>>>>>>>>> >> >>>>>>>>>> Am 17.11.17 um 09:03 schrieb Javier H.: >> >>>>>>>>>> >> >>>>>>>>>> On 2017-11-14 08:21, "Javier H."<[email protected]> wrote: >> >>>>>>>>>>> >> >>>>>>>>>>> On 2017-11-14 08:02, "pierre.gaudin" < >> >>>>>>>>>>>> >> >>>>>>>>>>> [email protected]> >> >>>> >> >>>>> wrote: >> >>>>>>> >> >>>>>>>> On 14/11/2017 08:55, Javier H. wrote: >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> Hello, >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>>> I have to import about 95.000 products into Ofbiz (mysql >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>> database). >> >>>>>> >> >>>>>>> I can import it to TXT or SQL formats, also to XLS but I >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>> get a >> >>>> >> >>>>> error >> >>>>>>> >> >>>>>>>> because max is 65.000 rows. >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>>> What format do you recommend for import, TXT or SQL? >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>>> Best regards >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>>> Hi Javier >> >>>>>>>>>>>>>> >> >>>>>>>>>>>>> We used to import about 700 000 article for a customer. >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> We used XML import via XSLT transformation to do so. I don't >> >>>>>>>>>>>>> >> >>>>>>>>>>>> think >> >>>>> >> >>>>>> there >> >>>>>>>>>>>>> is a limit with xml import. >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> Pierre >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> Thank you Pierre, >> >>>>>>>>>>>>> >> >>>>>>>>>>>>> I think that I can to export to XML, I have to check it. >> >>>>>>>>>>>> >> >>>>>>>>>>>> Best regards >> >>>>>>>>>>>> Hello, >> >>>>>>>>>>>> >> >>>>>>>>>>>> I have exported the data to an XML file. >> >>>>>>>>>>> >> >>>>>>>>>>> Something similar to this: >> >>>>>>>>>>> >> >>>>>>>>>>> <?xml version="1.0" encoding="UTF-8" standalone="yes"?> >> >>>>>>>>>>> <RECORDS> >> >>>>>>>>>>> <RECORD> >> >>>>>>>>>>> <ROW >> >>>>>>>>>>> CODE="1308051" >> >>>>>>>>>>> DESCR="DEMO PRODUCT" >> >>>>>>>>>>> PRICE="5,50" >> >>>>>>>>>>> TAX="21" >> >>>>>>>>>>> QUANTITY="40" >> >>>>>>>>>>> LASTPRICE="4,9" >> >>>>>>>>>>> TAXCODE="3" >> >>>>>>>>>>> PROVIDER="87" >> >>>>>>>>>>> CATEGORY="00099" >> >>>>>>>>>>> DATE="01012015" >> >>>>>>>>>>> /> >> >>>>>>>>>>> </RECORD> >> >>>>>>>>>>> ..... >> >>>>>>>>>>> </RECORDS> >> >>>>>>>>>>> >> >>>>>>>>>>> How can I make the definition file for this? >> >>>>>>>>>>> >> >>>>>>>>>>> And how can I ignore the fields that I do not want to import? >> >>>>>>>>>>> >> >>>>>>>>>> (For >> >>>> >> >>>>> example DATE). >> >>>>>>>>>>> >> >>>>>>>>>>> Best regards >> >>>>>>>>>>> >> >>>>>>>>>>> Hi Michael, >> >>>>>>>>>> >> >>>>>>>>>> Because I have no idea. >> >>>>>>>>> >> >>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+ >> >>>>>>>>> Data+File+Tools >> >>>>>>>>> >> >>>>>>>>> I'm testing Data File Tools, I added this >> >>>>>>>>> >> >>>>>>>> "/opt/apache-ofbiz-16.11.03/fr >> >>>>>> >> >>>>>>> amework/datafile/dtd/datafiles.xsd" to Definition Filename or >> >>>>>>>>> >> >>>>>>>> URL" >> >>>> >> >>>>> but >> >>>>>> >> >>>>>>> I >> >>>>>>> >> >>>>>>>> get this error: >> >>>>>>>>> >> >>>>>>>>> No <data-file> elements found in file:/opt/apache-ofbiz-16.11.0 >> >>>>>>>>> 3/framework/datafile/dtd/datafiles.xsd >> >>>>>>>>> >> >>>>>>>>> Best regards >> >>>>>>>>> >> >>>>>>>>> Hi Javier, >> >>>>>>>>> >> >>>>>>>> Did you follow https://cwiki.apache.org/confl >> uence/display/OFBIZ/ >> >>>>>>>> >> >>>>>>> OFBiz's+ >> >>>>>>> >> >>>>>>>> Data+File+Tools ? >> >>>>>>>> Did you have a look at https://cwiki.apache.org/confl >> >>>>>>>> uence/display/OFBIZ/Handling+of+External+data ? >> >>>>>>>> >> >>>>>>>> HTH >> >>>>>>>> >> >>>>>>>> Jacques >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>> -- >> >>>>>>> Saludos >> >>>>>>> >> >>>>>>> >> >>> >> > >> > >
