Nhorning
commented
8 years ago Example Spreadsheet attached. Please note this process requires the CSV export plugin from issue https://github.com/desastre-ecuador/mapa.desastre.ec/issues/96
Open parewa-punit opened 8 years ago
Nhorning
commented
8 years ago Example Spreadsheet attached. Please note this process requires the CSV export plugin from issue https://github.com/desastre-ecuador/mapa.desastre.ec/issues/96
If people are using the CSV export feature, it can be a hassle to keep downloading the latest excel file every now and then.
A simple process can be used to create an excel sheet that picks up data from the CSV export URL every hour and updates the excel sheet.
This excel sheet can be given to all responding organizations and they will automatically get all the latest reports every hour.
You can follow this article to see how its done. http://www.kimgentes.com/worshiptech-web-tools-page/2010/8/19/web-connecting-csv-files-as-external-data-to-excel-spreadshe.html