Administrator
  •  Admin
  • Advanced Member Topic Starter
2009-01-06T13:46:00Z
mySQL Examples
-Creation script
-templates (.ini) for all folder types

http://www.geniusconnect.com/d/MySQLSamples.zip 

Sponsor
GeniusConnect documentation search (User Manual Downloads...)
WimP
2020-01-09T11:14:00Z
Hello,

how can I install mySQL example for Mail with Attachments?
Administrator
  •  Admin
  • Advanced Member Topic Starter
2020-01-09T11:14:00Z
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)
);

https://support.geniusconnect.com/Posts/t541- 
-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
Similar Topics