Csv Datenfile beschreibung, wo kann ich die finden?

norbertschulz · 7. Dezember 2021 um 17:49

Die Spalten im csv trackfile sind weitestgehend selbsterklärend, aber ich versuche die Spalten O - T besser zu verstehen. Das sind Confirmed - Marked - Invalid - InsidePrivacyArea - Factor - Measurements.
Wenn der Knopf am Lenker beim Überholvorgang gedrückt wird, was wird wo hinein geschrieben?

opatut · 7. Dezember 2021 um 18:11

github.com

openbikesensor/OpenBikeSensorFirmware/blob/master/docs/software/firmware/csv_format.md

# Format specification for the internal CVS format

## Encoding

The whole data file is encoded as UTF-8. Writers of the file may choose not to use the whole unicode range for simplicity and restrict themselves to 7-bit ASCII for simplicity, because it is identical with UTF-8. The OBS does this for example, since it only produces data that can be encoded this way. Parsers should interpret the whole file as UTF-8 however, since other data sources may produce special characters inside the file, such as in free text comment fields.

The file must not include a [BOM](https://de.wikipedia.org/wiki/Byte_Order_Mark).

## Metadata

The 1st line of the CSV file contains key value metadata as URL encoded 
parameters. This line must be skipped to get a full CVS conform format. 
A sample line could look like follows:

```URL
OBSFirmwareVersion=v0.3.999&OBSDataFormat=2&DataPerMeasurement=3&\
MaximumMeasurementsPerLine=60&OffsetLeft=30&OffsetRight=30&\
NumberOfDefinedPrivacyAreas=3&PrivacyLevelApplied=AbsolutePrivacy&\
MaximumValidFlightTimeMicroseconds=18560&\
DistanceSensorsUsed=HC-SR04/JSN-SR04T&DeviceId=ecec

This file has been truncated. show original

norbertschulz · 7. Dezember 2021 um 18:24

Danke für die schnelle Antwort, ich hatte in der Doku gesucht aber nicht in Github nachgesehen . Dann werde ich mal weitersuchen warum manche tracks fehlerhaft sind.