FCGeoCodingService Installation

Database Setup

1. In each SQL script you will need to change the “USE [FieldConnect]” line at the top of the script to match the name of the database the scripts are to be run against. For example, if you are going to be using the “FieldConnectVPQA” database; then you would change the first line to “USE [FieldConnectVPQA]”.
2. Run the following scripts in the order given:
   1. sql
      1. This script creates the location and address tables, along with creating geo coding values in the [Settings] table.
   2. sql
      1. This script creates all of the stored procedures used by the geo coding service
   3. sql
      1. This script creates a new API access key for the client and stores it in the [Settings] table.
      2. The newly created key will be displayed in the message window of SQL Server Management Studio after its creation.

FCGeoCodingService Web Application Setup

The following steps are given under the assumption that the normal software release procedures have been done.

1. Using IIS Manager
   1. Add a new application named “FCGeoCodingService” in the desired ERP folder
   2. Copy the files and folders from the FCGeoCodingService release folder into the newly created web folder
   3. Right-click on the newly created FCGeoCodingService web folder and create add a virtual directory
      1. In the “alias” field