• 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

    Unsolved Export archive file to csv

    User help
    2
    6
    2.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.
    • T
      tom_buzink
      last edited by

      Hi, is it possible to set up the MangoES to export data as a csv/excel file, ideally on a separate local drive? Ideally this would be a daily or monthly file saved to a specific location, where the site engineer can access it if required.

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

        You can use the Excel reports module to generate an Excel file on a schedule. The files are stored on the local system in /opt/mango/web/modules/excelReports/web/report-data

        You could set up a cron job to copy all these files to your location of choice.

        1 Reply Last reply Reply Quote 0
        • T
          tom_buzink
          last edited by

          Hi Joel,

          Thanks for your reply. That looks like being a potential solution for us. Is cron able to copy the files to a Windows machine? And does the Excel report allow data / time to be appended to the file name?

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

            You could set up a ftp process to push the file to a windows machine. The file names look like: Nov_13__2016_9_00_00_AM_Sync_Time_Report.xlsx

            1 Reply Last reply Reply Quote 0
            • T
              tom_buzink
              last edited by

              @JoelHaggar said in Export archive file to csv:

              You can use the Excel reports module to generate an Excel file on a schedule. The files are stored on the local system in /opt/mango/web/modules/excelReports/web/report-data
              You could set up a cron job to copy all these files to your location of choice.

              We can probably make that work. Just one question - does the Mango have Samba (installed and configured), and therefore set up a shared directory. This way we can 'pull' from Windows?

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

                I'm not sure if Samba is installed but you could probably install it if isn't.

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