• 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

    excell file in the reports

    User help
    2
    4
    1.9k
    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.
    • S
      sprokkie
      last edited by sprokkie

      Hi.

      Does some one know where the excell report is stored before downloading it ?
      When i make a report i have to press the arrow to open it, where is it stored before opening.

      that excell file is what i need for my other aplication

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

        It should be in Mango/web/modules/excelReports/web/report-data/

        1 Reply Last reply Reply Quote 0
        • S
          sprokkie
          last edited by sprokkie

          I dont have that directory, i am using mango 2.5.2
          I upgrades once to a newer version and the whole mango installation became really slow.
          this version is working for me.

          I scheduled with a cronjob each minute a report.
          Then i did a file search wit wincommander on recently changed files
          The report was not in the recenrly changed files.

          In the help file i found this:

          An instance can be considered a snapshot of the data at the time it was run. Instance attributes cannot be changed. Also, the data that the instance reports exists as long as the instance exists. (I.e. it survives the purging of the source data.) For this reason, it is important to purge report instances—especially large instances—when they are no longer needed since they can consume large amounts of storage.

          Now i want to know where it is stored, maybe i can acces that location to get the files i want.

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

            Ah! You are using the Reports module (generates emails and HTML), not the Excel Reports (generates Microsoft Excel documents). The data for those Reports is stored in three database tables,

            ReportInstanes - Each run report will correspond to a row here.
            ReportInstancePoints - Each run report will insert rows for all the points in its context.
            ReportInstancePointData - Each point in a run report will store its data for that report here.

            So the finished product isn't stored as a composed item unless you email it.

            One thing the Reports module enables that is cool is copying & customizing the reportChart.ftl file to something simpler, then you can get data formatted however you like over HTTP from a URL endpoint for each finished report, such as mangoUrl/reportChart.shtm?instanceId=1

            The modules' files should be in Mango/web/modules/reports

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