Custom layouts

User-defined layouts can be used to specify the number, content and format of the address output columns.

To create a custom layout, navigate to addressValidate\runtime folder in the Aperture Data Studio installation directory (by default C:\ProgramData\Experian\addressValidate\runtime) and edit the qaworld.ini file using a text editor.

Once you've created a custom layout, we recommend checking that it is valid and correct using the BATWV64.EXE test harness before using it in Data Studio.

We also recommend that you restart the Data Studio service after adding or updating a custom layout.

Here's an example of a custom layout that will return a 5-column output with:

• Line 1 containing business name and department information.
• Line 2 containing automatically formatted premise and street information.
• Lines 3 to 5 containing town, county and postcode, respectively.

[CustomGBR]
CountryBase=GBR
CleaningAction=Address

GBRAddressLineCount=5
GBRAddressLine1=W100,O21,O11
GBRAddressLine2=W60
GBRAddressLine3=W60,L21
GBRAddressLine4=W60,L11
GBRAddressLine5=W60,C11

You can define custom labels for each address line. These labels can then be used as column names for the cleansed address output from the Validate addresses step.

To define a label for an address line, add the label text prefixed with a "T" before specifying the address element.
Here is an example of a custom layout with line labels specified:

[Layout with labels]
CountryBase=GBR
CleaningAction=Address

GBRAddressLineCount=5
GBRAddressLine1=W100,TBusiness information,O21,O11
GBRAddressLine2=W60,TPremise detail
GBRAddressLine3=W60,TTown,L21
GBRAddressLine4=W60,TCounty,L11
GBRAddressLine5=W60,TPostcode,C11

The value of the CountryBase setting should be the identifier of the data mapping the layout is to be used with. The AddressLine setting keywords also need to be prefixed with the data mapping identifier. For example, if you have the following mappings:

DataMappings=GBR,United Kingdom,GBR
+ABC,UK with Names,GBR+GBRNAM

and want to specify a layout for your UK with Names mapping, the mapping identifier should be used as follows:

[Layout for UK with Names]
CountryBase=ABC
CleaningAction=Address

ABCAddressLineCount=5
ABCAddressLine1=W60
ABCAddressLine2=W60
ABCAddressLine3=W60,L21
ABCAddressLine4=W60,L11
ABCAddressLine5=W60,C11

Configuring USA for CASS certified cleaning

To return addresses in a CASS certified layout with DPV information, the layout should include the following settings:

Certification=True
CompatibilityFormatting=False