@jared-wiltshire , @CraigWeb

After digging in deeper and rethink the usage of the dashboard designer, I realized that it is my failure to understand correctly the intent of dashboard designer.

It is a page creation tool. The editor is a container that register a list of HTML components. It will update and keeps track of the positioning and the attribute of the elements. The page view is final output which show the layout of HTML components. Changes made via the designer canvas or the generated code will update the page view.

The editor records the order sequence of HTML components which has dragged and dropped in the canvas. The generated code provide information about the HTML components.

It will be a great helper for designing the page quickly. I think I need to spend more time to get familiar with the rich features offered by the dashboard designer.

Thank you for your attention.

Certainly! Thanks for the kind words, we do try to keep this a helpful place!

@phildunlap
Thank you for your prompt reply. It works like a breeze.

In my opinion, this is a powerful tool that open up the doors to communicate with internet of things / web content. In addition it provide flexibility to integrate your creativity into application.

"Logic will get you from A to B. Imagination will take you everywhere".

Thanks for taking a second look, reporting your experience, and the kind words!

Hence the removal of RhinoJS from the help documents. My bad I probably should of looked first.

After my attempt to shut down the MangoES and reboot it, now I see magic, It works!

It is a false alarm and thank you @CraigWeb for your fast response.

Upon investigation, I found Mango online and accessible. I updated it from 3.4.1 to 3.4.3

Hi Desmond,

Nothing in the folder structure should have changed. You should be seeking /opt/mango/overrides/properties/env.properties

Yes you can use the ES USB utility to overwrite your env.properties file with one from the drive. Have a look at the copy.properties file, with an env.properties on the USB in the base folder, and a copy.properties in the enabled scripts like

fileToCopy=env.properties targetDirectory=/opt/mango/overrides/properties

It should overwrite your old properties file. You would have to restart Mango to pick up that change.

Nicely done, good to see you're making headway

Hi Desmond,

We prefer to handle license, warranty and this sort of request through email. Please email support@infiniteautomation.com about the situation and we'll try to work with you.

Hi Jared,
Thank you for your answer.
In fact I really appreciate your development team making the MangoUI such a nice interface for application designer to build any type of dashboard to meet the business needs.
As for the adminTemplate issue, it is not critical stage in our development. Perhaps I will try out your suggestion and look forward to the coming exciting feature for MangoUI.

Hi All,
Mango is so sweet!
I've got it which run perfectly and display out in the dashboard as per my requirement.
Thank you once again for the prompt reply.

https://www.amcharts.com/kbase/vertical-or-horizontal-lines-or-fill-ranges/
https://docs.amcharts.com/3/javascriptcharts/Guide

@Desmond if you didn't already hear, we have released v3 -
https://forum.infiniteautomation.com/topic/2741/mango-automation-3-0-released

Hi Desmond,

I would not expect a login every minute, but it is weird that you say it is only when the session is active (which I'm guessing means when you are logged in?).

My first question would be if you are using the API to do anything, and perhaps the program using the API is performing a login before whatever calls it is making.

I would also think you could get information from that IP. Is it an IP you could be using? You can google 'what is my ip' to find out your internet facing IP (which that looks like, as opposed to a local network).

Hi Desmond,

Do you mean inside Mango, or for SSH?

In Mango, you can navigate to the /users.shtm page when logged in as admin and change anything other than the admin's username. To change the username of admin, either run something like this in the SQL console: UPDATE users SET username='Desmond' WHERE username='admin'; then log out and in or you can create another admin user as desired, then switch to them and either rename the admin user or remove it.

For SSH, the credentials provided have sudo privileges. There are many guides and answers around the internet for renaming Linux a user, but you could consider making a different Linux user, changing the default user's password using passwd and, if your interest is security, restricting SSH login to this possibly less privileged user (although this could prevent you from sudo access over SSH as well).

When you are using the Mango NoSQL database the data is not stored in the pointvalues table and rather in the NoSQL database. See this video for more information: The .data files are the NoSQL files where the data is stored. The number like 692.data refers to the date range within the file and the folder number it is in is the data point ID that relates to the dataPoint table. http://help.infiniteautomation.com/support/solutions/articles/14000022517-enterprise-nosql-database

Hi Desmond,

The SQL data source allows you to pull data from an SQL database table into data points, and then you could do anything with that information you could do with any other data point.

I would consider the solution in (1), but I wonder what data you are storing in the jsondata table that you would be pulling into Excel? Why would you choose to place the data there, as opposed to in data points? If you really want the raw text from the table, you could be saving that information directly into an Alphanumeric virtual point and then pulling that into Excel.

Hi Desmond,

An UnknownHostException means it could not resolve the URL. It means either the DNS is not configured or not working properly. You can resolve the problem by ensuring your gateway is resolving URLs and that you have internet access from the computer running Mango (i.e. at the command line does ping www.google.com work?)