Listware Online:Global Address

From Melissa Data Wiki
Jump to navigation Jump to search

← Listware Online


Upload

You must first upload the file you want to cleanse and enrich.

Then select the data quality service you want to use.


Mapping

By default, the File Name, File Size, Header presence, and Record Count are displayed at the top of this page.

Data Quality Service Check Options

Country of Origin
The origin country for mailing used in the Formatted Address output column.
Output Script
The character set to use to format the output data.
Default Country
Used if no country column is specified or if a record's country column is blank.

Review and Map the Input Columns

Match the input columns with the correct data type. The service will try to match the columns automatically, but you may need to do some fine tuning.


Outputs

Check the boxes next to your desired output columns

Output Columns

Select the addressing style that best describes the type of data that you would like to output.

Multi-Line Address
The entire mailing address will appear in output Address Lines 1-8.
Delivery Address
The street address will appear in Address Lines 1-8 and the Regional information to appear in separate fields.
Delivery Address and Parsed Components
The entire mailing address will appear in output Address Lines 1-8 and the Regional information to appear in separate fields. In addition, you can capture the parsed street address components.

Organization

Organization
Matches the Organization input. It is not modified or populated by the Cloud Service.

Address Lines

Address Line 1
Address Line 1. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 2
Address Line 2. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 3
Address Line 3. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 4
Address Line 4. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 5
Address Line 5. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 6
Address Line 6. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 7
Address Line 7. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.
Address Line 8
Address Line 8. The standardized or corrected contents of the input address. These lines will include the entire address including the locality, administrative area, and postal code.

Country

Country Name
The standardized country name.
ISO 3166-1 Country Code
The country code. Select what format this will be in with the format drop-down.
Format
Select the format of the output country code.
Code Definition
Alpha-2 The two letter abbreviation for countries. e.g., for United States; Canada; and the Philippines: US; CA; PH.
Alpha-3 The three letter abbreviation for countries. e.g., for United States; Canada; and the Philippines: USA; CAN; PHL.
Numeric The number code for countries. e.g., for United States; Canada; and the Philippines: 840; 124; 608.

GeoLocation

Latitude & Longitude
The latitude and longitude geo coordinates.

Regional Levels

Double-Dependent Locality
Double-Dependent Locality. An area or village (e.g., UK) within a Dependent Locality required to identify an address.
Dependent Locality
Dependent Locality. A district, area, or neighborhood (e.g., Turkey) within a Locality required to identify an address.
City/Locality
A city (e.g., US), town, or municipality (e.g., Canada) that is the most common population center element within an Administrative Area.
Sub-Administrative Area
A county (e.g., US) or region larger than the Locality but smaller than the Administrative Area.
State/Province/Admin Area
A state (e.g., US), province (e.g., Canada) or canton (e.g., Switzerland) contained within a Country.
Zip/Postal Code
The postal code or ZIP code (e.g., US) for the input address.
Sub-National Area
Sub-National Area. Not commonly used. An arbitrary region smaller than a Country but larger than an Administrative Area.

Parsed Components

Address Type
A one-character code for the type of address coded. Only for US and Canadian addresses.
Address Key
A unique key for the address. Only for US and Canadian addresses.
Throughfare
The thoroughfare (e.g., the name of the street or block).
Throughfare Pre-Direction
The prefix directional contained within the Thoroughfare.
Throughfare Leading Type
The leading thoroughfare type indicator within the Thoroughfare.
Throughfare Name
The name indicator within the Thoroughfare.
Throughfare Trailing Type
The trailing thoroughfare type indicator within the Thoroughfare.
Throughfare Post-Direction
The postfix directional contained within the Thoroughfare.
Dependent Throughfare
The dependent thoroughfare (e.g., the name of the dependent street or block).
Dependent Throughfare Pre-Direction
The prefix directional contained within the Dependent Thoroughfare.
Dependent Throughfare Leading Type
The leading thoroughfare type indicator within the Dependent Thoroughfare.
Dependent Throughfare Name
The name indicator within the Dependent Thoroughfare.
Dependent Throughfare Trailing Type
The trailing thoroughfare type indicator within the Dependent Thoroughfare.
Dependent Throughfare Post-Direction
The postfix directional contained within the Dependent Thoroughfare.
Sub-Premises
The alphanumeric code that identifies an individual location.
Building
The descriptive name identifying an individual location.
Premises Type
The leading premises type indicator within Premises.
Premises Number
The alphanumeric indicator within Premises.
Sub-Premises Type
The sub-premises type indicator within Sub-Premises.
Sub-Premises Number
The alphanumeric indicator within Sub-Premises.
Post Box
The post box information for a particular delivery point.


Review

This section displays your selected options and columns.

Create Job Name

You must also create a name for the job.


Report

Once we have processed your job, you may access a summary report of the job. This will show you the record counts (e.g. number of verified records, matches, etc.) and credit costs.