Features and Requirements
- Supported folder types
Microsoft® Outlook® 2002 2003 2007 2010 2013 2016 2019 2021
-Calendar
-Contact
-Mail
-Task
-Journal
-Note
Microsoft® Outlook® 2000
-Contact - Link any database schema
Select database table or view and link the columns to outlook fields. Define data conversions (int to char, date to char etc.). - Load / Import selected item(s)
Load database data for selected outlook item(s) into the outlook folder and update the outlook item(s) data. The selected outlook item(s) will be updated only if a database record already exists. - Load / Import all items
Load all database records in the outlook folder. If an outlook item already exists, the data will be updated. If the outlook item doesn’t exist, a new outlook item will be inserted into the outlook folder. - Store / Export selected item(s)
Store selected outlook item(s) data in the database. If a database record already exists, the data will be updated. If a database record doesn’t exist, a new record will be inserted. - Store / Export all items
Store all outlook folder items in the database. If a database record already exists, the data will be updated. If a database record doesn’t exist, a new record will be inserted. - Auto-synchronize
Auto Synchronize on timers
Set order and direction per Outlook folder, optionally auto start/stop Outlook
Auto Save on Outlook Item change
Save Outlook Item(s) to database immediately after a change has been made. New Items will be automatically inserted.
Database change detection
Use custom SQL commands/stored procedures to detect changes in table data. - Timestamp compare
This option enables last modification time compare. Based on the timestamp, GeniusConnect can decide direction of the update. - Filters
Ignore private items
Ignore all outlook items that are marked as private.
SQL Filter
SQL where clause can be entered for every linked table.
Specifies the condition for the rows returned by a query. - User-defined fields
Outlook User-defined fields can be linked to a table column. - Deleting
Delete all Outlook Items before Load All
Use this option to empty the folder before loading all items.
Delete all Database Records before Store All
Use this option to empty the table before storing all items.
Delete Outlook items when an item is removed from the database
Delete Outlook items that are deleted from the database.
Delete Database Record when Outlook Item deleted
Table record will be deleted immediately after Outlook Item has been deleted. - Link multiple folders
Every outlook folder can be linked to a different table. - Import/ Export link setting
Import or export foleder mapping configuration. - Administrator password
Configuration options can be protected by a password. - Log info, warnings and errors to a file or event log
- Html Body support
Link the HTML body text to a table column, it is still possible to use the plain text body. - External Scheduler
This option enables usage of external scheduler. - Basic support for Business Contact Manager Contacts
(example .ini file included) - Initial Sync
associate Database records with Outlook items before first Load/Store - Support for identity (auto-increment) primary keys
- Automatic Folder Creation during Auto deployment
(MultiUser only) - support for multiple Exchange user Mailboxes in Outlook
It is possible to sync multiple MS Exchange user accounts from one Outlook installation. Changes made by the users from their PC's are automatically saved to the database (Auto Save option).MultiUser only. - Custom SQL commands
overrule auto generated SQL commands for Insert, Update and Delete (custom stored procedures, SQL Batch etc..) . Custom SQL commands for Start-End sync... - Dynamic parameter
Dynamic parameter(s) can be used in SQL filter or in custom SQL Commands for Insert, Update and Delete - Auto. Load selected item's
- Follow Outlook offline mode
The actions will be recorded and executed immediately after you switch back to online state. Scheduled synchronization and auto load are blocked in offline mode. - ODBC File DSN support
File-based ODBC data sources can be shared among all users who have the same (network) drivers installed. - Support for mail date fields
Received date, SentOn date etc. in both directions-Export / Import - Attachments support
Outlook attachments can be mapped to a BLOB (binary large object) column or extracted to a folder. - Contact pictures support (as attachment)
- Convert UTC(Coordinated Universal Time) database values to local date-time
Limitations
Exceptions on recurring appointments and tasks are not supported.
Requirements
Microsoft® Outlook® 2000 2002 2003 2007 2010 2013 2016 2019 2021