Compensation Management: Troubleshooting Import Data Errors

Importing data into can be affected by common errors such as inconsistent formatting, missing or incorrect date fields, and invalid email addresses. This article identifies the most frequently encountered import data errors, their causes, and solutions to help you troubleshoot and resolve issues efficiently.

In this article:
Common Errors
Export Errors
Additional Resources

Common Errors

The onscreen error result list will provide the Column in question, which Row(s) the data issues occur within, and a Message with more details about the error.

Error	Details
File column order or Headers do not match Template layout	File does not match the current/correct Import Data Template file.
Manger Employee ID - Manager not found	An employee record includes a Manager ID (the Employee ID for the Manager) for an employee that is not found in the system or in the current upload file.
No Manager listed	The Manager ID is blank
Date Formats	Dates must be in MM/DD/YYYY format.
ExcelColumn values must be A for Active, I for InActive/Terminated	The Status field will only accept 1 character code: A or I (A = Active, I = Inactive/Terminated) If you want other codes like L = Leave of Absence or T = Terminated, you must work with Implementation to set that up ahead of time.
Eligibilities need to be 1 or 0	When providing Eligibility, the system will be set to accept either Y/N or 0/1 (0=Eligible; 1=Ineligible) The correct codes depend on your setup and will be noted in the header of the import file.
Can Login = Y or N	This is a 1-character code to flag Y=Yes, N=No for who has CanLogin status.
Email (Email in System), Excel column contains duplicate Email ID, this email already set for current system employee.	Email addresses must be unique for each employee record in the system.  This can flag if/when the Employee’s ID (Empno) has changed and the existing system Employee ID is different from what is being uploaded.

Export Errors

While there are details included in the error table, you also have the option to Export Errors.

This will download an Excel copy of your original import with a new Error Result column. These errors can help you quickly locate and edit your errors. 

 Notes

This export will include an additional row and should only be used as a reference. Make sure to update your original file for import.

Additional Resources

Compensation Management: Phase 2 - Refreshing Employee Data