Import Issues - Troubleshooting
Import Issues
- 1 Receiving error - ‘email address specified must be unique as Email Login mode is enabled. Please specify a unique email address’
- 2 Receiving error - ‘The INSERT statement conflicted with the FOREIGN KEY constraint'
- 3 Receiving error - ‘Error validating []: Missing Foreign Key Value’
- 4 Receiving error - ‘Training Provider Name isn't permitted to add a 'Coursename' date onto the system at Internal And External level’
- 5 Having issues updating Min/Max Places on Course Templates using an Import
- 6 Can multiple Trainers be imported onto a Course using Imports?
- 7 Will Importing User awards trigger any Award Workflows
- 8 Will Importing trigger my Workflows?
- 9 I'm having issues displaying the dates in UK format(DD/MM/YY) instead of USA (MM/DD/YY) using Imports?
If you’re experiencing problems when managing Imports, then you’re in the right place! This guide walks you through the most common Import-related issues and questions and how to resolve them!
Receiving error - ‘email address specified must be unique as Email Login mode is enabled. Please specify a unique email address’
This error will show during a User Import if two User records in the Import file csv. have the same email address.
This error will only occur if duplicate email addresses are turned off on your Platform.
Please Note
To enable duplicate Email Addresses within your Platform, please reach out to the Customer Support Team for further support.
Receiving error - ‘The INSERT statement conflicted with the FOREIGN KEY constraint'
Related help guide page(s):
This error is triggered when the Import process references an ID that cannot be found in the Platform. There are several variants of this error, depending on which data field is involved. For example, User ID, Course ID, Venue ID, or Course Template ID. The error message will specify the affected column, allowing you to quickly pinpoint and resolve the missing reference ID
See an example here:
Example 1:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_sessionplans_courses". The conflict occurred in database "accessplan_configcode", table "dbo.courses", column 'courseid'. The statement has been terminated.
Example 2:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_resources_companies". The conflict occurred in database "accessplan_configcode", table "dbo.companies", column 'companyid'
In the example above, you will see highlighted in Red which column is being affected (companyid or courseid). Make sure you check the ID against the correct ID within the Platform
Once you have updated the correct field/column in your csv. run the Import again.
For eLearning only
If you see the following ‘The UPDATE statement conflicted with the FOREIGN KEY constraint’ for eLearning:
The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_userselearningpackages_elearningpackages"
This means that there is no eLearning Package attached to the Course Template. Please see the following guidance for uploading an eLearning package to a Course Template: Create a new eLearning Course Template
Receiving error - ‘Error validating []: Missing Foreign Key Value’
Related help guide page(s):
If you are having issues with ‘Error validating []: Missing Foreign Key Value’ when running an Import, please check the following:
Check the column headers of your csv. file
Check that all 'Mandatory' fields have been included in the csv. file
Receiving error - ‘Training Provider Name isn't permitted to add a 'Coursename' date onto the system at Internal And External level’
Related help guide page(s):
For all Course related Imports, a mandatory field of ‘CCLevel’ is required to Import.
Add a new column to your csv. sample file titled ‘CCLevel’ and ensure the whole column is listed with the number '4'
Please see example file here:
Once you have added the CCLevel field to your sample file, don't forget to recreate the Import Profile and update it with the new sample file.
Having issues updating Min/Max Places on Course Templates using an Import
In order to update the Minimum and Maximum Places on a Course Template, you need to use the ‘Course Company’ import destination, not ‘Course Template’.
The mandatory ‘key’ columns required are Course ID and Company ID.
For further guidance on Importing Course Templates, please visit the following help guide: How To: Import Course TemplatesArchived
Can multiple Trainers be imported onto a Course using Imports?
Unfortunately, multiple Trainers cannot be imported onto a Course using Imports. Only a single value can be entered in the csv. sample file
Will Importing User awards trigger any Award Workflows
Importing User Awards will trigger an expiring Certificate Workflow if you have one enabled on your Platform. Please check your Workflows before Importing any User Awards.
This happens as the Workflow does not contain a ‘has changed’ rule within the settings.
This ensures that Importing User Awards always triggers the relevant workflow (such as expiring certificate), which is often required.
Will Importing trigger my Workflows?
Related help guide page(s):
Great question! The behaviour of Workflows largely depends on how your Workflow has been configured.
In most cases, a Workflow rule such as “Status – Has Changed” will not be triggered when you run an import through the platform. This is because the imported data isn’t actively changing the status from one value to another, it’s simply being set or applied as part of the Import process.
To avoid any unexpected Workflow triggers during your Import, we recommend temporarily setting any relevant Workflows to Inactive. This ensures that nothing triggers unintentionally while the Import runs.
Alternatively, you can temporarily add or adjust a “has changed” rule within your Workflow if needed, and then remove or revert it once the Import is complete, especially if it’s not required for your ongoing automation setup.
The only time a has changed rule is not required is for User awards, please see Import Issues - Troubleshooting
I'm having issues displaying the dates in UK format(DD/MM/YY) instead of USA (MM/DD/YY) using Imports?
Related help guide page(s):
Check that you are not using Excel online or your PC date and time are correct
Check you are not copying and pasting data from one spreadsheet to another
If you have copied and pasted the data from a program into Excel, then Excel will override the sheet and keep the original formatting
If you have a certain data range with values in each cell (in this example A2:A7) and you want to copy those values in another range (E2:E7) without formatting. You can easily do that, just follow the next steps.
First, select the range (or cell) with values you want to copy, right-click it, and from the drop-down menu choose Copy.
After that, select the destination where you want to paste it, right-click it, and from the drop-down menu choose Paste Special.
In the Paste Special window, under the Paste section, choose Values and then click the OK button.
As a result, the data range will be pasted without formatting