Specifications

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.
NOTE: 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, InBoxn and msgn. 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