Support

Submit a ticket My Tickets
Welcome
Login  Sign up

Appogee HR: Backfill from CSV - Validation

Applicable plans LeaveHR EssentialsHR SuccessGoals


Required RolesTeam Manager HR ManagerAdministratorADU Manager



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










Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.