Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 38EA8200D41 for ; Wed, 22 Nov 2017 18:03:58 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 37240160BFD; Wed, 22 Nov 2017 17:03:58 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 81B0D160BEC for ; Wed, 22 Nov 2017 18:03:56 +0100 (CET) Received: (qmail 85391 invoked by uid 500); 22 Nov 2017 17:03:55 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 85378 invoked by uid 99); 22 Nov 2017 17:03:55 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Nov 2017 17:03:55 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 0D6FA1A1212 for ; Wed, 22 Nov 2017 17:03:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id ScGId23Efg4q for ; Wed, 22 Nov 2017 17:03:41 +0000 (UTC) Received: from mail-lf0-f46.google.com (mail-lf0-f46.google.com [209.85.215.46]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 835CF5F3B6 for ; Wed, 22 Nov 2017 17:03:40 +0000 (UTC) Received: by mail-lf0-f46.google.com with SMTP id y2so18111435lfj.4 for ; Wed, 22 Nov 2017 09:03:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=RWNirvOIiI0T8U9xP1jOgDoBYJGvPxy3pwVHaIehtpk=; b=FFDP4ZgV+5Yhv0+cSOp3zjSnsbvI61s8D8t2S/BithrIKMfeCnD5+6AQqcYmMwXkor xLEnWLg+8y/FnxpKTzS6LwnGZMEEfugmbFjWx+Yp1QVug5EpTwIEqELtDRpJ23bhuDY0 /35yxSrtMKH+mI0Xct8JN3vM2P8PmcsOdHpFtRo3ickEBLKJaFSrdlznkwsGdIhKOUjQ UviQDIXOzO19vM4xmhRwb89IOaxCePk3zeIDauN3HyW1dv6PWKbPNcRKKHb9xe77ov+o hroi/l7RnKHJLf87PLpjrQqSVfUZoIRPZN9rd28IDadmPoQG9Lcbh0LlUDRxY2yUZIAr hocg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=RWNirvOIiI0T8U9xP1jOgDoBYJGvPxy3pwVHaIehtpk=; b=RRBtKugNmbmwNP7Ube0xhru77acv0vOfNDl9XonND3aHeHK0rrGepJrDtiiSlZkTcx 8APdBS1LctBgAmQ/C36Vd5ET2+U9NzLPo+0uuIOlah7241n7q+vlGw48AFK5bTmEr80x Rvqt6HhdGd249LCy9m1ShrjX5Fjx8N2l2S2+4COuScwCmmyxPwuzZqcvVME8Vju4pheE YS6YrL/O3PaHq8nxQRsh0rqa3PgkGjrrhpkBubVyW2NPHW+iPUlvvdAjZ9CLTZe8WuwS IJW8igVj5rCFgwlwFD3XGeNrArRUs9A8/6FsEFCs8Wk14uvx7IC8qWHrq8Gk41Pf+hJM k3eg== X-Gm-Message-State: AJaThX5A1hqsGK3sRtMLUxHWV2oFIk4+d60kDjQqKnwMWaBdDyR2JWME vNqjoe4qjpF5MbTSIHJkuFyWKm8B6nbOkoJyZfC5NJmF X-Google-Smtp-Source: AGs4zMaTYnCD7iRDUGpGOHxPb2qoU5LP4Yg5orVxWZIgY+CUi8V4yUHaKoM+G7+hW1Ck2jVp3gyDBJLmojD+nH9+qBM= X-Received: by 10.25.99.80 with SMTP id x77mr6053381lfb.205.1511370219075; Wed, 22 Nov 2017 09:03:39 -0800 (PST) MIME-Version: 1.0 Received: by 10.25.215.30 with HTTP; Wed, 22 Nov 2017 09:03:37 -0800 (PST) In-Reply-To: References: <308e1b0b-b1df-4223-359c-4143391b6b49@ecomify.de> <2254bd0d-6d29-e854-0538-e7cce00ee54b@les7arts.com> <37fe54a1-6393-504f-93fd-d4f9a5e10d6b@nereide.fr> From: Javier Date: Wed, 22 Nov 2017 17:03:37 +0000 Message-ID: Subject: Re: File format to import products To: user@ofbiz.apache.org Content-Type: multipart/alternative; boundary="94eb2c0d90320843c5055e954d08" archived-at: Wed, 22 Nov 2017 17:03:58 -0000 --94eb2c0d90320843c5055e954d08 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 : > Regarding: > > PRICE=3D"0,6" TAX=3D"7" primaryProductCategoryId=3D"10001" > productTypeId=3D"FINISHED_GOOD" inventoryItemTypeId=3D"SERIALIZED_INV_ITE= M" > isVirtual=3D"N" isVariant=3D"N" inShippingBox=3D"N" createdDate=3D"2017-1= 1-21 > 16:32:57.0" lastModifiedDate=3D"2017-11-21 16:33:21.0" > lastUpdatedStamp=3D"2017-11-21 16:33:21.0" createdTxStamp=3D"2017-11-21 > 16:33:21.0" createdByUserLogin=3D"admin" lastModifiedByUserLogin=3D"admin= " > lotIdFilledIn=3D"Allowed" billOfMaterialLevel=3D"0" createdStamp=3D"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 " table, and ONLY the columns in that table are legal for each of the lines > in your ofbiz XML. For instance, you have "PRICE=3D"0,6" TAX=3D"7"... N= either > "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=3D# \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'l= l > 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 > 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 : > >> > >> Thanks Mike, > >>> > >>> I used xmlstarlet and this is the result for 2 products, I made 2 fil= es > >>> Product.xml and ProductPrice.xml. Do you think it can work? > >>> > >>> Best regards > >>> > >>> Product.xml > >>> > >>> >>> PRICE=3D"0,6" TAX=3D"7" primaryProductCategoryId=3D"10001" > >>> productTypeId=3D"FINISHED_GOOD" inventoryItemTypeId=3D" > SERIALIZED_INV_ITEM" > >>> isVirtual=3D"N" isVariant=3D"N" inShippingBox=3D"N" createdDate=3D"20= 17-11-21 > >>> 16:32:57.0" lastModifiedDate=3D"2017-11-21 16:33:21.0" > >>> lastUpdatedStamp=3D"2017-11-21 16:33:21.0" createdTxStamp=3D"2017-11-= 21 > >>> 16:33:21.0" createdByUserLogin=3D"admin" lastModifiedByUserLogin=3D"a= dmin" > >>> lotIdFilledIn=3D"Allowed" billOfMaterialLevel=3D"0" > createdStamp=3D"2017-11-21 > >>> 16:32:57.0"/> > >>> > >>> >>> PRICE=3D"0,49" TAX=3D"7" primaryProductCategoryId=3D"10001" > >>> productTypeId=3D"FINISHED_GOOD" inventoryItemTypeId=3D" > SERIALIZED_INV_ITEM" > >>> isVirtual=3D"N" isVariant=3D"N" inShippingBox=3D"N" createdDate=3D"20= 17-11-21 > >>> 16:32:57.0" lastModifiedDate=3D"2017-11-21 16:33:21.0" > >>> lastUpdatedStamp=3D"2017-11-21 16:33:21.0" createdTxStamp=3D"2017-11-= 21 > >>> 16:33:21.0" createdByUserLogin=3D"admin" lastModifiedByUserLogin=3D"a= dmin" > >>> lotIdFilledIn=3D"Allowed" billOfMaterialLevel=3D"0" > createdStamp=3D"2017-11-21 > >>> 16:32:57.0"/> > >>> > >>> > >>> ProductPrice.xml > >>> > >>> >>> createdDate=3D"2017-11-21 16:32:57.0" lastModifiedDate=3D"2017-11-21 > >>> 16:33:21.0" lastUpdatedStamp=3D"2017-11-21 16:33:21.0" > >>> createdTxStamp=3D"2017-11-21 16:33:21.0" createdByUserLogin=3D"admin" > >>> lastModifiedByUserLogin=3D"admin" createdStamp=3D"2017-11-21 16:32:57= .0" > >>> currencyUomId=3D"EUR" productStoreGroupId=3D"_NA_" fromDate=3D"2017-1= 1-22 > >>> 07:15:53.0" productPricePurposeId=3D"PURCHASE" > >>> productPriceTypeId=3D"DEFAULT_PRICE" > >>> taxInPrice=3D"Y"/> > >>> > >>> >>> createdDate=3D"2017-11-21 16:32:57.0" lastModifiedDate=3D"2017-11-21 > >>> 16:33:21.0" lastUpdatedStamp=3D"2017-11-21 16:33:21.0" > >>> createdTxStamp=3D"2017-11-21 16:33:21.0" createdByUserLogin=3D"admin" > >>> lastModifiedByUserLogin=3D"admin" createdStamp=3D"2017-11-21 16:32:57= .0" > >>> currencyUomId=3D"EUR" productStoreGroupId=3D"_NA_" fromDate=3D"2017-1= 1-22 > >>> 07:15:53.0" productPricePurposeId=3D"PURCHASE" > >>> productPriceTypeId=3D"DEFAULT_PRICE" > >>> taxInPrice=3D"Y"/> > >>> > >>> > >>> 2017-11-21 15:49 GMT+00:00 Mike : > >>> > >>> It is a two step process as I outlined in my previous email. From yo= ur > >>>> 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 unt= il > >>>> 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" XM= L > >>>> 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 wrote: > >>>> > >>>> Thanks Mike, > >>>>> > >>>>> One of the biggest problems in my current program is that it does n= ot > >>>>> 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 b= e > >>>>> organizing it from Ofbiz. > >>>>> > >>>>> I have to familiarize myself with the schema of the database. I hav= e > >>>>> > >>>> been > >>>> > >>>>> studying a bit the OfbizDataModelBook. > >>>>> > >>>>> Best regards. > >>>>> > >>>>> 2017-11-17 18:31 GMT+00:00 Mike : > >>>>> > >>>>> 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 T= HE > >>>>>> 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 hav= e > >>>>>> 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 WIL= L > be > >>>>>> importing the same seed (store) data (example below), over and ove= r > >>>>>> 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. > >>>>> > >>>>>> > >>>>>> > >>>>>> >>>>>> > >>>>> useQuickAdd=3D"N" > >>>> > >>>>> viewAllowPermReqd=3D"N" purchaseAllowPermReqd=3D"N" > >>>>>> > >>>>> createdStamp=3D"2017-11-05 > >>>> > >>>>> 10:59:43"/> > >>>>>> >>>>>> productCategoryTypeId=3D"CATALOG_CATEGORY" categoryName=3D"Gallery= " > >>>>>> description=3D"Gallery" createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> prodCatalogCategoryTypeId=3D"PCCT_BROWSE_ROOT" fromDate=3D"2017-11= -05 > >>>>>> 10:59:43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productCategoryTypeId=3D"SEARCH_CATEGORY" categoryName=3D"Gallery > Search" > >>>>>> description=3D"Gallery Search" createdStamp=3D"2017-11-05 10:59:43= "/> > >>>>>> >>>>>> productCategoryId=3D"Gallery_SEARCH" prodCatalogCategoryTypeId=3D" > >>>>>> > >>>>> PCCT_SEARCH" > >>>>> > >>>>>> fromDate=3D"2017-11-05 10:59:43" createdStamp=3D"2017-11-05 10:59:= 43"/> > >>>>>> >>>>>> fromDate=3D"2017-11-05 10:59:43" createdStamp=3D"2017-11-05 10:59:= 43"/> > >>>>>> >>>>>> contentName=3D"Product Description" createdDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productCategoryTypeId=3D"CATALOG_CATEGORY" > >>>>>> > >>>>> primaryParentCategoryId=3D"10000" > >>>> > >>>>> description=3D"Games & Entertainment" createdStamp=3D"2017-11-0= 5 > >>>>>> 10:59:43"/> > >>>>>> >>>>>> parentProductCategoryId=3D"10000" sequenceNum=3D"1" > fromDate=3D"2017-11-05 > >>>>>> 10:59:43" createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> Entertainment" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> dataResourceId=3D"10001Den" description=3D"DESCRIPTION en 10001" > >>>>>> localeString=3D"en" createdDate=3D"2017-11-05 10:59:43" > >>>>>> createdByUserLogin=3D"admin" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> contentId=3D"10001Den" > >>>>>> prodCatContentTypeId=3D"CATEGORY_NAME" fromDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> contentAssocTypeId=3D"ALTERNATE_LOCALE" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> textData=3D"games-entertainment" > >>>> > >>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> dataResourceId=3D"10001Aen" description=3D"ALT_URL en 10001" > >>>>>> > >>>>> localeString=3D"en" > >>>>> > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> contentId=3D"10001Aen" > >>>>>> prodCatContentTypeId=3D"ALTERNATIVE_URL" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> contentAssocTypeId=3D"ALTERNATIVE_URL" fromDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> > >>>>>> > >>>>>> "one product" example: > >>>>>> > >>>>>> > >>>>>> > >>>>>> >>>>>> primaryProductCategoryId=3D"10002" internalName=3D"798936836182" > >>>>>> brandName=3D"SELECTSOFT GAMES" comments=3D"JEWEL CASE EVERYONE" > >>>>>> smallImageUrl=3D"/images/products/10000/1001MINIGOLF/small.jpg" > >>>>>> mediumImageUrl=3D"/images/products/10000/1001MINIGOLF/medium.jpg" > >>>>>> largeImageUrl=3D"/images/products/10000/1001MINIGOLF/large.jpg" > >>>>>> originalImageUrl=3D"/images/products/10000/1001MINIGOLF/original.j= pg" > >>>>>> detailImageUrl=3D"/images/products/10000/1001MINIGOLF/detail.jpg" > >>>>>> inventoryMessage=3D"Ships from NashVille" requireInventory=3D"N" > >>>>>> weightUomId=3D"WT_lb" weight=3D".350000" productWeight=3D".350000" > >>>>>> > >>>>> returnable=3D"Y" > >>>>> > >>>>>> taxable=3D"Y" chargeShipping=3D"Y" isVirtual=3D"N" isVariant=3D"N" > >>>>>> requirementMethodEnumId=3D"PRODRQM_DS" billOfMaterialLevel=3D"0" > >>>>>> introductionDate=3D"2007-06-14 00:00:00" salesDiscontinuationDate= =3D" > >>>>>> 2038-01-01 > >>>>>> 00:00:00" createdDate=3D"2017-11-05 10:59:43" > createdByUserLogin=3D"admin" > >>>>>> autoCreateKeywords=3D"Y"/> > >>>>>> >>>>>> > >>>>> productId=3D"798936836182" > >>>> > >>>>> fromDate=3D"2007-06-14 00:00:00" thruDate=3D"2038-01-01 00:00:00" > >>>>>> sequenceNum=3D"0" quantity=3D"0" createdStamp=3D"2017-11-05 10:59:= 43"/> > >>>>>> >>>>>> productId=3D"798936836182" fromDate=3D"2007-06-14 00:00:00" > >>>>>> thruDate=3D"2038-01-01 00:00:00" sequenceNum=3D"0" quantity=3D"0" > >>>>>> createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> > >>>>> PRICE" > >>>>> > >>>>>> productPricePurposeId=3D"PURCHASE" currencyUomId=3D"USD" > >>>>>> > >>>>> termUomId=3D"OTH_ea" > >>>> > >>>>> productStoreGroupId=3D"_NA_" price=3D"3.85" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin"/> > >>>>>> productPriceTypeId=3D"LIST_PRICE > >>>>>> > >>>>> " > >>>> > >>>>> productPricePurposeId=3D"PURCHASE" currencyUomId=3D"USD" > >>>>>> > >>>>> termUomId=3D"OTH_ea" > >>>> > >>>>> productStoreGroupId=3D"_NA_" price=3D"9.95" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin"/> > >>>>>> productPriceTypeId=3D"WHOLESALE_ > >>>>>> PRICE" > >>>>>> productPricePurposeId=3D"PURCHASE" currencyUomId=3D"USD" > >>>>>> > >>>>> termUomId=3D"OTH_ea" > >>>> > >>>>> productStoreGroupId=3D"_NA_" price=3D"2.75" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin"/> > >>>>>> >>>>>> availableFromDate=3D"2017-11-05 10:59:43" > supplierPrefOrderId=3D"10_MAIN_ > >>>>>> SUPPL" > >>>>>> standardLeadTimeDays=3D"1" minimumOrderQuantity=3D"1" > >>>>>> > >>>>> orderQtyIncrements=3D"1" > >>>> > >>>>> unitsIncluded=3D"1" quantityUomId=3D"OTH_ea" currencyUomId=3D"USD" > >>>>>> supplierProductName=3D"1001 MINIGOLF CHALLENGE" > >>>>>> supplierProductId=3D"1001MINIGOLF" canDropShip=3D"Y" comments=3D"S= upplier > >>>>>> Comment" createdStamp=3D"2017-11-05 10:59:43" lastPrice=3D"3.85"/> > >>>>>> >>>>>> goodIdentificationTypeId=3D"UPCA" idValue=3D"798936836182" > >>>>>> createdStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> lastInventoryCount=3D"9.000000" createdStamp=3D"2017-11-05 10:59:4= 3"/> > >>>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> MINIGOLF > >>>> > >>>>> CHALLENGE" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> > >>>>> createdTxStamp=3D"2017-11-05 > >>>> > >>>>> 10:59:43"/> > >>>>>> >>>>>> dataResourceId=3D"798936836182Den" description=3D"DESCRIPTION en > >>>>>> > >>>>> 798936836182" > >>>>> > >>>>>> localeString=3D"en" createdDate=3D"2017-11-05 10:59:43" > >>>>>> createdByUserLogin=3D"admin" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productContentTypeId=3D"DESCRIPTION" fromDate=3D"2017-11-05 10:59:= 43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Den" > >>>> > >>>>> contentAssocTypeId=3D"ALTERNATE_LOCALE" fromDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Den" > >>>> > >>>>> contentAssocTypeId=3D"SUB_CONTENT" fromDate=3D"2017-11-05 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> textData=3D"1001-minigolf-challenge" createdStamp=3D"2017-11-05 > 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> dataResourceId=3D"798936836182Aen" description=3D"ALT_URL en > >>>>>> > >>>>> 798936836182" > >>>> > >>>>> localeString=3D"en" createdDate=3D"2017-11-05 10:59:43" > >>>>>> createdByUserLogin=3D"admin" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productContentTypeId=3D"ALTERNATIVE_URL" fromDate=3D"2017-11-05 > 10:59:43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Aen" > >>>> > >>>>> contentAssocTypeId=3D"ALTERNATIVE_URL" fromDate=3D"2017-11-05 10:59= :43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> to > >>>>>> > >>>>> the > >>>>> > >>>>>> largest mini-golf course ever" createdStamp=3D"2017-11-05 10:59:43= " > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> dataResourceId=3D"798936836182Len" description=3D"DESCRIPTION en > >>>>>> > >>>>> 798936836182" > >>>>> > >>>>>> localeString=3D"en" createdDate=3D"2017-11-05 10:59:43" > >>>>>> createdByUserLogin=3D"admin" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productContentTypeId=3D"LONG_DESCRIPTION" fromDate=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43" > >>>> > >>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Len" > >>>> > >>>>> contentAssocTypeId=3D"ALTERNATE_LOCALE" fromDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Len" > >>>> > >>>>> contentAssocTypeId=3D"SUB_CONTENT" fromDate=3D"2017-11-05 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> dataResourceTypeId=3D"ELECTRONIC_TEXT" localeString=3D"en" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> MINIGOLF > >>>> > >>>>> CHALLENGE" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> > >>>>> createdTxStamp=3D"2017-11-05 > >>>> > >>>>> 10:59:43"/> > >>>>>> >>>>>> dataResourceId=3D"798936836182Nen" description=3D"DESCRIPTION en > >>>>>> > >>>>> 798936836182" > >>>>> > >>>>>> localeString=3D"en" createdDate=3D"2017-11-05 10:59:43" > >>>>>> createdByUserLogin=3D"admin" createdStamp=3D"2017-11-05 10:59:43" > >>>>>> createdTxStamp=3D"2017-11-05 10:59:43"/> > >>>>>> >>>>>> productContentTypeId=3D"PRODUCT_NAME" fromDate=3D"2017-11-05 10:59= :43" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Nen" > >>>> > >>>>> contentAssocTypeId=3D"ALTERNATE_LOCALE" fromDate=3D"2017-11-05 10:5= 9:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> >>>>>> > >>>>> contentIdTo=3D"798936836182Nen" > >>>> > >>>>> contentAssocTypeId=3D"SUB_CONTENT" fromDate=3D"2017-11-05 10:59:43" > >>>>>> createdDate=3D"2017-11-05 10:59:43" createdByUserLogin=3D"admin" > >>>>>> createdStamp=3D"2017-11-05 10:59:43" createdTxStamp=3D"2017-11-05 > >>>>>> > >>>>> 10:59:43"/> > >>>> > >>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> On Fri, Nov 17, 2017 at 1:43 AM, Javier 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 > >>>>> > >>>>>> >>>>>>> > >>>>>> type-code=3D"UTF-8" > >>>> > >>>>> delimiter=3D" " text-delimiter=3D"" > >>>>>>> description=3D"this takes the product data from doba file" > >>>>>>> has-header=3D"true"> > >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> default-value=3D"dropShip" type=3D"String"/> > >>>>>>> >>>>>>> default-value=3D"FINISHED_GOOD" type=3D"String"/> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> > >>>>>> type=3D"String"/> > >>>> > >>>>> > >>>>>>> > >>>>>>> >>>>>>> > >>>>>> default-value=3D"WT_lb" > >>>>> > >>>>>> type=3D"String"/> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> > >>>>>> default-value=3D"1" > >>>>>> > >>>>>>> type=3D"String"/> > >>>>>>> > >>>>>>> > >>>>>>> >>>>>>> > >>>>>> type=3D"String"/> > >>>>>> > >>>>>>> >>>>>>> > >>>>>> type=3D"String"/> > >>>>>> > >>>>>>> > >>>>>>> > >>>>>>> default-value=3D"N" > >>>>>>> type=3D"String"/> > >>>>>>> default-value=3D"N" > >>>>>>> type=3D"String"/> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> but always I get this error "No elements found in > >>>>>>> file:/home/user/data-file.xml" > >>>>>>> > >>>>>>> Best regards > >>>>>>> > >>>>>>> 2017-11-17 9:30 GMT+00:00 Jacques Le Roux < > >>>>>>> > >>>>>> jacques.le.roux@les7arts.com> > >>>>> > >>>>>> : > >>>>>> > >>>>>>> Le 17/11/2017 =C3=A0 09:43, Javier H. a =C3=A9crit : > >>>>>>>> > >>>>>>>> On 2017-11-17 08:05, Michael Brohl > >>>>>>>>> > >>>>>>>> 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." wrote: > >>>>>>>>>>> > >>>>>>>>>>> On 2017-11-14 08:02, "pierre.gaudin" < > >>>>>>>>>>>> > >>>>>>>>>>> pierre.gaudin@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: > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> >>>>>>>>>>> CODE=3D"1308051" > >>>>>>>>>>> DESCR=3D"DEMO PRODUCT" > >>>>>>>>>>> PRICE=3D"5,50" > >>>>>>>>>>> TAX=3D"21" > >>>>>>>>>>> QUANTITY=3D"40" > >>>>>>>>>>> LASTPRICE=3D"4,9" > >>>>>>>>>>> TAXCODE=3D"3" > >>>>>>>>>>> PROVIDER=3D"87" > >>>>>>>>>>> CATEGORY=3D"00099" > >>>>>>>>>>> DATE=3D"01012015" > >>>>>>>>>>> /> > >>>>>>>>>>> > >>>>>>>>>>> ..... > >>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>>> 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 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 > >>>>>>> > >>>>>>> > >>> > > > --94eb2c0d90320843c5055e954d08--