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.
Excel Report
-
I have tested the excel reporting with the Available Disk Space point with this sheet. test.xlsx Here is my results sheet Sep_8__2015_1_57_24_PM_test.xlsx
No headers and the time stamp is in milliseconds or something. How do I fix this?
-
This is Excels wonderful way of thinking it knows how you want to format your data.
To fix this in your template excel doc put a few time stamps in formatted the way that you want. To do that highlight the cells and righ click on them and select format. I think I generally use custom and something link: yyyy/mm/dd hh:mm:ss for the format.
Now when the report runs the data in the template will be overwritten but the format will be kept. This also works with other types of data if you want to round decimal places for example.
-
Wonderful and the headers? Are the meant to be missing in the report?
-
One more thing. Why is there not a rollup option 'delta' for consumption reports of a incremental point?
-
Sorry, I missed that question. My guess is that you included your header in the named range so Mango overwrote the header data.
The named range should start one row below the header.
I made a video the other day that isn't on the website yet:
I cover some tips on how to create your named ranges. -
Good question on the missing Delta rollup. I'll check in on that and see if it can be included. thanks.
-
I have just added the Delta rollup option to the module. The option from the drop down was missing, the rest of the code was already implemented.
-
How do we go about doing the upgrade?
-
Here is a link to get the module with the delta added: https://dl.dropboxusercontent.com/u/6546748/m2m2-excelReports-1.0.0.zip
-
Also note that the delta option will be displayed on the list a bit funny if you are not also upgrading your core. We'll have an updated core 2.6 release soon which will fix that.
-
Thanks for the video, had a report working in under a minute. Is there anyway to run these reports besides a set schedule or on demand? Say from a script or event detector? The use case here is a failure or unexpected data from a device, it would then email a report will all the details of that specific device.
-
Interesting idea. We don't currently have any other way to run these reports. The event detector idea would be very useful unfortunately they are not 'modularized' yet, meaning we can't add new event handlers via a module so that is out of the question. However you could get crafty with a Process event handler. Here is the basic idea:
The Excel Reports uses its extension of the REST API so you could use Curl or something else to GET the URL:
{YourMangoHost}/rest/v1/excel-reports/run/{xid-of-your-report}This would run the report just as if you were to run it from the web ui.
