Administrator
  •  Admin
  • Advanced Member Topic Starter
2012-01-24T23:54:00Z
GeniusConnect stores information about record primary key value in Outlook item or (from version 5.0.0.7) in a file.


Outlook item storage (default setting):
GeniusConnect will create custom fields (MAPI user-defined fields) inside Outlook items to store database record primary key value.

Pro
less maintenance/no external files
Con
Performance decrease on MS Exchange
Possible problems on MS Exchange with Outlook cached mode

File storage:
GeniusConnect will store database record primary key value in a file outside Outlook.

Pro
Better performance on MS Exchange
No problems on MS Exchange with Outlook cached mode
Con
more maintenance/external files must be included in regular backup!

How To...
Assign Table->Options->Advanced->Primary Key storage
When changed for existing folder mapping, GeniusConnect will activate conversion automatically after closing Assign Table dialog.

Convert folders to another storage:
GeniusConnect->Database->Right Click the folder->Convert Primary key storage...

Change default storage(does not change existing folder configuration, only default values for new table assignments):
GeniusConnect->Database->Right Click any folder->Primary key storage defaults...

File storage support from GeniusConnect 5.0.0.7

Screen shots:
UserPostedImage

Convert storage:
Menu:
UserPostedImage
Dialog:
UserPostedImage



Set Default Storage:
Menu:
UserPostedImage
Dialog:
UserPostedImage



Administrator
  •  Admin
  • Advanced Member Topic Starter
2015-02-26T00:16:00Z
File storage: primary key file(s) should be included in regular backup!