Hello Marty,
We use SQL data sources and then Meta Sources to scale the raw data into meaningful data. To avoid Mango creating data points while communication was lost from the data logger we have Mango set to read on a timestamp change only.

On the SQL data source we have a data point just for the timestamp, the other data points use a time override column name and on the meta source we use the timestamp data point for the context update.

Of course this will only work if your logging device creates its own timestamp or your SQL database records the date and time of the data insertion into the table.

I hope this helps

Cheers

Brian

Hello Terry,
Thank you for you response. This will let me continue with the upgrade. I am sure we can work with the unique email address point. It will just need to make sure I get a separate contact address for each user and explain to the customer it is for password recovery.

Thank you for your help and I hope you all had a happy Thanksgiving.

Cheers

Brian

Hello Phil,
I just wanted to thank you. The point links worked great once I understood how to use them and the scripting. This is how I did it in case anyone else wants to know:

I have an SQL data source that needs to be read when the data comes in, not on a set interval and I need to use the data's own timestamp.

My data source uses this select statement:

SELECT * FROM staging_all where logger_id=1 and flag=0 order by date asc limit 1;

To trigger the reading of each row I set up a point link as follows:

I have a source data point that is set a a virtual sinusoidal that is going between -1 and +1 every 10 seconds.

I have a target data point set up as a modify table only point.

The point link uses the following one line script:

  if (source.value >0) return '(1)'; return '(0)';

I needed this line because the target data point was an alphanumeric data point.

My target point has this script:

  UPDATE staging_all SET flag=? WHERE logger_id=1 AND flag=0 ORDER BY date ASC LIMIT 1;

Now the data point that modifies the staging table gets a trigger (1) several times a minute and that causes my data rows to be read one at a time until they are all marked as (1).

Thank you for pointing me in the right direction.

Hello Shubham,
We run a system with many users and limit what the users can access on the menu. We also have to isolate the custom pages from one user to the other. Matt is correct, you will have to edit the Menu permissions and the Page permissions to limit what each user is able to see and do.

I will show you what we have set up. It might not be the best way to do it but it works for us. Any advice on a better way to do this would be greatly appreciated. :)

1. Create the user and give the user a unique role.
   

2. In the settings / permissions remove User from all items you do not want the average user to access. Everything else will still be accessible by the superadmin as default.
   

3. Use the Edit Menu function to remove set the appropriate permission for your user. Some items such as the Help menu we have left as User:
   

4. other items we remove the User account from the permissions such as the API Docs menu item:
   

5. Those items that are user specific such as the custom pages, we set the unique user role:
   

I hope this helps you get it set up the way you wish.

Remember to click Save in all the right places.

Cheers

Brian

Hello cwangv,
If you are just browsing the list from the drop down of the Point Properties - Unit values then you will not see some of the units available. I found that if you type the ones you need such as mm, cm kW and kWh and click save, the point will save with proper validation. %RH is not available for validation, but % is available. The drop down list is not the full list of units available.

To use non standard units, you would need to go to the Text Renderer Properties and untick "use unit symbol as suffix". Then you can enter in your desired text in the Suffix value.

Cheers
Brian

Hello,
Since our recent Excel Reports Module upgrades from 3.6.2 to 3.7.0, all of our scheduled Excel reports are not running automatically. They were working fine before the upgrades. I can run the reports manually but the CRON schedule is not working.

I have recreated the schedule from scratch on our test report but is is not running either. There is also nothing showing up in the ma.log file.

I have noticed that when I click the gear icon next to the report, I get the choices to copy, delete, run or schedule. When selecting schedule the only option there is to set the time period. I have always used the actual report template set up to set the schedule so am not sure if the CRON pattern choice was available from the schedule option of the gear icon.

I am wondering if the schedule option from the gear icon does not allow setting the CRON pattern for the schedule, has the scheduling been dropped by accident?

I am eagerly looking forward to your response.

Cheers,

Brian

Hello Terry,
Thank you very much, I just got a chance to update the modules and test the scheduling.
Working great now.

Cheers

Brian

Hello Zaaphod,
Unique roles are added in the user menu. When creating a new user we add the user name to the "Roles (permission groups)" setting. This creates a new user role in the system. We then assign that role to the read / set settings on the data points and dashboards as needed.

I hope this is what you were looking for.

Cheers

Brian

Hello all,
I hope everyone is well and safe during the pandemic.

My system is:
core 3.7.7
mangoui 3.7.8
excel reports 3.7.1
Centos 7.8
Chrome Version 88.0.4324.190

