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
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.
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, ...
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, ...
Overwrite/Delete Data with the Excel Import
If you want to clean out larger portions of your data, the Excel Import is an easy approach. Your Excel file contains all segments like you see them in your account: The Excel Import handles every segment individually when importing. You may import ...
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 ...