| |
|
|
|
GeniusConnect
Features & Configuration options |
 |
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 and link the table 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 and store 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 on start or timer
Automatically load or store data based on timer.
- 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.
- Auto-synchronize
New auto-synchronize options.
- MS Outlook® 2003 compatible (from
version 1.0.2.0)
- 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. (Multi-user version)
- 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.
IMPORTANT: if you are using old ODBC drivers, please upgrade to
a version that supports ANSI quoted identifiers!
- No database update if Outlook® item
equal to database record.
Progress message displays number of "equal" records.
(Store only)
- ANSI quoted identifiers
New checkbox on assign table dialog to set use of ANSI
identifiers per folder.
- New birth date handling
Date value will be ignored if db value equals outlook
value. This will avoid strange Outlook behavior (e.g., adding a
birth date multiple times to the calendar).
- User-defined fields
Outlook User-defined fields can now be linked to a table
column
- New load/save handling
faster loading/saving. GeniusConnect will not load/save an
item if nothing changed.
New Features version 3.0.0.0
- 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. Please don’t use SHIFT-Delete: Shift
-Delete removes Outlook Item(s) permanently from Outlook (Item
is not transferred to "Deleted Items" Outlook Folder).
GeniusConnect is not able to detect Permanent delete!!
- 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
New Features version 3.0.0.1
- Block use of Outlook Status bar
- Block Error/Warning Message Box
New Features version 3.0.0.1SP1
- support for calendar Label column
- Basic support for Business Contact
Manager Contacts (example .ini file included)
New Features version 3.0.0.2
- 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.
New Features version 3.0.0.5
- 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)
New Features version 3.0.0.6
- 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)
New Features version 3.0.0.7
- Linked Contacts support for Journal
and Contact folders
- Keywords Outlook data type conversion
(from string array to a string value using a separator)
New Features version 3.0.0.8
- Custom SQL commands (stored procedure,
SQL Batch etc..) for Insert, Update and Delete
- Avoid scanning of slow/remote folders
(only registry setting)
- Log errors and
warnings to Windows event log
Limitations:
Attachments are not supported and can not be linked to a
database.
Exceptions on recurring appointments and tasks are not supported.
Requirements
Microsoft® Outlook® 2000/XP/2003
|
| |
|
|
| |
| |
| |