Table of Contents
Author: (Enterprise Solutions Architecture & Systems Engineering)
Published: Updated: Verified Architecture

Address Book Management

FaxCore supports personal user address books, centralized global directories, and live connections to external ODBC/OLEDB corporate contact databases.

Address Book Types

  1. User Private Address Books: Managed individually by end users via the Web Client.
  2. Global / Public Address Books: Created by administrators and shared domain-wide.
  3. External Address Books: Queries live external data sources via OLEDB without duplicating records into FaxCore.

Configuring External Address Books

Navigate to Domain Management > Address Books and click +.

External Address Book Configuration

Set Visibility to Global, Address Book Type to External, and configure connection settings:

1. External CSV Delimited File

  • Connection Type: OleDb Connection
  • Connection String: 
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\addressbooks\;Extended Properties="text;HDR=Yes;FMT=Delimited";
  • Query Expression: 
    SELECT DisplayName as xDisplayName, CompanyName as xCompanyName, Fax as xAddress FROM Contacts_01.csv

2. External Microsoft Access (.mdb)

  • Connection String: 
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\externalAddressBook.mdb;
  • Query Expression: 
    SELECT ContactName as xDisplayName, Company as xCompanyName, FaxNum as xAddress FROM tblContacts

3. External Microsoft SQL Server

  • Connection String: 
    Provider=sqloledb;Data Source=SQLPROD01;Initial Catalog=CRM_DB;User Id=fxc_reader;Password=YourPassword;
  • Query Expression: 
    SELECT FullName as xDisplayName, Company as xCompanyName, FaxNumber as xAddress 
FROM dbo.vw_FaxContacts 
WHERE FullName LIKE (@filter + '%') 
ORDER BY FullName
Tip

Always click Test to verify network connectivity, followed by Read Data to ensure column mapping resolves properly.

Bulk Contact Import from CSV

To import static contact lists into FaxCore's internal database:

Navigate to Utilities > Import Contacts.

Import Contacts View

Default Contact Import Header (16 Columns)

DisplayName,FirstName,MiddleName,LastName,CompanyName,Desc,Email,Fax,Http,Ftp,File,Printer,Mobile,FaxRaw,Phone,CSID/CallerID

Upload the CSV, choose delimiter settings, and map default group permissions.