Hi all,

Initially I read the answer provided by @phildunlap on the topic how to export event alarm to excel report?

I downloaded the 0_1525963325748_EventsRanges.xlsx template and used it to create an excel report template. I mapped a data point X to the named range "data". This generates the report of the events only related to that data point X.

However, I would like to generate a report for the events of all the data points. Can I please kindly request @phildunlap or anyone who can help me on this?

Thank you.

Hi All,

I am trying to get a sum of PointA for defined period where the value of PointB meets a given condition. These Point A and B are logged at the same interval.

e.g. if it was SQL Statement, I believe it would be something like below
SELECT SUM(PointA)
FROM TableName
WHERE PointB IN (1,5);

Is it possible to put a condition in the PointValueQuery object or is there any other way to achieve this?

Thanks.

AR

@joelhaggar Thanks. Will send the email.

Hi there,

We have two MangoHTS installed in our two separate sites. One of the data sources is a HTTP Image, which is used to poll images every 10 sec from the CCTV Camera connected to the same local network as MangoHTS. After polling the images for few hours, the HTTP Image poll keeps getting aborted. Then when the MangoHTS is restarted from the Administrator/Modules page, the system fails to restore connection until the unit is restarted via Putty using an SSH connection.

Can anyone please suggest what the issue could be?

Thanks,
AR

Thanks Matt for the suggestion.

Hi all,

I am trying to set up a POP3 Email as a data source. The outlook pop setting requires the Encryption method: TLS. However, but there is no encryption method selection field on the Data Source setup page. Can someone please advise how we can set up POP3 Email using an Outlook account?

Thanks.