GSE Scale Systems - 209
Chapter 20 Database (OPTION) Technical Reference Manual
a. <ENTER> key alone:
The "Down-load" command causes the currently selected
database to be transmitted out of the unit in a format
which could easily be accepted by a computer. The
format will the database to be imported into most
spreadsheet programs, such as Lotus 123 ©, Quattro ©,
and other database type programs. After pressing the
<ENTER> key on this selection, the prompt: "1 for
Comm" followed soon by "2 for Prntr" will appear.
Press the <1> key to send the transmission out the bi-
directional computer port or press the <2> key to use the
uni-directional printer port. Pressing any other key will
abort the transmission. The format for this transmission
is compatible with the unit's "UPLOAD" database
commands. Backed-up databases may be easily reloaded
into the unit.
If the database is being downloaded with the intention of
reloading it back into a unit in the future, an alternate
format is available by pressing the <3> or <4> key to
specify the comm or print port respectively. This will
cause the database to be preceded by the necessary
commands to access the database upload command when
the file is sent back to the unit later on. The pre-pended
information is:
*%s0%s
%i11%sx%e16%s%e
where the “x” would be replaced by the database number
being downloaded, ie 1 - 16.
Also, the <3> or <4> entry causes the last row of data to
be followed by a line with "ENDofDB". When the file is
reloaded, this causes the database upload mode to be
exited.
The "Down-load" command can be very useful for
'backing up' the database (ie saving a copy of the
database somewhere else). Also, for applications where
transaction information is collected on the scale
throughout the day, this can be useful for transferring the
collected to a computer for permanent storage,
integration into other databases, or further analysis. GSE
recommends that any databases that are stored within the
unit which are considered valuable be backed up to a
computer on a periodic basis in order to safeguard the
data. While this instrument provides a reasonably secure
storage means, any computer application will
recommend that the data be backed up to prevent any
loss of your data.
b. An entry followed by the <ENTER> key:
A <1> or <2> may precede the <ENTER> key for the
"Down-load" command in order to specify the port to be
used, <1> for the communication port or <2> for the
printer port. This form of the "Down-load" command
bypasses the prompting for the operator to key in a
particular port number. (The "number followed by the
<ENTER> key MUST be used when a macro is
programmed to print the database.)
14 PRINT ROW:
a. <ENTER> key alone:
The "Print row" command causes the current row within
the currently selected database to be transmitted out of
the unit in a format which will line up well with
subsequent issuances of this command. This could be
used for selectively building a report. After pressing the
<ENTER> key on this selection, the prompt: "1 for
Comm" followed soon by "2 for Prntr" will appear.
Press the <1> key to send the transmission out the bi-
directional communications port or press the <2> key to
use the uni-directional printer port.
Also available from this database menu selection is the
ability to send the database header which consists of the
column names of the selected database. Press <3> to
send the header out the comm port or <4> to use the
print port.
Pressing any key other than <1> through <4> will cancel
the transmission request.
The "Print row" command may be used where a report
needs to be generated which contains only certain stored
rows. This might be implemented in conjunction with a
series of "Recll Next" commands. This custom printing
could also be implemented by programming a custom
transmit appropriately, however with only four custom
transmits and up to 16 databases one could easily run out
of custom transmit setups.
b. An entry followed by the <ENTER> key:
A <1> or <2> may precede the <ENTER> key for the
"Print row" command in order to specify the port to be
used, <1> for the communication port or <2> for the
printer port . This form of the "Print row" command
simply bypasses the prompting for the operator to key in
a particular port number. If a <3> or <4> is entered,
then the column headings are printed instead, as
described above. (The "number followed by the
<ENTER> key MUST be used when a macro is
programmed to print the database.)
SECTION - 20.8
To Next Page
Loading...