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.

Craig, I noticed on the point_details.shtm page that it would display zero when the device was polled every five seconds, but when I clicked the green refresh icon, it would display the correct floating point value. After I checked the "contiguous batches only" check box, everything worked properly. Thanks for your help!

No, I don't have a mango/overrides/lib directory. I'm looking forward to the next release.

Can you check that the modules successfully installed during the upgrade process? You can check your modules page and see if they are loaded, or you can watch the bootup logging to see if it is loading the modules. It sounds like you upgraded the core, but have no modules perhaps.

If anything has actually happened to your data, nothing in the upgrade will destroy the databases at mango/databases, and if any automatic backup was enabled from within Mango, you should have many backups in your mango/backups folder. You will probably want to restore your H2 database and MangoNoSQL database. You can restore H2 in the "H2 Database Backup Settings" on the System Settings page, and you can restore you MangoNoSQL Database on the NoSQL page, restore database tab. If your NoSQL database is performing incremental backups, be sure to select the oldest backup to begin a complete restore.

Thanks, Terry. I should have thought of that. I have a greek keyboard layout set up as an alternate keyboard because it is useful for engineering. That's where I got the mu character from. After reading your post, I copy/pasted the µ symbol from the Mango help into the unit box, and it worked!

Hi Joel,

The polling rate is 3s. I'll keep an eye out for the update

Craig

Hmmm, ok. Thanks for the fast response.
How is it then, that virtual points can be written with the publisher?
Also, we tested one more thing:

we had our modbus point A we created a virtual data point VirtA we created two 'onchange' point links, A->VirtA and VirtA->A voilá, it worked, point A could be written using the bacnet publisher! (it also worked using a metapoint and a single pointlink)

thoughts?

Hello Joel,
I have been trying to set the data source / point to update when the timestamp changes in the MySQL table. I need to use the timestamps from the reports table.

I can see that the timestamps in the watchlist matches the timestamp from the MySQL table.

However the time stamps that are listed in the spread sheet downloaded from the watchlist does not match what is displayed on the watchlist web page.

Each data point in the spread sheet has a difference of about 30 seconds.

I also then checked the history recorded in the data points details page and found that they don't match the watchlist either.

The data is first brought into Mango via an SQL data source where I have the data points using a "Time override column" that points to the data column in the originating MySQL table. I also have the data points set so that the "Logging type" is set to "When point timestamp changes"

Then we use a Meta Data Source so we can scale the SQL data points into meaningful data. I have tried simply keeping the logging interval to a set 15 minutes because that is the time the data will normally come into the database. I also had the "Update Even set to "Start of Minute". But I found that the data points had data for every minute in the history even thought the logging was set to 15 Minute Interval.

So I changed the Update Event to "Context Update" and added a new context above the script box for the timestamp.

Please let me know if I have the is set up incorrectly or if there are any other changes I need to make to get the original data timings from the MySQL table.

Thank you

Brian

Hi Pedro, You can move a data point from one data source to another as long as the data sources are correct. You just need to update the dataSourceId field in the dataSources table.

An example SQL command would be:

update dataPoints set dataSourceId = 23 where deviceName = "XYZ"

Where the data source ID you want them moved to is 23.

The full command is going to depend on how you are going to filter out your data points to move only the ones you want to move.

Running a "report on event" would be particularly useful to preserve 1-second or sub-second resolution data before the daily purge. It would greatly facilitate investigating what led up to an alarm event.

^ this was my first thought as well.

Pedro,

There wasn't anything in the help file for this, I've added it but it won't be available until the next Core release.

Hello Phildunlap,

Thanks for kindly reply.
I have disable IPv6 in webmin.
webmin capture
In MangoES system configure page eth0 IPv4 shows ip in IPv6 style.
configure ip capture

Ah! You are using the Reports module (generates emails and HTML), not the Excel Reports (generates Microsoft Excel documents). The data for those Reports is stored in three database tables,

ReportInstanes - Each run report will correspond to a row here.
ReportInstancePoints - Each run report will insert rows for all the points in its context.
ReportInstancePointData - Each point in a run report will store its data for that report here.

So the finished product isn't stored as a composed item unless you email it.

One thing the Reports module enables that is cool is copying & customizing the reportChart.ftl file to something simpler, then you can get data formatted however you like over HTTP from a URL endpoint for each finished report, such as mangoUrl/reportChart.shtm?instanceId=1

The modules' files should be in Mango/web/modules/reports

finaly i got it up and running, now i am missing values from one data point, ill gusess something went wrong while updating :(
the performance of the graphical view is better than the upgrade to 2.6.

now find out how to fix the missing value's and than renaming the folder to mango and it should work

Okay I'll play around and see if I can make something work. First step is to get the public user to access the dashboards without having to login.

Initially I thought that's what the true/false field meant on the first column of the permissions filter page. Nonetheless, I just added https://github.com/infiniteautomation/ma-core-public/issues/622 to request this enhancement.

Here are some tips on how to set up your account so you get email notifications: http://infiniteautomation.com/forum/topic/1830/welcome-to-our-new-forum

@phildunlap said:

Is there any output to the browser's console? You should be able to right click the page and select 'Inspect Element' then navigate to the console.

Great one to check - this is the error from the console:

mango-clip-ie.PNG

mango-clip-ie-console.PNG