Options - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
Copyright
2024
First publish date
2007
Last updated
2024-10-11
Published on
2024-10-11T22:55:47.128293
Table 1. Get Candidate Addresses Options

Option Name

Description

Enable U.S. address processing

Specifies whether or not to process U.S. addresses. If you enable U.S. address processing Get Candidate Addresses will attempt to retrieve candidate addresses for U.S. addresses. If you disable U.S. address processing, U.S. addresses will fail, meaning they are returned with an "F" in the Status output field. The output field Status.Code will say "DisabledCoder." If you are not licensed for U.S. address processing you must disable U.S. address processing in order for your jobs to complete successfully, regardless of whether or not they contain U.S. addresses.

Note: You must have a valid license for U.S. address processing to successfully process U.S. addresses. If you enable U.S. address processing but are not licensed for this feature, or your license has expired, your entire job will fail.

Database

Specifies the database to be used for U.S. address processing. Only databases that have been defined in the US Database Resources panel in the Management Console are available.

Enable Canadian address processing

Specifies whether or not to process Canadian addresses. If you enable Canadian address processing Get Candidate Addresses will attempt to retrieve candidate addresses for Canadian addresses. If you disable Canadian address processing, Canadian addresses will fail, meaning they are returned with an "F" in the Status output field. The output field Status.Code will say "DisabledCoder." If you are not licensed for Canadian address processing you must disable Canadian address processing in order for your jobs to complete successfully, regardless of whether or not they contain Canadian addresses.

Note: You must have a valid license for Canadian address processing to successfully process Canadian addresses. If you enable Canadian address processing but are not licensed for this feature, or your license has expired, your entire job will fail.

Database

Specifies the database to be used for Canadian address processing. Only databases that have been defined in the Canadian Database Resources panel in the Management Console are available.

Enable International address processing

Specifies whether or not to process international addresses (addresses outside the U.S. and Canada). If you enable international address processing Get Candidate Addresses will attempt to retrieve candidate addresses for international addresses. If you disable international address processing, international addresses will fail, meaning they are returned with an "F" in the Status output field. The output field Status.Code will say "DisabledCoder." If you are not licensed for international address processing you must disable international address processing in order for your jobs to complete successfully, regardless of whether or not they contain international addresses.

Note: You must have a valid license for international address processing to successfully process international addresses. If you enable international address processing but are not licensed for this feature, or your license has expired, your entire job will fail.

Database

Specifies the database to be used for international address processing. Only databases that have been defined in the International Database Resources panel in the Management Console are available.

Casing

Specifies the casing of the output data. One of the following:

Mixed
Returns the output in mixed case (default). For example:

123 Main St
Mytown FL 12345

Upper
Returns the output in upper case. For example:

123 MAIN ST
MYTOWN FL 12345

Maximum records to return

The maximum number of candidate addresses that Get Candidate Addresses should return. The default is 10. The maximum is 10.

Return short city name

For U.S. addresses, specifies whether or not to return the USPS®-approved abbreviation for the city, if there is one. The USPS® provides abbreviations for city names that are 14 characters long or longer. City abbreviations are 13 characters or less and can be used when there is limited space on the mailing label. If there is no short city name for the city, then the full city name is returned.

Dual address match logic

(U.S. addresses only). Controls whether Get Candidate Addresses should return a street match or a PO Box/Rural Route/Highway Contract match when the address contains both street and PO Box/Rural Route/Highway Contract information. For more information, see About Dual Address Logic.

Normal Match
(Default) USPS® CASS™ regulations determine the address returned based on the following order of priority:
  1. PO Box
  2. Firm
  3. Highrise
  4. Street
  5. Rural Route
  6. General Delivery
Street Match
Return a street match, regardless of the address line.
PO Box Match
Return a PO Box match, regardless of the address line.

Street matching

The strictness of the street name match (U.S. addresses only).

Exact
The input street name must match the database exactly.
Tight
The matching algorithm is "tight."
Medium
The matching algorithm is "medium" (default).
Loose
The matching algorithm is "loose."

Firm matching

The strictness of the firm name match (U.S. addresses only).

Exact
The input firm name must match the database exactly.
Tight
The matching algorithm is "tight."
Medium
The matching algorithm is "medium" (default).
Loose
The matching algorithm is "loose."

Directional matching

The strictness of the directional match.

Exact
The input directional must match the database exactly.
Tight
The matching algorithm is "tight."
Medium
The matching algorithm is "medium" (default).
Loose
The matching algorithm is "loose."

Perform enhanced street matching

Specifies whether or not to perform Enhanced Street Matching (ESM). ESM applies extra matching logic with additional data to any input address that is not matched through the regular address validation process. ESM applies to U.S. addresses only.

Search address lines on fail

Specifies whether ValidateAddress will search address lines for the city, state/province, and postal code.

This option enables Validate Address to search the AddressLine input fields for the city, state/province, postal code, and country when the address cannot be matched using the values in the City, StateProvince, and PostalCode input fields.

Consider enabling this option if your input addresses have the city, state/province, and postal code information in the AddressLine fields.

Consider disabling this option if your input addresses use the City, State/Province and PostalCode fields. If you enable this option and these fields are used, there is an increased possibility that Validate Address will fail to correct values in these fields (for example a misspelled city name).