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 |