Exporting table data
The table data can be exported in two different formats:
JSON
Exports the used data source informationCSV
Exports the shown data without considering pagination data
Proceed as follows
Click on the Download button below the table to open the drop-down list.
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] |
|
|
header |
[present] |
|
|
lineBreak |
[CRLF] |
|
|
columnSeparator |
[comma] |
|
|
masking |
[false] |
|
|
decimalSeparator |
[dot] |
|
|
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:
-
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