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.
Unsolved Export archive file to csv
-
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.
-
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.
-
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?
-
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
-
@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?
-
I'm not sure if Samba is installed but you could probably install it if isn't.
