When using the Backfill from CSV tool, the system validates the information in the CSV sheet that you are uploading. Sometimes your data will fail validation, below is a list of the validation checks and what you can do to resolve them.
| Error Message | Action |
| Employee with email address {email} could not be found | There is no employee in the system with that email address - change the CSV or add an employee with this email address |
| Employee with email address {email} is Inactive | The use with this email address is former or archived - change the employee's end date or restore their account from archive to active |
| Start Date must be on or before End Date | Change the start date in the CSV |
| Morning contains invalid data | Change the CSV to one of the following: 'TRUE', 'YES', 'ON', 'T', 'Y', '1', 'FALSE', 'NO', 'OFF', 'F', 'N', '0' |
| Afternoon contains invalid data | Change the CSV to one of the following: 'TRUE', 'YES', 'ON', 'T', 'Y', '1', 'FALSE', 'NO', 'OFF', 'F', 'N', '0' |
| For one day requests, Morning and Afternoon cannot both be True | If the request is one day, remove the data from both Morning and Afternoon columns |
| Override Hours contains invalid data | Change the CSV so the data in this field is a number |
| Deduct From Allowance contains invalid data | Change the CSV so the data in this field is a number |
| Deduct From Allowance should not be provided for Sickness Reports | Sickness reports do not need to be deductible |
| Request clashes with another request in the CSV file on row {row} | Change the dates of one of the requests |
| Request clashes with another request in the system | Change the dates of this requests |
| Allowance not found for the Request period | Ensure the employee has an allowance - check the allowance calculator and active leave years |
| Request cannot span a leave year | The last day of the request must be the last day of the leave year - split the leave request into two |
| Request Type must be 'leave' or 'sick' | Change the CSV to 'leave' or 'sick' |
| Leave / Sick Type '{field}' could not be found | Change the Leave/Sick Type to one that has been configured in Process Config |
| Leave/Sick Type Not Provided | Provide a Leave/Sick type in this field on the CSV |
| The specified date range does not result in any working hours | The request has been input across non-working days, e.g. a weekend. Check the employee's Working Rota (Leave Profile) and update the CSV |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article