Hello,
I have been trying to create ILT sessions via a CSV. I managed to create a session but now when trying to upload an event via CSV I keep getting an error regarding the time_begin parameter. I have already read the following article https://help.docebo.com/hc/en-us/articles/5226538368658-Importing-ILT-and-VILT-Sessions-and-Events-via-CSV-Files to cross check the data type and format. Still no luck, any suggestions?
+8
HI
Hi,
I have selected other formats which do not have the AM/PM suffixed. However, the issue seems to continue. Any idea on how to get the AM/PM to be removed permanently?
+8
I create a template that includes both Sessions and Events as it makes more sense to see it all in one place and when you import, you can choose what columns you want to import. Hopefully you can use this to solve your issue. I fixed the time issue with a custom time format in excel.
+8
sadly, it won't accept my file although it says it should...will need to repot this to Docebo
+8
+1
+1
When I do this, I save the file as *.csv and then open the CSV (in another spreadsheet application) to verify that everything is properly formatted. Things like the number formatting can become switch from the proper date representation and that formatting is so picky!
+8
sure will send by email...it was meant for this thread if you can add it here that would be great. Thx
+8
I create a template that includes both Sessions and Events as it makes more sense to see it all in one place and when you import, you can choose what columns you want to import. Hopefully you can use this to solve your issue. I fixed the time issue with a custom time format in excel.
Apparently the file upload doesn't work with Safari. removed the “&” from the file name and it works but only with Chrome…
Click on ‘View Original’ to get to the file.
Thank you @lrblab this is really helpful. I also encountered an issue with the webinar tool. We use zoomv2meeting and that is the only field I fill in. However when it is uploaded it throws a very vague error along the lines of error encountered while processing. Any idea what could be causing this? I attached what I have been doing below.
+4
I create a template that includes both Sessions and Events as it makes more sense to see it all in one place and when you import, you can choose what columns you want to import. Hopefully you can use this to solve your issue. I fixed the time issue with a custom time format in excel.
Apparently the file upload doesn't work with Safari. removed the “&” from the file name and it works but only with Chrome…
Click on ‘View Original’ to get to the file.
This is great! They really need to work on this process as it stands currently it is incredibly confusing for new users to figure out and interpret. I remember just giving up and moving to the API as it seemed so much easier, which is crazy when you think about it.
I create a template that includes both Sessions and Events as it makes more sense to see it all in one place and when you import, you can choose what columns you want to import. Hopefully you can use this to solve your issue. I fixed the time issue with a custom time format in excel.
Apparently the file upload doesn't work with Safari. removed the “&” from the file name and it works but only with Chrome…
Click on ‘View Original’ to get to the file.
Our use case currently is that we have to create 30 sessions inside of a single ILT for classes taught across a single week. For each session we are creating a single event so it is like doing double the work. From what I can tell right now the process would be to create a single csv for the linked session and event would this not mean I would have to create 30 unique csvs then?
+4
Exactly right, just add new rows to the excel template posted and then one upload creates them all, really nice!
Exactly right, just add new rows to the excel template posted and then one upload creates them all, really nice!
Can I upload both directly to the session upload option?
I was curious as to how this would work given that the fields which can be chosen are limited to the session fields and not event:
+8
Correct
+8
Exactly right, just add new rows to the excel template posted and then one upload creates them all, really nice!
Can I upload both directly to the session upload option?
I was curious as to how this would work given that the fields which can be chosen are limited to the session fields and not event:
you ned to run the Session import first, then get your session unique IDs, backfill those into the same template, then run the Events import. Each import only allows you to import the fields aligned to that specific area so pretty error proof. At the end of it all you have a good back up in the CSV file that has all the related information.
+4
Correct
1000% this! It would be nice if the post report for the session creation gave you a session ID report after. Until then I find this CSV approach for session management almost unusable for any volume.
+8
Yes it is quite annoying that these necessary parts seem so unlinked when creating Sessions.
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
