Data is broken up into fields of keys. Commas delimit successive keys, alphabetic keys are surrounded by double quotes and numeric keys are not quoted. This file format is also suitable for importing into database and spreadsheet programs. Spreadsheet macros may be used to re-expand and process the keys for data reports, etc.
Comma Delimited Keys Format
" Time/Date Stamp"," Channel Number "," Current Reading "," Channel State "," PIN Number "
Channel State Keys
0 = NORMAL
2 = ALARM
3 = ALARM ACKNOWLEDGED
7 = COMMUNICATIONS ALARM
Example:
" Fri Aug 06, 1999 10:40:14"," 7 "," 220 "," 3 "," 2 "
Note: The channel number replaces any text message. When exported to a spreadsheet, various spreadsheet functions can be used to re-expand the report as desired.
Note: Configuration Change reports are always delivered in Full Text format regardless of this setting.
For System Channel keys, let "Number of Channels" be the maximum number of user-configurable channels for a given model number. The "Channel Number" field of any channel status message formatted as "comma delimited keys" will be:
|
|
Number of Channels |
||
System Channel Data Point |
SysChan |
256 |
96 |
56 |
Phone Failure |
Nchans + 1 |
257 |
97 |
57 |
Power Failures |
Nchans + 2 |
258 |
98 |
58 |
Battery Charging |
Nchans + 3 |
259 |
99 |
59 |
Time of Day Clock Reset |
Nchans + 4 |
260 |
100 |
60 |
Log File Overflow |
Nchans + 5 |
261 |
101 |
61 |
RACO SCADA Session Failure |
Nchans + 6 |
262 |
102 |
62 |
See Also
Comma-Delimited Keys Data Sample