Validate imported staging records

Validate the imported staging records from your import task to find missing, duplicate, and invalid data.

시작하기 전에

Role required: ot_excel_import_user

프로시저

1. Navigate to All > Industrial Workspace.
2. Select the List () icon.
3. Under the OT Excel SGC - Import Task module, select one of the available lists.
4. Select the Import Task record that you want to validate.
5. Ensure you're the assigned to the import task so you can see the Validate UI action.
   주:

   If you aren't in the Assigned to field of the import task, click the Assign to me UI action before proceeding with the next step.
6. Click the Validate UI action.
   Once the validation process is complete, the State field of the Import Task record changes to Validation complete. The Validation state of the staging records created can update to one of the following values.

   • Valid
   • Invalid
   • Partially invalid

   If invalid, the Validation comments field contains the cause or causes of the invalid state.

   If an imported staging record matches an existing configuration item (CI) in the CMDB, you can preview the existing OT records. For more information, see Preview existing OT records in the CMDB.

다음에 수행할 작업

For valid records, you can directly trigger the Configuration Management Database (CMDB) import. For more information, see Trigger a CMDB import for valid staging records.

To resolve invalid or partially invalid records, you can optionally create remediation tasks. For more information, see Create a remediation task for invalid staging records.

• Managing Validations
  Validation enables you to review and manage the imported data in the staging table.
• Preview existing OT records in the CMDB
  Preview existing Operational Technology (OT) device records in the Configuration Management Database (CMDB) before you import any new records from the staging table. By previewing existing records, you can avoid reconciling or merging unrelated records.