CSV file formatting

When creating user directory files in CSV format, ensure that these conditions are met:
  • Encoding:

    Use the UTF-8 character set or use a character set that is supported by its JVM installation.

  • Separate fields using commas.
  • End each record with a line feed or carriage return/line feed.
  • Escaping and quotes:
    1. Enclose fields that contain a special character (semicolon, new line, or double quote) in double quotes.
    2. If a field’s value contains a double-quote character, escape it by placing another double-quote character next to it.
  • Omit optional fields and replace them with the delimiter.
  • When a field contains a list, separate the list elements using a semicolon (;) and enclose the entire field in double quotes, unless the list contains 1 element or none.