• Register
    • Login
    • Search
    • Recent
    • Tags
    • Popular

    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.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

    Excel Reports - Add a point functionality

    Wishlist
    3
    8
    3842
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • sjobbe
      sjobbe last edited by

      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....

      1 Reply Last reply Reply Quote 0
      • JoelHaggar
        JoelHaggar last edited by

        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.

        Thanks,
        Joel.

        1 Reply Last reply Reply Quote 0
        • sjobbe
          sjobbe last edited by

          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....)

          1 Reply Last reply Reply Quote 0
          • JoelHaggar
            JoelHaggar last edited by

            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.

            1 Reply Last reply Reply Quote 0
            • JoelHaggar
              JoelHaggar last edited by

              I filed a git issue here, you can follow it for updates: https://github.com/infiniteautomation/ma-core-public/issues/454

              1 Reply Last reply Reply Quote 0
              • sjobbe
                sjobbe last edited by

                Thank you

                1 Reply Last reply Reply Quote 0
                • phildunlap
                  phildunlap last edited by

                  Hi sjobbe,

                  We've closed the issue by implementing XID search in the next version of the module. Check for it from your modules page!

                  1 Reply Last reply Reply Quote 0
                  • sjobbe
                    sjobbe last edited by

                    Hello

                    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

                    What's up?

                    1 Reply Last reply Reply Quote 0
                    • First post
                      Last post