Crestron
e-control Mail SW-MAIL
44
••
The e-Mail Database Tables
Installation & Reference Guide — Doc. 5798
The
eMail_Addr
Table
Each record in the
eMail_Addr
table must contain at least the following fields:
ID, first, last,
and
addr
. An entry with null
addr
field contents is still useful as a way
of labeling an outgoing message which will be sent to the default recipient as
described by the e-mailer signal block defaults.
The
eMail_Subst
Table
For more information about text
substitution, see “Text
Substitution Directives,” 48.
Each record in the
eMail_Subst
table must contain at least the following fields:
ID
and
substitution
. This table supports text substitution. In brief, the purpose of this
table is as follows:
Signals from the control system define the contents of text substitution “registers.”
The register is defined either directly by the string data of a serial signal or indirectly
by the analog datum of a lookup signal. In the latter case, the datum is used to lookup
a record in the
eMail_Subst
table, based on the
ID
field. The
substitution
field
of the matching record contains the new value of the register.
N
OTE
:
Normally, there is no direct relationship between the text substitution directive’s parameter
value and the
ID
field of a particular record in the
eMail_Subst
table. However, for directives
referencing undefined text substitution registers, the
Substitution Defaults
checkbox (see “Lookup
Substitution Defaults Checkbox,” page 23) can reverse this statement.
Tables for receiving e-mail
The following subsections discuss the tables available to an e-mailbox signal block.
There are two such tables,
InBox
n
and
msg
n
. They are maintained dynamically by
the activity of the signal block, and are not accessible from the
e-Mail Tables
window.
These tables are for displaying an IN box and displaying a selected message. Both
tables are optional. The tables are hooked to the signal block by referencing scroller
signal blocks in the
e-Mailbox Signal Block Definition
window
.
The referenced
scroller’s query numbers refer to entries in the
Queries
table. Each entry in turn
refers to a specific IN box or message table. The names of these tables are not “hard-
wired”; they are taken from the
Table
field of the
Queries
table.
IN Box Table
The IN box table is completely maintained by the e-mailbox signal block. It is
populated when the signal block downloads new mail; it is de-populated when the
control system issues the Delete signal. There should never be a need to edit these
tables directly. For your edification, the fields in these tables are summarized below.
Note that the field names are “hard-wired” in the server and must not be changed.
Field
Description
ID
e-Mail host’s unique message ID. Used by the server
to positively identify messages already downloaded to
avoid downloading them again.
msgDate
Verbatim text from messages date header.
msgFromName
Name of sender (if available).
msgFromAddr
Address of sender (always available).
msgSubj
Verbatim text from messages subject header.
msgRecp
Recipient list consisting of either the name (when
