Hello,
Please use the creation script in C:\Program Files (x86)\Genius@WORK\GeniusConnect\Examples\mySQL\
Example MySQL Outlook.sql to create example tables
(on 64bit Outlook version the default installation path is
C:\Program Files\Genius@WORK\GeniusConnect\Examples)
OR create only these tables:
CREATE TABLE mail (
gc_AlternateRecipientAllowed VARCHAR(1) NULL,
gc_AutoForwarded VARCHAR(1) NULL,
gc_BCC LONGTEXT NULL,
gc_BillingInformation LONGTEXT NULL,
gc_Categories LONGTEXT NULL,
gc_CC LONGTEXT NULL,
gc_Companies LONGTEXT NULL,
gc_CreationTime DATETIME NULL,
gc_DeferredDeliveryTime DATETIME NULL,
gc_DeleteAfterSubmit VARCHAR(1) NULL,
gc_ExpiryTime DATETIME NULL,
gc_FlagDueBy DATETIME NULL,
gc_FlagRequest VARCHAR(100) NULL,
gc_FlagStatus INT(10) NULL,
gc_HTMLBody LONGTEXT NULL,
gc_Importance INT(10) NULL,
gc_InternetCodepage INT(10) NULL,
gc_Mileage VARCHAR(100) NULL,
gc_NoAging VARCHAR(1) NULL,
gc_OriginatorDeliveryReportRequested VARCHAR(1) NULL,
gc_ReadReceiptRequested VARCHAR(1) NULL,
gc_ReceivedByName VARCHAR(150) NULL,
gc_ReceivedOnBehalfOfName VARCHAR(150) NULL,
gc_RecipientReassignmentProhibited VARCHAR(1) NULL,
gc_RemoteStatus INT(10) NULL,
gc_ReplyRecipientNames LONGTEXT NULL,
gc_SenderEmailAddress LONGTEXT NULL,
gc_SenderEmailType VARCHAR(100) NULL,
gc_SenderName VARCHAR(150) NULL,
gc_Sensitivity INT(10) NULL,
gc_SentOn DATETIME NULL,
gc_SentOnBehalfOfName VARCHAR(150) NULL,
gc_Subject LONGTEXT NULL,
gc_To LONGTEXT NULL,
gc_Unread VARCHAR(1) NULL,
gc_ReceivedTime DATETIME NULL,
gc_id INT(10) NOT NULL,
PRIMARY KEY (gc_id)
);
CREATE TABLE mailattachment (
gc_parent_id INT(10) NOT NULL,
gc_attach_number INT(10) NOT NULL,
GC_ATTACH_FILENAME VARCHAR(100) NULL,
GC_ATTACH_LONG_FILENAME VARCHAR(100) NULL,
GC_ATTACH_METHOD INT(10) NULL,
GC_ATTACH_MIME_TAG VARCHAR(200) NULL,
GC_RENDERING_POSITION INT(10) NULL,
GC_ATTACH_CONTENT_LOCATION VARCHAR(200) NULL,
GC_ATTACH_BINARY LONGBLOB NULL,
GC_ATTACH_CONTENT_ID VARCHAR(200) NULL,
GC_ATTACH_FULL_PATH_AND_NAME LONGTEXT NULL,
PRIMARY KEY (gc_parent_id, gc_attach_number),
INDEX MailMailAttachment (gc_parent_id)
);
-Start Outlook and open the ‘GeniusConnect setup’ dialog.
-Select on the
Database property page the Outlook folder you want to sync
-Click the ‘Assign table’ button to open the ‘Assign table’ dialog.
-select your ODBC data source.
-Enter a login name and password and click the ‘Connect’ button.
-select
mail table in "Table or View" combobox
-click ‘Import’ button and select the example mapping file C:\Program Files (x86)\Genius@WORK\GeniusConnect\Examples\mySQL\
Example MySQL- Outlook Mail.ini-click "Item Attachments" Tab
-Check "Enable attachment support"
-Connect to the same database
-select
mailattachment table
-click ‘Import’ button and select the example mapping file C:\Program Files (x86)\Genius@WORK\GeniusConnect\Examples\mySQL\
Example MySQL- Outlook Mail Attachment.ini