Hello,
the images/attachments etc.. in RTF/HTML Text are always stored in Outlook as attachments.
You have to map also the attachments! Please see Item Attachments Tab on Assign table dialog.
You will need a child table (1-n relation with your main table) to store the attachments.
Please see Example MS SQL Server script for Attachment table:
(Replace the example table prim.key with datatype of main table prim.key)
CREATE TABLE [MyAttachment](
[replace this: gc_parent_guid] [uniqueidentifier] NOT NULL,
[gc_attach_number] [int] NOT NULL,
[GC_ATTACH_FILENAME] [varchar](100) NULL,
[GC_ATTACH_LONG_FILENAME] [varchar](100) NULL,
[GC_ATTACH_METHOD] [int] NULL,
[GC_ATTACH_MIME_TAG] [varchar](200) NULL,
[GC_RENDERING_POSITION] [int] NULL,
[GC_ATTACH_CONTENT_LOCATION] [varchar](200) NULL,
[GC_ATTACH_BINARY] [image] NULL,
[GC_ATTACH_CONTENT_ID] [varchar](200) NULL,
[GC_ATTACH_FULL_PATH_AND_NAME] [varchar](400) NULL,
[GC_ATTACH_DISPLAYNAME] [varchar](100) NULL,
[GC_ATTACH_HIDDEN] [tinyint] NULL,
[GC_ATTACH_IS_CONTACT_PICTURE] [tinyint] NULL,
CONSTRAINT [PK_MyAttachment] PRIMARY KEY CLUSTERED
(
[replace this: gc_parent_guid] ASC,
[gc_attach_number] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Example mapping template (you can save this to a .ini file and import it->Import button):
# GeniusConnect settings file
# Comments are allowed on a single line only!
[Attachments_Fields]
# Format: outlookfield=column,conversion
Attachment number=gc_attach_number,
Attachment filename=GC_ATTACH_FILENAME,
Attachment long filename=GC_ATTACH_LONG_FILENAME,
Attachment full path and filename=GC_ATTACH_FULL_PATH_AND_NAME,
Attachment method=GC_ATTACH_METHOD,
Attachment mime tag=GC_ATTACH_MIME_TAG,
Attachment rendering position=GC_RENDERING_POSITION,
Attachment content id=GC_ATTACH_CONTENT_ID,
Attachment content location=GC_ATTACH_CONTENT_LOCATION,
Attachment binary=GC_ATTACH_BINARY,
[Attachments_PrimaryKeys]
# Format: column=newstatement
gc_parent_id=[ParentColumn]gc_id [replace this]
[Attachments_MandatoryKeys]
# Format: column=newstatement
[Attachments_WhereFilter]
# Format: WHERE=statement
Attachments_WHERE=
[Attachments_OptionsWhereFilter]
# Format: WHEREOPTIONS=X,X 0 or 1 IgnoreForUpdate,IgnoreForDelete
Attachments_WHEREOPTIONS=0,0
[Attachments_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
Attachments_OPTIONS=
# Format: InsertSQLCmd=statement,UpdateSQLCmd=statement,DeleteSQLCmd=statement
[Attachments_InsertSQLCmd]
Attachments_InsertSQLCmd=
[Attachments_UpdateSQLCmd]
Attachments_UpdateSQLCmd=
[Attachments_DeleteSQLCmd]
Attachments_DeleteSQLCmd=
# Format: Attachment extraction
[Attachments_AttachmentExtractionEnabled]
Attachments_AttachmentExtractionEnabled=0
[Attachments_AttachmentExtractionPath]
Attachments_AttachmentExtractionPath=