Configuring an address book for Microsoft CRM

Before you can use a Microsoft CRM address book, you must configure settings in FootPrints.

To configure an address book for Microsoft CRM

1. Open the address book and contact item that you want to configure:

   1. Click the Administration tab.
   2. In the Address Books section, click the address book name or click Manage to open the Address Book Administration page. Then, double-click the address book.
      The Address Book details page appears.
   3. In the left pane, click Contacts.
   4. Double-click the contact item.
2. In the left pane, click Address Book Options.
3. Select Microsoft CRM
   The Configure External Source button becomes active.
4. Click Configure External Source.
   The Microsoft CRM Configuration page appears.

5. Complete the fields:

   1. In the Server Address field, enter the name or IP address of the SQL server for this address book.
   2. In the Server Port field, enter the port number for the server.
   3. In the Database Type field, select the type of database.
   4. In the Database field, type the name and location of the default database for this address book.
   5. In the Server User ID and Server Password, enter the credentials for logging into this server.
   6. Click Connect.
      The system attempts to connect to the SQL database server. If the system is successful, the mapping section becomes active.
6. In the Table or View field, select the table or view that contains the fields for this address book.
7. Map the SQL source fields to the Footprints Address Book Fields by clicking an entry in the SQL Fields column and selecting the matching field.
   For more information, see Working with mappings.
8. Click Save.
   After you save this record, the Server User ID and Password fields become read-only.

9. To modify the Server User ID and Password, click Change Credentials.
   You can return to this page at any time to update the server credentials.

10. Publish the address book to implement your changes:

    1. In the breadcrumb trail, click the Address Book link.

    2. Click Save and Publish.

       A confirmation message appears.

    3. Click Yes.

       The Publication Succeeded message appears, showing the number of errors and warnings.

Next steps

Configuring contact items

Configuring Master Contact records

Related topics

Configuring address books

Creating address books