It's finished. Showing 1 - 20 of 95.094
Now I going to load ProducPrice.xml, let's see if I have the same luck. Thanks very much to alls! Best regards. 2017-11-22 17:09 GMT+00:00 Javier <droin...@gmail.com>: > 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 <droin...@gmail.com>: > >> 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 <mz4whee...@gmail.com>: >> >>> 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 <pierre.gau...@nereide.fr >>> > >>> 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 <droin...@gmail.com>: >>> >> >>> >> 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 <mz4whee...@gmail.com>: >>> >>> >>> >>> 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 <droin...@gmail.com> >>> 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 <mz4whee...@gmail.com>: >>> >>>>> >>> >>>>> 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 <droin...@gmail.com> >>> 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 < >>> >>>>>>> >>> >>>>>> jacques.le.r...@les7arts.com> >>> >>>>> >>> >>>>>> : >>> >>>>>> >>> >>>>>>> Le 17/11/2017 à 09:43, Javier H. a écrit : >>> >>>>>>>> >>> >>>>>>>> On 2017-11-17 08:05, Michael Brohl <michael.br...@ecomify.de> >>> >>>>>>>>> >>> >>>>>>>> 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."<droin...@gmail.com> wrote: >>> >>>>>>>>>>> >>> >>>>>>>>>>> On 2017-11-14 08:02, "pierre.gaudin" < >>> >>>>>>>>>>>> >>> >>>>>>>>>>> pierre.gau...@nereide.fr> >>> >>>> >>> >>>>> 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 >>> >>>>>>> >>> >>>>>>> >>> >>> >>> > >>> >> >> >
