Importing Events via CSV
To bulk import events via CSV, while on the Course Management page, identify the ILT /VILT course for which you want to import events via CSV, click on its description, and, once in the course area, move to the Sessions tab. From here, click on the session name and move to the Events & Attendance tab. Click on the plus button in the top right corner and select the New Events via CSV option.
In the Import ILT Events 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 check the following table for the accepted values for the event data fields.
| Docebo Learn Data Field | Acceptable CSV Values for the Field | Notes about Field |
|---|---|---|
| Session ID | Numeric | The internal session identifier in a specific platform database. It is determined by the platform and cannot be modified or removed. You have to include either the Session ID or the Session UUID in the CSV file for a |
| Session UUID | String | Unique alphanumeric session identifier, automatically calculated by the platform when the course is created. It cannot be modified or removed. You have to include either the Session ID or the Session UUID in the CSV file for a This field is case-sensitive. |
| Event ID | Numeric | Unique event identifier, automatically calculated by the platform when the course is created. It cannot be modified or removed. When this field is set, the import process will update the event with the CSV data. |
| Event Name | String | |
| Event Description | String | |
| Event Date | YYYY-MM-DD Example: 2022-03-17 | |
| Event Start Time | HH:mm:ss Example: 14:24:35 | This field is mandatory. |
| Event End Time | HH:mm:ss Example: 14:24:35 | This field is mandatory. |
| Break Start Time | HH:mm:ss Example: 14:24:35 | The break time is optional but, when used, both the Break Start Time and the Break End Time fields must be specified. The Break Start Time must occur after the Event Start Time. |
| Break End Time | HH:mm:ss Example: 14:24:35 | The break time is optional but, when used, both the Break Start Time and the Break End Time fields must be specified. The Break Start Time must occur after the Event Start Time. |
| Time Zone | Region/Local Example: Europe/Rome | This field must match the timezone name format (without GMT + XX:XX) in the platform. Find out more about the timezone management in your platform. For example, the time zone format for Jerusalem is "Asia/Jerusalem", while for Prague it is "Europe/Prague". This field is case-sensitive. |
| Instructor User ID(s) | Numeric (array) Example: 1105, 2347, 7321 | The list of the event's instructors, identified by their User ID. The Instructor User ID and the Instructor Username fields are optional, and cannot coexist in the same CSV row or you will receive an import error. |
| Instructor Username(s) | String or numeric (array) | The list of the event's instructors, identified by their Username. The Instructor User ID and the Instructor Username fields are optional, and cannot coexist in the same CSV row or you will receive an import error. This field is case-sensitive. |
| Location ID | Numeric | Location identifier. It is determined by the platform and cannot be modified or removed. Every event must have a Location ID or a Webinar Tool, or both. |
| Classroom ID | Numeric | Classroom identifier. It is determined by the platform and cannot be modified or removed. This is an optional field, that can be specified when Location ID is set. |
| Collaboration Tool | String | Optional text to specify an external collaborative tool for learners to get in touch and interact on the course topic. |
| Video Conference Tool | String | Use this field to set the Video Conference Tool for the VILT event. Accepted values are:
|
| Video Conference Account ID | Numeric | Internal webinar account identifier. It is determined by the platform and cannot be edited or removed. It becomes a mandatory field when the Video Conference Tool field has a value and it is not set to "custom". It must not be used in other cases. |
| Passcode / Meeting Password | String | Password to access the webinar. It becomes a mandatory field when the Video Conference Tool option is enabled and it is not set to "custom". If not specified, the system will automatically generate a password for the VILT event. |
| Video Conference Custom URL | String | This field is mandatory when the Video Conference Tool is set to "custom". It must not be used in other cases. |
| Mark the event as attended if the user accesses the recordings | Boolean true/false | This field is mandatory when a Video Conference Tool is specified. |
| Mark the event as attended if the user joins the webinar | Boolean true/false | This field is mandatory when a Video Conference Tool is specified. |
| Join in Advance Time for Learner | HH:mm Example: 16:03 | This field is optional and can be used only when a Video Conference Tool is specified and when configuring the Join Button Options for learners and instructors. The learner join in advance time cannot be earlier than the instructor value. |
| Join in Advance Time for Instructor | HH:mm Example: 18:46 | This field is optional and can be used only when a Video Conference Tool is specified and when configuring the Join Button Options for learners and instructors. The instructor join in advance time cannot be later than the learner value. |
| Adobe Connect % for Completion | Numeric | This field is optional and can be used only when a Video Conference Tool is set to Adobe Connect V2 Meeting or Adobe Connect V2 Webinar. |
| Adobe Connect v2 Template | String | This field is optional and can be passed as an empty string. It represents the SCO-ID of the template in the Adobe Connect V2 Account. |
| Adobe Connect v2 Folder | String | This field is optional and can be passed as an empty string. It represents the SCO-ID of the folder in the Adobe Connect V2 Account. |
| Adobe Connect v2 Room | String | This field is optional and can be passed as an empty string. It is mandatory when using Adobe Connect V2 Seminar as a video conference tool. It represents the SCO-ID of the room in the Adobe Connect V2 Account |
In order to view a correct example, select Download a Sample CSV File item in the slide-out panel. Please note that dates are formatted as YYYY-MM-DD, but your spreadsheet may display them differently, depending on the program you used to open the CSV sample.
The maximum file size of a CSV file that you’re able to import into your platform for a user upload is 3MB.
After selecting the file, click on the Advanced Settings section to view and configure 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.
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.
The system will then process your CSV file. Once ready, you will be redirected to the page used to map the fields included in your CSV file with the Docebo available fields.
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 your columns, review all of the info on the import page. Before proceeding, you can save the fields you have mapped as a preset, so that the same mapping will be used for your future CSV imports. To do so, in the Preset area of the left panel, click on Save this Preset as New. In the pop-up box, provide a name for the preset, then press Save. Once created, a preset cannot be deleted, but you can overwrite it by clicking on the Overwrite Actual Preset.
When ready, click on the Import button at the bottom of the page. The Import button is enabled only when the mandatory fields (Session ID, Date Name, Day, Start Time, Time End, Time Zone as well as the events mandatory fields) are mapped. Read the information in the pop-up message that will be displayed, then press Import ILT Events.
The import job happens in the background. In case of any errors, an error file will be made available for download. To find this file, access the Admin Menu, then select the Background Jobs item. Find the job in the list to download the file.
All of the events that were imported into the platform will be listed in the Events & Attendance tab of the course session.
Remember that Power Users are allowed to import events only for the courses they are assigned to.