I have a simple workbench that read data from a table and produce a number of Excel files. Depending on the config, the output can be 2, 3 or more Excel files (via FeatureWriter). At the end, I want to send the result by email. If I use Emailer and put my attachment manually, it works perfecly, but if I want it to be more flexible, I want as many attachment as my workbench produce. Is it possible to concatenate the output dataset produced ? I tried but failed... any Idea ? No zip please!
Solved
Multiple attachment emailer
+7- Contributor
Best answer by virtualcitymatt
It's an annoying problem for sure. I have run into this one too. In the end Zipping proved to be the best solution for my particular case.
Prior to Zipping I was using multiple Email transformers each with a different number of attachments, it's fine if you only have a limited number of attachments, however, if it literally could be any number then I really don't see a way around Zipping.
Unless of course creating multiple Sheets in a workbook would be an option? This is definitely doable in FME. The Sheet can be the FeatureTypeName and all can be written to the same xlsx file
Why is zipping for you not desirable?
+35- Celebrity
- Best Answer
It's an annoying problem for sure. I have run into this one too. In the end Zipping proved to be the best solution for my particular case.
Prior to Zipping I was using multiple Email transformers each with a different number of attachments, it's fine if you only have a limited number of attachments, however, if it literally could be any number then I really don't see a way around Zipping.
Unless of course creating multiple Sheets in a workbook would be an option? This is definitely doable in FME. The Sheet can be the FeatureTypeName and all can be written to the same xlsx file
Why is zipping for you not desirable?
+7- Contributor
Exactly what I did. One workbook (Excel), with multiple Sheets. But the problem is still there. We should be able to concatenate multiple output or use a "list" of object to attach to the email. Anyway, better to find a workaround... thanks!
+35- Celebrity
francis_m wrote:
Exactly what I did. One workbook (Excel), with multiple Sheets. But the problem is still there. We should be able to concatenate multiple output or use a "list" of object to attach to the email. Anyway, better to find a workaround... thanks!
Couldn't agree with you more. Here vote on the idea I just created: https://community.safe.com/s/idea/0874Q000000j0DbQAI/detail
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.