talend send multiplate attachements to multi emails TsendMail

0 votes

hi , i am new to talend . i found a way to read emails from DB and save them to excel file than send to each one of them a seperate email having 1 file as attachement , by using tFlowToIterate on the excel file i could each time send email to one adress of them . but now when i try to iterate on tFileList and extract files in each email iteration i found out that it sends multiple emails to the first email only and having 1 file each time which the first file . so the iteration values in tSendMail is not correctly passed after i added the second iteration . but  the LOG is showing that the iteration goes correctly without any confusion . the problem happens only in the tSendMail . 

please find below the screen shot having my problem .

SENARIO TO ACHIEVE :  2 email 2 diff files : i want to send 1 email to adress1 having 2 files and then 1 other email to adress2 havnig same 2 files 

.

Dec 1, 2020 in Talend by aminegac
• 560 points
447 views

Hi, @Aminegac,

Regarding your query, you can have a look at these two 

https://help.talend.com/r/DWOsiInOQ66kqlFO9d1IJw/ZpnNRHm38aGDFjuF2xEWNg

https://help.talend.com/r/wDRBNUuxk629sNcI0dNYaA/hQK6FuxAY7sFBTjXEb~ISQ

I hope this will be helpful!!!

Hello , thank you for the reply . I already checked those web sites to learn how to use the  tSendMail component but i am now doing even more advanced senarios than the shown by talend guide , because in talend guide all you can find is very basic things , they hide the complex senarios .

So my issue here is maybe with the double iteration that i am doing  that is why the tSendMail does not get the current values  but only the first value

@Aminegac

First, you try to send one iteration and check you facing the same problem or not! If not then we need to figure out what can be done next!!

hello again , as i mentioned before when i send 1 iteration only for exemple i only loop through email ; the sendMail works fine and sends emails seperately up to the number of emails it iterated on . 
here what is happening :
i successfully looped through excel file lines,i successfully looped through files "paths" in a folder, but when i loop through both at the same time it never change current value it only pass first values for both loops. 

 what did you mean by sending 1 iteration ? means i remove all iteration components and send 1 static email request to sendMail component or i use iterateFLow and make the excel file have only 1 email adress in it ? or is it possible to use iteration components but limit its itirations to 1 max and after 1 donc the iteration quit the job ? 

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Talend

+1 vote
1 answer
0 votes
2 answers
0 votes
1 answer
0 votes
1 answer

Using tHiveRow to execute multiple Hive queries in Talend

In order to execute multiple queries, you ...READ MORE

answered Apr 14, 2018 in Talend by misc.edu04
• 1,440 points
2,079 views
0 votes
1 answer

How to load a set of files into database using Talend

Using tFileList component,  you can read all the files present ...READ MORE

answered Apr 16, 2018 in Talend by code.reaper12
• 3,500 points
2,835 views
0 votes
1 answer

How to generate multiple rows from a single row in Talend?

I think using tJavaFlex, tMap and tFlowToIterate ...READ MORE

answered Apr 18, 2018 in Talend by code.reaper12
• 3,500 points
4,908 views
0 votes
1 answer
0 votes
2 answers

How to use java classes in Talend?

For many data integration requirements, the standard ...READ MORE

answered Oct 3, 2018 in Talend by daisyridley
• 160 points

edited Oct 3, 2018 by Vardhan 1,709 views
0 votes
1 answer

In Talend, how to specify multiple conditions as expression

@Palaniswamy, have a look at this discussion ...READ MORE

answered Aug 5, 2019 in Talend by Vardhan
• 13,190 points
3,495 views