• Recent
    • Tags
    • Popular
    • Register
    • Login

    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 Mango 5 Documentation Website

    Excel Reports - Add a point functionality

    Wishlist
    3
    8
    4.2k
    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.
    • sjobbeS
      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
      • JoelHaggarJ
        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
        • sjobbeS
          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
          • JoelHaggarJ
            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
            • JoelHaggarJ
              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
              • sjobbeS
                sjobbe
                last edited by

                Thank you

                1 Reply Last reply Reply Quote 0
                • phildunlapP
                  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
                  • sjobbeS
                    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