Skip to main content

Sickness data upload validation message

Unable to complete sickness data import due to data loader validation messages.

J
Written by Joshua Shooter
Updated today

We compiled below a list of sickness data worksheet validation messages and their description:

Validation message

Details

Please check your dates include working days

To ensure all holidays land on a working day for your employees, review their working pattern.

'First Name' & 'Last Name' are not correct for given EmployeeId

To check the employee ID of your employees, check out their personal record.

Employee(s) with 'Employee Id' does not exist in system

In your worksheet, you have employee IDs that don't match those you store in PeopleHR.

Overlapped absence entries exists in excel file

One or more holiday records for a certain employee overlap.

Absence 'start date' must be after employee 'start date'

To review the employee's start date, check out their personal record.

Absence too far into future

You can only load holiday records in the past and up to one holiday year in future.

There is already has an existing absence entry during the period requested. Please edit or split the entry so the dates do not coincide

To check the overlapping holiday or other events, check out the employee's planner.

Invalid duration

Ensure the holiday duration format is as follows: 0.25, 0.5, 0.75, 1 and so on.

"Column_Name" contains invalid data

Ensure the column highlighted contains data with the same format, order and name as the original worksheet template.

Make sure the start date is before the end date

Ensure the sickness rows have the start date before the end date.

Data Exceeded permissible limit

The data exceeds the character limit of the fields in PeopleHR.

"Column_Name" is Mandatory

Ensure you fill in the column highlighted.

Did this answer your question?