DataFlux Data Management Studio 2.7: User Guide
By default, the Address Verification (QAS) node supports version 6 of Experion QAS. If you need to perform La Poste-certified French address verification, you must use version 4.7 of QAS. Contact SAS technical support for information about obtaining this version.
The following table contains a list of possible output fields for the Address Verification (QAS) node.
Note: Not all output fields are available for all countries.
Field | Description |
---|---|
Output Line 1 | This is the first line in your address. |
Output Line 2 | This is an additional line for the address. Not all addresses carry to more than one line. If there is no data for this address line, the line is blank. |
Output Line 3 | This is an additional line for the address. Not all addresses carry to more than one line. If there is no data for this address line, the line is blank. |
Output Line 4 | This is an additional line for the address. Not all addresses carry to more than one line. If there is no data for this address line, the line is blank. |
Locality | Locality is the city name for the address. |
State Code | The State Code is an abbreviation of the state. |
Postcode | The Postcode is a postal code for the state and territory for the selected country. |
Country | This is the country represented in the address. |
Town | The Town field is the city or town in the address. |
County | This is the county where the address is located. |
When you install DataFlux Data Management Studio, a set of default configuration files is provided for the Address Verification (QAS) node. Verify that the default values are appropriate and update these files as needed.
There are three files that require changes before you can begin using the Address Verification (QAS) node. These files are qalicn.ini, qaworld.ini, and qawserve.ini.
Important: If you have existing DataFlux Data Management Studio jobs that include the Address Verification (QAS) node, your jobs will not work. You must reconfigure your existing jobs to work with QAS 6.x.
For more information about configuring QAS, refer to the QuickAddress Batch API Guide. You can also review the country-specific documents provided with your QAS data installation.
This QAS license file is located in the bin directory in your DataFlux Data Management Studio installation (by default, C:\Program Files\DataFlux\DataFlux Data Management Studio\[version]\bin\qalicn.ini). Open the license file in a text editor and copy your license key for each country to the license file.
Note: Each country license key must be on a separate line.
In the qaworld.ini file, verify that the CountryBase, InputLineCount, and AddressLineCount parameters are correct.
Under [ALL], set the value of the CountryBase parameter equal to one or more country prefixes for the countries you have installed. For example, for Australia, add the following line to the qaworld.ini file:
[ALL]
CountryBase=AUS
If you have more than one country prefix, separate each country with a space.
CountryBase=AUS GBR FRA
Refer to the International Address Data lists on the QAS Web site, for a complete list of countries.
Set the value of the InputLineCount parameter with the country. Add the country prefix to the parameter name and set the count equal to the number of lines your input addresses contain. For example, to define six lines for your Australia data, enter:
[ALL]
CountryBase=AUS
AUSInputLineCount=6
Set the value of the AddressLineCount parameter. Add the country prefix to the parameter name and set the count equal to the total number of lines. Then, specify which address element will appear on which line in the input address by setting the value of the AddressLine parameter equal to a comma-separated list of element codes. For example:
[ALL]
CountryBase=AUS
AUSInputLineCount=6
AUSAddressLineCount=8
When you are finished setting up your Australia data in qaworld.ini, it should look similar to this:
[ALL]
CountryBase=AUS
AUSInputLineCount=6
AUSAddressLineCount=8
AUSAddressLine1=W60
AUSAddressLine2=W60
AUSAddressLine3=W60
AUSAddressLine4=W60,L21
AUSAddressLine5=W60,L11
AUSAddressLine6=W60,C11
AUSAddressLine7=W60,X11
AUSAddressLine8=W120,L21,L11,C11,X11
The following options are important for performance:
Specifies the time in milliseconds that the batch will wait until it finds a correspondence in the data set. This value can be reduced to increase performance.
Specifies whether the QAS database is partially loaded into memory (Default) or completely loaded into memory (All). If you have enough memory available, the All setting can increase performance significantly.
In the qawserve.ini file, you must specify the following parameters. If more than one country prefix is added to the parameter, each subsequent country prefix should be typed on a new line and preceded by a + (plus sign). For a complete list of supported countries, refer to the International Address Data lists on the QAS Web site.
Set the value of the DataMappings parameter equal to the country prefix, country name, and the country prefix again. Separate each value by a comma. For example:
DataMappings=AUS,Australia,AUS
Set the value of the InstalledData parameter equal to the country prefix and installation path. Separate each value by a comma. For example:
InstalledData=AUS,C:\Program Files\QAS\Aus\
Set the value of the InstalledCountries parameter equal to the path to the countries data set. For example:
InstalledCountries=FRX,France,C:\Program Files (x86)\QAS\Data\Frx.001\frx
In the previous example path, frx is the name of the countries data set. For more information about configuring the qawserve.ini file, see the QuickAddress Batch API Guide and the country-specific data guides.
If desired, you can specify a path to a log file for QAS processing. See the item about
Failure while retrieving the country list; country name is invalid
This usually means that you have at least one country listed in the CountryBase setting (in the qaworld.ini file) that is not referenced in the qawserve.ini file, or there could be a typographical error in the qawserve.ini file that is preventing the data from being loaded.
The best way to find out which file is affected is to turn on logging in the qaworld.ini file (located in C:\Program Files\DataFlux\Unity\[version]\bin\qaworld.ini). The settings to add/change are:
LogFile=/usr/[username]/api.log
LogTrace=-1
LogErrors=Yes
QAS data becomes old and must be refreshed from time to time. You will be prompted when it is time to refresh QAS data.
The DataFlux Data Management Studio Address Verification (QAS) node accesses QuickAddress Software (QAS). You will find detailed QAS documentation with your country data installation. You can also review the QuickAddress Batch API Guide.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_PFEnrich_AddrVerQAS_Ref.html |