Introduction
Users can either be enrolled in courses and sessions by Superadmins, or they can self-enroll. As an option, as a Superadmin or Power User with granted permissions, you can bulk enroll users in courses and sessions of Instructor-Led Training (ILT) courses and assign instructors to sessions via CSV files, speeding up the enrollment and assignment procedures.
This article will guide you through the creation of a properly formatted CSV file for this purpose.
Other articles in the knowledge base provide information on how to:
- Enroll users in e-learning courses
- Enroll users in Instructor-Led Training (ILT) courses
- Manage enrollments
- Manage self-enrollments and waiting lists
Enrolling users in multiple courses and sessions using CSV files
To enroll users in more than one course, or in more than one session at a time using CSV files, log in as the Superadmin, access the Navigation menu > Content and delivery (folder icon) > Courses. Click on Manage enrollments in the top right corner and select Manage enrollments via CSV.
A slide-out Manage enrollments from CSV panel will open on the right side of the platform. Select the Enroll users option.
For a successful upload, it is important to create a CSV file properly formatted. Please see the following table for the accepted values for the session data fields.
| Docebo Learn data field | Acceptable CSV values for the field | Notes |
|---|---|---|
username |
String value |
The list of the users to enroll, identified by their usernames. This field is mandatory. |
level |
Possible values:
|
The user level in the course. Tip: This field is mandatory. |
course_id |
Numeric value |
The internal course identifier in the platform database; it is determined by the platform and cannot be modified or removed.
You have to include either the
|
course_code |
String value |
Course code defined in the platform.
You have to include either the
|
session_id |
Numeric value |
The internal session identifier in the platform database. It is determined by the platform and cannot be modified or removed. You have to include either the
Do not include a
|
session_code |
String value |
Session code defined in the platform. You have to include either the
Do not include a
|
active_from |
Example: |
Enrollment start of validity date. The default format of the date is UTC. This field is NOT mandatory. |
active_until |
Example: |
Enrollment end of validity date. The default format of the date is UTC. This field is NOT mandatory. |
timezone |
Expressed according to the IANA timezone database (Europe/Rome, etc.). If not specified, the default format is UTC. This field is optional and for informational purposes only. It does not impact the enrollment start or end dates. |
|
enrollment_attribute |
Possible values:
|
If the Show the Enrollment attributes option is enabled in the platform's advanced settings menu, you can configure the enrollment priority to clarify the importance of the learning plan or for learners, indicating whether it is mandatory, required, recommended, or optional. |
field_{id} |
The value depends on the type of enrollment additional field:
|
Identifies the enrollment additional fields by their ID, if they have been configured on the platform. This field is either optional or mandatory, depending on the configuration of each field. When the field is mandatory and requested only for a category of courses, you still have to map the field for all courses, but it will be imported only for the enrollments in courses within that category. The enrollments of the courses belonging to other categories will be imported without the mandatory additional field. |
Click on Download the sample CSV file for an example of file formatting. Remember that the sample file always includes all of the available fields. Depending on your use case, not all the columns may be needed.
When your CSV file is ready, follow the instructions provided in the Uploading the CSV file and mapping fields chapter of this article to proceed.
Once the CSV file is processed, all of the enrolled users are listed in the course Enrollments tab, where you will be able to edit the enrollment details.
Enrolling users in a single course or session using CSV files
To enroll users in a single course, or in the sessions of a course using CSV files, log in as the Superadmin, access the Navigation menu > Content and delivery (folder icon) > Courses.
Find the course in the Course Management page, click on its description to access the course area and click on Manage enrollments in the top right corner and select Manage enrollments via CSV.
A slideout Manage enrollments from CSV panel will open on the right side of the platform. Select the Enroll users option.
For a successful upload, it is important to create a CSV file properly formatted. Please see the following table for the accepted values for the session data fields.
| Docebo Learn data field | Acceptable CSV values for the field | Notes |
|---|---|---|
username |
String value |
The list of the users to enroll, identified by their usernames. This field is mandatory. |
level |
Possible values:
|
The user level in the course. This field is mandatory. |
session_id |
Numeric value |
The internal session identifier in the platform database. It is determined by the platform and cannot be modified or removed. You have to include either the
Do not include a
|
session_code |
String value |
Session code defined in the platform. You have to include either the
Do not include a
|
active_from |
Example: |
Enrollment start of validity date. The default format of the date is UTC. This field is NOT mandatory. |
active_until |
Example: |
Enrollment end of validity date. The default format of the date is UTC. This field is NOT mandatory. |
timezone |
Expressed according to the IANA timezone database (Europe/Rome, etc.). If not specified, the default format is UTC. This field is optional and for informational purposes only. It does not impact the enrollment start or end dates. |
|
enrollment_attribute |
Possible values:
|
If the Show the Enrollment attributes option is enabled in the platform's advanced settings menu, you can configure the enrollment priority to clarify the importance of the learning plan or for learners, indicating whether it is mandatory, required, recommended, or optional. |
field_{id} |
The value depends on the type of enrollment additional field:
|
Identifies an enrollment additional field by its ID, if they have been configured on the platform. This field is either optional or mandatory, depending on the configuration of each field. |
Click on Download the sample CSV file for an example of file formatting. Remember that the sample file always includes all of the available fields. Depending on your use case, not all the columns may be needed.
When your CSV file is ready, follow the instructions provided in the Uploading the CSV file and mapping fields chapter of this article to proceed.
Once the CSV file is processed, all of the enrolled users are listed in the course Enrollments tab, where you will be able to edit the enrollment details.
Assigning instructors to sessions using CSV files
To assign instructors to sessions via CSV, log in as the Superadmin, access the Navigation menu > Content and delivery (folder icon) > Courses.
Find the course on the Course management page, click on its description to access the course area, move to the Sessions tab and click on the plus button in the top right corner, then select the Assign session instructors via CSV option.
In the Import ILT instructors panel, drag and drop your CSV file into the upload section, or press the Browse button to find it on your device.
For a successful upload, it is important to create a CSV file properly formatted. Please see the following table for the accepted values for the session data fields.
| Docebo Learn data field | Acceptable CSV values for the field | Notes |
|---|---|---|
session_id |
Numeric value |
The internal session identifier in the platform database. It is determined by the platform and cannot be modified or removed. This field is mandatory. |
instructor_user_id |
Numeric value |
User ID of the session instructor. This field is mandatory. |
Click on Download the sample CSV file for an example of file formatting. Remember that the sample file always includes all of the available fields. Depending on your use case, not all the columns may be needed.
Follow the instructions in the Uploading the CSV file and mapping fields chapter of this article to proceed.
Uploading the CSV file and mapping fields
When your CSV file is ready, you can either drag and drop it into the upload section of the slideout panel or click the upload area to find the file on your device.
Once the file is uploaded, press the Advanced settings title to configure additional options.
Please note: When uploading your CSV file, you must manually select the field separator used to organize the information by columns. Select the appropriate delimiter from the dropdown menu (for example: comma, semicolon or another character) based on the formatting of your CSV file.
Information can be divided by a comma, a semicolon, or manually, depending on your needs.
Enable the option to consider the first row as a header, if this fits your CSV file format, and select the File charset from the dropdown menu. We recommend the UTF-8 charset, which is standard. Please remember to use quotation marks to delimit the text content. Press Confirm to upload your.CSV file.
The system will then process your CSV file. Once ready, you will be redirected to the Import page. In the Profiles section, you can select a preset profile from the dropdown menu to associate a previous mapping configuration to this CSV import. Presets are associated with the user you are using to perform the import action. Also, the list of saved presets is visible in other parts of the platform such as user enrollments into courses via CSV.
Press the Overwrite current preset button if you want to save changes to the current preset. Additionally, you can manually map the columns to platform fields (see more hereafter), then save the configuration by pressing the Save this preset as new button. In the pop-up box, provide a name for the preset, then press Save.
Please note: Once created, a preset cannot be deleted, but you can overwrite the preset if you wish.
The Preview section will display a preview of the CSV file as read by the system. Drag and drop the fields in the Docebo fields section on the left to match the fields with the column names of your CSV file.
Once you’ve matched the fields for all of the columns you need, review all of the info on the import page, then press the Import button at the bottom of the page. Confirm the information in the pop-up message that will be displayed, then press Enroll users.
The import job happens through a background job. In case of any errors, an error file will be made available for download. To find this file, access the Navigation menu > Data and analytics (chart icon) > Background jobs item. Find the job in the list to download the file.
Retrieving the course ID and the session ID
You can retrieve both the course ID and the session ID from the course URL. To do so, navigate to the My courses and learning plans page from the learner menu, click on the card of a course, and check its URL.
The course ID is the number after course/
https://mylearningplatform.com/learn/course/181/summer-vibesThe session ID is stated after session/
https://mylearningplatform.com/learn/course/175/session/158/how-toBest practices
- The maximum file size for CSV files is 3MB.
- Power Users are allowed to enroll users and to assign instructors only for the courses they are assigned to.
- If a course or session has an enrollment limit, the import will respect this limit, and only the first users of the CSV file will be imported until the maximum enrollment capacity is met. Once the limit is met, any additional users will be placed on the waiting list.
- When downloading the sample files, dates are formatted as
YYYY-MM-DD, but they may display differently, depending on the program you used to open the file. - The procedure to enroll users via CSV is not intended to manage the status of enrollments too. For this reason, when you enroll users via CSV file, the user course enrollment status is always reset to enrolled.
- For CSV imports that specify an enrollment end of validity (
active_untilfield), if there is a one hour seasonal time change during the period between when the CSV import is done and the specified “end of validity”, then the “end of validity” will be accordingly shifted by one hour.
Tips and tricks
- You can use CSV files to unenroll users from courses (and thus from their sessions), following the same procedure. Unenrolling users from sessions alone via CSV is currently not supported.