Databoom allows to import signals and their values using CSV files.
When editing a device it is possible to set the Decimals separator, CSV datetime format and CSV signals fields. The datetime format must match the one present in the files (in order to parse data correctly) and it is required to specify the descriptions of the signals to import or all data will be left out.
There are two categories of .CSV files supported:
- with header;
- without header.
In case of CSV with header, the first row will be the header where are allowed up two columns for date and time, while the following are to be used for signals descriptions. In the next rows, signals description are substituted from signals value.
DATETIME;SIGNAL_1;SIGNAL_2 18/01/2017 16:00;123.45;678.91
In case of CSV senza header, are allowed up two columns for date and time, one for the description and one for the value.
How to import CSV
There are two ways to import from .CSV:
- Import a single file, from the device details page by clicking the button Import CSV (the button is available only after checking the Enable CSV import option in the device edit page);
- Create a device whose type uses CSV, for example Google Drive.