topic Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows in Talend Studio

Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Sat, 17 Nov 2018 06:28:58 GMT

I have created a JOb Tfilelist----->tfileinputdelimited-->tJavarow

Tsendmail

1 have 2 files and in 1 file there are multiple rows and in 2nd file 1 row. System is sending 2 Mails with content as 2 and other file with 3 content , but i need to send 2 mails i.e file wise . Can you help me in achieve that .

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Sat, 17 Nov 2018 11:41:26 GMT

Hi,

The description given is slightly confusing. Could you please rephrase the description of this problem?

In between, are you trying to achieve the same logic what you have asked in your other post in a different way? If yes, I have added one logic in your other post and I am adding the link here.

https://community.talend.com/t5/Design-and-Development/Fetch-data-using-Iterate-and-send-logs-by-mail/m-p/139533#M86300

Warm Regards,

Nikhil Thampi

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Sat, 17 Nov 2018 12:26:07 GMT

Nikhil its different ....There are 2 files in Folder having below content .....

file A

row 1 -- (A,VIJAY,dahiya.vijay@gmai.com).

row2 -- (A,DAHIYA,dahiya.vijay@gmai.com)

File B.

row 1 -- (B,VD,vd@yahoo.com)

now i need to send content of above 2 files in mail body . 1st Mail will have FILE A content and 2nd Mail will be have File 2 Content .

I tried by system is sending all the 3 content in single mail it is not sending file by file .

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Mon, 19 Nov 2018 05:51:50 GMT

Hi,

For each iteration, you can read the content of a file to a variable (for example String) and use that String variable to deliver the content in tsendmail component.

Below link can help you to understand how to read the entire file and capture it to a string variable. But please have an eye on the upper threshold limit of String variable.

https://howtodoinjava.com/java/io/java-read-file-to-string-examples/

I hope the idea has helped to find way ahead for your query. Could you please mark the topic as resolved if the answer has helped you. Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Mon, 19 Nov 2018 07:51:36 GMT

Nikhil it is too big way to do that , is it not possible i read 1 file at a time and send

@nthampi wrote:

Hi,

For each iteration, you can read the content of a file to a variable (for example String) and use that String variable to deliver the content in tsendmail component.

Below link can help you to understand how to read the entire file and capture it to a string variable. But please have an eye on the upper threshold limit of String variable.

https://howtodoinjava.com/java/io/java-read-file-to-string-examples/

I hope the idea has helped to find way ahead for your query. Could you please mark the topic as resolved if the answer has helped you. Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

those content by mail and delete that file and again read next file .

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Mon, 19 Nov 2018 09:17:41 GMT

Hi,

Could you please share the job you have created and the error you are getting?

Warm Regards,

Nikhil Thampi

Re: Tfileinput Fetch file 1 by 1 and send mail multiple rows

Anonymous — Mon, 19 Nov 2018 10:06:54 GMT

PFA the screen shot below first Records are getting generated and 2 File are getting created and then next job they are getting send . Is it possible to do below :

Fetch Records ( multiple records ) based on email id ---> send mail-->delete file (continue same for other customers )

Currently i am fetching records -->sending to file and multiple file are getting created based on mail id --> sending those to customer .