In this section, you’ll find guidance on how to identify why some employees may not be imported successfully into CPL Learning from your payroll system. It covers how to access the import history, check for import exceptions, and understand the common reasons so you can resolve them.
View employee import exceptions
⚠️Important: If the new users are not showing on the system or in the import exceptions list, ask your data team to double-check the import file for any discrepancies.
🤓Tip: For guidance on how to identify import exceptions, we've recorded the webinar 👉
To view the employee's import exception, follow the steps below:
Log in to the Admin Tool.
Click Import, then click Employees Import.
Click Batches on the top left.
A list of the employee history batches will be displayed.
If the status column has an exclamation icon, that batch contains exceptions.
Click visibility icon
next to the batch to open the import details.Click Exceptions on top right corner.
You'll see a list of users who were not imported, along with the reason for each exception.
Note: To view import exceptions, you need specific permissions and admin access. If you don’t have them, contact your Head Office or system administrator.
Import exception reasons
Below is a list of the most frequent reasons users may not be imported successfully into CPL Learning. These exceptions appear in the exceptions tab of the import batch and highlight missing or incorrect data that needs to be corrected before the user can be imported.
Exception | Description |
Duplicate in Source | Multiple users in your file have the same external reference. External References are expected to be unique. |
Invalid Surname | Surname is mandatory and cannot be blank or null. |
Invalid External Reference | External Reference is a mandatory field and cannot be blank or null. |
Invalid Position | The Position does not appear to existing on our database. Please add the position or contact support. |
Invalid Division | The Division does not appear to existing on our database. Please add the position or contact support. |
Duplicate in Target | An External Reference for a user being imported is in use multiple times already, the user to update cannot be established. |
Invalid Site | The site external reference does not map to a valid site. |
Duplicate Position Description | Multiple positions appear to exist in your position config. |
Duplicate Division Description | Multiple divisions appear to exist in your division config. |
Duplicate Site Description | Multiple sites appear to have the same site external reference. |
Troubleshoot payroll integration exceptions
This happens when there are discrepancies in site references or missing job positions. To resolve this, check the following:
Verify job positions: Ensure that every job position for the users you're trying to import is already present in CPL Learning. If a position is missing, users linked to that position won't import.
Create or update job positions: If the relevant job position isn't available, add or update it in CPL Learning.
Wrong site reference during import: Ensure the site reference matches the CPL Learning configuration.
Incorrect site reference: Check the site external reference in CPL Learning is identical to the one in the payroll system. This reference is crucial for correctly mapping users to their respective sites.
Check the required details in the Admin Tool
To check your employee details, follow the steps below:
Log in to the Admin Tool.
Click Employees, then search for the user.
Select the employee, and here you're able to view:
Position.
Division.
Site.
Supported integrations for import exceptions
This feature is available only for specific payroll integrations that support automated employee imports into CPL Learning.
Here's a list of integrations where import exceptions can be viewed in the Admin Tool:
Fourth
Cascade
Polaris