• BG

    Hello Jarrod,
    Thank you, I will enter it manually.

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello Mangoans,
    I am using the most up to date version of mango 3 at time of writing.

    I am trying to get an Excel report to run on a quarterly schedule. I have set up the schedule as shown in the screen shot:

    11 17 1 1 0/3 ? (these arae all selected from the drop downs, not entered manually)

    0_1553869924027_0a1efe53-d9d8-4782-a91a-29127ecdb19f-image.png

    But whenever I try to save I get a validation failed error.

    I have tried different combinations of "don't care" and "every" but they all come up with the validation error. It appears to not like the "every 3" month setting.

    Is there another way to get the report to run on the first day of every 3rd month?

    Cheers

    Brian

    posted in User help read more
  • BG

    Thanks Phil for clearing that up for me. That all makes sense now. I was wanting to capture more warnings on the Mango 3 server than I had on the Mango 2.

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello Phil,
    Thank you for your reply. The user account is set to ignore for the Send Alarm Emails level. And these are indeed coming up ad Data Point events in the table. I said they seemed like to work like system events because my admin account is not identified to get those user alarms and one of the users event detectors does not have an event handler but I am still getting the alarm emails for that one as well..

    Saying all that, you made me think of the user account settings and I had only looked at the new user. I found that my admin account has its Send Alarm Emails set to urgent. And I now understand why I was getting the data point alarms as well. On my Mango 2 set up the admin account was set to ignore.

    My follow up question now though is this:
    Will setting the Send Alarm Emails to ignore affect whether or not I get the system alarms such as Backup Failures, System Shutdown / Startup?

    Cheers

    posted in User help read more
  • BG

    Hello,
    First of all:
    Mango Core: 3.5.6
    Mango API: 3.5.2
    Mango UI: 3.5.5
    Platform: Centos 7.4.1708
    Java Version: 1.8.0_161
    Browser: Chrome 72.0.3626.121 (Official Build) (64-bit)

    I have set up a new set of data sources and data points for a user. The new data points have a few event detectors set up such as High Current and High Voltage thresholds. I have also set up the High voltage detector with an event handler so the user gets the email.

    For some reason I, as the system administrator, am getting those alarms as well even though I am not set up on the event handler. It seems that all the events are being treated as system events.

    I have tried setting the system event alarms and audit event alarms to ignore for a short while to see if this would stop the behaviour but I am still getting their alarms.

    Any Ideas how I can stop the emails coming to my inbox?

    Cheers

    Brian

    posted in User help read more
  • BG

    Hello Phil,
    I had created the Pop3 Data Source but stopped when I was about to create the data point. I checked the help file for the data points and realised there will be a problem, so I didn't go any further.

    Here is a paste of the entire body of the email:

    +--------------------------------------------------------------------------------------------------------------------------------+
    | WS0001                                                                                                                         |
    +----------+----------+------------------+--------------+-------------+------------+---------------+------------+----------------+
    | Date     | Time     | <Wind_Direction> | <Wind_Speed> | <Barometer> | <RH>       | <Temperature> | <Dewpoint> | <Sensor_Power> |
    +----------+----------+------------------+--------------+-------------+------------+---------------+------------+----------------+
    | 21/02/19 | 00:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 23:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 22:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 21:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 20:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 19:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 18:00:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 17:50:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 17:40:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 17:30:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 17:20:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    | 20/02/19 | 17:10:00 |     89.000       |      0.050   |    999.500  |     39.000 |     22.490    |      8.040 |     24.000     |
    +----------+----------+------------------+--------------+-------------+------------+---------------+------------+----------------+
    

    We discovered that the logger does not have to put all the -'s or +'s. They are used to make the email look like a spreadsheet. We can set the email to not use what it calls "Framing"

    Thank you for your help with this.

    posted in How-To read more
  • BG

    Hello Phil,
    Thank you for your reply.
    I was trying with the POP3 data source initially. I think with my level of programming experience the "quicker, dirtier" way sounds better for me. We may get other loggers that have a different format to the email data and if I use the same method fora each I will be able to support them all more effieicently

    Please expand a bit more on that method.

    Cheers

    Brian

    posted in How-To read more
  • BG

    (using the latest Mango 3 installation on a Linux server)

    Hello All,
    I am hoping someone can help me with an email data extraction. I understand that the RegEx on the data points will look for a unique sequence and extract the data from that line between the delimiters as shown in the help example. And it works great for email with a single line / data point.

    I have a logger that sends one email a day and the data is structured as shown here:

    0_1551783673904_8153b57f-b29c-481e-a9f9-61f23bd44260-image.png

    The data continues every 10 minutes. So one email contains 144 rows for each day and 7 data points for each row.

    Is there a way to extract all the data into Mango 3?

    Cheers

    Brian

    posted in How-To read more
  • BG

    Hello Jared,
    I just wanted to let you know that it worked great. Thank you for your help on this.

    Cheers
    Brian

    posted in User help read more
  • BG

    Hello Jared,
    Thank you very much for finding a solution that sticks. I will try that tonight.

    Cheers

    Brian

    posted in User help read more