Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Is there a way to use the Emailer Transformer where it gets the list of email addresses from a text file?

Basically here is the need: right now workbenches run (Using FME Desktop 2020.2 and Task Scheduler) and the email addresses are typed out within the Emailer Addressing "To" parameter.

We would like things to be more easily updated. For example, if someone is no longer on the team, or if someone is new on the team, we would like to simply update a text file and ALL of our jobs will be updated.

 

I tried reading the text file in, aggregating the addresses into one long string separated with a comma, but I wasn't sure how to assign the value to a User Parameter.

(I tried a couple things and failed)

 

Thanks in advance for your help.

@danminneyatsaf​ 

Hi @juliarozema​ ,

You can use a FeatureMerger for this. After aggregating to concatenate all of the email addresses into a single feature (comma separated), you can merge it onto the feature(s) that trigger the Emailer. In the FeautreMerger, set the requestor and supplier to the same character like "." or "x". This will merge the aggregated attribute onto the stream that is going into the Emailer.

imageIn your case, the Creator is the rest of your workspace (goes into the requestor port), and the aggregate feature from the Text file goes into the supplier port.

 

From here, you can set the email to from the attribute value containing the concatenated list of emails.

image

Hi @juliarozema​ ,

You can use a FeatureMerger for this. After aggregating to concatenate all of the email addresses into a single feature (comma separated), you can merge it onto the feature(s) that trigger the Emailer. In the FeautreMerger, set the requestor and supplier to the same character like "." or "x". This will merge the aggregated attribute onto the stream that is going into the Emailer.

imageIn your case, the Creator is the rest of your workspace (goes into the requestor port), and the aggregate feature from the Text file goes into the supplier port.

 

From here, you can set the email to from the attribute value containing the concatenated list of emails.

image

Woohoo!! Thank you @chrisatsafe​. Most excellent. This is exactly what I needed.

Have a great weekend,

Julia

Hello,
I have to activate this question again.  I have upgraded to FME 2024.1.3 and using the FeatureMerger (like shown in Chris’ screen capture use a “.” in the Requestor and Supplier) to add the email addresses from a text file is no longer working.

Is there a way to continue using the Feature Merger but with different settings?

Again, the question is:

an email address is within a text file.  How can this email address be added to every record?  Was using a FeatureMerger before upgrading to 2024.

Reply


Community Stats

30,234
Posts
114,762
Replies
37,901
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.