IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Expand all | Collapse all

Writing Excel File generated from ITX Excel Adapter to a Queue

  • 1.  Writing Excel File generated from ITX Excel Adapter to a Queue

    Posted 01/17/18 04:07 PM

    Originally posted by: carao2020


    Hi All,

    I am generating an Excel document using ITX Excel adapter. Could you please clarify whether it is mandatory to write the file to a file system before I can write the generated Excel file to a queue? If not, could you please help me the way to write generated Excel file to a queue? Basically, I am trying to generate the Excel document and converting it into BASE64ENCODE format and send to Target application using MQ

     

    Thanks in advance.


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Writing Excel File generated from ITX Excel Adapter to a Queue

    Posted 01/22/18 05:36 AM

    Originally posted by: PaulBrett


    It is mandatory to write the Excel file to the file system.  You could then use a GET() to get the exact file, wrap it in a function to encode it and then wrap that entire thing is a PUT() to put the file to a queue.

    Thank you.

    Paul

    Follow me on Twitter


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: Writing Excel File generated from ITX Excel Adapter to a Queue

    Posted 01/22/18 10:56 PM

    Originally posted by: carao2020


    Hi Paul,

     

    Thank you very much for the details. I will design to write the report to a file system and consume it as a message.


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange