Import CSV

Databoom allows to import signals and their values using CSV files.

When editing a device it is possible to set the Decimals separatorCSV 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.

CSV compatibility

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.

 DATE  TIME  SIGNAL_1  SIGNAL_2
 18/01/2017   16:00  123,45  678,91
...

or

 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.

 18/01/2017  16:59  SIGNAL_1  123,45
 18/01/2017   17:00  SIGNAL_2  678,91
...

o

 18/01/2017 16:59  SIGNAL_1  123,45
 18/01/2017 17:00  SIGNAL_2  678,91
...

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.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.