Skip to main content
Solved

Automation: email the result xlsx file with the dynamic name

  • February 23, 2024
  • 8 replies
  • 108 views

marias
Contributor
Forum|alt.badge.img+10

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

8 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2940 replies
  • 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+10
  • Author
  • Contributor
  • 22 replies
  • February 23, 2024

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

 

 


marias
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 22 replies
  • 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.

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+60
  • 2940 replies
  • February 23, 2024

The path to the file is in the dataset attribute.


david_r
Celebrity
  • 8394 replies
  • 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+60
  • 2940 replies
  • February 23, 2024

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


marias
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • 22 replies
  • June 26, 2025

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
  • 8394 replies
  • June 30, 2025

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