PZercom
2022-03-16T19:08:40Z
Hello,

we are using Firebird DB  is it possible to sync Outlook Contacts to/from Firebird ? And do you have an example?

Thank you
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2022-03-16T19:14:34Z
Hello,

Yes, it is possible, I have converted mysql example Contact table to Firebird , here the steps to install the example :

What to install
  1. Close Outlook and Download and Install GeniusConnect... 
  2. Request GeniusConnect Free Trial...  
  3. Install Firebird ODBC driver, Download... 

Create Firebird Example Database and Table

Start Firebird ISQL Tool
CREATE DATABASE 'c:\GeniusConnectDemo.fdb' page_size 8192 user 'SYSDBA' password 'YOURPassword';
CONNECT 'c:\GeniusConnectDemo.fdb' user 'SYSDBA' password 'YOURPassword';
CREATE TABLE Contacts (
  GC_ID INT NOT NULL primary key,
  GC_SENSITIVITY INT,
  GC_IMPORTANCE CHAR(1),
  GC_INITIALS VARCHAR(32),
  GC_FIRSTNAME VARCHAR(128),
  GC_MIDDLENAME VARCHAR(128),
  GC_LASTNAME VARCHAR(128),
  GC_SUFFIX VARCHAR(32),
  GC_JOBTITLE VARCHAR(64),
  GC_COMPANYNAME VARCHAR(64),
  GC_DEPARTMENT VARCHAR(64),
  GC_GENDER CHAR(1),
  GC_SELECTEDMAILINGADDRESS CHAR(1),
  GC_BUSINESS_CITY VARCHAR(64),
  GC_BUSINESS_COUNTRY VARCHAR(32),
  GC_BUSINESS_POSTALCODE VARCHAR(16),
  GC_BUSINESS_POSTOFFICEBOX VARCHAR(16),
  GC_BUSINESS_STATE VARCHAR(32),
  GC_BUSINESS_STREET VARCHAR(64),
  GC_BUSINESS_FAX VARCHAR(32),
  GC_BUSINESS_TELEPHONE VARCHAR(32),
  GC_BUSINESS_TELEPHONE2 VARCHAR(32),
  GC_EMAIL1ADDRESS VARCHAR(128),
  GC_EMAIL1ADDRESSTYPE VARCHAR(64),
  GC_EMAIL2ADDRESS VARCHAR(128),
  GC_EMAIL2ADDRESS_TYPE VARCHAR(64),
  GC_EMAIL3ADDRESS VARCHAR(128),
  GC_EMAIL3ADDRESS_TYPE VARCHAR(64),
  GC_HOME_CITY VARCHAR(64),
  GC_HOME_COUNTRY VARCHAR(32),
  GC_HOME_POSTALCODE VARCHAR(16),
  GC_HOME_POSTOFFICEBOX VARCHAR(16),
  GC_HOME_STATE VARCHAR(32),
  GC_HOME_STREET VARCHAR(64),
  GC_HOME_FAX VARCHAR(32),
  GC_HOME_TELEPHONE VARCHAR(32),
  GC_HOME_TELEPHONE2 VARCHAR(32),
  GC_OTHER_CITY VARCHAR(64),
  GC_OTHER_COUNTRY VARCHAR(32),
  GC_OTHER_POSTALCODE VARCHAR(16),
  GC_OTHER_POSTOFFICEBOX VARCHAR(16),
  GC_OTHER_STATE VARCHAR(32),
  GC_OTHER_STREET VARCHAR(64),
  GC_OTHER_FAX VARCHAR(32),
  GC_OTHER_TELEPHONE VARCHAR(32),
  GC_TITLE VARCHAR(50)
);

Config license and Firebird ODBC
  1. Start Outlook, Start GeniusConnect config and Register your license... 
  2. Configure ODBC Datasource for the example database  and name it FirebirdDemoDSN

Map the example table
  1. In GeniusConnect Config, go to Database Tab  select a Contact folder you want to use and click Assign table button.
  2. In Assign Table Dialog , Select FirebirdDemoDSN in ODBC Datasource combobox, enter your login/password and click Connect button.
  3. Select CONTACTS table in Table or View combobox.
  4. Download and extract example mapping 
  5. Click Import button in Assign Table Dialog and select the downloaded example mapping Example Firebird Outlook Contacts.ini
  6. Click OK to save the mapping


The example is installed, you can test the sync by using ribbon buttons  (Store, Load etc.) or config auto sync 

You can also map the table columns manually  , for manual (not using mapping ini file) config use
select COALESCE(max(GC_ID) + 1, 1) from CONTACTS
in Mandatory Keys Dialog  for GC_ID primary key value creation.