Skip to main content
  • EN

Hello, 

Here is what I need to do: 

I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. 

But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. 

I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. 

I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. 

Looking for some ideas on what transformer(s) I would need to use before the Emailer.

You’ll need to add a reader to read the spreadsheet. Each row has an email address so when that’s passed to the Emailer it will send an email to that address. Since it reads the spreadsheet at runtime it’ll always send it to the most current list of recipients.

I managed to get it to work. I added a new Reader for a spreadsheet. It does send the emails to the recipients in the spreadsheet. But, when I delete an email address in the spreadsheet by deleting the value in the cell and not the entire row, FME still reads this as a missing/null record. What Parameter do I need to set in the Reader to ensure that if an email address in the spreadsheet is deleted FME does not still read the now empty row/cell?

In Excel if I delete the entire row (not just the value in the cell), then FME will recognize that it no longer exists which is what I would expect. But I do not want my users to have to remember to delete the row in Excel if they want to remove an email address. I want them to be able to delete the value in the cell. It is easier for them. 

Nevermind, I figured it out. I had to disable Feature Caching to test it successfully. All is good. No changes were necessary. 

Thank you for your assistance. 

 

Here is a screenshot of my workspace in case anyone needs to do something like this. THe column name in the spreadsheet with the list of email addresses is named “EmailAddress”:

 

Here is the Emailer Transformer Parameters: 

 

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.