In this article, we'll introduce the User Imports Report.
Many customers use an automated People-data feed to transfer information from an HR source to Learn LMS. The User Import report details any exceptions or failures with the previous night's data feed. For example, users not created or invalid/duplicate information.
This is one of the very few fixed reports not to contain any ‘all pages’ filters. That’s because any exceptions/failures need to be viewed in the context of the overall Learn import process.
In the below screenshot, the report has run but with some failures:
The failures are:
- Invalid Username
- UserName already exists under another User
Select 'Import Exceptions and failures' to see more detail:
This page gives specific detail about the failures. For example:
What exceptions will the report identify?
The 'User Import' report can identify various issues. Review the table below to understand the exceptions, their implications, and how to resolve them.
Note: Corrections to user data must be made in your data source.
|
Exception |
What it means |
How to resolve |
|
Duplicate Importkey in file |
This means the ImportKey occurs more than once in the data file. This is a problem as Import keys must be unique, and so the import process doesn’t know which is the correct record to process. |
Check your import files to find and remove/amend the duplicate ImportKey. |
|
Duplicate ImportKey in LMS |
This is a technical failure where the imported ImportKey is duplicated in the Learn/LMS. |
Check the Users accounts with the duplicated ImportKey. On the users account with the duplicate record, update this to a different value so it no longer matches. |
|
Duplicate UserName in file |
This means the Username occurs more than once in the data file. This is a problem as Usernames must be unique, and so the import process doesn’t know which is the correct record to process |
Remove/correct the duplicate username. The record can then be processed next time. |
|
Invalid UserName |
This means the username has a space - either before, after or within the username. Spaces are not allowed, so the username is rejected. |
Remove the spaces from the usernames. |
|
Missing Firstname |
This means the record does not have a first name recorded. First name is a mandatory field. |
Insert the first name. |
|
Missing ImportKey |
This means the record does not have an ImportKey. Import key is a mandatory field. |
Insert the correct ImportKey. |
|
Missing Lastname |
This means the record does not have a last name recorded. Last name is a mandatory field. |
Insert the last name. |
|
Missing Username |
This means the record does not have a username recorded. Username is a mandatory field. |
Insert the username. |
|
UserName already exists under another user |
This means that the UserName already exists in Learn LMS with a different ImportKey. As the ImportKey doesn’t match, the Import process would create a new user account but can’t as the Username already exists on the system. Usernames must be unique. |
Either the Username in the feed needs to be corrected or the existing Username needs to be updated to another value so it isn’t the same as the supplied Username. |
If you are unable to resolve the exception or can't identify what the issue is, contact Support for further assistance.
How often does the reports database refresh?
- The report database refreshes twice every 24 hours
- A time stamp showing the most recent database refresh is shown in every fixed report
- The 'database refresh' time stamp can also be added to a user-created report
- The 'database refresh' time stamp displays in GMT/BST time
- Each Dataset is refreshed individually, so the time stamp may differ between reports using different Datasets
- When a fixed report and a user-created report are built using the same dataset, the time stamp will be the same
Discover more about the Fixed reports
Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.
When you're ready to explore further, view Key techniques for using the Fixed reports in which Gary walks through real-world use cases.
Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.