Step 8 - Create Task to Build Address Lookups

Now we need to build the Address Lookup tables. To do this you will need to add a Task entry. In the tree, right click on the Build from NLPG Job you have just created and select New Task.

Select the Stored Procedure type and click OK.

Name

Enter a name for the task e.g. Build NLPG.

Connection Details

Select the Postgres NLPG database from the list. Then select the Workflow radio button as this will limit the list of available Functions and then select the at_wkf_build_from_nlpg entry from the list (from v6.0.0 this is called wkf_build_from_nlpg under the -Workflow- Function filter).

Run the Task to Build the Address Lookups

Now we need to run the task to build the Address Lookups to test that it works correctly.

Right click on the Task and select Run Build NLPG [or whatever you called the task]. Depending upon the size of your NLPG database this may take a little while.