IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Send excel as attachment on email

    Posted 08/03/12 02:58 PM

    I am able to send xls as an attachment on email but it ended up as “AT0001.dif” attachment on email

    .dif: data interchange format

    PSUtilities.email:smtp

    contentype:application/vnd.ms-excel
    filename:localfile.xls
    encoding:base64
    charset:utf-8

    Can someone suggest how to see .xls file as an attachment


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 2.  RE: Send excel as attachment on email

    Posted 08/06/12 07:39 AM

    Could you please use pub.client:smtp service with the inputs you mentioned and let us know the result.

    Regards,
    Sasanka


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 3.  RE: Send excel as attachment on email

    Posted 08/06/12 11:38 AM

    /email/contenttype = ‘/application/vnd.ms-excel/’(for .xls), ‘/application/vnd.openxmlformats-officedocument.spreadsheetml.sheet/’(for .xlsx),


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Send excel as attachment on email

    Posted 08/07/12 07:11 PM

    I have tried providing the path name on attachments/filename and removed all other definitions on attachments and ran the service. It works. If any of the other definitions are provided. i am returning an attachement “XXX.dif”, data interchange format, which can be opened in excel.

    It all works thanks for response and can some one tell me how to set priority of importance on pub.client:smtp service.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Send excel as attachment on email

    Posted 08/07/12 07:23 PM

    In the smtp service there is input for “priority” and you can set hardcode value to High

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 6.  RE: Send excel as attachment on email

    Posted 08/07/12 07:45 PM

    For setting priority of High you need to use mime services to accomplish

    pub.mime:createMimeData
    pub.mime:addMimeHeader (set inputs under mimeHeader/X-Priority) and map priority (setValue to 1) or X‐Severity =10 etc…
    pub.mime:addBodyPart
    pub.mime:getEnvelopeStream
    pub.client:smtp (map the envStream to mimeStream)
    pub.io:closeStream

    Please review the documentation also and test the above logic:

    Also view this thread:
    [url]wmusers.com

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services