Reference: Data Import Errors and Warnings
When uploading employee data, it's possible to get both warnings and errors.
- Errors cause the import to fail before uploading any data. Fix the cause of the error before attempting another import.
- Warnings enable the import to continue. These warnings are visible on the import summary. We recommend downloading the import log after the upload is complete, for a full list of warnings. For security reasons, the import log is no longer retrievable after exiting the page.
Warnings
Warning | Explanation |
|---|---|
No value for column X, the row will be skipped.
| An employee is missing a value in a required column. |
No identifier found for row, skipping.
| Ensure that an employee Email or Employee ID is present. |
No field found for the column X, it will be ignored.
| Ensure that this column has a matching attribute name on Peakon. |
No column found for the field X, no values will be imported for this field.
| There’s a (nonrequired) attribute defined that doesn’t correspond to any column header. |
No employee found with email, name or employee number X for attribute Manager.
| There’s no employee record on the sheet or on Peakon matching the manager details given on an existing employee record. Add an employee record for the manager to the sheet and reupload. |
Employee with name X is not part of [segment name], skipping.
| For main account administrators: you’re uploading the data file while you've set your dashboard to a specific segment context. The file contains employees that are outside of that segment context. Switch to the main company level context and reupload the file.
For local or limited administrators: you’re uploading an employee that already exists in the wider account, but not in the specific segment you manage. They’re either part of another segment in that attribute, or the attribute field is empty on their employee record. Request your main account administrator to add this employee to the exact segment that you manage. |
There is already another employee with the email X.
| The unique identifiers of the employee already exist on Peakon, but the upload is trying to create a duplicate for that employee. It's likely that the unique identifiers exist separately across multiple employee records. The upload can't consolidate employee records, even if you try to override unique identifiers. There are ways that you can locate the employee and make the change manually.
|
The email X does not match any of the company domains X.
| You need to contact Customer Care to add the domain as an authorized domain to your Peakon account. |
Errors
Error | Explanation |
|---|---|
Unable to read Excel file.
| Try opening and saving in Microsoft Excel first. |
Unable to open workbook. Is it password protected?
| Make sure that your Microsoft Excel sheet isn’t password protected. |
The sheet contains more than the maximum amount of rows (actual limit depends on the attributes).
| The error can also trigger if extraneous rows don’t hold any data, but had a format or styling applied to them. |
Multiple sheets found in the workbook. Only a single sheet should be present.
| Delete the additional sheets. |
No worksheet found.
| Make sure to create the file using Microsoft Excel. |
The sheet must contain at least a header row and a content row.
| Make sure that the sheet isn’t empty. |
The sheet must contain a X column.
| A required column isn’t present in the file, causing the import to fail. |
The sheet must contain one of the identifier columns "Email", "Employee ID".
| Ensure that a unique identifier column is present. |
You cannot remove the identifier for an employee with no email.
| Each employee must have at least one unique identifier. |