Phone White-List Checking

$whitelist_phone pathname|databasespec [phonetype] [EmptyOK] [WSDelim] [Partial]

This command is used in a Job Administration UJP file to specify a white-list look-up file for use at launch time for phone items (fax, voice, poll, SMS).  The command may also be placed in an FS Template file (.FST) for use in an FFBC launch. Multiple commands may be supplied, and commands from System, Owner and Jobtype UJP files migrate to the job instance properties in the usual way.

The same pathname should only be used once in a set of lookup files.

The advantages of the launch-time do-not-send and white-list commands are described in the Configuration topic and an overview appears in Launch-Time Do-Not-Send Checking.

A match in the white-list file causes checking specified in the $dns_phone entries in the same file to be skipped.  It also causes legacy do-not-send look-ups at transmit time to be skipped.  If there is a $dns_phone command with a FailAll keyword, all entries not in the whitelist(s) will be failed.

The parameters on this command are used as follows:

pathnameThe pathname of the look-up file to be used.  Currently supported file extensions are:
.NDXa character- or numeric-mode index file created and maintained by the PIN utility.
.TXTa list of entries to be matched
databasespecThe components of the database specifier are separated by the vertical bar symbol (|) and are described in more detail in the description of the do-not-send feature.
Database NameThe full pathname of a supported database, or a DSN source
Table NameThe name of the table to use (default table name: DNS)
Key Field NameThe name of the key field to use (default key field RECIPIENT)
Timeout ValueTimeout for look-up (defaults to ADO default value)
Data Field NameThe name of the data field to use from the matched entry.
phonetypeOne of the keywords fax, phone, poll or sms to indicate the type of phone numbers for which this file is to be used.  If no keywords are given, the file is used for all types of broadcast involving a telephone number.
EmptyOKA keyword which indicates that the index/list may be empty.  This suppresses the check that ensures that at least one entry has been loaded from the file. Failure to load any entries could be a symptom of a corrupted file.
PartialA keyword which indicates that a partial match is allowed in addition to an exact match.  Specifically, a match is also recorded if the item in the index is shorter than, and an initial substring of, the item to be tested.  This parameter is ignored if databasespec is used
WSDelimA keyword which indicates that any number of white spaces may separate the phone number and the WHITELIST_DATA code in a loaded TXT list.  If you use this parameter, phone numbers in the list should of course not have embedded blank space.

The following processing is done on numbers to be matched:

if the value starts with sip: then the check is carried out on the portion following this string and preceding any @, if present.

in the NANP area, either two look-up operations are done on NANP numbers (with and without the leading 1 digit) or if the look-up index is known to contain only numbers with a leading 1 digit, the number looked up is forced to this format. Otherwise, non-numeric characters are removed and the numbers are then matched as entered.

The NDX file may contain a positive numeric data value for each entry, the TXT file may contain a positive numeric data value separated from the phone number by a single TAB character (or any white space, if WSDelim is used), and the database data field may also contain a numeric value. The default value is 1. The value will be saved as the value of a variable named WHITELIST_DATA in the launched FS file. This variable is used to cause legacy and pre-loaded do-not-send checking at transmit time to be skipped.

When multiple commands are specified, items will be checked in the order of System, Owner and Jobtype entries and in the reverse sequence to that in which they appear in each file.  In an FEB2 broadcast type (two list columns) a matched item will be prevent rejection even if fax transmission was specified to occur second.

Default:  Do-not-send items will not be skipped.

Example:

$whitelist_phone  @FFBASE\whitephone.ndx