MS Exchange examples

How to synchronize multiple MS Exchange user accounts from one dedicated PC/Server with MS Outlook and GeniusConnect.

Two-way synchronization contact folders
In this example we want to synchronize user’s Contact folders with a CRMCustomers table. Since our CRM system can change the Contact data outside of GeniusConnect, we will setup LastModificationTime compare, to solve possible synchronization conflicts. We want to sync only records owned by the user, so we will have to specify a filter and a default value with owner data for inserts. This will be two-way synchronization.

  One-way synchronization from DB to user’s Calendar
In this example we want to synchronize users Calendar with a central CRM table named CRMCalendar. Only “Department meeting” will be pushed into user’s calendar. This will be one way synchronization from Database to user’s Calendar. 

One-way synchronization from user's Sent Items mail folder to Database
In this example we want to save all outgoing emails to an archive table named OutgoingMailArchive. This will be one-way synchronization from Outlook to Database.

Using ODBC File data source 

Using ODBC File data source.pdf
System and User DSNs are stored in the registry. File DSNs, however, are stored as a file with a .DSN file extension. A common use for a file DSN is to provide a data connection for a local application, such as GeniusConnect , Excel or Access. The advantage of using a file DSN is that you can share it easily with other users by placing it on a network share. Download the PDF and follow the steps to use a ODBC File DSN. 

Microsoft Access example 

Combine two database datetime fields
Example MS Access db and .ini template:
This example (for calendar folders)combines two table fields into one in a MS Access query. The template contains also example statements for custom insert / update / delete SQL statements. The statements are using the table behind the query, to write back to database. 

3rd party examples 

Author: b'Files®
b'Files® ist eine Datenbanklösung für FileMaker®. 

GeniuisConnect PC-News review(German)
Author: Paul Belcl
Windows Mobile specialist,
Director of Clubpocketpc Austria