Integration»File Maker Pro Integration

File Maker Pro Integration

Integration

In addition to the NRG Address Validation Blackbox.fp7 database which performs the primary communication and data conversion with the address validation servers you will find ancillary databases which provide specific functionality.

NRG Address Validation.fp7 – Provides address validation services via the

The field names in this database are well-defined and easy to decipher:

Integrating with other FileMaker Databases

Included with the Address Validation Database is a sample Integration example. If you have a basic knowledge of FileMaker Development you can open this file and “dissect” it to see the type of changes required to your own solutions. Following are the steps we took to create this sample database.

  1. Created new database with generic address fields and unique id.
  2. Opened AddrInfo database and created a new field with the name/type of the field used for the unique ID in Integration database
  3. Created relationship in Integration database between UserID fields. Checked allow creation of related records.
  4. Added fields from relationship (response_* fields) to layout
  5. Created script to perform address validation. First it sets values in the related file to the value of the current record. It then goes to Related Record (show only related is checked) and invokes the external script to perform address validation.
  6. Added a button to layout and set script to the Address Validation script that was just created

As you can see, it’s very easy to integrate the Address Validation database with your existing FileMaker solution.

Faceless Interface

Once the software is registered you will no longer see the splash screen on startup. In addition you can also “lock down” the solution so that end-users cannot access the address validation layouts. First, open the NRG Address Validation Blackbox.fp7 database in single user mode (non-server). Next, select Script->Lock Solution. Enter in a special password which can be used to unlock the files if necessary. To unlock the solution, open again in single user mode and select the Unlock Solution script.