Validate the correctness of the data

The same XLSX file that is exported from Alfabet must be used to capture and import the data to Alfabet.

Ensure that the data that is captured in the XLSX is semantically correct before importing it. All valid data in the XLSX file will overwrite existing data in the database.

You can validate the technical correctness of the intended data upload so that you can correct validation rule violations before actually uploading the data. The validation checks the correctness of the specification of the operation, mandatory fields, DateTime attributes, data size, stereotype definitions, enums, indicators, information flows, and references.

  1. If your company's files include the feature to restrict file access via sensitivity labels, set the sensitivity label setting of the XLSX file to Public before you import the file with your data.s
  2. Go to Data Capture Templates.
  3. Click Import Data > Validate XLSX File.
  4. Click the Select File button and select the XLSX file form your local drive or network and click Upload. You can download the file in the Notifications panel.
  5. Review the Processed and Error Message columns. Correct the erroneous data in the file based on the information in the Error Message column. An error message is displayed for only the first violation of a validation rule for a record.