Excel Reports - Add a point functionality
It is almost impossible to add points to the excel report when there are thousands of points and the dropdown list is short and hard to use. Also it seems it uses "name" field and not XID. Problem with that is that I have several with the same name (not unique).
Could you fix the "Add a point" dropdown list so that typing the XID would find the right point? Or some similar solution....
The drop down box searches the Device Name and the Data Point name which is the same as the other drop down lists throughout Mango. Could you solve this issue but using better defined Device Names or Data Point Names? I don't think it's normal use to use XID's for this purpose.
I can't get it to "search" with Device Name. If it would do that then there would not be any problem.
Only typing in the "Point Name" seems to yeld results but we have named out points as your suggestion similarly (ie. KWH or L1-A etc....)
I've tested this a bit more and it does seem that the Device Name search is not performing as it should. We'll look into this and should be something we can resolve soon. Thanks. Joel.
I filed a git issue here, you can follow it for updates: https://github.com/infiniteautomation/ma-core-public/issues/454
phildunlap last edited by
We've closed the issue by implementing XID search in the next version of the module. Check for it from your modules page!
I have upgraded our Mango today and this issue is resolved :) Thank you very much.
Today I started creating reports and noticed that it fails if some cell contains for example:
=PROPER(SLA!G9)&" Environmental Averages"
Message in the log is: Error evaluating cell 'HEL01 - Environmental Averages'!A1