The multi-list component, available on the Form Template Studio, depends on importing a .csv file that respects some specifications.

Specifications of the file to import

The file to import to generate a multi-list must respect :

• .csv format
• UTF-8 encoding
• Separator to choose - however ";" is recommended
• The first column must be named "Value"
• Following structure:

Valid file

Example of a valid file

Download the example here.

Display in case of a file validated

• In the "Specific Properties" card:

• At the bottom of the page:

Errors

Display in case of an error

• In the "Specific properties" card in case of a first import:

• In the "Specific properties" card in case of an import as a file is already taken into account:

• At the bottom of the page:

List of common errors

• Single quotation mark
  
  • Critical error when a quotation mark is not doubled (opening without closing, or closing without opening)
    Indeed, if the quote is single, it shall be considered as a separator, which will cause to break the file's structure. If the quotation mark is doubled (one opening and one closing) then it shall be included in a value, and the importation shall success.
  • MissingQuotes
• Missing or non-recognized separator
  
  • Characters usually used as textual elements shall never be considered as separators (like the dot "." or the dash "-")
  • UndetectableDelimiter
• Missing "Value" column
  • Without "Value" column, no technical value can be fetched. And this is a mandatory field.
  • ValueColumnError
• No column can be found besides "Value"
  
  • Each column in addition to "Value" is a dropdown list. Having at least one is mandatory.
  • EmptyPickerColumnError
• Missing separator(s)
  
  • A missing separator makes the length of the combination not equal to the number of lists, resulting in an inconsistency.
  • RowsLengthError