Topic:   How to send email which contains table structure in the body from webMethods
Dec 07, 2012 13:56 4 Replies 2059 Views yuva
Prev Next
Topic Replies (4)
  1. 1
    idnkx user

    yuva

    Hi All,

    I would like to send an automated email to the business user of the daily failed messages in the table structured format.

    Can anyone please help me out solution to convert xmlstring or document list which contains the list of failed messages into table structure format and i need to bring that table into body of email.

    I have tried the following below steps,

    1.created adapter to get the failed messages from database.the output will be in documentlist
    2.Then converted document list to xml string and attached in the body of pub.client.smtp

    To be user friendly i want it to present in a table format not in xml string.

    Thanks in advance
    rekha

    1
    idnkx user

    Tomas

    Hi Rekha,

    Try to use DSP's and output Templates to achieve this..Refer the below post:

    http://idnxchange.com/forum/flow-and-java-services/155-how-to-send-a-colourful-email-alert-from-webmethods.html

    Let me know if you need any further help on this.

    1
    idnkx user

    yuva

    Hi tomasidn,

    Many Thanks for your reply:)

    I want to get the data from the database and according to that i want to generate table for that.since the data getting from database we can't predict the no.of.rows/columns and can't do predefined tags with html.

    Is it possible to do with your solution if so can you tell me in brief of how to do please.

    At present i am getting in text format in the body content and attached the file.Please refer and suggest for some solution to present it in table format.

    1
    idnkx user

    Tomas

    Rekha,

    You can dynamically Build a table with n number of rows or columns using loop over document types from http://documentation.softwareag.com/webmethods/wmsuites/wMdoc/_webM_suite_65/Developer/Developer%206.5/Dynamic%20Server%20Pages%20and%20Output%20Templates%20Developer's%20Guide%206.5.pdf]DSPs or Output templates .

    [b]See example below which i used to send list of Broker clients dynamically:[/b]
















    %ifvar eventExeItem/STATUS_EVENT equals('ERROR')%
    %else%



    Please note following Broker Clients which reached treshold:




    %loop /inputXMLData/status/brokers%
    %loop clientList% %value message%
    %endloop%

    %endloop%

    %endifvar%

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect