• 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

    How to change extreme values in the history database

    User help
    2
    9
    2.1k
    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.
    • A
      alexcclarke
      last edited by

      Hi Everyone,

      I have some unwanted extreme values in some of my points history databases. Do any of you know what the best way would be to go about changing a value in the history with a specific ts?

      Regards,
      Alex

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

        Hey Alex,

        You can download a Excel file on either the Watch List or the Point Details page. There is a column that you can mark the value to be deleted. So you could write a formula to populate this column or mark it manually. You then import the file on the Data Import page and the document will be processed. See the help popup on the Data Import module for more information.

        Joel.

        1 Reply Last reply Reply Quote 0
        • A
          alexcclarke
          last edited by

          Hey Joel,

          You see I face a slight challenge here. I'm using the DGBox with Mango... so when you say down load the excel file - I can go to the points History and download the data, when i open the file there is no column to delete any value? not sure if this is what you mean. I have the Data Import page but not help popup :(

          any other explanation that might clear things up for me would be great.

          Alex...

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

            Hi Alex,

            The DGBox uses a derivative of Mango so doesn't have all the same features. You'll need to contact DGLogik for DGBox related support.

            Thanks,
            Joel.

            1 Reply Last reply Reply Quote 0
            • A
              alexcclarke
              last edited by

              FYI

              The format is the same as for normal Mango

              Time,XID
              yyyy/mm/dd hh/mm/ss,value

              have not figured out how to delete a value though...

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

                I don't think the DGBox has this feature.

                1 Reply Last reply Reply Quote 0
                • A
                  alexcclarke
                  last edited by

                  You mean the delete feature? - does not seem like it.

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

                    Right.

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