Managing data validation errors

During the upload process, AlphaVAT will run validation checks on the file type and data to ensure that it is compatible with AlphaVAT.

The status of the file upload will be returned as one of four possible categories, each represented by a specific icon as shown in the table below:

If the validation checks do detect any errors or warnings, you can review these by hovering over the icon and selecting the View Warnings button.

This will take you to the File Errors tab.  

This screen will provide you with the name of the uploaded file that contains the validation error(s).  Below that will be the File Warnings list that will display the error(s) that have been detected.  

In the above example, one of the header cells is empty and this has prompted AlphaVAT to highlight this as a data validation error. The warning tells you that there is an empty header in column 2 of your data file.  

You can view your data file by clicking on the File name.  In this example, you can see that the second column does not have the appropriate header and in this preview, AlphaVAT has populated the header with the column number.  

To exit the preview screen, click on the Close button.  This will take you back to the File errors tab.

Having identified the error(s), you can now open your data file and amend it.  In this example you would open the SalesLedger.csv file and provide the correct heading name, which in this instance is Tax Code.

Once you have saved your changes, you can then click on the Replace File button. This will launch your File explorer window and you can navigate to your amended file to upload it again.

You will now be taken back to the Upload Files tab where your amended data file will be uploaded and will go through the data validation process again.  

You should repeat this process for any files that have been identified as having validation errors in them.

NOTE: If you have uploaded an Excel file with multiple tabs and errors are found in the data from one of these tabs, you will not have the option to Replace file.  You will need to select the Back to uploads button and then delete the Excel file from the uploads table.  You will now be able to open your Excel file to fix the identified errors and then you can upload the file again.

To see a full list of errors and warnings see File errors and warnings.

You can customise the data validation checks that AlphaVAT runs on your data via the Data cleansing checks options.  

SECTION CONTENTS

PREV

NEXT

BACK TO MAIN