Skip to main content
Solved

Automation: email the result xlsx file with the dynamic name


marias
Contributor
Forum|alt.badge.img+9

Hello,

I have automation which triggers a workbench and has to send result file on email in the end.

The resulted excel file has dynamic name with @DateTimeNow parameter.

How to set that automation takes the correct file? If I add fixed name, it works fine but I don’t know how to make it for dynamic name. Could anyone help, please?

Best answer by nielsgerrits

Do you send the email using an Emailer transformer in the workspace? Then use a FeatureWriter to write the file and initiate the Emailer, and use the filename from the summary feature.

View original
Did this help you find an answer to your question?

8 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • February 23, 2024

Do you send the email using an Emailer transformer in the workspace? Then use a FeatureWriter to write the file and initiate the Emailer, and use the filename from the summary feature.


marias
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • February 23, 2024

Thanks for the reply. No, I use Action in the Automation itself:

 

 


marias
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • February 23, 2024
nielsgerrits wrote:

Do you send the email using an Emailer transformer in the workspace? Then use a FeatureWriter to write the file and initiate the Emailer, and use the filename from the summary feature.

Thank you! I have adjusted my process using Emailer and set it to attach output _dataset and it works as expected. 

 


nielsgerrits
VIP
Forum|alt.badge.img+54

The path to the file is in the dataset attribute.


david_r
Celebrity
  • February 23, 2024

You can use the Automation writer to send the filename from your workspace back to the automation:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/automations/automations.htm


nielsgerrits
VIP
Forum|alt.badge.img+54

Thanks David learned something new today. I expected it to be possible but never used it myself.


marias
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • June 26, 2025
david_r wrote:

You can use the Automation writer to send the filename from your workspace back to the automation:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/automations/automations.htm

Hi, sorry, how from automation side find attributes from automation writer? I don’t see anything new using automation writer comparing with regular writer.


david_r
Celebrity
  • June 30, 2025
marias wrote:
david_r wrote:

You can use the Automation writer to send the filename from your workspace back to the automation:

https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/automations/automations.htm

Hi, sorry, how from automation side find attributes from automation writer? I don’t see anything new using automation writer comparing with regular writer.

Hopefully this article can help: https://support.safe.com/hc/en-us/articles/25407765367053-Routing-Data-Between-Workspaces-in-Automations


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings