on 07-14-2010 8:37 PM
Hi
I have a requirement in which I have to send the email to the user and all the information should be present in the email content no attachment.
I have to pick the xml file for the FTP location and then send the email to the user in the specific format which is mention below.
FTP.........................XI..........................MAIL (No Attachment)
Example
abc.xml
Output must be in this format
Original File name. Original Creation date and time Customer ID File level Ack Name File level Ack
xxxxxxx xxxxxxxxx xxxxxx xxxxx xxx
xxxxxxx xxxxxxxxx xxxxxx xxxxx xxx
xxxxxxx xxxxxxxxx xxxxxx xxxxx xxx
Creation date and time Total number of trasnsactions Status code Error Description
xxxxxxxxx xxxxxx xxxxx SYNTAX ERROR
xxxxxxxxx xxxxxx xxxxx SYNTAX ERROR
xxxxxxxxx xxxxxx xxxxx SYNTAX ERROR
Can somebody please tell me how to generate the output like that. I am concatenating all the fields but I have to do too many padding to generate the output like that which I think is not the correct way to generate the output.
Is there any way to generate the required output with UDF or any other way except concat.
Is there any way I can convert the output in Excel or Word file.
Thanks,
If it is the body of the mail.... I did it as below.
I did send all the data from all the fields from sender to a single field at the receiver in mapping using fallowing UDF
return (a + u2018\nu2019 + b);
}
OUTPUT was below:
Date : MM/DD/YYYY
Time : HH:MM:SS (GMT-Server Time)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
Could you please tell me the complete UDF
My Requirement is to generate the output in 1 or multi line along with the heading.
Original File name. Original Creation date and time Customer ID File level Ack Name File level Ack
.............. .................. ............ ...............
.............. ................... .............. ..............
Where ....... represent the values.
No Solution
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Refer this blog
/people/jyothi.anagani/blog/2010/06/17/convert-the-input-xml-to-string-in-pi-71-using-standard-graphical-mapping
or look at these snapshots.
http://www.flickr.com/photos/8764045@N06/4462432588/sizes/l/
http://www.flickr.com/photos/8764045@N06/4462432598/sizes/z/
Hope this works..
Edited by: on Sep 3, 2010 10:08 AM
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.