As standard Breece On-Premises imports data from standard CSV data files or XML data, but before the data can be imported into Breece, the system needs configuration to know about the data.:


  1. Go to Breece Explorer, log-in with BreeceAdmin and choose Configuration tab.
  2. Select Data, and now review the box named Product data import:

    W32fodce30ik-3jP-K_AY9C_MsZMJq5-3g.PNG

    • Data source type: Choose between CSV or XML.
    • Import directory: Directory which the product data will be located.
    • Processed directory: After processing a import, the imported file will be copied to this location.
    • Result directory: Contains result files which contains details about how each product in the imported files has been processed (added, updated, deleted, failed)
    • Filename filter: Create a filter to only select a specific file, like data.xml or use wildcard to select all files which starts with data* or ends with *.xml
    • XML Schema path: Is not mandatory, only an option if you like to validate the import data with a XML Schema.
    • XML Append Xml Variables: Allows you to send data using multiple XML files containing each part of the complete product details.
    • CSV Text qualifier: Choose a text qualifier, if you are using ; (semicolon) as field seperator, a text qualifier is needed if you want to use ; in e.g. the description field.
    • CSV Field seperator: Choose the seperator used in the file, normal ; or , or | is used.
    • CSV Ignore first line as data: If your data file contains a header line, this can be ignored to be imported using this feature.
    • Trim spaces: This feature will trim empty spaces in front and after the data in all fields.
    • Use timer watch: Instead of using standard file system events when a file is placed in the import file, enable timer watch if not available or using network shares.
    • Timer interval: Specify the timer interval.


  3. Specify which file type to import, and configure the related settings, in this example a XML file:
    yygkAIUrbN2BvigouJqBRJmF07a7f263Rg.PNG
  4. Create fields which the file contains, press the Add bottom or use the import function.

    EmYgOunNwadWx21deOluy0nQHnJtEXYQAA.PNG

  5. Map the headers to specific fields in the systen:

    Xk4pcNJBo2BxwVurFyFQjFnOKLnIv1f9Uw.PNG

    • Product number field: The unique identifier of the product.
    • Product description field: The name or description of the product, is used to make a more user-friendly navigation within the products.
    • Reorder code field: Is used if you both have a barcode and internal product number on the same product, if not available, map it to the same as product number.
    • Display page 1 design field: Specifiy which design template to use on this product, it could be used to choose between normal or discount layout, or differentiate on product group.
    • Display page 2 design field: Same a above, but for page 2.
    • Record command field: To enable the option to delete a product from the system using product data import, choose a record command field in the import data, and type in value in Add and Delete command field.
    • Add command: Content of record command field if the product should be added, example: 1
    • Delete command: Content of record command field if the product should de deleted, example : 0
    • Design page 1, default value: If no dynamic design selection is made, use this default design template name.


  6. Save the configuration by pressing the Save button, close Breece Explorer and restart Breece Core service, after that - you should be able to import products into the system, simply just place the product files in the import folder, and the system will automatic process it.



Here is a example on a XML data file:

 

<?xml version="1.0" encoding="UTF-8"?>
<Items xmlns:xs="http://www.w3.org/2001/XMLSchema-instance">
<Item>
<PN>70222555</PN>
<Description>Delfi Technologies Test Product</Description>
<Price>99,99</Price>
</Item>
</Items>