I have inserted/stored thousands of outlook emails nicely to the MySQL DB.
However I cannot import some emails in outlook folders as Genius Connect suddenly stops with the error message Genius Connect middle man ATL server has stopped working. The subsquent error message is then Error [The RPC server is unavailable.] (Method: RibbonClicked) HRES -2147023174. Only if restart Outlook I can resume storing all records but for the affected folders/messages the import would fail again with the described error messages. The difficulty is to find out if there are types of emails, fonts, forms etc that make the GC add-in crashing.
Question is now why we the import of the emails stops with those error messages?
GC: Private V501501 32-bit
Outlook 2013, 32-bit (on 64-bit Win8 OS)
ODBC: 5.2 Unicode driver (32-bit)
MySQL: 5.5.34 (on ubuntu 13.10.1 server)
Mapping Table:
eniusConnect settings file
# Comments are allowed on a single line only!
[Fields]
# Format: outlookfield=column,conversion
Categories=gc_Categories,
Importance=gc_Importance,
Sensitivity=gc_Sensitivity,
Subject=gc_Subject,
Unread=gc_Unread,N,Y
BCC=gc_BCC,
CC=gc_CC,
DeferredDeliveryTime=gc_DeferredDeliveryTime,
ReceivedByName=gc_ReceivedByName,
ReceivedTime=gc_ReceivedTime,
ReplyRecipientNames=gc_ReplyRecipientNames,
SenderName=gc_SenderName,
SentOn=gc_SentOn,
SentOnBehalfOfName=gc_SentOnBehalfOfName,
To=gc_To,
SenderEmailAddress=gc_SenderEmailAddress,
SenderEmailType=gc_SenderEmailType,
HTMLBody=gc_HTMLBody,
[PrimaryKeys]
# Format: column=newstatement
gc_id=select IFNULL(max(gc_id)+1, 1) from mail
[MandatoryKeys]
# Format: column=newstatement
[WhereFilter]
# Format: WHERE=statement
WHERE=
[OptionsWhereFilter]
# Format: WHEREOPTIONS=X,X 0 or 1 IgnoreForUpdate,IgnoreForDelete
WHEREOPTIONS=0,0
[FolderOptions]
# Format: OPTIONS=X,X,X. 0 or 1 values slash for advanced options in format:NOPRIVATE,NOOUTLOOKUPDATE,NODBUPDATE,,,DELOUTLOOK_ITEM,DELDB_RECORD,BLOCKDELETECONFIRM,DBTIMEOUT,BLOCKDB_DELETECONFIRM\USE_LASTMODIFICATION_TIME,CONFLICT_RESOLUTION
OPTIONS=0,0,0,,,0,0,0,30,0,0,0,0
# Format: InsertSQLCmd=statement,UpdateSQLCmd=statement,DeleteSQLCmd=statement
[InsertSQLCmd]
InsertSQLCmd=
[UpdateSQLCmd]
UpdateSQLCmd=
[DeleteSQLCmd]
DeleteSQLCmd=
# Format: DB Detection params
[DBDetectEnable]
DBDetectEnable=0
[DBDetectExecSeconds]
DBDetectExecSeconds=30
[DBDetectSQL]
DBDetectSQL=
[DBDetectUpdateSQL]
DBDetectUpdateSQL=
# Format: Primary Key storage
[PrimKeyStoreType]
PrimKeyStoreType=0
[PrimKeyFile]
PrimKeyFile=C:\Users\CKELLER\Documents\ShareFile\Outlook Files\BACK-UP INBOX.gc
[OutlookFilter]
OutlookFilter=
# Format: Disable Toolbar buttons
[DisableToolbarButtons]
DisableToolbarButtons=0,0,0,0