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.

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: [image: VPhPvHU.png] [image: MUJ9b51.png]

Hi phildunlap, I use a simple USB A male to B male cable to connect my Arduino and unfortunately I am not capable of building 485 type of connection. Any type of timing settings (even above 10 s) resulted in aborted polls in Mango, while as strict polling as 500 ms or 1 s in ScadaBR or RapidSCADA or any other Modbus Master (downloaded some applications acting as Modbus Master) do not act like Mango with the same settings. Therefore, I do not know what type of timing override I might employ to make it work.

Meanwhile, you could type kW*h into the unit field. It is then displayed as kW·h. I use it all the time in the integral field since it is more useful than the default kW·s. However, if Mango considers kW/h to be an alias for kWh, that should definitely be corrected, as it could cause undetected incorrect numerical conversion issues. In fact, just today I was thinking of writing a function that used kW/s, so the possibility that someone may use kW/h is not out of the question.

I tried multiple times. At this time having squid running is not important, and I don't want to change anything manually, since that might be overridden by updates and so on. I mainly brought it forward in case y'all are interested in looking into it. I can help test out any patches you may make. Searching around it's known that squid can break program updates, so I don't expect you guys to cater to that. I'll drop this issue as, as mentioned earlier, it's not important to us.

Also I believe the behavior you're describing is a bug on our part. I will submit an issue. Thanks for bringing it to our attention! Created: https://github.com/infiniteautomation/ma-core-public/issues/600

Hi sjobbe, These functions are implemented in apache-poi, and it looks like by version 3.10-FINAL (the one we package with Mango at the moment) these are not implemented. The good news for you, however, is that that function is implemented in the current stable version, 3.13! I will make an issue for us to consider packaging that version of the apache poi library into the next Mango release, but in the meantime you can download version 3.13 from https://poi.apache.org/ and swap the Mango/lib/poi-3.10-FINAL.jar and two poi-ooxml jar files with the versions in the poi 3.13 release (such that you only have jars for one version in your lib folder). Hope this helps!

You may also want to check the 'save realtime data' is enabled or not on the data source. It is offered an an option to help with the differing logging between the publisher and the receiver and maximizing efficiency in certain sync'ing situations. I'm guessing you want it enabled.

@phildunlap I first tried the JSON Import/Export method as that is what I am familiar with using to make similar changes, but for this it just wasn't sticking. @JoelHaggar Thanks for the step by step instructions, it was extremely helpful as I don't have much experience with SQL queries. It worked like a charm, just had to add a device name filter to the update query as I didn't want to move all datapoints.

In general doing direct database actions like this are not a good idea. If you were to do direct database inserts you would at least need to reboot Mango after to get all the changes loaded into Memory. The right way to do this is through our RESTful API. The feature isn't available right now but this is something we could add for you in the near future. You can contact us at support@infiniteautomation.com for more details.

Thanks Terry, I'm tracking the issue and hoping it can be done sooner.

Ah yes, same bug. I'll make a note of that and re-open it while closing #489.

Pedro, Mango will discard values that have a timestamp larger than the 'Discard point values future dated more than' setting. I am not aware of any problems with storing/using future dated points but I haven't used that feature much.