Table of Contents

Import DataNorm files

Use DataNorm import to load supplier catalog files into Vendor Catalog. You can review the imported vendor items before you activate them in your master data. This keeps supplier data separate from your items while you check the incoming information.

PRECONDITIONS
  • The DataNorm extension is installed.
  • The number series in Data Import Setup are configured.
  • A partner and mapping are available, or you have permission to create a partner during the import.

DataNorm 4.0 and 5.0 files are supported. The extension creates a default DATANORM mapping when it is installed.

Import a DataNorm file

  1. Select Search (Alt+Q), enter Import from DataNorm, and choose the related link.
  2. On the DataNorm Files Upload step, select Upload and add one or more DataNorm files. You can upload a ZIP file when the supplier provides the files together.
  3. Select Next.
  4. On the Settings step, review or enter Description, DataNorm Version (4.0 or 5.0), Reference Type, Reference No., and Mapping Code. The default version is 5.0 and the default mapping is normally DATANORM.
  5. Select Next.
  6. On the final step, choose Process File: Yes processes immediately, Background processes in the background, and No indexes the file without creating vendor items.
  7. Select Finish.
Note

Reference No. is required when you select an existing partner. It is not required when you select New Partner.

Review the import

After the wizard finishes, the import first has the state Indexed. At this stage, Pimics has read the uploaded files but has not yet created the vendor items.

  1. Select Search (Alt+Q), enter Product Data Imports, and choose the related link.
  2. Select the DataNorm import.
  3. If the state is Indexed, select Import and choose whether to process it in the foreground or in the background.
  4. To inspect source lines, select Indexed Data. To inspect processing problems, select Log.
  5. Select Items to review the vendor items created by the import.

The import can then be Partially imported, Imported, or Archived. Archived imports remain available as a source for their vendor items.

Imported data

DataNorm imports can create vendor items with supplier item information, prices, discounts, texts, pictures, and other supported lines from the source files. Verify the resulting vendor items before activation. Product-group and discount-group files are not a replacement for Pimics category or discount setup.

DataNorm does not provide keywords and features in the same way as every other catalog format. If a supplier sends unsupported line types, review Log and Indexed Data.

Activate the imported items

Use Activate vendor items to check the references and transfer approved data into your master data. Importing a file does not automatically replace master-data values.

HIDDEN

Documentation sources: #38919, #7109, #34189, #35420, #12306.

TODO

Check the commented section and make sure that everything is above and then delete it