Encountering data errors in Verodat? No worries, let's break it down. In this guide, we'll explore what data errors are, the types you might encounter, and how to handle them.
Table of Contents
Data Errors
A data error occurs when the uploaded data doesn't meet the conditions set in a validation rule. Simply put, it's a signal from Verodat that something needs attention. There are two types of data error, a Warning and a Critical Error.
Types of Data Errors
Warning Error: Indicated by Verodat when an error is detected, but it won't stop you from submitting your data. It's a heads-up, and you can choose to resolve it or proceed. If unresolved, the data is flagged for analysis.
Critical Error: This one's more serious. Verodat prevents you from submitting the data until the error is fixed and retested. It ensures data integrity before moving forward.
Handling Data Errors: For warnings, it's optional to fix them, but resolving critical errors is a must before submitting your data.
Data errors are like gentle reminders from Verodat to ensure your data is correct. Whether it's a warning or a critical error, addressing them ensures a smooth data submission process.
Viewing Errors
have you got validation errors in Verodat? No problem. Let's go through how to view and fix them step by step.
Accessing Errors
Once you "Process File" on the "Map Data" tab, your file will be processed and reviewed for any errors.
Once processed, a pop-up will be generated, advising of any errors.
If error-free, close the pop-up and progress to the "View Data" tab.
Error Indicators
If there are errors, they will be highlighted for easy identification along with a brief description, in the pop-up once the file has been processed.
Close the pop-up to view the errors in the View Data tab.
Details of errors are provided within the section. If errors exist, they'll be highlighted in this section.
Correcting Errors
If errors exist you can submit data corrections, re-process and re-validate your data.
There are two options available:
Re-process within the application.
Export error files to Excel, fix errors, and re-upload for re-processing.
Review, fix, and re-process your data for a smooth data validation experience.
Re-process errors within the application
Encountered errors in your Verodat data? Here's a guide on identifying, fixing, and moving forward.
Steps to Correct Errors:
Spotting Errors: Take note of the error message generated.
Amending Errors: Click on a cell with an error to make necessary amendments.
Identification of Amendments: Amended cells will have a distinct shading.
Save and Re-Process: After making amendments, save your changes and re-process the data.
Review Summary: Verodat will review the update and present an updated summary.
Color Indicators: Correct updates are highlighted in green. Any remaining errors persist in red.
Correct All Errors: Ensure all errors are corrected before re-processing the file.
Next Stage: Once all errors are correctly processed,
Click "Next"
to progress to the "Commit to Dataset" tab
Fixing errors in Verodat is as easy as identifying, amending, and progressing to the next stage.
Export error files to Excel, fix errors and re-upload for re-processing.
Steps to Export Validation File:
To Access the Validation File: Click on the "Export to Excel" button in the middle of the screen to export the "Mapping Output file."
Then the "Latest Validation Error File" file icon.
Your file will begin to download
Summary of Errors: Open the downloaded file, and a summary of the errors is provided.
Navigate to the Data Tab: Click on the data tab to view errors; they will be highlighted for easy identification.
Correct and Re-upload: Correct the file as needed and re-upload the file.