Appendix e: logged data format – ADS Environmental Services Spider QR 775010 A0 User Manual
Page 98

ADS Environmental Services ADS Spider User Manual
Page 96
Appendix E: Logged Data Format
The Spider logs data internally in an efficient binary format.
The internal binary format is converted into a standard
“
CSV
”
(Comma Separated Values) file before each download. A CSV file is
readable by most spreadsheet and database programs. This
appendix provides information about the structure of the
“
CSV
”
file.
Each record in the file consists of four fields:
1. record date (e.g., 11/29/07)
2. record time (e.g., 12:34:15)
3. record numeric identifier
4. record text description or, in the case of analog and counter
inputs, the value of the input
The following table lists all possible values for the numeric identifier
and the text fields:
Numeric
Identifier
Range
Text
Comment
32768
32768
New File
New log file created
32769
32769
NORML ST
Normal program
start
32770
32770
PHONE ST
Phone program
start
32771
32771
MODM ON
Modem came on-
line
32772
32772
MODM OFF
Modem went off-line
32773
32773
RING DTC
Incoming ring
detected
0 + IN#
0
–
10
Numeric value
of analog /
system input
Analog / system
input log record
20 + IN#
20 - 27
Numeric value
of counter
input
Counter input log
record
50 + 2*IN# +
50
–
65
STx=y
Digital input change