发送多封电子邮件，其中包含Talend Open Studio中行中的数据 [英] Sending multiple emails with data from rows in Talend Open Studio

问题描述

我正在使用软件 talend 处理Enterprise应用程序体系结构的项目 我有此表:用户(ID用户，名称用户，电子邮件) 我想做的是从此表中选择数据"，然后使用Tsendemail组件向每个用户发送电子邮件
到目前为止，我可以使用 TMssinput 与数据库建立连接，并使用Tsendemail发送单个电子邮件
但我不知道如何选择Row的值并将其用作 Tsendemail 的电子邮件"

有人可以帮我吗?谢谢你

I m working of a project of Enterprise application architecture using software talend i have this table : User(Id_user, name_user, Email) what i want to do is select Data from this table and sending email to each user using Tsendemail component
i could so far make a connection to Database using TMssinput and send a single email using Tsendemail
but i dont know how to select values of Row and use them as "email" for Tsendemail

Can someone help me pls ? and thank you

推荐答案

由于tSendMail组件不是处理组件(即，它不能处理输入中的多个向量)，而是起始组件，所以最好的方法是像我们一样使用良好的tFlowToIterate 在这里.您的工作几乎像这样:

As tSendMail component is not a processing component (ie, it cannot handles more than one vector in input) but a starting component, the best way to do so is to use the good-ol' tFlowToIterate as we did here. Your job will almost look like:

tMssInput---row---->tFlowtoIterate--->Iterate---->tSendEmail

在tFlowToIterate实例内部，您将需要的所有内容从row放入globalMap.在此之前，应在row上下文中完成所有数据处理操作(例如，筛选出您不会发送邮件的用户，等等).

Inside the tFlowToIterate instance you're going to put everything you need from row into the globalMap. Every data-processing operation should be done before that, on the row context (for example, filtering out users you won't the mail to be sent, etc.).

这篇关于发送多封电子邮件，其中包含Talend Open Studio中行中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！