Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

  • Hi,
    I am trying to create a simple email in event handler triggered by a scheduled event that sends the current value of a data point.
    The scenario is to report a weekly reading of a water meter to a local government department via email.
    In the UI, I made a scheduled event then added an email to it in Event Handler, adding the required data point in the "Additional Context" section. The email; gets sent fine but there is never any data point value included in the email.
    Any advice on how to get this working is much appreciated.
    I'm not at all familiar with scripting if that is required.

    Thanks
    Andy


  • HI Ataz

    In my opinion, you would be better off doing an excel report as I believe you would need to do some scripting to add the additional context point into the email. I have done the exact same for a water utility company and it is great because you can be creative with the rollups. eg, send last value of each day, week or month if it a flow meter you can do the daily delta or weekly delta. The reports give you a lot more freedom. It is also then in a format that is a lot easier for the utility to copy and paste into their internal spreadsheets.


  • Hi Ataz, welcome to the forum! Sorry for the delayed reponse!

    This thread likely contains the information you're seeking about using additional context points to get more values in alarm emails.
    https://forum.infiniteautomation.com/topic/3989/send-multiple-point-value-in-alarm-text

    This thread may also contain useful information: https://forum.infiniteautomation.com/topic/4126/request-for-info-email-templates-for-data-points-notifications


  • Thanks for the replies.
    All I really need is to send a regular email (via scheduled events) which contains a single value ( a water meter reading) to the local council officer.
    A normal report will work just fine if I select a date range of "previous 1 minute" as the data point is only logged every 5 minutes. It would just be cleaner not to have to send the chart graphic with minimum, maximum, average etc etc values in the email as well (all I really want to send is the one number a site identifier). See below
    0_1556748230541_749ed242-f0f6-4975-a641-b5923ac8180c-image.png
    I'll have a crack at using the information you have provided.
    Thanks again.
    Andy


  • You can modify the FTL that generates that report. Take a peak in Mango/web/modules/reports/web/ftl and place any versions you write into Mango/overrides/web/modules/reports/web/ftl/ (may take restarting Mango if that directory is new).