Re: File format to import products

Javier Wed, 22 Nov 2017 00:33:13 -0800

Thanks Mike,

I used xmlstarlet and this is the result for 2 products, I made 2 files
Product.xml and ProductPrice.xml. Do you think it can work?


Best regards

Product.xml

    <Product productID="JR119" productName="CONECTOR SOCKET 3POS IDC"
PRICE="0,6" TAX="7" primaryProductCategoryId="10001"
productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
16:32:57.0"/>

    <Product productID="JR120" productName="CONECTOR SOCKET 2POS IDC"
PRICE="0,49" TAX="7" primaryProductCategoryId="10001"
productTypeId="FINISHED_GOOD" inventoryItemTypeId="SERIALIZED_INV_ITEM"
isVirtual="N" isVariant="N" inShippingBox="N" createdDate="2017-11-21
16:32:57.0" lastModifiedDate="2017-11-21 16:33:21.0"
lastUpdatedStamp="2017-11-21 16:33:21.0" createdTxStamp="2017-11-21
16:33:21.0" createdByUserLogin="admin" lastModifiedByUserLogin="admin"
lotIdFilledIn="Allowed" billOfMaterialLevel="0" createdStamp="2017-11-21
16:32:57.0"/>


ProductPrice.xml

    <ProductPrice productID="JR119" price="0,6" taxPercentage="7"
createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
07:15:53.0" productPricePurposeId="PURCHASE"
productPriceTypeId="DEFAULT_PRICE" taxInPrice="Y"/>

    <ProductPrice productID="JR120" price="0,49" taxPercentage="7"
createdDate="2017-11-21 16:32:57.0" lastModifiedDate="2017-11-21
16:33:21.0" lastUpdatedStamp="2017-11-21 16:33:21.0"
createdTxStamp="2017-11-21 16:33:21.0" createdByUserLogin="admin"
lastModifiedByUserLogin="admin" createdStamp="2017-11-21 16:32:57.0"
currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2017-11-22
07:15:53.0" productPricePurposeId="PURCHASE"
productPriceTypeId="DEFAULT_PRICE" taxInPrice="Y"/>


2017-11-21 15:49 GMT+00:00 Mike <[email protected]>:

