16 Replies Latest reply: Sep 7, 2018 6:16 AM by Steve Dark RSS

    How to read an attached excel with Qlik Mailbox Imap connector

    Joaquín Lázaro

      Hello:

       

      I have to read an excel file attached to a mail in a QlikView document.

       

      I have well configurated de connector, and I'm able to read all the tables included on the conector but when I try to use the tables MessageGetAttachmentAsText (or Binary) I get the data in an unreadable format.

       

      I have been trying some differents formats on script, getting unreadable data or this error:

       

      Error: File extdata.cpp, Line 2348

      MailboxIMAPConnector_GetAttachmentAsText:

      LOAD

          *

      FROM

      [http://qlikpublisher:5555/data?connectorID=MailboxIMAPConnector&table=MessageGetAttachmentAsText&Server=MyNotesServer&SSL=False&Username=MyUser&Password=MyPwd&ignoreClientCertificateErrors=False&Folder=Inbox&MessageID=EAAAEY&AttachmentFileName=Informe+Conversiones+BING+Mecalux+mes+en+curso.xlsx&appID=&loadAccessToken=KZQMZ6OnE1]

      (qvx)

       

      Could you help me, please ?

       

      I have attached some pictures to show you that the connector is working

       

      Thank you

      Joaquín