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 Reports point limit
-
Thanks for finding that. I will wait for the update. Currently this is just in the testing phase and hasn't been implemented so I'll leave my named ranges as is. Thank you!
-
Hi,
Checking back in. I haven't seen the excel reports update yet. Any new ETA? Hoping to use the report in production soon. -
Hi Nathan,
Sorry for the delay. It will get released at some point tomorrow. Some good news is Craig found a bug in the purge of Excel Reports, so that fix will be in there too.
-
This has been released.
-
I'm not sure if the update solved my problem or created a new one. I have the report set to past 30 days with a 30 day rollup. The email body lists the correct date, but the time stamps in the excel file are incorrect.
-
I also get a system exception when going into system settings that looks related.
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: javax.servlet.ServletException: File "/modules/excelReports/web/settings.jspf" not found
-
Hi Nathan,
Oh my. You can resolve the issue on the system settings by renaming Mango/web/modules/excelReports/web/modules/excelReports/web/settings.txt to settings.jspf
I will put a version in the store that doesn't have this issue.
Edit: fixed in store
-
So I still have a problem that when the report runs, it isn't including the correct date range. I have it scheduled to run on the first of the month and the time period is 30 days with 30 day delta rollup. The email I received this morning showed the time as Time - 2017/07/03 00:00:00 EDT to 2017/08/01 00:00:00 EDT. But the excel file has timestamps of 6/23/17 12:00AM to 7/22/17 12:00AM. Any ideas on how to fix that?
-
Hi solarnathan,
I have been looking into it and I think there may be a problem with the rollup using days. Can you try a rollup of 720 hours instead of 30 days? We're working on it.
-
I changed the rollup to 720 hours, saved it, and then ran it. It locked up the mango for couple a minutes and didn't email the report. I went to the finished reports paged and clicked the download button. I get an error the file is not found. So I changed the time period to 720 hours. Now I get a report emailed with the correct time stamps, but incorrect data. One of the data fields is a timer that counts in second and it is only showing 57,600 seconds or 16 hours far away from the 720 hours it should be. I guess my next try will be to delete this report and try making one using myNamedRange.delta for all the fields.
-
Have you set your user's timezone and the timezone of the device?
