Validations on Excel/XML Qualifiers Import

Validations on Excel/XML Qualifiers Import

Qualifiers Import Validations

When you import or re-import Qualifiers into PDM, it's important to know that they should meet certain conditions in order to get successfully imported. PDM provides validations for these imports that will help you enhance your data.

To access the Qualifiers Import Validations:

Open the Excel file. In the Qualifier Values column, values must match the Qualifier parameter criteria. For instance, you can see in the image below that the Qualifier Values are set to be two, separated by a pipe.

The parameter criteria state p1 & p2, meaning that two values must exist for the Qualifier to be valid. Let's change these two values for just one.

 Save the file and Import. When importing, select only Applications segment.

When the import is done, go to the Import Reports tab and click on the Errors icon in the Status column.

 It will give you the Error details showing you the row number where it is located, and an explanation that will help you fix the error and re-import.

    • Related Articles

    • Excel Import & Export Reports

      Your data is validated already while importing it. The Excel Import and Export validations give you valuable feedback. The Excel Import and Export reports give you feedback that helps you to improve your files to get non-ACES compliant data into the ...
    • Excel Import & Export

      Excel Import & Export If you want to make changes in your data in bulk or add products in bulk, you can use Excel Import & Export. Excel Import Select the required Brand and click on Import/Export. Click Import (If you want to get a PDM template, ...
    • Overwrite/Delete Data with the Excel Import

      If you want to clean out larger portions of your data, Excel Import is an easy approach. When you Export a full Excel file, it will contain all segments as you see them in your account: The Excel Import handles every segment individually when ...
    • Import/Export Applications

      Import/Export Applications  When updating application values in PDM, like Qualifiers and Notes, you'll need to export these applications, edit them in the excel file and then re-import. You have two options to edit Applications: Applications style ...
    • Update Duplicate Notes/Qualifiers

      Update Duplicate Notes/Qualifiers  PDM allows you to easily find where your data can be improved. There are specific validations that you can turn on in the Scorecards that will show you an alert icon whenever the Notes/Qualifiers are duplicated, ...