Skip to main content
Best Answer

Unable to import courses via CSV with mandatory additional field

  • September 3, 2022
  • 5 replies
  • 324 views
T
Novice II

Hello! 

I am using the Automation app to create course shells with a CSV file upload. I have setup a scheduled rule which, once a CSV file is added to an FTP folder, imports the courses using a custom import schema. 

The process itself works absolutely fine. However, we now have a mandatory additional course field, which causes the import to fail and sends the following error on the log:

Invalid option 'field_1’
The additional field is a dropdown list, so I have assumed that the value should be the string value of the dropdown option, as per the information for managing uses via CSV on this page: https://help.docebo.com/hc/en-us/articles/360020128839-Importing-and-Managing-Users-via-CSV-Files

...But clearly this is not working, and we can’t leave it blank because it’s a mandatory field. 

Does anyone know the correct way to reference a dropdown value when importing via CSV, please?

Best answer by trouk

With help from Docebo Support, I have now managed to resolve the issue. 

To reference a dropdown value of an additional course field, the Value ID (and not the string of the dropdown option) must be used. 

These values can be retrieved using the Docebo API: “Retrieves the list of all course additional fields, optionally filtered with the input parameters”  (/learn/v1/courses/field).

For example:

        "dropdown_options": {
          "3": {
            "type": "single_value",
            "value": "This is the dropdown option text",
            "values": []

In the example above, I would need to type ‘3’ onto my CSV file in order to retrieve the relevant dropdown option and for this to be populated into my course shell.

The Docebo team have assured me they will update the documentation to avoid confusion.

View original
Did this post help you find an answer to your question?

5 replies

KMallette
Hero I
Forum|alt.badge.img+7
  • KMallette
  • Hero I
  • 741 replies
  • September 6, 2022

@trouk Interesting question … just remember that the automation app and course shells aren’t the same as users, so the same “rules” don’t necessarily apply.

When you import with the Automation app, you have to define the schema (the map of columns to fields), and I don’t see anything on that list of attributes that shows additional fields or enrollment fields. This indicates to me that what you want to do isn’t supported, but confirming with Docebo Help would be a good idea.

 

Would love to hear the workaround you come up with.

Regards,

KM

KMallette, Surgical Training Institute (STI)
Bfarkas
C
T
3 people like this
  • Bfarkas
    Bfarkas
  • C
    Chelsy Koshy
  • T
    trouk
T
Novice II
  • trouk
  • Author
  • Novice II
  • 6 replies
  • September 7, 2022

@KMallette thank you for your reply! You raise a very good point – perhaps the same rules do not apply. I am unable to find a specific support article on the Docebo website, after all.

However, when additional fields are created (Course Management>Additional Fields), these then become available as options to define as part of the import schema for CSVs. For example, in the screenshot below, I’ve created a test additional field and added it to my import schema.

 

 

I’m not sure why additional fields would be available to include in the import schema if they were not supported. We’ve raised the issue with our Docebo contact, so hopefully we will have an answer soon. In the meantime, our workaround will be to make the affected fields non-mandatory so that they do not block the import.

I will keep you updated on our progress 😊

Bfarkas
1 person likes this
  • Bfarkas
    Bfarkas
T
Novice II
  • trouk
  • Author
  • Novice II
  • 6 replies
  • Answer
  • September 7, 2022

With help from Docebo Support, I have now managed to resolve the issue. 

To reference a dropdown value of an additional course field, the Value ID (and not the string of the dropdown option) must be used. 

These values can be retrieved using the Docebo API: “Retrieves the list of all course additional fields, optionally filtered with the input parameters”  (/learn/v1/courses/field).

For example:

        "dropdown_options": {
          "3": {
            "type": "single_value",
            "value": "This is the dropdown option text",
            "values": []

In the example above, I would need to type ‘3’ onto my CSV file in order to retrieve the relevant dropdown option and for this to be populated into my course shell.

The Docebo team have assured me they will update the documentation to avoid confusion.

Bfarkas
1 person likes this
  • Bfarkas
    Bfarkas
andrew.charles
Docebian
Forum|alt.badge.img

Hey Community! I also wanted to point out that this has been updated in the Knowledge Base at the below link:

https://help.docebo.com/hc/en-us/articles/360020082520-Creating-a-Rule-for-the-Automation-App#h_01FHZ4DNTG469Z69J0128Y8CZB:~:text=If%20you%20are%20importing,to%20Docebo%20APIs

Thank you for your assistance in getting this added Trouk. This post and your answer just helped one of our other Docebo clients in an open ticket :)

Bfarkas
C
T
4 people like this
  • Bfarkas
    Bfarkas
  • C
    Chelsy Koshy
  • T
    trouk
  • J
    julioedd
Bfarkas
Hero III
Forum|alt.badge.img+5
  • Bfarkas
  • Hero III
  • 3582 replies
  • May 30, 2023
andrew.charles wrote:

Hey Community! I also wanted to point out that this has been updated in the Knowledge Base at the below link:

https://help.docebo.com/hc/en-us/articles/360020082520-Creating-a-Rule-for-the-Automation-App#h_01FHZ4DNTG469Z69J0128Y8CZB:~:text=If%20you%20are%20importing,to%20Docebo%20APIs

Thank you for your assistance in getting this added Trouk. This post and your answer just helped one of our other Docebo clients in an open ticket :)

Thanks @andrew.charles , great to know!

andrew.charles
1 person likes this
  • andrew.charles
    andrew.charles

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings