Soft82.com » Windows » Business » Database Management » GeniusConnect 5.0.0.8

View screenshots

GeniusConnect Description

Add database connectivity to Outlook or Exchange

Have you ever been frustrated by the fact that you can't see and use vital information stored in your database while working in Outlook or Exchange?

GeniusConnect turns Outlook into a more powerful information management tool through database connectivity!

-Improved efficiency while working in Outlook through immediate access to current database information.
-Easy access to contact, calendar and customer information, stored in your database.
-Create Tasks in Outlook based on events in your database.
-Ability to quickly update and back-up information.
-Offers complete flexibility by allow connectivity to any standard SQL Database.
-2 way synchronization
-Attachments synchronization

While there may be other applications, which allow limited database access or work only with a specific database structures,
GeniusConnect can be used with any of the most commonly used database systems.

GeniusConnect will synchronize Outlook data with any relational database that supports ODBC (MS Access, mySQL, MS SQL Server, Oracle etc.).
An Outlook folder (Calendar, Contacts*, Mail, Journal, Notes and Tasks) can be linked to a database table.
You can use your own table structure and define conversions for columns with data type's that are not compatible with an Outlook field.
It is possible to use GeniusConnect on multiple Outlook or Exchange folders and multiple databases.
GeniusConnect supports synchronization of the following Folder types:

Microsoft Outlook 2002/2003/2007

-Calendar
-Contact
-Mail
-Task
-Journal
-Note
-Microsoft Outlook 2000
-Contact

Technology
GeniusConnect is an Outlook Add-On and becomes an integral part of Outlook after installation.
GeniusConnect adds a new toolbar to Microsoft Outlook with buttons specific for synchronizing data and configuring GeniusConnect.

Features and configuration options

* 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

* 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.
* 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.
* 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.
* 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.
* 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.
* Ignore private items
Ignore all outlook items that are marked as private.
* Never update Outlook items
Never update outlook items that already exists in the contact folder.
* Never update database items
Never update database data that already exists in the database.
* Delete Outlook items when an item is removed from the database
Delete Outlook items that are deleted from the database.
* Auto-synchronize
Automatically load or store data based on schedulers.
* Show progress
Show progress dialog during loading or storing of data.
* Link multiple folders
Every outlook folder can be linked to a different table(and/or database).
Example:
Central database contains customer data in the customer table and supplier data in the supplier table.
Link the contact folder "customers" to the customer table and the contact folder "suppliers" to the supplier table.
* Import/ Export link setting
Import or export information about link (mapping) between an Outlook field and database table field from/to a file.
* Customizable toolbar
* Administrator password
Configuration options can be protected by a password.
* 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.
* Status bar
Synchronization process visible in Outlook status bar if progress dialog not used.
Process can be aborted by pressing a key.
* Silent delete
Outlook items will be deleted without confirmation dialog.
* Message class (form description)
Outlook field form description can be linked to a field. This is helpful for using custom forms.
* 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.
* User-defined fields
Outlook User-defined fields can be linked to a table column.
* 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.
* 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 non-private items" options is used).
* 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).
* Delete Database Record when Outlook Item deleted
Database record will be deleted immediately after Outlook Item has been deleted.
* Support for Calendar, Mail, Task, Journal, Note
Not for Microsoft Outlook 2000
* Log info, warnings and errors to a file
* Html Body support
It is now possible to link the HTML body text, it is still possible to use the plain text body.
* Deployment of folder links to different computers
* Extern Scheduler
This option enables usage of external scheduler.
* Set sequence and direction for auto. synchronization per folder
* Block use of Outlook Status bar
* Block Error/Warning Message Box
* support for calendar Label column
* Basic support for Business Contact Manager Contacts
(example .ini file included)
* Initial Sync
associate Database records with Outlook items before first Load/Store
* Timestamp compare
This option enables last modification time compare.Based on the timestamp, GeniusConnect can decide direction of the update.
* Support for identity (autoincrement) primary keys
* New dynamic filter parameter {OUTLOOK_USER}
(only Outlook 2003)
* Dynamic parameters availible also in SQL statements for primary/mandatory keys
* Customize Toolbar buttons behavior
* Support for Email MessageHeaders
(property contains transport-specific message envelope information)
* Support for Contacts field in Appointments
* Automatic Folder Creation during Auto deployment
(MultiUser only)
* Hide progress status details
* 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).
(MultiUser only)
* Linked Contacts support for Journal and Contact folders
* Keywords Outlook data type conversion
(from string array to a string value using a separator)
* Custom SQL commands
(stored procedure, SQL Batch etc..) for Insert, Update and Delete
* Log errors and warnings to Windows event log
* Dynamic parameters
* Dynamic parameter inside custom SQL Commands
Dynamic parameter can be used inside custom SQL Commands for Insert, Update and Delete
* Copy a folder configuration
Copy a folder configuration to other folders of the same type
* New advanced option to set cache file
(for slow networks/hosted exchange)
* Options to Ignore where filter during updates/deletes
* Prepare Load All optimized
* 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.
* Context menu on Database tab to manipulate folders and Export/Import settings
* GCScheduler options-auto start/end Outlook
* ODBC File DSN support
File-based ODBC data sources can be shared among all users who have the same (network) drivers installed
* Delete Outlook Item in Initial Sync dialog (right click)
* Swiftpage Add-on
support for email marketing campaigns directly from GeniusConnect.
* Attachments support
Outlook attachments can be mapped to a BLOB (binary large object) column
* Contact pictures are also supported (as attachment)
* Extract attachments to a folder
* Add Exchange Mailbox to GeniusConnect profile (Exchange and MultiUser license only)
* Convert UTC(Coordinated Universal Time) database values to local date-time
* Database change detection
Use custom SQL commands/stored procedures to detect changes in table data
* Disable Toolbar buttons
Disable toolbar Load/Store buttons per folder

Requirements:
Microsoft Outlook 2000/XP/2003/2007

GeniusConnect Limitations

Exceptions on recurring appointments and tasks are not supported

GeniusConnect Version History

GeniusConnect Download Button For Your Site

If you want to place a Download Button for GeniusConnect on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

GeniusConnect User Reviews

New Database Management Software

QueryToDoc May 21, 2012 Use QueryToDoc to export SQL Server and Oracle query results to a Word, HTML, or CSV File				DataSlave May 21, 2012 Import, Validation and Transformation of Data
Universal SQL Editor May 17, 2012 Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc.				DTM DB Stress May 16, 2012 DTM DB Stress is a utility for database and db-applications stress testing
SB Solutions May 15, 2012 BAAC offers Small Business Database SW for managing Contacts and Accounting				ActiveData For Office/SQL Edition May 14, 2012 A Windows application that leverages the power of Microsoft Office and SQL databases
MONyog MySQL Monitor May 11, 2012 MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers				MDB Viewer Plus May 10, 2012 View and edit the content of .mdb files without the need to have Microsoft Access installed
PHPRunner May 9, 2012 PHPRunner creates set of PHP pages to access and modify any MySQL database				X-SQLT May 9, 2012 A free-form, declarative, XML-based language used to describe a series of commands for data
TirePrices May 8, 2012 Click on Mfg., or Size, or Type, or Misc. Code to see 3 pricing levels				DBConvert for MS SQL & MySQL May 8, 2012 DBConvert for MS SQL & MySQL - Bi-directional db conversion tool for MS SQL and MySQL databases
GeniusConnect May 8, 2012 Add database connectivity to Outlook or Exchange				B&B Quick Quote May 3, 2012 Quick Quote displays the costs (labor or parts/products) from a selected job
phpMyAdmin May 2, 2012 phpMyAdmin is a tool written in PHP used to administrate MySQL databases				My Money May 2, 2012 My Money is a high quality personal financial software written from ground up
dotConnect for MySQL April 25, 2012 An enhanced data provider for MySQL that builds on ADO.NET technology to present a complete				DBSync for MS Access & MSSQL April 24, 2012 Bi-directional synchronization and convertion for MS Access and MS SQL Server
CDBF - DBF Viewer and Editor April 20, 2012 Easy to use, very fast and small DBF viewer and editor				DBF Manager April 19, 2012 Manage DBF files easily using this innovative tool! Free trial version available

Last 7 Days Most Downloaded Database Management Products

MySQL Workbench 171 downloads Visual database design application that can be used to efficiently design, manage				Mobile DBViewer Plus for Nokia S60 3rd E 42 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.
QI Macros 35 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more				TOAD for Oracle Freeware 33 downloads Tool for Oracle Application Developers
HotRez 24 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				phpMyAdmin 24 downloads phpMyAdmin is a tool written in PHP used to administrate MySQL databases
smart report maker (MySQL Report Generator) 17 downloads Create and manage unlimited number of MySQL Reports				ESF Database Migration Toolkit Pro 17 downloads Transfer data across various database / file systems
Full Convert Enterprise 15 downloads Full Convert is the best application to convert structure and data of databases.				Pabx Billing System and Hotel Management 14 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel

All Time Most Downloaded Database Management Products

MySQL Workbench 19,559 downloads Visual database design application that can be used to efficiently design, manage				Mobile DBViewer Plus for Nokia S60 3rd E 11,062 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.
QI Macros 722 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more				TOAD for Oracle Freeware 14,499 downloads Tool for Oracle Application Developers
HotRez 3,948 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				phpMyAdmin 9,625 downloads phpMyAdmin is a tool written in PHP used to administrate MySQL databases
smart report maker (MySQL Report Generator) 252 downloads Create and manage unlimited number of MySQL Reports				ESF Database Migration Toolkit Pro 2,563 downloads Transfer data across various database / file systems
Full Convert Enterprise 2,337 downloads Full Convert is the best application to convert structure and data of databases.				Pabx Billing System and Hotel Management 345 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel