Crestron
e-control Vote SW-VOTE
53
••
Database
Installation & Reference Guide — DOC. 5822
in the
Queries
table, and from the naming of Request-to-Speak Console signal
blocks, as described below.
N
OTE
:
The agenda scroller record in the
Queries
table must name
Agenda
in its
table
field.
The reason this name must be used is that the table is also referenced by the combo-box (or list-box)
in the
Vote Proctor
window.
Queue tables
The naming of the queue tables (and scroller tables in general) is completely
arbitrary. All that is required to provide the Software Server with access to the table
is to place the chosen name into the
table
field of the scroller’s referenced record in
the
Queries
table. Typical names for scrollers used as queues (see “Queue
scroller tables,” below) might be
Q1
,
Q2
,
etc.,
as in the sample database (see figure
in next section). To reduce confusion, we recommend naming them the same as the
scroller signal blocks that reference them.
Save files
The “save files” are actually implemented as sets of tables, one table for each queue
in the queue set, one set for each “file.” Sufficient “save file” tables must exist in the
database for each queue; the present version does not create them on its own.
Specifically, if an RTS Console has three queues and five save files, you must create
3
x
5 =15 additional (empty) tables congruent in structure to your queue tables.
These tables are named as follows:
queue-table-name
_
i
where
queue-table-name
is the name of each table comprising the queue set; and
i
is
the number of the save file. The underscore character is required (sans spaces). If, for
example, the three queue tables in this example are called
QA
,
QB
, and
QC
, then
the 15 required “save file” tables would need to be named as follows:
Example “save file” table names
Queue A
Queue B
Queue C
Save file #1
QA_1
QB_1
QC_1
Save file #2
QA_1
QB_1
QC_1
Save file #3
QA_1
QB_1
QC_1
Save file #4
QA_1
QB_1
QC_1
Save file #5
QA_1
QB_1
QC_1
See the next section, “Queue scroller tables,” for instructions on how to create these
tables.
Save file directories
Each RTS Console also accesses a table of timestamps which is used as a directory
to select a “save file” for reloading. These tables are named as follows:
signal-block-name
_TimeTable
where
signal-block-name
is the name that was given to each Request-to-Speak
Console signal block when it was created.
different configuration files and/or different database files before the meeting begins. Another strategy for serving multiple rooms simultaneously
might be to provide a separate PC for each, or, at least, a separate instance of the Software Server app.
