CSV File Structure¶
The DataPump Service exports time-series data as .csv files. Depending on the DataPump configuration, files may be delivered uncompressed or compressed with gzip (.csv.gz).
Two format variants are supported for the measurements dataset:
| Format | Description |
|---|---|
csv |
Standard CSV format per RFC 4180, including GNSS columns |
csv-no-gnss |
Standard CSV format per RFC 4180, without GNSS columns |
Each row represents one signal value at a specific point in time for a specific machine. The CSV file has no header row. The following seven columns are present in both formats:
| Field | Type | Description |
|---|---|---|
| CU-ID | String | Unique Identifier of the Communication Unit, usually the IMEI-number |
| machine_id | Long (64-bit) | Internal numeric identifier of the machine |
| machine_name | String | Human-readable name of the machine |
| machine_serialnumber | String | Serial number of the machine |
| timestamp | Integer | Unix timestamp in milliseconds of the data point |
| signal_key | String | Identifier of the signal (e.g. value.common.engine.hours.total) |
| signal_value | String | Measured value of the signal at the given timestamp |
Signal labels are not included in the file — these must be resolved externally.
The following columns are only present when GNSS export or OEM external key export is enabled in the DataPump configuration:
| Field | Type | Description | Condition |
|---|---|---|---|
| latitude | Float | GPS latitude of the machine | csv format only |
| longitude | Float | GPS longitude of the machine | csv format only |
| altitude | Float | GPS altitude of the machine | csv format only |
| heading | Float | GPS heading of the machine | csv format only |
| oem_external_key | String | OEM-specific external machine identifier | When OEM external key export is enabled |
CSV Example Data — csv-no-gnss format (click to view)
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.engine.hours.total","63947720.35"
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.machine.hours.pto.total","13.75"
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.engine.fuel.used.total","172.0"
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.engine.fuel.level","82.0"
"357520077898886",110309,"PRO Donau logging_3k","357520077898886",1624406357000,"value.common.cu.sensors.acc.x","-0.07910156"
"357520077898886",110309,"PRO Donau logging_3k","357520077898886",1624406357000,"value.common.cu.sensors.acc.y","0.0390625"
CSV Example Data — csv format with GNSS (click to view)
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.engine.hours.total","63947720.35",50.5401818,9.6828053,281.112,177.36062
"352648068064187",59454,"PRO Donau logging_5k","253004046 SN1560002 352648068064187",1624406349000,"value.common.machine.hours.pto.total","13.75",50.5401818,9.6828053,281.112,177.36062
"357520077898886",110309,"PRO Donau logging_3k","357520077898886",1624406357000,"value.common.cu.sensors.acc.x","-0.07910156",50.5401818,9.6828053,281.112,177.36062
"357520077898886",110309,"PRO Donau logging_3k","357520077898886",1624406357000,"value.common.machine.geo.speed","0.036",50.5401818,9.6828053,281.112,177.36062