This guide explains how to use the review spreadsheet to troubleshoot the import process. It is intended for general users.
During the import process, aACE verifies the source file by validating each field of every record against the relevant value requirements. If any field in a record fails the validation, aACE adds a note to the end of the record, then continues checking the remaining records.
Then aACE displays a dialog reporting any issues:
Clicking Review halts the import process. It also prompts aACE to create a new copy of the source spreadsheet. On this new spreadsheet, aACE adds a column at the end with details about each validation error (see below for examples). aACE saves this review spreadsheet on your desktop with the title set to the relevant module name and "Review".
Check the error messages on the review spreadsheet, then update the data on your import spreadsheet. Once you have corrected your data, restart the import process from the beginning.
Example of Validation Errors
This screenshot shows a sample review file with problems noted in the appended Errors column:
Different types of records have different data validation requirements. For example, GJ entry items must include the GJ entry ID number, while the Debit and Credit columns cannot both include a value (i.e. if one of these columns has a value, the other must be blank, not a zero).
You can run the import and review process as many times as necessary.
To leverage the validation functionality, we recommend running test imports using small data sets. This can help you quickly verify the quality of your data.
We recommend that before each import attempt you save the source file with a new name (e.g. Companies Import Review1.xlsx, Companies Import Review2.xlsx, etc). This gives you a sequential reference to the modified data file(s) and helps 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.