The table data can be exported in two different formats:

  • JSON
    Exports the used data source information
  • CSV
    Exports the shown data without considering pagination data

Proceed as follows

  1. Click on the Download button below the table to open the drop-down list.
  2. Select the data format.

CSV formatting parameters

Bosch IoT Insights offers eight parameters with which the CSV output can be modified:

Parameter name

Default value

Possible arguments

CSV result

charset

[UTF-8]

For the table widget, only UTF-16 is supported


file encoding

locale

[en]

  • [en]

  • [de]

  • English date time names

  • German date time names

header

[present]

  • [present]

  • [absent]

  • header as first row

  • first dataset as first row

lineBreak

[CRLF]

  • [CRLF]

  • [LFCR]

  • [LF]

  • [CR]

  • [\r\n]

  • [\n\r]

  • [\n]

  • [\r]

columnSeparator

[comma]

  • [comma]

  • [semicolon]

  • [tab]

  • [,]

  • [;]

  • [\t]

masking

[false]

  • [false]

  • [true]

  • whatever.value.xxx

  • "whatever.value.xxx"

decimalSeparator

[dot]

  • [dot]

  • [comma]

  • [.]

  • [,]

dateTimeFormat

[yyyy-MM-dd HH:mm:ss]

All valid date time formats

formats date time fields

Predefined CSV formats

The predefined CSV formats are specified below:

  • RFC 4180
    • charset: UTF-8
    • locale: en
    • header: present
    • lineBreak: CRLF
    • columnSeparator: comma
    • masking: false
    • decimalSeparator: dot
    • dateTimeFormat: yyyy-MM-dd HH:mm:ss
  • Excel DE
    • charset: UTF-8
    • locale: de
    • header: present
    • lineBreak: CRLF
    • columnSeparator: semicolon
    • masking: false
    • decimalSeparator: comma
    • dateTimeFormat: dd.MM.yyyy HH:mm:ss