How to bulk import Users into Learn (with the latest IDS)

In this article, we'll guide you through the process of importing users into the Kallidus suite, using the latest version of our identity solution. View this article to check if your site is upgraded to the latest IDS.

In many cases, an automated People-data feed is configured between your HR system (or another people-data source) and Learn LMS. This ensures user information is automatically populated and kept up to date. Sometimes, however, it is necessary to manually add users who are not present in your automated data source, such as contractors, volunteer staff, and seasonal workers.

Note that if an automated People-data feed is not configured, all Users must be added using the bulk import process described in this article.

We'll cover:

• Preparing for User Import
• Update User information fields using the import
• Use the import to add Users to a Group
• How to switch the date format between American / UK format
• Steps to import Users into Learn

Preparing for User Import

The user import spreadsheet must be in CSV format and include as a minimum, the following mandatory fields:

• Username
• First Name
• Last Name
• Email Address

Update User information fields

User information fields may be either auto-filled by the People-data feed (if configured) or created and managed manually by the Learn admin team.

The import process described in this article should be used to update User information fields created and managed manually by administrators only. If fields managed automatically by the People-data feed are updated, then the feed will overwrite any changes when it next runs.

View some examples of People-data fields and how they're used.

Use the import to add Users to a Group

There are a couple of options here, depending on whether you want to create new Users and add them to a Group, or add existing Users to a Group. 

Add new Users to a Group

Through the import process, new Users can be mapped to an existing Group. You'll just need a 'Group' column in the import spreadsheet. Keep the following in mind:

• Users can be added to ONE group only
• The Group Code must be used to map Users to the Group

If Users must be added to multiple Groups, you can repeat the import multiple times, mapping a different Group each time. See below for more details.

Add existing Users to a Group

An administrator can move existing Users between Groups manually or by creating a Group rule.

However, if there is no obvious data point with which to create a Group rule, then you can also use the import process to add existing Users to a Group.

To make this work, you must add the Users Import Key to the import spreadsheet. With this in place, Learn will not create a duplicate User, it will instead update user fields and Group membership as defined in the import spreadsheet. 

How to switch the date format between American / UK format

The date format for imports can be switched between American or UK format. Before importing, follow the steps below to check that the date format is correct. 

1. Select the Manage users tab:
2. Go to Settings
3. Scroll down to the Import options section and choose which date format you wish to use (MM/dd/yyyy or dd/MM/yyyy):

Steps to import Users into Learn

1. Select Manage Users tab:
2. Select Import users button:
3. Select Upload file:
   
4. Browse and select the file to upload.
5. Review and confirm mapping choices. To adjust, select a Destination field. Learn will make a best guess at this using the data types and headings provided. Matches can be edited, and additional data can be mapped to custom fields as required. Make sure all destination fields have a mapping selected:
6. Select Continue:
7. The import will be pre-checked for issues before the import is started. This will pick up non-unique entries or incorrect date formats. These will be shown in red and can be corrected before the import is submitted:
8. Once all errors have been corrected, Select Submit
9. A confirmation message will be shown. The import is complete, select Continue to close and finish:

Get deeper learning in The Academy

The Academy is your forever free learning hub for Kallidus products including live events, eLearning videos, and more. If you're new to The Academy or know someone who is missing out on free learning, contact your Customer Experience Manager or the Support Team to sign up today.

Discover the latest insights, tips and industry news on the Kallidus blog.