AddressDoctor Concepts

In this section:

This section explains some AddressDoctor concepts and how they are reflected in DataMigrator.


Top of page

x
Preloading

The Preloading_Type attribute controls if preloading is done. The following preloading types are available.


Top of page

x
Process Modes

AddressDoctor supports four different validation types specified as the Database Type element. For use with DataMigrator, the BATCH mode is used.


Top of page

x
Address Element Abstraction

Addresses have developed differently in different countries, cultures, and languages around the world. AddressDoctor uses mapping to describe the different parts of an address. However, the generic names they use do not always correspond to American usage. The following table shows this:

AddressDoctor

American Usage

Example

Country

Country

United States

Province

State

Georgia

Locality

City

Atlanta

Street

Street

Hammond Drive, NE

House Number

Number

980

Building

Building

Two Lakeside Commons

Sub Building

Floor, Suite, Apartment, and so on

Suite 1200

Delivery Service

P.O. Box, RFD, and so on

Postal Code

Zip Code

30328

Organization

Organization, Company, and so on

Information Builders

Department

Department, Division

Southern Sales

Contact

Addressee

Although not used for address, verification and address can also include

AddressDoctor

American Usage

Example

Organization

Organization, Company, etc.

Information Builders

Department

Department, Division

Southern Sales

Contact

Addressee

Depending on the country, these generic terms take on different meanings. For example, while province maps to state in the U.S., its county in the U.K. and, well, province in Canada.



x
Input Data

In this section:

AddressDoctor can process address data in a wide variety of formats.



x
Fielded

AddressDoctor provides the most reliable input when the input data is what they call Fielded where each address components in a database is in a separate column. For example:

Company

Street

City

State

Zip

Country

Information Builders

2 Penn Plaza

New York

NY

10121

USA

Information Builders

2 Lakeside Commons

Atlanta

GA

30328

USA

Note that even in databases that have address components in separate columns, it is common to have the street number and name in the same column. In this case, the address is still considered to be fielded.



x
Partially Fielded

In some cases, input data may contain contact information separate from address data, but the address data itself is broken up only into address lines, for example:

Company

Address Line 1

Address Line 2

Country

Information Builders

2 Penn Plaza, 29th Floor

New York, NY 10121

USA

Information Builders

2 Lakeside Commons

Atlanta, Georgia 30328

USA

In this case AddressDoctor can parse the Address Line fields into the component fields.



x
Address Parsing

Databases containing addresses typically contain fields for each part of the address. However, information in address databases can be entered in the wrong field address parsing is needed to assign data to the correct field. AddressDoctor implements a parsing engine that is independent of postal reference data.

The Optimization_Level attribute controls how AddressDoctor behaves in respect to input data fields, the following types are available.


Top of page

x
Process Status

For each address processed. AddressDoctor provides a status code in the field PROCESSSTATUS. The meanings of these codes are shown in the table below.

V4

Verified - Input data correct - all (postal relevant) elements were checked and input matched perfectly.

V3

Verified - Input data correct on input but some or all elements were standardized or input contains outdated names or exonyms.

V2

Verified - Input data correct but some elements could not be verified because of incomplete reference data.

V1

Verified - Input data correct but the user standardization has deteriorated deliverability (wrong element user standardization - for example, postcode length chosen is too short). Not set by validation.

C4

Corrected - all (postal relevant) elements have been checked.

C3

Corrected - but some elements could not be checked.

C2

Corrected - but delivery status unclear (lack of reference data).

C1

Corrected - but delivery status unclear because user standardization was wrong. Not set by validation.

I4

Data could not be corrected completely, but is very likely to be deliverable - single match (for example, HNO is wrong but only 1 HNO is found in reference data).

I3

Data could not be corrected completely, but is very likely to be deliverable - multiple matches (for example, HNO is wrong but more than 1 HNO is found in reference data).

I3

Data could not be corrected, but there is a slim chance that the address is deliverable.

I1

Data could not be corrected and is pretty unlikely to be delivered.

N1

Validation Error: No validation performed because country was not recognized.

N2

Validation Error: No validation performed because required reference database is not available.

N3

Validation Error: No validation performed because country could not be unlocked.

N4

Validation Error: No validation performed because reference database is corrupt or in wrong format.

N5

Validation Error: No validation performed because reference database is too old - please contact AddressDoctor to obtain updated reference data.

S4

Parsed perfectly.

S3

Parsed with multiple results.

S2

Parsed with errors - elements changed position.

S1

Parse error - input format mismatch.


iWay Software