The Errors screen lists all files that have completed validation and have encountered file or line errors.
The errors can be viewed per file or all at once and each list is paginated to 50 results per page.
The errors page should be displayed by line number when viewed by file and by file and line number when viewing all.
The observations page will give distinct error messages grouped by their codes to allow for easier identification of common or recurring errors.
Options available per file are:
Re-upload File: This allows the user to replace the file with a new or amended version. The user would do this if there were format, syntax or value errors in the file that could only be corrected by amending the file
Re-validate File: This allows the user to clear down the errors for that file and re-validate without replacing the file. This would be done if for example reference data was added in the software
View Errors for File: This displays an error screen limited to the file in question
Delete File: This allows the user to delete the file and errors associated with it and begin again
The View All Errors or View Errors for File options return a screen like the below. This screen will list the errors generated by the validation on a file by file and line by line basis
For lower numbers of errors (less than 100) it is advised that this screen is best used. This screen is ideal for identifying validation errors with a particular record or records
Once all reference based errors have been corrected the user can re-validate the file without needing to re-upload. This only applies to errors where the data on the file is correct but something needs to change in the system to allow validation (i.e. setting up a Department).When files have been set to re-validate the Upload tab will show the below status
Once the file or files have passed validation the status on the Upload Tab will change to Validation Complete. No Errors and the files appear in the Valid Files section of the Migrate tab.
Note: Users should wait until all the files they are loading have been validated before Migrating. This is to ensure data integrity is maintained between the files and the actual system
Once happy that all the necessary files are uploaded and validated then you should press the Migrate button to set the files as ready to Migrate into the CoreHR main database tables (this option is menu controlled and will not appear without the correct access).
Files that are queued to Migrate appear with the following status
A second DBA job runs (<V23 this runs every 5 minutes, V24+ this runs on demand when the 'Migrate button is selected) to migrate the files into the database. Once this has completed and the rows have been inserted in the database they appear in the Completed Files section of the Migrate screen and are removed from the File Upload screen allowing additional files of that type to be uploaded.