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