Bulk Uploading Users into Different Learning Plans

In this guide, we walk through the process of uploading a large group of users into different learning plans. This guide is for TAs who have several distinct learning populations that will need different learning plans.

This guide will walk through the process in three parts:
1. Uploading users.
2. Adding users to groups.
3. Enrolling those groups in learning plans.

Tip: Having trouble? Submit your bulk upload for us to run.

Alert: Please follow these steps in order. You won’t be able to add users to a group until after you’ve created them in the system.

Preparing Your Files

1. Assemble a list of your users using our template or your own system.

Alert: The file must be a CSV (.csv) type file and contain the following information for each user:

Username (Email address)
First Name
Last Name
Email address
Branch code (Displayed on the blue banner in your Admin Panel)

Additional fields include:

Active (yes/no)
Expire on (YYYY-MM-DD)
UID (Institutional ID number)
Role (user’s role or job title)
Contact information for the TA they should contact if there are issues with the training

A template and full list of optional fields can be found in the Bulk Upload guide here.

2. ## What are CSV (.csv) files?

Comma-Separated Values (CSV) files store tabular data in plain text. Each line of a CSV file is a data record/row. Each record/row consists of one or more fields/columns separated by a delimiter.

CSV files can be created with a number of software programs (i.e. Excel, Google Sheets, Notepad, TextEdit, Emacs). The content within the file must follow the CSV Standard format and the file must have a “.csv” file extension.

How are CSV files generally formatted?

CSV files should follow a standard format:

Fields/columns are separated by a single character delimiter, typically a comma or semicolon.
Each record/row is terminated by a new line.
All records/rows have the same number of fields/columns in the same order.
The first record/row may be a header that contains the field/column names of each field/column.
Data within each field is interpreted as a sequence of characters or plain text.
Any field may be quoted within double-quote characters.
A field should be quoted when it contains one or more special characters.
Leading and trailing spaces are considered part of the data in a field.

How are CSV files used to create and update user accounts?

User accounts in your platform consist of a number of user data fields. Each of these fields may or may not be populated with data, depending on which fields you’ve filled out when creating the user.

To create a user, you should at least populate the user fields that are mandatory for creating a user account (username and any mandatory user additional field). To update an existing user account, you’ll need to update the relevant user fields of the user account with new data. Both creating and editing users (either one user at a time or multiple users at a time) can be done manually, or by importing user data fields into the platform via a CSV file.

For the second option, each user account that you intend to create or update is represented by a record/row in the CSV file. Each user data field is represented by a field/column in the file.

Import the CSV file to the platform, then map the contained data to the corresponding user fields supported by the platform. By doing so, you’re creating and updating user accounts.

Bulk Uploading Users to the System

3. Login to your account at learn.ue.org

4. Click on Manage My Learners.

5. Then click, Import and Manage.

6. Click “CSV”

7. You can drag and drop it into the upload section of the slideout panel, or press the Browse button to find the file.

8. Once uploaded, press the Advanced Settings title to view the additional settings. The system is configured to automatically detect the Field Separator, which is needed in order to organize the information by columns. Information can be additionally organized by a comma, a semicolon, or manually, depending on your needs.

9. Then, flag the option that the first row is considered a Header (only if this fits your CSV file format), and select the File Charset from the dropdown menu. As for the File Charset, we recommend UTF-8, which is standard. Please remember to use quotation marks to delimit the text content. Press Confirm to upload your .csv file.

10. Click “CONFIRM”

Alert: Do not use the header, “User ID.” The required headers are: Username, First Name, Last Name, Email Address, Password, Active, and Branch Code.

11. Adjust your import options and map the UE Learning Portal Fields to the fields from your file.

You can find a more detailed guide on uploading users here

Enrolling Learners in Groups

Tip: This is a quick overview of enrolling learners in groups. View our detailed Creating & Managing Groups guide for more assistance.

12. Click the gear icon in the upper right corner to open the Admin Menu.

13. Click “Groups”

14. Create a new group for your users. We recommend naming it something like, institution name + population.

Ex: “HalliwellCollegeStudents”

See our guide on Group Management for a more detailed look at setting up groups.

15. To bulk add users to the group, click on the group’s hyperlinked name.

16. Then click “CSV” in the upper right corner to upload your list of users. You can use the same file you used to create users.

17. Follow the same steps you used for bulk creating your users.

Alert: You’ll start to see learners slowly being added to your population as the system processes. If you only see a fraction of your upload, refresh the page and check if the number has gone up. If it doesn’t, or you’re getting a lot of error messages, please reach out to launch@ue.org.