CSV requirements - Fluid Topics - Latest

Fluid Topics Configuration and Administration Guide

Category
Reference Guides
Audience
public
Version
Latest

CSV vocabularies must meet the following requirements:

  • Use UTF-8 encoding to prevent issues with special characters, such as diacritics.

    Programs can change the encoding of CSV files when users open, edit, or export them. Check the encoding of CSV files at all stages.

  • Use commas or semicolons as separators.

  • Write the language selector as a full locale (for example, afs:lang=fr-FR), or only an ISO-639-1 language designator. When using only a language designator, the selector matches all locales for that language.

    For example, afs:lang=en matches documents with locale en-US and en-GB.

When processing CSV vocabularies, Fluid Topics ignores:

  • Invisible characters (including the byte-order mark) and whitespace at the start and end of entries. Fluid Topics does not ignore them when in the middle of an entry.
  • Whitespace before and after the language selector.
  • Empty lines. Fluid Topics also considers a line containing only empty columns as empty.
  • Empty columns at the end of a line, as well as empty columns after the language selector.