QAS Pro address verification software is designed to instantly verify & search addresses against the latest Australia Post’s Postal Address File (PAF).
Find the Borrowers for whom you wish to export addresses. For example you could use the date of joining as a way of selecting borrowers or select by Surname Letter etc.
Borrower Address 1 : Export Borrower Address 1 for QAS checking
Borrower Address 2 : Export Borrower Address 2 for QAS checking
Borrower Address 3 : Export Borrower Address 3 for QAS checking
When the option is selected e.g. Borrower Address 1, a message will display, prompting a File to be selected.
If Yes is selected, a list of files will display. Select the file as required by choosing [F9] Select.
A Windows dialogue box will display where a file can be created for use with QAS.
The Number of Address records will display
Refer to this product for more details. A brief description is given below. When you open the file in QAS batch, a configuration wizard should display where the Input fields are shown.
The first field (the address number) must be left as set unused.
FIELD |
TYPE |
---|---|
FIELD 1 |
Leave blank. This will be used by Amlib to populate a system Address Number |
FIELD 2 |
Address Line 1 |
FIELD 3 |
Address Line 2 |
FIELD 4 |
Address Line 3 |
FIELD 5 |
Address Line 4 |
FIELD 6 |
Postcode |
FIELD 7 |
Postal Barcode |
FIELD 8 |
Leave blank. Not used as yet |
On the set output layout screen ensure Field 7 exists and is fixed as the AUSBAR data holder and other fields as required. Note use a right click to fix a field.
Click the clean button to check the data through QAS. At the end of the process choose the view option to display the records. The examples below are shown after the QAS processing “Clean”.
If the results are successful, they can be exported to a Windows file and updated to Amlib. Do not use the QAS commit option. This Windows file will have the data separated by $ signs to separate the data.
Export the new addresses from the Tools menu, Export option:
Filter name: Use the Records to Commit option so you will only get good records in your output file.
Fields to Export: Output Fields
Field Delimiter: Ensure this is set to Other ($)
Filename: Enter the Filename you want to save the data in.
DO NOT FORGET TO SET THE DELIMITER A $ !!!!!!!!!!!!!!!
In Borrower Details, select File, Import addresses to update Borrowers that have been changed in QAS will be added to a chosen Borrower File within Amlib.
Select a File to contain updated Borrowers.
A list of Files will display. Add a New File or select an alternative File and choose Select [F9].
Select the QAS Windows file as saved previously within QAS. A confirmation message will display. Select either Yes to continue or No to abandon the import of Addresses.
When addresses are imported the following rules apply:
Note: Matching is case-sensitive for Suburbs. Therefore your suburbs table should be in UPPER case if you expect Amlib to match it using the QAS locality field.
Amlib reports will print the Postal Barcode if:
The export address data is exported in the following format. The facility is only available in Borrower version 5.1.1.1 and beyond.
Select the address number using the respective option address number ( 1, 2 or 3 ) and the saved file to actually export the data to a ‘$’ delimited file.
FIELD |
DATA |
---|---|
BA_ADDR_NO |
Unique Amlib Address Number |
BA_ADDR1 |
Line 1 of Address |
BA_ADDR2 |
Line 2 of Address |
BA_ADDR3 |
Line 3 of Address |
BA_ADDR4 |
Line 4 of Address |
BA_PCODE |
Postcode |
BA_DPBARCODE |
Post office Address Barcode |
The 7 fields above are exported and will be returned in the import file from QAS. Field 1 (Address number) must never be changed. All the other fields will be used to replace the matching fields on the Amlib Address.
Depending on your use of addresses within Amlib, it may be found that Lines 1 through 4 may have different contents for different Address numbers. For example, Address 3 may contain the Guardian Name in Line 1 so within QAS you should use a different QAS session for each of the three address types so that Amlib data is not overridden. .
Note: where a field is blank you will get two $ signs next to each other
9479$6 Grand Enterance$Australind WA$$$6233$$
3771$Address 1$Address 2$$$9999$$
12330$8 Wakefield Cres$Australind WA$$$6233$$
751$Address 1$Address 2$$$9999$$
9483$17 George Street$Boyanup WA$$$6237$$
9485$11 Brooksy Place$Burekup WA$$$6227$$
9487$41 Millard Street$Eaton WA$$$6232$$
Import File
If the records can be viewed in Notepad. The longer number at the end is the Postal barcode. The imported File also uses the $ symbol as the delimiter.
9479$6 Grand Ent$$AUSTRALIND$WA$6233$1301012121201130210230313330313203013$
12330$8 Wakefield Cres$$AUSTRALIND$WA$6233$1301011010111201000102313002021101013$
9483$17 George St$$BOYANUP$WA$6237$1301011100100020110102300122123220313$
9485$11 Brooksy Pl$$BUREKUP$WA$6227$1301013002012010111000301313030322213$
9487$41 Millard St$$EATON$WA$6232$1301011102221021021201333220223111113$
9493$10 Wildflower Way$$LESCHENAULT$WA$6233$1301012212102100103002311122321310013$
9495$86 Hamilton Rd$$EATON$WA$6232$1301012121203010010111333210222003213$
9491$86 Hamilton Rd$$EATON$WA$6232$1301012121203010010111333210222003213$
9489$10 Wildflower Way$$LESCHENAULT$WA$6233$1301012212102100103002311122321310013$
9497$3 Hanks Way$$AUSTRALIND$WA$6233$1301011212112122100110310201300202113$
9499$PO Box A426$$AUSTRALIND$WA$6233$1301012010011021111202332113010321313$
9501$PO Box A426$$AUSTRALIND$WA$6233$1301012010011021111202332113010321313$
9503$67 Millard St$$EATON$WA$6232$1301012201212212302012331331110310313$
9505$33 Paris Rd$$AUSTRALIND$WA$6233$1301011020112030023012332113033321113$
9507$16 Travers Dr$$AUSTRALIND$WA$6233$1301012120200202112212330001113212013$
9509$1 Milligan Ave$$AUSTRALIND$WA$6233$1301012011220220120012322220310130313$