Excel Report E-Mail FTL Template

---

Good Morning,

I’m working on a template for monthly e-mail reports but the overrides folder doesn't seem to be functioning properly for this folder.

I tried 2 different ways.

I put my own ftl in “/opt/mango/overrides/web/modules/excelReports/web/ftl/myReport.ftl” but the template didn’t show up in the GUI.

I then put my own in “/opt/mango/web/modules/excelReports/web/ftl/myReport.ftl” and it showed up and works great.

I don’t want to lose mine on an update though so I went ahead and copied the default "reportEmailBody.ftl" as "myReport.ftl".
I assumed at this point the "myReport.ftl" in the overrides folder should override the one in the original folder but it still sends out the report as if the overrides folder doesn't exist.

Should the override folder path be different or a I doing something else wrong?

Thanks!

Hi Xof1986,

Nope, you're not doing it wrong! There is an outstanding issue for the HTML reports module not having its templates persist between upgrades as well, and I have added the fact that Excel also does this to this issue: https://github.com/infiniteautomation/ma-core-public/issues/929

Hi Xof1986,

I decided to knock that issue down by adding the expected overrides/web/modules/.../web/ftl to the appropriate loading path, so you will be able to use the overrides directory for this purpose in the next release of those two modules, which should be next week.

Hi.

Sorry to drag up this old topic, but I had something very similar happen to me last week and this was the most relevant topic that came up in search.

When I upgraded to 3.6.0 last week, all of my email template ftl's for my excel reports disappeared causing the reports to stop working.

What is the correct directory to store these templates in so they don't get removed between updates?

Hi fishfacs, no problem at all!

You can use

Mango/overrides/web/modules/excelReports/web/ftl/

which will persist upgrades.