In this section: |
This section explains some AddressDoctor concepts and how they are reflected in DataMigrator.
The Preloading_Type attribute controls if preloading is done. The following preloading types are available.
AddressDoctor supports four different validation types specified as the Database Type element. For use with DataMigrator, the BATCH mode is used.
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.
In this section: |
AddressDoctor can process address data in a wide variety of formats.
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.
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.
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.
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 |