Glötzl CSV

Coding

In order to avoid problems with eventual multi-lingual usage, but also not to waste space, UTF8 coding should be used.

Line dividers

The line divider consists of the characters #13#10 (typical in the Windows world).

Header

The header consists of one line. It contains the respective column names, separated by semi-colons.

English column name in CSV	Column name	Description	Example
MPoint	Measuring point name	Any name with max. 30 characters Without quote marks Always present and should be unique	Name.P1 Name.P2 Name.T
MStation	Measuring station name	Any name with max. 24 characters Without quote marks Can be empty	MCC1
Ch	Measurement channel	Measurement channel 1..2000 Can be empty	1
Time	Measurement time	Time incl. milliseconds (NNN) Format YYYY-MM-DD HH:MM:SS,NNN Converted to Coordinated Universal Time (UTC)	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 Without quote marks	mm
Error	Error class	Number from 0..3999 0000: no error 1000..1999: light error 2000..2999: medium error 3000..3999: major error (measured value invalid in this case)	0
PreAlarm	Pre-alert	-1: fallen short of pre-alert 0: no pre-alert +1: pre-alert exceeded Empty: no pre-alert possible	0
Alarm	Alert	-1: fallen short of alert 0: no alert +1: alert exceeded Empty: no alert possible	0
MainAlarm	Main alert	-1: fallen short of main alert 0: no main alert +1: main alert exceeded Empty: no main alert possible	0

Example:

CODE

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