Skip to content

CSV export configuration

Export settings for the csv you can set are:

  • charset: Sets the charset the csv is encoded in. Default "utf-8".
  • delimiter: Sets the delimiter used for dividing cells in the csv. To change the delimiter the useBOM setting has to be set to false! Default ";".
  • title: Sets the title used in the exported csv.
  • useBOM: Defined if a universalBOM will be added to the beginning of the csv. Default true.
  • attributes: When exporting to CSV, the standard attribute settings are used. If you need to adapt the way each attribute is exported to CSV, you can override the settings of an attribute.

Example

"...": {
    "settings": {
        "csv": {
            "attributes": [
                {
                    "name": "ATTRIBUTE_NAME",
                    "control": "hidden"
                }
            ],
            "charset": "windows-1252",
            "delimiter": ",",
            "title": "CSV Title",
            "useBOM": false
        }
    }
}

Additional Information

Excel does not open files in utf-8 by default, even though that is the international standard. You have to force Excel to open any exported csv file in utf-8. This can be done by adding a universal BOM at the start of the file. In order to do so, set useBOM to true in the config (which is the default). This will force excel to open the exported csv in utf-8 and therefore not have encoding problems for special characters. If you want to export a csv with anything other than the standard delimiter ";", this will clash with the universalBOM as the custom delimiter needs to be at the start of the csv as well. This means that when setting a custom delimiter AND a universalBOM at the same time to prevent encoding problems only one will work. Therefore, Insight gives priority to encoding (BOM) instead of custom delimiters.