Hi Stephanie, I agree with you that the template only has a minimal amount of information you can add to it to create what I call the “shell” session and from there you need to go into each session to adjust it according to whatever settings you want. I found that once i figure out what value and formatting the upload requires, i usually create my own version of the template including a first line with SAMPLE data and depending on the field, an explanation of what type of data is required in that particular column, etc. If you save that as an EXCEL TEMPLATE format, it can easily be shared and will cannot be overwritten by another user...this helps to maintain the integrity of your template.

Hey @Stephanie Dreiling! There are a couple of PDFs in the Docebo Help article “Creating and Managing ILT Sessions” that I reference and have found useful in demystifying what the CSV import process for sessions and events is looking for in terms of data type and format.

• Here is the link for the section Importing Sessions via CSV
• And here is the link for the section Importing Events via CSV

In each there should be a link to a PDF that goes over all the fields you might want to include on your CSV import file and some additional notes too! It looks like this:

I would agree with @lrnlab suggestion! Once you have CSV file that works for you, you can use that as a template for all future CSV uploads to make the whole import process as quick as possible!

@mj_ Thanks for this. As it does help...shame I spent a ton of time creating this only to see you all already did :)… just made it harder to find...LOL

@mj_ Do you know where the same files can be found for handling enrollments?
I downloaded the sample and searched the help site but could not find anything for “accepted values” for the different fields. 

Has anyone been able to import sessions with multiple instructors assigned to the same session? I enclosed the instructors’ user names in brackets s ] and separated each username with a comma but no space. Our usernames are email addresses. I copied them from each instructors’ user profile because of case sensitivity. I mapped the instructor username column to Instructor Username(s) column. I still received an error: Invalid parameter 'instructors'

I tried again by copying the uuid from each instructor’s user profile into the Instructor User ID(s) column, and deleted the instructor usernames from the user name column. Enclosed in s ], separated by commas but no spaces. Still received the Invalid parameter 'instructors'. 

I see that we can also assign session instructors via csv, however, we have to populate that import file with the system-generated session IDs which would involved too much labor-intensive copy/pasting for us given the number of vILT courses and sessions we have. I really want to be able to import all the session instructors in the session import file. 

Never mind my question about importing sessions with multiple instructors. I figured it out. In case anyone else has the same question, the key was to enclose the list of instructor user names in double quotes, not ] brackets, as I had been told. I am using a comma delimited file, so I was told to separate each instructor username with a comma and enclose the whole list within ]. 

I’m curious, last time I looked at this the annoying part seemed to be you had to bulk create the sessions and then gather their id’s to make the event file to run. Is this still true or is there an easier way to gather those ids now?

Without that, I find it way easier to process these creations through the apis since when the session is created the id is returned and then the event can be generated right away. 

I am attempting to create Events using the CSV, but it is massively challenging. I got the Sessions imported and named how they need to be, but there’s no way to get the Docebo-generated session IDs to add into the CSV for the events. It’s absolutely screwing up the process.

Do you have any resources for the API? I may need to explore this as an option but I’m not well-versed on the API. This is part of Docebo that really frustrates me.