Différences entre versions de « SBK-CSV-File »
Ligne 52 : | Ligne 52 : | ||
The <font color="teal">'''first column'''</font> contains the "iteration" number. This number is incremented by 1 for each new data captured.<br /> | The <font color="teal">'''first column'''</font> contains the "iteration" number. This number is incremented by 1 for each new data captured.<br /> | ||
− | {{dbox-orange| Thanks to this number, it is quite easy to detect missing entries in the log file (which may happens when capturing lot of data at very high rate).}} | + | {{dbox-orange| Thanks to this iteration number, it is quite easy to detect missing entries in the log file (which may happens when capturing lot of data at very high rate).}} |
− | The second column | + | The <font color="teal">'''second column'''</font> contains the timing of captured data. |
+ | * Sampling >= 1sec: the column contains the date and time. | ||
+ | * Sampling < 1sec: the column contains the number of milliseconds since recording start. | ||
The other columns, one by captured data, contains the data with format identical to preview mode. | The other columns, one by captured data, contains the data with format identical to preview mode. |
Version du 6 juillet 2024 à 19:24
Forewords
When recording the sensor data, the DataLogger do store the data into a CSV file.
Unlike a computer, the microcontroler that powers the DataLogger has no concept of regional settings.
Consequently, the commonly used settings are applied when generating the CSV files and write numeric values into them.
CSV convention
The comma is used as field separator.
Numbers are written with
- dot as decimal separator
- Without thousand separator
Text value are double quoted
DateTime are encoded with the format "dd/mm/yyyy hh:nn:ss"
- dd: day of the month in two positions
- mm: month of the year in two positions
- yyyy: year in four positions
- hh: hour in two positions (00 to 24)
- nn: minutes in two positions (00 to 59)
- ss: seconds in two positions (00 to 59)
CSV filename is based on its creation time:
- yyyymmdd-hhnnss.csv (see datetime encoding here above)
- CSV files are stored into the /data path.
CSV File content
The capture below shows an example of CSV file generated by the datalogger.
"iter","datetime","Pression Atmosphérique (hectopascal)","Temperature (Celcius)" 1,01/01/2021 00:01:29, 990.92, 22.92 2,01/01/2021 00:01:30, 990.90, 22.91 3,01/01/2021 00:01:31, 990.88, 22.86 4,01/01/2021 00:01:32, 990.90, 22.85 5,01/01/2021 00:01:33, 990.88, 22.84 6,01/01/2021 00:01:34, 990.88, 22.85 7,01/01/2021 00:01:35, 990.84, 22.84 8,01/01/2021 00:01:36, 990.88, 22.83 9,01/01/2021 00:01:37, 990.87, 22.84
First row
The first row contains the columns title.
As they are text values, each entry is double-quoted.
The title for data columns use the "long description" of data together with "unit name" (inside parenthesis).
The first column contains the "iteration" number. This number is incremented by 1 for each new data captured.
The second column contains the timing of captured data.
- Sampling >= 1sec: the column contains the date and time.
- Sampling < 1sec: the column contains the number of milliseconds since recording start.
The other columns, one by captured data, contains the data with format identical to preview mode.
xxxxxxx
Written by Meurisse D. for MCHobby