There are two ways to link to a data source for an Address Book:
These two options are discussed below.
New workspaces are created by selecting the Administration | System | Workspaces link on the FootPrints Toolbar. Only the System Administrator has access to this option.
The instructions below refer specifically to linking to an ODBC Address Book when creating a new Workspace. For complete instructions on creating Workspaces, please refer to Workspaces in the chapter on System Administration.
There are two options for creating a new workspace:
In option 1 select the Create a Dynamic SQL Address Book Link and the next page that is displayed (after the other Workspace options are selected) is the ODBC Configuration page. In option 2, if you would like to link to an ODBC Address Book, the options are to select FootPrints Address Book and then convert the Address Book later (see below), or to convert the Address Book associated with the originating workspace to an ODBC Address Book (see below).
An existing FootPrints Address Book can be converted to a Dynamic SQL Address Book at any time. This is done from the Address Book Administration Address Book Type page. Under Select Address Book Type, click the radio button for Dynamic SQL Address Book Link (SQL Server, Oracle, MySQL or Access), enter your password, and click GO. The Configure Address Book Connection to Dynamic SQL Address Book (Step 1) page is displayed. For more information about configuring the Address Book, please review Setting up a Relational Database.
When converting from a FootPrints Address Book to a Dynamic SQL Address Book, the references between Issues and Address contacts may be affected. Contacts are linked to Issues based on the primary key in the Address Book. In order to ease the transition, you can map existing Address Book fields to ODBC field attributes. Although not all fields map directly to the ODBC attributes, for those that do map directly you may still search the Address Book for a particular contact and any existing Issues with contact data that matches the primary key in the new ODBC Address Book is associated with that contact.