• 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 post processing script question

    User help
    2
    7
    1.7k
    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.
    • P
      psysak
      last edited by

      Hey hey, quick question, does the post processing script have any idea what points are assigned to the specific report? For example, I'd like to assign a point to a report and then have the script work with that particular point rather than having to hard code a point into the script.

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

        Hi psysak,

        I'm not 100% sure what you mean, but the points associated with named ranges are available to the script as context points using their range names. I believe if one uses a range name that shadows something defined in JavaScript that could be an issue. So, no naming a range "var" and using a post processing script, but "VAR" is fine.

        Try out,

        for(p in CONTEXT_POINTS) {
          print(p);
        }
        

        If you print(ExcelReportUtility) you should see a method like openNamedRange(String namedRange, boolean append) which you can use to continue writing values to a range used in the report if append is true when opening the range (see methods for writing to open ranges in print output).

        1 Reply Last reply Reply Quote 0
        • P
          psysak
          last edited by

          Hi @phildunlap what I mean is something akin to Script Context points in the sense that when the post processing script runs does it know which actual points are part of that report? I think you answered my question about the CONTEXT_POINTS.

          1 Reply Last reply Reply Quote 0
          • P
            psysak
            last edited by

            One more question related to this, is the post processing script somehow aware of the time period that the report is running for? So for example my report is configured to run "Previous Month". Is there some parameter that the script can see which I could use to determine that the time range is currently Feb 1 - Feb 28?

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

              Not currently. It's a relatively new feature and may not have had every possible use considered and accounted for yet. I do like the idea, I will see about adding it.

              1 Reply Last reply Reply Quote 0
              • P
                psysak
                last edited by

                Great!

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

                  It will be possible in 3.6 via

                  //add ExcelReportVO available under 'report' variable name for post processing script
                  for(var k = 0; k < report.getTimeSeries().length; k+=1) {
                    //epoch time of time series beginning and end, for actual run
                    var startTimestamp = report.getTimeSeries()[k].getStartTimestamp();
                    var finishTimestamp = report.getTimeSeries()[k].getFinishTimestamp();
                  }
                  
                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post