[resolved] need to send the data of tLogRow to tSendMail.

[Anonymous]

Hi Team,
I have a job which reads the data from *.CSV and details are as follows,
tFileList  --> tFileInputDelemiter --> tmap --> tLogRow -->tSendMail
Here tfileList reads all CSV files and gives the data to tLogRow.
Here I am able to print tLogRow in console, but I want the data which is available in tLogRow to be sent as an email, How to do that?
Note: .CSV files are of same types

[Anonymous]

Hi,
How about saving data into output file(tfileouputdelimited) then uploading the attchement(output file) into tsendmail?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Thanks for your quick reply,
That is one option, but I want the data to be in message body.
How can we do this.
Thanks & Regards,
Rajendra Lella.

[Anonymous]

Hi,
You can use tJavaRow  to save each value to a variable then get them in tsendmail message body.
Please see my screenshots for detail.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Thanks for your reply,
please could you help us in sharing the job format..
Ex:
tFileList  --> tFileInputDelemiter --> tmap --> tLogRow -->tSendMail
Where can I fit the tFixedFlowInput in the above flow..?
Regards,
Rajendra.

[Jcs19]

Hi Sabrina,
Thanks for your reply,
please could you help us in sharing the job format..
Ex:
tFileList  --> tFileInputDelemiter --> tmap --> tLogRow -->tSendMail
Where can I fit the tFixedFlowInput in the above flow..?
Regards,
Rajendra.

I don't think that you need tFixedFlowInput
Just put tJava after tmap

[Anonymous]

design your job like below. 

tFileList  --> tFileInputDelemiter --> tmap --> tLogRow --main-->tFileOutputDelemited.
|
|
OnSubJob OK
|
tSendMail

Created Delimited file using above design then attached same file using tSendMail. 
When you processed all the files then you want to send the mail then above approach is ideal. if you want to send each file process then need to twist the job design 

[Anonymous]

Hi Umesh,
Thanks for your reply, I want the data to be displayed in e-mail message body, please could you help me in this regards?
Thanks & Regards,
Rajendra Lella.

[Anonymous]

Ok then just do the job like this. 
Created variable named with mailData string ""
then design job like below. 

tFileList  --> tFileInputDelemiter --> tmap --> tLogRow --main-->tJavaRow
|
|
OnSubJob OK
|
tSendMail

add below code in tJavaRow. 
context.MailData=context.MailData+inputrow.yourcolumn(s);
Add this variable in tSendMail body part.  Not Tested but you can try.

[Anonymous]

hi,
try simply 


but be aware that for each row a mail will be send  ....
regards
laurent