Différences entre versions de « SBK-CSV-File »

De MCHobby - Wiki
Sauter à la navigation Sauter à la recherche
Ligne 30 : Ligne 30 :
 
* {{fname|yyyymmdd-hhnnss.csv}} (see datetime encoding here above)
 
* {{fname|yyyymmdd-hhnnss.csv}} (see datetime encoding here above)
 
* CSV files are stored into the {{fname|/data}} path.
 
* CSV files are stored into the {{fname|/data}} path.
 +
 +
== CSV File content ==
  
 
The capture below shows an example of CSV file generated by the datalogger.
 
The capture below shows an example of CSV file generated by the datalogger.
Ligne 43 : Ligne 45 :
 
8,01/01/2021 00:01:36, 990.88, 22.83
 
8,01/01/2021 00:01:36, 990.88, 22.83
 
9,01/01/2021 00:01:37, 990.87, 22.84</nowiki>
 
9,01/01/2021 00:01:37, 990.87, 22.84</nowiki>
 +
 +
xxxxxxx
  
 
{{SBK-TRAILER}}
 
{{SBK-TRAILER}}

Version du 6 juillet 2024 à 00:39

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

xxxxxxx


Written by Meurisse D. for MCHobby


MCHobby investit du temps et de l'argent dans la réalisation de traduction et/ou documentation. C'est un travail long et fastidieux réalisé dans l'esprit Open-Source... donc gratuit et librement accessible.
SI vous aimez nos traductions et documentations ALORS aidez nous à en produire plus en achetant vos produits chez MCHobby.