Validation

Validation that is run during an upload. Alternatively, it can also be run independently of the upload process. The sections below outline the steps to run validation.

Validate Selected

Validate Selected will only validate selected records in the worksheet that contain an upload action.

Rows without an upload action will not be validated unless they relate to a record within the data structure that has an upload action.

  1. Using the cursor, select the records in your sheet that require validation.

    image52
    Selecting a single row will still process the entire record the row is associated with. Providing an Upload Action designates what rows within a record will be processed (Validated/Uploaded). Rows without an upload action will be ignored.

  2. Via the Add-in Ribbon click Validate image53.

  3. Click the Validate Selected image54 option.

  4. Validation will begin on the selected records.

  5. Data that does not meet validation will error and a respective status and message will print to the sheet. For example:

    image55

    Or

    image56

Refer to the Status and Message Columns section for reprocessing.

Validate All

The Validate All option validates all records within the worksheet that include an Upload Action.

Rows without an Upload Action will not be validated unless they relate to a record within the data structure that has an upload action.

  1. Click Validate image53 via the Add-in ribbon.

  2. Click Validate All image57

  3. Validation for all records in the active worksheet will be performed.

  4. Error and successful validation statuses will print to the sheet.

image58

For reprocessing errored data refer to the Status and Message Columns section.