Glötzl CSV
Encoding
To avoid problems with possible multi-language support but also to avoid wasting space, UTF8 encoding should be used.
Row dividers
The row divider consists of the characters #13#10 (typical in Windows).
Header
The header consists of one row. It consists of the respective columns names, separated by semi-colons.
Column name in the CSV file | Column name | Description | Example |
|---|---|---|---|
MPoint | Name of measuring point | Any name with max. 30 character No quotation marks | Name.P1 Name.P2 Name.T |
MStation | Name of measurement station | Any name with max. 24 characters No quotation marks | MCC1 |
Ch | Measurement channel | Measurement channel 1..2000 Can be empty | 1 |
Time | Time of measurement | Time incl. milliseconds (NNN) | 2011-12-06 10:05:06,125 |
Value | Measured value | Double float value with point as decimal separator | 1.23 |
Unit | Unit | Any unit with max. 20 characters No quotation marks | mm |
Error | Error class | Number from 0..3999 1000..1999: mild error 2000..2999: medium error 3000..3999: serious error (in this case, measured value is invalid) | 0 |
PreAlert | Pre-alert | -1: Pre-alert not reached 0: No pre-alert +1: Pre-alert exceeded Empty: no pre-alert possible in principle | 0 |
Alert | Alert | -1: Alert not reached 0: No alert +1: Alert exceeded Empty: no alert possible in principle | 0 |
MainAlert | Main alert | -1: Main alert not reached 0: No main alert +1: Main alert exceeded Empty: no main alert possible in principle | 0 |
Beispiel:
MPoint;MStation;Ch;Time;Value;Unit;Error;PreAlarm;Alarm;MainAlarm
ZA12.P1.Raw;Station MCC;10;2011-11-17 21:25:10,120;93.60;mm;0;0;0;0
ZA12.P2.Raw;Station MCC;10;2011-11-17 21:25:15,050;90.60;mm;0;0;0;0
ZA12.T.Raw;Station MCC;10;2011-11-17 21:25:20,000;13.7;°C;0;0;0;0
TA12.P1.Raw;Station MCC;10;2011-11-17 21:26:10,056;93.60;mm;0;0;0;0
TA12.P2.Raw;Station MCC;10;2011-11-17 21:26:15,345;90.60;mm;0;0;0;0
TA12.T.Raw;Station MCC;10;2011-11-17 21:26:20,123;33.7;°C;0;1;1;0
HYD14.H.Raw;Station MCC;10;2011-11-17 21:27:10,111;10.60;mm;2100; 0;0;0
HYD14.T.Raw;Station MCC;10;2011-11-17 21:27:20,432;-12.7;°C;0;-1;0;0
GLACalculatedDemo.P.Sum;;;2011-11-17 21:28:10,234;12.5;mm;0;0;0;0