Navigation:  Configuration and Setup > The Do-Not-Send Files >

User-Specific Do-Not-Send database lookup

Previous pageReturn to chapter overviewNext page

Purpose

The lookup checks for phone number, e-mail address or e-mail domain name for outbound operations controlled by a specific user (.USR) or user job properties (.UJP) file, and if found in the specified index file the outbound operation will fail.

The check is carried out in addition to any specified global NDX lookup or global database lookup.

Specifying User-Specific Do-Not-Send lookup NDX files

There is no default database.  You must always specify one to use this feature.

For phone number lookups, used for fax, voice and polling outbound operations, the user-specific database is specified on the $dns_file command.

For e-mail lookups, the user-specific database is specified using $var_def to assign a specification to the USER_DNS_MAIL system variable in the USR or UJP file controlling the outbound call.

For e-mail domain lookups, the user-specific database is specified using $var_def to assign a specification to the USER_DNS_DOMN system variable in the USR or UJP file controlling the outbound call.

Missing or invalid database elements will cause all lookups to succeed, so that all transmissions will fail.

The components of the database specifier are separated by the vertical bar symbol (|) and are as follows:

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 lookup (defaults to ADO default value)

Examples:

$var_def DNS_MAIL "@FFBASE\DoNotSend.MDB|DNSTABLE|EMAIL"

$dns_file "@FFBASE\DoNotSend.MDB|DNSTABLE|FAXNUMBER"

Do-Not-Send database maintenance

The database can be maintained using any database application which supports the specified file format.  You can also build an IVR application to maintain the database using the CopiaFacts built-in extended database features.

Do-Not-Send lookup exclusions

The $dns_file command may be placed in an FS file with a parameter of "none" to suppress the user do-not-send lookup for a specific item.  The system variables USER_DNS_MAIL and USER_DNS_DOMN may be assigned a value of NONE in an FS file to exclude the transmission from do-not-send lookup.  This may be useful when sending a fax or email to the target to confirm that the exclusion has been recorded.  Values of other than NONE on $dns_file or in these FS-file variables are ignored.

Failure Outcome codes

Phone and E-mail lookup failures:  76
Domain lookup failures: 84
Lookup database/table/field not found: 84.

 


Topic url: http://www.copia.com/support/refmanual/index.html?user_specific_do_not_send_db.htm