During the import process, aACE prepares the source file by validating each field of every record against the value requirements. If any field in a record fails the validation, aACE will add a note to the end of the record.
If validation errors are found, aACE completes the check for all records, then displays a dialog message:
Click Review to halt the import process and:
- Save a new copy of the source data file to your desktop, with the word "Review" appended to the module name.
- Open that data file so you can review and correct the data.
Once you have corrected the validation errors, restart the import process from the beginning.
Example of Validation Errors
This screenshot shows a sample of an amended data file with problems noted in the Errors column:
You can run the import and review process as many times as necessary.
Before each import attempt, we recommend that you save the source file with a new name (e.g. Companies Import Review1.xlsx, Companies Import Review2.xlsx, etc). This will give you a sequential reference to the modified data file(s) and help prevent overwriting a file by accident.
For information on specific validation logic, refer to the Validation Logic Sheet attached to each module's import instructions.