DataLoader performs the same validations and security checks as the various forms, pages and application throughout Advance. When Validation Errors are encountered during the Validation process, they appear in the additional information pane to the right. After the Validation process has completed, and errors are encountered, you can modify the data and perform the Validation process a second time. There is no limit to the amount of times you can Validate the data.
Validations performed through the Validation Process include, but are not limited to:
Validating TMS codes serially (one by one) to ensure they exist and are active. Note: be sure to use upper case values when creating fields that use TMS values in the input data.
Validating that loaded data matches the target column’s data type. For example, it validates that a datetime column contains a valid date format for the DBMS, etc.
Validating that start dates fall before stop dates.
Validating that users have the correct Form access.
Validating that users have the correct TMS Access.