ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Javier <droin...@gmail.com>
Subject Re: File format to import products
Date Sun, 26 Nov 2017 17:39:03 GMT
Thank you!

2017-11-23 16:47 GMT+00:00 Mike <mz4wheeler@gmail.com>:

> Javier.  I'd recommend you reduce your sample set to just 2-3 products (to
> save time) until all the tables/columns are importing proper.
>
> On Thu, Nov 23, 2017 at 7:08 AM, Javier <droining@gmail.com> wrote:
>
> > One or Two hours, I don't know to use xmlstarlet, but it's funny.
> >
> > 2017-11-23 14:15 GMT+00:00 Pierre Smits <pierre.smits@gmail.com>:
> >
> > > And how much time did it take you to get everything prepared?
> > >
> > > Pierre Smits
> > >
> > > ORRTIZ.COM <http://www.orrtiz.com>
> > > OFBiz based solutions & services
> > >
> > > OEM - The OFBiz Extensions Marketplace1
> > > http://oem.ofbizci.net/oci-2/
> > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > >
> > > On Wed, Nov 22, 2017 at 8:35 PM, Javier <droining@gmail.com> wrote:
> > >
> > > > 10 minutes, much less than understanding it.
> > > >
> > > > 2017-11-22 18:26 GMT+00:00 Pierre Smits <pierre.smits@gmail.com>:
> > > >
> > > > > Hi Javier,
> > > > >
> > > > > How much time did this import take?
> > > > >
> > > > > Best regards,
> > > > >
> > > > > Pierre Smits
> > > > >
> > > > > ORRTIZ.COM <http://www.orrtiz.com>
> > > > > OFBiz based solutions & services
> > > > >
> > > > > OEM - The OFBiz Extensions Marketplace1
> > > > > http://oem.ofbizci.net/oci-2/
> > > > > 1 not affiliated to (and not endorsed by) the OFBiz project
> > > > >
> > > > > On Wed, Nov 22, 2017 at 6:57 PM, Mike <mz4wheeler@gmail.com>
> wrote:
> > > > >
> > > > > > Javier.  Study my original post of one category and one
> product.  I
> > > > gave
> > > > > > away the keys to the kingdom there [grin].  I would ditch the
> idea
> > of
> > > > one
> > > > > > category.  That is not realistic.  Do it right and create seed
> data
> > > > that
> > > > > > reflects the true tree structure of the categories, and then
> import
> > > the
> > > > > > products with the correctly assigned categories.  Also, other
> > content
> > > > > (like
> > > > > > images) should be filled in.  Good luck.
> > > > > >
> > > > > >
> > > > > > On Wed, Nov 22, 2017 at 9:42 AM, Javier <droining@gmail.com>
> > wrote:
> > > > > >
> > > > > > > Sorry Mike, you were right.
> > > > > > >
> > > > > > > I forgot to remove PRICE and TAX from Product.xml file, but
> they
> > > were
> > > > > > still
> > > > > > > imported.
> > > > > > >
> > > > > > > 2017-11-22 17:21 GMT+00:00 Javier <droining@gmail.com>:
> > > > > > >
> > > > > > > > As Pierre said, the price has to be with a '.' for decimals.
> > > > > > > >
> > > > > > > >
> > > > > > > > 2017-11-22 17:18:37,524 |http-nio-8443-exec-8
> |EntitySaxReader
> > > > > > > >    |W| Could not set field ProductPrice.price to the value
> 8,99
> > > > > > > > java.lang.NumberFormatException
> > > > > > > > at java.math.BigDecimal.<init>(BigDecimal.java:494)
> > > ~[?:1.8.0_151]
> > > > > > > > at java.math.BigDecimal.<init>(BigDecimal.java:383)
> > > ~[?:1.8.0_151]
> > > > > > > > at java.math.BigDecimal.<init>(BigDecimal.java:806)
> > > ~[?:1.8.0_151]
> > > > > > > > at org.apache.ofbiz.entity.GenericEntity.setString(
> > > > > > > GenericEntity.java:574)
> > > > > > > > ~[ofbiz.jar:?]
> > > > > > > > at org.apache.ofbiz.entity.util.
> EntitySaxReader.startElement(
> > > > > > > EntitySaxReader.java:579)
> > > > > > > > [ofbiz.jar:?]
> > > > > > > > > Buildiat org.apache.xerces.parsers.AbstractSAXParser.
> > > > > > > startElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > > > Buildiat org.apache.xerces.parsers.
> > AbstractXMLDocumentParser.
> > > > > > > emptyElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > > at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl
> > > > > > > .scanStartElement(Unknown
> > > > > > > > Source) [xercesImpl-2.9.1.jar:?]
> > > > > > > >
> > > > > > > >
> > > > > > > > 2017-11-22 17:14 GMT+00:00 Javier <droining@gmail.com>:
> > > > > > > >
> > > > > > > >> 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 <droining@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 <droining@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 <mz4wheeler@gmail.com>:
> > > > > > > >>>>
> > > > > > > >>>>> Regarding:
> > > > > > > >>>>>
> > > > > > > >>>>>   <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"/>
> > > > > > > >>>>>
> > > > > > > >>>>> 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.gaudin@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 <droining@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 <
> mz4wheeler@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 <
> > > > > droining@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 <
> > mz4wheeler@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 &amp; 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
> > > > > > &amp;
> > > > > > > >>>>> >>>>>> 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 <
> > > > > droining@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="&#009;" 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.roux@les7arts.com>
> > > > > > > >>>>> >>>>>
> > > > > > > >>>>> >>>>>> :
> > > > > > > >>>>> >>>>>>
> > > > > > > >>>>> >>>>>>> Le 17/11/2017 à 09:43, Javier H. a écrit :
> > > > > > > >>>>> >>>>>>>>
> > > > > > > >>>>> >>>>>>>> On 2017-11-17 08:05, Michael Brohl <
> > > > > > > michael.brohl@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."<
> > > droining@gmail.com
> > > > >
> > > > > > > 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:
> > > > > > > >>>>> >>>>>>>>>>>
> > > > > > > >>>>> >>>>>>>>>>> <?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
> > > > > > > >>>>> >>>>>>>
> > > > > > > >>>>> >>>>>>>
> > > > > > > >>>>> >>>
> > > > > > > >>>>> >
> > > > > > > >>>>>
> > > > > > > >>>>
> > > > > > > >>>>
> > > > > > > >>>
> > > > > > > >>
> > > > > > > >
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message