Best Answer

How to bulk import course shells on Docebo?

Forum|Forum|1 year ago
February 22, 2024
5 replies
597 views

sdswarn04
Novice I

Hello Team,

Is there any video on 'How to bulk import course shells on Docebo?' that defines the process end to end? I am searching it for some time but unable to find any video.

I found this article, but it does not give me a clear picture of the end-to-end process: https://help.docebo.com/hc/en-us/articles/360020082520-Creating-a-rule-for-the-Automation-app#h_01FHZ4DNTG469Z69J0128Y8CZB

Best answer by trose23

I don’t have a video, but I have done it before.

It’s been a long time since we did this, but we were able to load a lot of courses in bulk at the beginning of our implementation. We did have to go back an individually add training material/tweak some settings, though some additional items might be able to be done via API.

We did ours via the Automation app with the settings:

Scheduled Rule (Even though we turned this off, it had to be selected as a schedule to do what we wanted.)
IF: The administrator has uploaded a file in the FTP Folder
- Insert SFTP with credentials, including appropriate folder and File Name
THEN Import courses via CSV
- CSV File UTF-8 with your email as error log email address. Auto-detect separator and check Consider first row as header. Import Schema Layout

Save your automation app rule.
Create your CSV file and save appropriately. Upload to SFTP and run rule.

Check the attachment for the template for the Course Shell Upload, which would need to be saved/converted as a CSV UTF-8 File before uploading to the SFTP. Note that some pieces could fail depending on if you entered the information the way the system likes (i.e. elearning cannot be hyphenated, and the “Course_Published” has to be “unpublished” instead of under maintenance.”)

TMWolfman
Contributor I
Forum|Forum|1 year ago
February 22, 2024

Bulk imports are typically handled by Docebo using template files. Submit a ticket or contact your AM to learn more.

C

Like

S

sdswarn04
Author
Novice I
Forum|Forum|1 year ago
February 22, 2024

Hi @TMWolfman. Thanks for your response. Can you please share where we can look for the template files on the platform??

C

Like

TMWolfman
Contributor I
Forum|Forum|1 year ago
February 22, 2024

They are not on the platform, contact your AM or submit a help ticket.

S

Like

+3

trose23
Helper III
Answer
Forum|Forum|1 year ago
February 26, 2024

I don’t have a video, but I have done it before.

It’s been a long time since we did this, but we were able to load a lot of courses in bulk at the beginning of our implementation. We did have to go back an individually add training material/tweak some settings, though some additional items might be able to be done via API.

We did ours via the Automation app with the settings:

Scheduled Rule (Even though we turned this off, it had to be selected as a schedule to do what we wanted.)
IF: The administrator has uploaded a file in the FTP Folder
- Insert SFTP with credentials, including appropriate folder and File Name
THEN Import courses via CSV
- CSV File UTF-8 with your email as error log email address. Auto-detect separator and check Consider first row as header. Import Schema Layout

Save your automation app rule.
Create your CSV file and save appropriately. Upload to SFTP and run rule.

Check the attachment for the template for the Course Shell Upload, which would need to be saved/converted as a CSV UTF-8 File before uploading to the SFTP. Note that some pieces could fail depending on if you entered the information the way the system likes (i.e. elearning cannot be hyphenated, and the “Course_Published” has to be “unpublished” instead of under maintenance.”)