Différences entre versions de « SBK-CSV-File »
Sauter à la navigation
Sauter à la recherche
| Ligne 21 : | Ligne 21 : | ||
<font color="teal">'''DateTime'''</font> are encoded with the format "dd/mm/yyyy hh:nn:ss" | <font color="teal">'''DateTime'''</font> 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) | ||
| − | + | The capture below show a short example of CSV file generated by the datalogger. | |
<nowiki>"iter","datetime","Pression Atmosphérique (hectopascal)","Temperature (Celcius)" | <nowiki>"iter","datetime","Pression Atmosphérique (hectopascal)","Temperature (Celcius)" | ||
Version du 6 juillet 2024 à 00:27
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)
The capture below show a short 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
Written by Meurisse D. for MCHobby