> It is a two step process as I outlined in my previous email.  From your
> source XML/CSV, you create (via an external utility) the
> catalog/categories/sub-categories into an ofbiz-compatible "catalog" XML
> file.
>
> You then test import the "catalog" XML file, OVER and OVER again until it
> looks proper. Why do you do this?  Because it will require tweaking.  Doing
> this in the ofbiz GUI would be tedious and error prone.
>
> You have to create "seed" compatible data.  After the catalog looks good,
> you repeat the same process (create an ofbiz-compatible "product" XML file)
> with the products.
>
> You really don't need the OfbizDataModelBook at this point, my previous
> email showed you the tables and the order.
>
> Good luck.
>
> On Mon, Nov 20, 2017 at 10:54 PM, Javier <[email protected]> wrote:
>
> > Thanks Mike,
> >
> > One of the biggest problems in my current program is that it does not
> > support SubCategories.
> >
> > So I have to reorganize all the Categories.
> >
> > So at the moment it would be enough for me to load all the products in a
> > category (for example, the Uncategorised family) and then I would be
> > organizing it from Ofbiz.
> >
> > I have to familiarize myself with the schema of the database. I have been
> > studying a bit the OfbizDataModelBook.
> >
> > Best regards.
> >
> > 2017-11-17 18:31 GMT+00:00 Mike <[email protected]>:
> >
> > > Nothing is simple in ofbiz.  There are a butt load of tables that have
> to
> > > be imported in ofbiz... for ONE category, and for ONE product, IN THE
> > > CORRECT ORDER!!!
> > >
> > > First, you have to pre-populate your categories. (example below)
> > >
> > > Then you can add the products.  (one product example below)
> > >
> > > All this takes a lot of time organizing and analyzing in order to
> > > understand the ofbiz schema.
> > >
> > > For the XML you posted, you have to create a custom script (i.e.
> > > perl/python/java) that reads each XML "row", and creates ofbiz XML
> > > compatible "seed"  file(s).
> > >
> > > If you write your own script, vice relying on ofbiz tools, you have
> > > absolute control over what exactly is imported, and no data limits.
> Want
> > > alternate URLs?  What multi language support?  Change your script.
> > >
> > > In addition, when you are setting up a new ofbiz instance, you WILL be
> > > importing the same seed (store) data (example below), over and over
> > > again...  This is why you must create ofbiz compatible "seed" data for
> > your
> > > store.  All the experts here know that.
> > >
> > > "one category" example... "10000" is top level, "10001" is first
> > category.
> > >
> > > <?xml version="1.0" encoding="UTF-8"?>
> > > <entity-engine-xml>
> > > <ProdCatalog prodCatalogId="10000" catalogName="Gallery"
> useQuickAdd="N"
> > > viewAllowPermReqd="N" purchaseAllowPermReqd="N"
> createdStamp="2017-11-05
> > > 10:59:43"/>
> > > <ProductCategory productCategoryId="10000"
> > > productCategoryTypeId="CATALOG_CATEGORY" categoryName="Gallery"
> > > description="Gallery" createdStamp="2017-11-05 10:59:43"/>
> > > <ProdCatalogCategory prodCatalogId="10000" productCategoryId="10000"
> > > prodCatalogCategoryTypeId="PCCT_BROWSE_ROOT" fromDate="2017-11-05
> > > 10:59:43"
> > > createdStamp="2017-11-05 10:59:43"/>
> > > <ProductCategory productCategoryId="Gallery_SEARCH"
> > > productCategoryTypeId="SEARCH_CATEGORY" categoryName="Gallery Search"
> > > description="Gallery Search" createdStamp="2017-11-05 10:59:43"/>
> > > <ProdCatalogCategory prodCatalogId="10000"
> > > productCategoryId="Gallery_SEARCH" prodCatalogCategoryTypeId="
> > PCCT_SEARCH"
> > > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> > > <ProductStoreCatalog productStoreId="Gallery" prodCatalogId="10000"
> > > fromDate="2017-11-05 10:59:43" createdStamp="2017-11-05 10:59:43"/>
> > > <Content contentId="PROD_DESCRIPTION" contentTypeId="DOCUMENT"
> > > contentName="Product Description" createdDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43"/>
> > > <ProductCategory productCategoryId="10001"
> > > productCategoryTypeId="CATALOG_CATEGORY" primaryParentCategoryId="
> 10000"
> > > description="Games &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/original.jpg"
> > > detailImageUrl="/images/products/10000/1001MINIGOLF/detail.jpg"
> > > inventoryMessage="Ships from NashVille" requireInventory="N"
> > > weightUomId="WT_lb" weight=".350000" productWeight=".350000"
> > returnable="Y"
> > > taxable="Y" chargeShipping="Y" isVirtual="N" isVariant="N"
> > > requirementMethodEnumId="PRODRQM_DS" billOfMaterialLevel="0"
> > > introductionDate="2007-06-14 00:00:00" salesDiscontinuationDate="
> > > 2038-01-01
> > > 00:00:00" createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > autoCreateKeywords="Y"/>
> > > <ProductCategoryMember productCategoryId="10002"
> productId="798936836182"
> > > fromDate="2007-06-14 00:00:00" thruDate="2038-01-01 00:00:00"
> > > sequenceNum="0" quantity="0" createdStamp="2017-11-05 10:59:43"/>
> > > <ProductCategoryMember productCategoryId="Gallery_SEARCH"
> > > productId="798936836182" fromDate="2007-06-14 00:00:00"
> > > thruDate="2038-01-01 00:00:00" sequenceNum="0" quantity="0"
> > > createdStamp="2017-11-05 10:59:43"/>
> > > <ProductPrice productId="798936836182" productPriceTypeId="DEFAULT_
> > PRICE"
> > > productPricePurposeId="PURCHASE" currencyUomId="USD"
> termUomId="OTH_ea"
> > > productStoreGroupId="_NA_" price="3.85" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>
> > > <ProductPrice productId="798936836182" productPriceTypeId="LIST_PRICE"
> > > productPricePurposeId="PURCHASE" currencyUomId="USD"
> termUomId="OTH_ea"
> > > productStoreGroupId="_NA_" price="9.95" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>
> > > <ProductPrice productId="798936836182" productPriceTypeId="WHOLESALE_
> > > PRICE"
> > > productPricePurposeId="PURCHASE" currencyUomId="USD"
> termUomId="OTH_ea"
> > > productStoreGroupId="_NA_" price="2.75" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"/>
> > > <SupplierProduct productId="798936836182" partyId="Gallery"
> > > availableFromDate="2017-11-05 10:59:43" supplierPrefOrderId="10_MAIN_
> > > SUPPL"
> > > standardLeadTimeDays="1" minimumOrderQuantity="1"
> orderQtyIncrements="1"
> > > unitsIncluded="1" quantityUomId="OTH_ea" currencyUomId="USD"
> > > supplierProductName="1001 MINIGOLF CHALLENGE"
> > > supplierProductId="1001MINIGOLF" canDropShip="Y" comments="Supplier
> > > Comment" createdStamp="2017-11-05 10:59:43" lastPrice="3.85"/>
> > > <GoodIdentification productId="798936836182"
> > > goodIdentificationTypeId="UPCA" idValue="798936836182"
> > > createdStamp="2017-11-05 10:59:43"/>
> > > <ProductFacility productId="798936836182" facilityId="Gallery"
> > > lastInventoryCount="9.000000" createdStamp="2017-11-05 10:59:43"/>
> > > <DataResource dataResourceId="798936836182Den"
> > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ElectronicText dataResourceId="798936836182Den" textData="1001
> MINIGOLF
> > > CHALLENGE" createdStamp="2017-11-05 10:59:43"
> createdTxStamp="2017-11-05
> > > 10:59:43"/>
> > > <Content contentId="798936836182Den" contentTypeId="DOCUMENT"
> > > dataResourceId="798936836182Den" description="DESCRIPTION en
> > 798936836182"
> > > localeString="en" createdDate="2017-11-05 10:59:43"
> > > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <ProductContent productId="798936836182" contentId="798936836182Den"
> > > productContentTypeId="DESCRIPTION" fromDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="798936836182Den" contentIdTo="798936836182Den"
> > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="PROD_DESCRIPTION"
> contentIdTo="798936836182Den"
> > > contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <DataResource dataResourceId="798936836182Aen"
> > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ElectronicText dataResourceId="798936836182Aen"
> > > textData="1001-minigolf-challenge" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <Content contentId="798936836182Aen" contentTypeId="DOCUMENT"
> > > dataResourceId="798936836182Aen" description="ALT_URL en 798936836182"
> > > localeString="en" createdDate="2017-11-05 10:59:43"
> > > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <ProductContent productId="798936836182" contentId="798936836182Aen"
> > > productContentTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="798936836182Aen" contentIdTo="798936836182Aen"
> > > contentAssocTypeId="ALTERNATIVE_URL" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <DataResource dataResourceId="798936836182Len"
> > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ElectronicText dataResourceId="798936836182Len" textData="Welcome to
> > the
> > > largest mini-golf course ever" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <Content contentId="798936836182Len" contentTypeId="DOCUMENT"
> > > dataResourceId="798936836182Len" description="DESCRIPTION en
> > 798936836182"
> > > localeString="en" createdDate="2017-11-05 10:59:43"
> > > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <ProductContent productId="798936836182" contentId="798936836182Len"
> > > productContentTypeId="LONG_DESCRIPTION" fromDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="798936836182Len" contentIdTo="798936836182Len"
> > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="PROD_DESCRIPTION"
> contentIdTo="798936836182Len"
> > > contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <DataResource dataResourceId="798936836182Nen"
> > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="en"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ElectronicText dataResourceId="798936836182Nen" textData="1001
> MINIGOLF
> > > CHALLENGE" createdStamp="2017-11-05 10:59:43"
> createdTxStamp="2017-11-05
> > > 10:59:43"/>
> > > <Content contentId="798936836182Nen" contentTypeId="DOCUMENT"
> > > dataResourceId="798936836182Nen" description="DESCRIPTION en
> > 798936836182"
> > > localeString="en" createdDate="2017-11-05 10:59:43"
> > > createdByUserLogin="admin" createdStamp="2017-11-05 10:59:43"
> > > createdTxStamp="2017-11-05 10:59:43"/>
> > > <ProductContent productId="798936836182" contentId="798936836182Nen"
> > > productContentTypeId="PRODUCT_NAME" fromDate="2017-11-05 10:59:43"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="798936836182Nen" contentIdTo="798936836182Nen"
> > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > <ContentAssoc contentId="PROD_DESCRIPTION"
> contentIdTo="798936836182Nen"
> > > contentAssocTypeId="SUB_CONTENT" fromDate="2017-11-05 10:59:43"
> > > createdDate="2017-11-05 10:59:43" createdByUserLogin="admin"
> > > createdStamp="2017-11-05 10:59:43" createdTxStamp="2017-11-05
> 10:59:43"/>
> > > </entity-engine-xml>
> > >
> > >
> > >
> > > On Fri, Nov 17, 2017 at 1:43 AM, Javier <[email protected]> wrote:
> > >
> > > > Hi Jacques,
> > > >
> > > > Yes, both, but I have problems in step 4:
> > > >
> > > >
> > > >    1. connect to the Webtools application
> > > >    2. go to the "Work With Data Files" screen
> > > >    3. enter the path to the your definition file in the "Definition
> > > >    Filename or URL" input field
> > > >    4. click on the submit button
> > > >
> > > >
> > > > I have used this file
> > > > /opt/apache-ofbiz-16.11.03/framework/datafile/dtd/datafiles.xsd and
> > this
> > > >
> > > > <data-file name="Product" separator-style="delimited"
> type-code="UTF-8"
> > > >     delimiter="&#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 <
> > [email protected]>
> > > :
> > > >
> > > > > Le 17/11/2017 à 09:43, Javier H. a écrit :
> > > > >
> > > > >>
> > > > >> On 2017-11-17 08:05, Michael Brohl <[email protected]>
> > wrote:
> > > > >>
> > > > >>> Hi Javier,
> > > > >>>
> > > > >>> why not directly export to the OFBiz datafile format?
> > > > >>>
> > > > >>> Regards,
> > > > >>>
> > > > >>> Michael
> > > > >>>
> > > > >>>
> > > > >>> Am 17.11.17 um 09:03 schrieb Javier H.:
> > > > >>>
> > > > >>>> On 2017-11-14 08:21, "Javier H."<[email protected]> wrote:
> > > > >>>>
> > > > >>>>> On 2017-11-14 08:02, "pierre.gaudin" <[email protected]
> >
> > > > wrote:
> > > > >>>>>
> > > > >>>>>> On 14/11/2017 08:55, Javier H. wrote:
> > > > >>>>>>
> > > > >>>>>>> Hello,
> > > > >>>>>>>
> > > > >>>>>>> I have to import about 95.000 products into Ofbiz (mysql
> > > database).
> > > > >>>>>>>
> > > > >>>>>>> I can import it to TXT or SQL formats, also to XLS but I get
> a
> > > > error
> > > > >>>>>>> because max is 65.000 rows.
> > > > >>>>>>>
> > > > >>>>>>> What format do you recommend for import, TXT or SQL?
> > > > >>>>>>>
> > > > >>>>>>> Best regards
> > > > >>>>>>>
> > > > >>>>>>> Hi Javier
> > > > >>>>>>
> > > > >>>>>> We used to import about 700 000 article for a customer.
> > > > >>>>>>
> > > > >>>>>> We used XML import via XSLT transformation to do so. I don't
> > think
> > > > >>>>>> there
> > > > >>>>>> is a limit with xml import.
> > > > >>>>>>
> > > > >>>>>>
> > > > >>>>>> Pierre
> > > > >>>>>>
> > > > >>>>>> Thank you Pierre,
> > > > >>>>>>
> > > > >>>>> I think that I can to export to XML, I have to check it.
> > > > >>>>>
> > > > >>>>> Best regards
> > > > >>>>> Hello,
> > > > >>>>>
> > > > >>>> I have exported the data to an XML file.
> > > > >>>>
> > > > >>>> Something similar to this:
> > > > >>>>
> > > > >>>> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> > > > >>>> <RECORDS>
> > > > >>>>     <RECORD>
> > > > >>>>       <ROW
> > > > >>>>         CODE="1308051"
> > > > >>>>         DESCR="DEMO PRODUCT"
> > > > >>>>         PRICE="5,50"
> > > > >>>>         TAX="21"
> > > > >>>>         QUANTITY="40"
> > > > >>>>         LASTPRICE="4,9"
> > > > >>>>         TAXCODE="3"
> > > > >>>>         PROVIDER="87"
> > > > >>>>         CATEGORY="00099"
> > > > >>>>         DATE="01012015"
> > > > >>>>       />
> > > > >>>>     </RECORD>
> > > > >>>>     .....
> > > > >>>> </RECORDS>
> > > > >>>>
> > > > >>>> How can I make the definition file for this?
> > > > >>>>
> > > > >>>> And how can I ignore the fields that I do not want to import?
> (For
> > > > >>>> example DATE).
> > > > >>>>
> > > > >>>> Best regards
> > > > >>>>
> > > > >>>
> > > > >>> Hi Michael,
> > > > >>>
> > > > >> Because I have no idea.
> > > > >>
> > > > >> https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz%27s+
> > > > >> Data+File+Tools
> > > > >>
> > > > >> I'm testing Data File Tools, I added this
> > > "/opt/apache-ofbiz-16.11.03/fr
> > > > >> amework/datafile/dtd/datafiles.xsd" to Definition Filename or
> URL"
> > > but
> > > > I
> > > > >> get this error:
> > > > >>
> > > > >> No <data-file> elements found in file:/opt/apache-ofbiz-16.11.0
> > > > >> 3/framework/datafile/dtd/datafiles.xsd
> > > > >>
> > > > >> Best regards
> > > > >>
> > > > >> Hi Javier,
> > > > >
> > > > > Did you follow https://cwiki.apache.org/confluence/display/OFBIZ/
> > > > OFBiz's+
> > > > > Data+File+Tools ?
> > > > > Did you have a look at https://cwiki.apache.org/confl
> > > > > uence/display/OFBIZ/Handling+of+External+data ?
> > > > >
> > > > > HTH
> > > > >
> > > > > Jacques
> > > > >
> > > > >
> > > >
> > > >
> > > > --
> > > > Saludos
> > > >
> > >
> >
>

Re: File format to import products

Reply via email to