I have a problem when selecting a specific date to run the Excel reports.
Using either the Configure and run option from the gear or the Time periods selection of the report set up, the date and time selection never seems to set properly. The date / time selection automatically moves from the date calendar onto the time clock, which is as expected. But what appears to happen is that the date does not get saved after clicking OK. The time seems to get saved properly but the date ends up as some random date. The following screen shots show one such sequence:

This is actually my 3rd attempt today. note the date in the future already in the "From" selection.

I am trying to get a report from midnight of 27 Feb to midnight of the 28th.

And it save the From time as 1 Mar.

On my next attempt is was the 12th of Mar.

The date / time period does not let me click into the string and edit the portion that is wrong. I have to tab into it and type the entire string.

A fix for this would be greatly appreciated.

Cheers

Brian

Just wanted to add my two cents worth here.... searching is still broken. Searched "excel" and it only brought up 3 results going back 21 days.

While digging about, I discovered that in mango 3, the legacy data points details page still works the way we need it to for the charts on the details page.

So, which is easier:

1. Make the new Data Points Details page show the limits on the chart like the legacy page does
   or
2. Change the quick info pop up icons redirect to the legacy data points details page
   or
3. Hide the quick info icons and make my data point on the dashboard click-able and redirect to the web page for the legacy data points details page.

I think with my programming skill level it might have to be option 3 as a down and dirty fix.

Your thoughts would be appreciated.

Cheers

Brian

Hello All,
I am using the latest Mango updates.

In Mango 2 the data points details page used to show the event detector high and low limits on the chart. The following screen shot shows dashed lines at 35 and 37.

The data points details page in Mango 3 does not show those limits as shown in the following screen shot.

The Data Points Detail chart in Mango 3 auto scales and does not show the limits. This is not a problem in most cases as alarms limits are not always used.

We need to put the alarm limits on the chart if the limits are configured for the data point.

Is there somewhere I can set up this option? I cannot find anywhere in the data point configuration to enable this so I am assuming it is somewhere deeper in the software.

Thank you for your time.

Cheers

Hello all,
I am using Mango 3.7.7 with all up to date modules.

I have a user that shows up in the event log as logged in for a month. In the image you can see the user in the event list, our HTTP session timeout setting and the user settings where the user is disabled and the session limit is reduced.

The Mango service has been restarted several times and the entire Linux server has been restarted.

I can't log in as the user with a new session because it says disabled (obviously).

How do I clear the user session without deleting the user? (I may need to re-instate them later)

This is not a critical issue for us but it is disturbing my sense of order. :)

Cheers

Brian

Hello Skazemi,
I may be wrong here as I have not used the MangoGT, but if you are wanting to edit network configuration items such as using DHCP or setting a static IP address and subnet, gateways etc... you will need to do that on the Linux server which is the OS for the MangoGT.

I have used Mango 2 and Mango 3, both of which run on a Linux server and all of the network configurations are done via the Linux command line (or in our case of a hosted web server, the Plesk control panel.)

The same goes for the time zone settings. Mango takes it time from the server OS. Each individual data source can be set to different timezones but the overall system time is used by Mango as a starting point.

There are some network items that can be set in the env.properties file such as which port the Mango web page will use. Please remember to save the env.properties file in the overrides folder or it will be overwritten when Mango is updated.

@IA Staff, if I am wrong please correct and my apologies.

Cheers
Brian

Thanks guys for checking. I wasn't sure if the new core upgrade was checking the database name and version.

Cheers

Brian

Hello Support,
I am currently using Core 3.7.4 and it is running well for us. We are using Maria DB instead of MySQL and everything has been fine with the JSON statements as Maria DB is an equivalent database to MySQL. But I am a bit wary about the items in the recent core upgrades, primarily:

Version 3.7.5
Make upgrade on MySQL more robust as to abort if MySQL is not 5.7.8 or higher

and also:

Version 3.7.6
If using a MySQL database Mango will only start on versions with JSON support which is 5.7.8 and above to ensure all upgrades and installation will work properly once the correct version is used

Can you tell me if the use of our Maria DB 10.3.22 will cause our Mango service to fail because it is not strictly MySQL 5.7.8 after the upgrades?

Cheers

Brian

Hello All,
I will add my two cents here.

We are also using Mango 2.8.8 on one server still and have seen the problems that are described here. Excel reports page not populating, User page not populating, also the Alarms page does not completely load and some others.

I have not found a problem within Mango, I discovered it is a browser issue. The latest browsers will not load the pages properly. We had to revert to an older version of the browsers to administer the Mango 2.8 service. Once we did that all the pages loaded properly. In the absence of mango errors in the log I suggest you revert to an older browser version.

Cheers
Brian