It is possible to create custom or dummy addresses in AddressBase. These addresses are not real addresses, but for consistency users need to be able to search for these addresses. A typical example of a custom address would be No Fixed Abode with a post code of XXX XXX.
There is a Java tool available for creating custom addresses or alternatively a SQL script can be created to insert the custom addresses. Custom addresses will need re-creating after each AddressBase Epoch update, so the SQL script has the benefits of quickly and consistently re-creating the addresses rather than manually re-entering them with the Java tool.
For hosted customers please raise a new case online and reference the title of this article.
For non-hosted:
Using the Java tool to create a custom address
CustomAddress.zip is included as part of the AddressBase release.
Copy the CustomAddress.zip to a location on your server. For example: E:\CustomAddress.
Unzip the file.
To run the program on Windows simply type: CustomAddress.bat
For Linux or Solaris type: ./CustomAddress.sh
The program will insert data into the addresses schema in order to generate a custom address. Below is an example for NO FIXED ABODE with the post code XXX XXX for both Oracle and SQL Server.
Oracle
Please enter the street description.
NO FIXED ABODE
Please enter the thoroughfare. example 'unknown'
NO FIXED ABODE
Please enter the town name.
NO FIXED ABODE
Please enter the postcode
XXX XXX
What is the database type? (There are two choices: Oracle or SQLServer)
Oracle
Please enter the ORACLE_SID or dbname.
mosprod
Please enter the database host name or IP address.
my-prod-db
Please enter the database port number.
1542
Please enter the mosaic database username.
fw
Please enter the password for the mosaic database user:
SQL Server
Please enter the street description.
NO FIXED ABODE
Please enter the thoroughfare. example 'unknown'
NO FIXED ABODE
Please enter the town name.
NO FIXED ABODE
Please enter the postcode.
XXX XXX
What is the database type? (There are two choices: Oracle or SQL Server)
SQL Server
Please enter the ORACLE_SID or dbname.
addresses
Please enter the database host name or IP address.
my-prod-db
Please enter the name of the mosaic database:
mosprod
Please enter sql instance name or do not enter anything if not a named instance:
Use windows authentication? (Two choices yes or no)
no
Please enter the database port number.
1433
Please enter the mosaic database username.
fw
Please enter the password for the mosaic database user: