Understanding the Validation Results and Import Results
The counts displayed on the Validation Results and Import Results tables are explained in the following table. This information is also provided on the Additional Info tab of the template spreadsheet.
Column
Explanation
Total
Total number of rows on the tab that contain data.
Valid
Number of valid rows on the tab.
Invalid (To Be Skipped) / Invalid (Skipped)
Number of rows on the tab with invalid content. These rows are skipped during import.
Already Exist
For the General Information tab—Number of rows matching equipment that is already present, as defined in the system.
For the Equipment Structure tab—Number of rows where the specified relationship already exists in the system.
For the Properties tab—Number of rows where the specified property already exists, as defined in the system.
To Be Created / Created
For the General Information tab—Number of rows specifying equipment that is not already present in the system. The equipment is created on import.
For the Equipment Structure tab—Number of rows with a valid relationship that is not already present in the system. The relationship is created on import.
For the Properties tab—Number of rows where the specified property is not already present in the system. The property is created on import.
To Be Updated / Updated
For the General Information tab—Number of rows that match existing equipment, where some attributes are modified. The equipment is updated on import.
For the Equipment Structure tab—Number of rows matching an existing relationship, where the parent is modified. The relationship is updated on import.
For the Properties tab—Number of rows matching an existing property for which a value is changed. The property value is updated on import.
Was this helpful?