GeniusConnect 4.0.0.8SP2 BETA4 / 4.0.0.8SP1

Microsoft Outlook stores Contact data (Name, Address, E-mail, etc.) on the local computer in a file called “.pst” file. It is difficult to exchange this data with other systems or applications. Changes to an E-mail address, phone number or name in a central database will never effect Outlook Contact data stored on other workstations. GeniusConnect makes it possible to synchronize Contact data with any relational database that supports ODBC (Open database connectivity).

GeniusConnect supports loading data from the database into an Outlook contact folder or storing data from Outlook into the database. It is possible to use GeniusConnect on multiple Outlook Contact Folders and multiple databases. The user can protect his private contact data by using a different Contact Folder to store private contacts or by telling GeniusConnect to ignore Contacts that are marked as private.

Major Features:

1. GeniusConnect supports synchronization of the following Outlook / Exchange Folder types
   • Microsoft® Outlook® 2002/2003/2007
   • Calendar
   • Contact
   • Mail
   • Task
   • Journal
   • Note
   • Microsoft® Outlook® 2000
   • Contact
2. Link your own database schema
   • Select your database table or view and link the columns to outlook fields. Define data conversion (int to char, date to char etc.) and SQL statements for generation of the primary key.
3. Load 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.
4. Store 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.
5. Load all items
   • Load all database records in the outlook folder. If a 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.
6. Store all items
   • Store all outlook items from the outlook folder 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.
7. Ignore private items
   • Ignore all outlook items that are marked as private.
8. Never update Outlook® items
   • Never update outlook items that already exists in the contact folder.
9. Never update database items
   • Never update database data that already exists in the database.
10. Delete Outlook® items when an item is removed from the database
    • Delete Outlook® items that are deleted from the database.
11. Autosynchronize
    • Automatically load or store data based on schedulers.  
12. Show progress
    • Show progress dialog during loading or storing of data.
13. Link multiple folders
    • Every outlook folder can be linked to a different table(and/or database).
14. Import/ Export link setting
    • Import or export information about link (mapping) between an Outlook® field and database table field from/to a file.
15. Customizable toolbar
16. Administrator password
    • Configuration options can be protected by a password.
17. Filter Rows
    • SQL where clause can be entered for every linked table.
    • Specifies the condition for the rows returned by a query. It is possible to use dynamic parameters that will be replaced with system values during the synchronization.
18. Status bar
    • Synchronization process visible in Outlook® status bar if progress dialog not used. Process can be aborted by pressing a key.
19. Silent delete
    • Outlook® items will be deleted without confirmation dialog.
20. Message class (form description)
    • Outlook® field form description can be linked to a field. This is helpful for using custom forms.
21. ANSI quoted identifiers
    • SQL statements are generated using ANSI quoted identifiers.
    • Column/Table/View names with, for example, space characters or reserved keywords can be used.
    • Use Checkbox on assign table dialog to set use of ANSI identifiers per folder.
22. Userdefined fields
    • Outlook Userdefined fields can be linked to a table column.
23. 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.
24. Delete all Outlook Items before Load All
    • All Outlook Item(s) will be deleted before Load All action. Use this option to empty the folder before loading all items. (Private Items will not be deleted if the "Only synchronize nonprivate items" options is used).
25. Delete all Database Records before Store All
    • All records will be deleted before Store All action. Use this option to empty the database table before storing all items. (If Filter is used: the where clause will be used for the delete action).
26. Delete Database Record when Outlook Item deleted
    • Database record will be deleted immediately after Outlook Item has been deleted.
27. Support for Calendar, Mail, Task, Journal, Note
    • Not for Microsoft® Outlook® 2000
28. Log info, warnings and errors to a file
29. Html Body support
    • It is now possible to link the HTML body text, it is still possible to use the plain text body.
30. Deployment of folder links to different computers
31. Extern Scheduler
    • This option enables usage of external scheduler.
32. Set sequence and direction for auto. synchronization per folder
33. Block use of Outlook Status bar
34. Block Error/Warning Message Box
35. support for calendar Label column
36. Basic support for Business Contact Manager Contacts
37. Initial Sync
    • Associate Database records with Outlook items before first Load/Store
38. Timestamp compare
    • This option enables last modification time compare.Based on the timestamp, GeniusConnect can decide direction of the update.
39. Support for identity (autoincrement) primary keys
40. New dynamic filter parameter {OUTLOOK_USER}
    • (only Outlook 2003)
41. Dynamic parameters availible also in SQL statements for primary/mandatory keys
42. Customize Toolbar buttons behavior
43. Support for Email MessageHeaders
44. Support for Contacts field in Appointments
45. Automatic Folder Creation during Auto deployment
46. Hide progress status details
47. Support for multiple MS Exchange user Mailboxes in Outlook
    • This feature enables server based install of GeniusConnect. 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).
48. Linked Contacts support for Journal and Contact folders
49. Keywords Outlook data type conversion
50. Custom SQL commands
    • (stored procedure, SQL Batch etc..) for Insert, Update and Delete
51. Log errors and warnings to Windows event log
52. Dynamic parameters
53. Dynamic parameter inside custom SQL Commands
    • Dynamic parameter can be used inside custom SQL Commands for Insert, Update and Delete
54. Copy a folder configuration
    • Copy a folder configuration to other folders of the same type
55. New advanced option to set cache file
56. Options to Ignore where filter during updates/deletes
57. Prepare Load All optimized
58. Auto. Load selected item's
59. 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.
60. Context menu on Database tab to manipulate folders and Export/Import settings
61. GCScheduler optionsauto start/end Outlook
62. ODBC File DSN support
    • Filebased ODBC data sources can be shared among all users who have the same (network) drivers installed
63. Delete Outlook Item in Initial Sync dialog (right click)
64. Swiftpage Addon
    • support for email marketing campaigns directly from GeniusConnect. 
65. Attachments support
    • Outlook attachments can be mapped to a BLOB (binary large object) column
66. Contact pictures are also supported (as attachment)
67. Extract attachments to a folder
68. Add Exchange Mailbox to GeniusConnect profile (Exchange and MultiUser license only)
69. Convert UTC(Coordinated Universal Time) database values to local datetime
70. Database change detection
    • Use custom SQL commands/stored procedures to detect changes in table data
71. Disable Toolbar buttons
    • Disable toolbar Load/Store buttons per folder.

• Use specific Outlook start switch when using auto-start.

Requirements:

• Microsoft Outlook 2000/XP/2003.