How to import attachments rows to work in Call Logging?

Version 1

    Details

    How does the INSERT statement need to be constructed to properly insert a row for a Call Ticket attachment and have that Attachment be visible through Call Logging?


    Resolution

    The INSERT statement needs to be constructed in the following manner. If the formatting differs at all (less the path and name of the attachment, CallID, etc) then the row will insert to HEATGen but the attachment will not be visible through Call Logging.

    INSERT INTO HEATGen (GCode,GName,GType,GDetail,GDTLastMod)

    VALUES('AT','00000075','','[Info]

    NumAttachments=1

     

    [Attachments]

    Attachment1=Description|\\PATH_TO\FILE_NAME.EXT','1339683967')