Instruction manual

SECTION 8. FILES, PROTOCOLS, AND UTILITIES
8-2
be able to manually find the missing data in
QUEUE.DAT. QUEUE.DAT is not intended to
be used as a reliable backup for an intermittent
pipe connection. There is no size restriction on
QUEUE.DAT but it does not increase in size
under normal conditions.
8.1.3 RTM
Template.ALM − Where template is the name
of the RTM template detecting the user defined
alarm. Logging of alarms is optional, as part of
the RTM numeric display. This file continues to
grow until manually erased.
8.2 EXTRACT UTILITY
The Extract utility is used to sort, check, and
combine ASCII files created by DBSelect and
GraphTerm when used with a CR10T
datalogger. Extract will take data from multiple
files, sort the data based on the record
numbers, remove any duplicate records and
notify the user of any missing records. A start
and stop time may be specified.
Extract uses command line parameters. The
syntax is as follows:
EXTRACT <source> [<destination> [<begin>
[<end>]]]
Source − Is the name (without extension) of
data files. This is usually something like
"LgrName\TblName".
Destination − Is the complete path and file
name where the extracted records will be
written.
Begin and end − Are times used to specify the
time swath of data to be extracted. Extracted
records will be greater than or equal to 'begin'
and less than 'end'. The date/time field must be
enclosed in quotations if it contains spaces or
commas.
The [ ] brackets indicate optional parameters.
Only the source name is required. The default
destination filename is TEMP.DAT and all
records in the source files are included by
default.
The following gives an example of extracting
data from a site named mtlogan with a table
named one_min:
extract mtlogan\one_min temp.dat "3-8-94
00:00:00" "3-8-94 24:00:00"
In response, Extract gives the following type of
information:
Extracting 'one_min' from '1994-03-08 00:00:00'
to '1994-03-09 00:00:00'.
Scanned 'ONE_MIN', 181 records, 181 match.
First record starts at "1994-03-08 09:15:00".
Duplicate - "1994-03-08
09:15:00",0,13.44,1,0.017,1
Duplicate - "1994-03-08
09:15:00",0,13.44,1,0.017,1
Duplicate - "1994-03-08
10:04:00",49,12.89,50,0.766
Duplicate - "1994-03-08
10:05:00",50,12.88,51,0.777
Last record is at "1994-03-08 10:06:00".
52 records written to 'temp.dat'.
8.3 FORMAT OF THE AUTOHOLE.DAT
FILE
DBSelect looks for a file named
AUTOHOLE.DAT in its default directory. If such
a file exists DBSelect will read it and insert the
holes described there into the hole queue as if
they had been inserted by hand from the hole
dialog.
The format for the file is a follows:
NOTE: The format for the holes.ini is
identical.
HOLECOLLECT01
{stationname tablename start end flag CRLF}
examples:
HOLECOLLECT01
Stn2 ONESECND 631152000 1262304000 1
Stn2 Status 631152000 1262304000 1
Stn2 TimeSet 631152000 1262304000 1
Stn2 ErrorLog 631152000 1262304000 1
Stn2 ErrorLog 0 12 0
What it means:
The first line of the file is a validity check, this is
HOLECOLLECT version 01. Each successive
line contains: