unable to create excelreport
-
I'm trying to create a new hourly rollup excel report. When I copy the hourly report sample and try to save it as a new report I get "Report template file not found".
Under the "select template file" link, when I click on Sample1_2.xlsx it opens up File stores > Excel_report_templates and it's empty.
If I try to create a new excel report I can't save it because i get the same "Report template file not found" error.
How do I get the report templates back or how do I create a new excel report?
-
Hi @mseverin
You will first need to upload an excel report into the file store. This file needs to be created in excel first with at least 1 named range. Here is a tutorial to follow: https://help.infiniteautomation.com/configuring-excel-reports
-
Thanks, that helped, The report I created was uploaded and I assigned data points. When I run it, it shows up in the Finished / in-progress with the state "queued".
what does this mean?
-
My report still shows queued under the State heading and the download and view buttons are disabled. I've tried a new simple report with just Timestamp and value and it does the same thing.
I see no errors in the log file.
Any ideas?
-
Could you email the spreadsheet as well as a JSON export of the report to support@infiniteautomation.com
-
I sent the requested data a couple weeks and haven't heard anything. Is there any update on this or can someone give my a different way to extract historical data.
I'm being asked to provide daily gas and water usage for the entire 2019 year.