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:
[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
To return addresses in a CASS certified layout with DPV information, the layout should include the following settings: