filter.csv-to-xml.format

Background

The following values may be set for this option:

  • RFC4180_SKIP_EMPTY_LINES: Process the CSV as RFC4180 skipping blank lines.

  • RFC4180: Process the CSV as RFC4180.

  • EXCEL: Process the CSV in the format Excel exports. Some regional settings may cause issues. You may be required to transform Excel CSV to RFC4180 before the CSVToXML filter is run.

  • TSV: Process the document as tab separated values.

  • MYSQL: Process the CSV in format generated when MySQL exports to a CSV file.

  • MIME_TYPE: Process the CSV using one of the previously listed formats based on the mime type of the document. If the mime type is text/csv then RFC4180_SKIP_EMPTY_LINES will be used. If the mime type is text/tab-separated-values then TSV will be used.

Setting the key

Set this configuration key in the search package or data source configuration.

Use the configuration key editor to add or edit the filter.csv-to-xml.format key, and set the value. This can be set to any valid CSVOptions allowed values: RFC4180_SKIP_EMPTY_LINES, RFC4180, EXCEL, TSV, MYSQL or MIME_TYPE value.

Default value

filter.csv-to-xml.format=MIME_TYPE

Examples

To interpret documents as MySQL style CSV.

filter.csv-to-xml.format=MYSQL