Quick description of the Application:
- Set Sheet ID, Sheet name, Rows range, Directory and Filename structure in the Settings pane
- Authorize application by clicking Re-Auth
- Process records by clicking Start
- Images will be stored in downloads folder according to the structure set in Settings
Make sure you have Java 11: https://adoptopenjdk.net/
On Windows, start the application by double clicking ODKDownloader.bat or running in the command line:
java --module-path libs\win\javafx-sdk-14.0.2.1\lib\ --add-modules javafx.controls,javafx.fxml,javafx.swing -jar odk-downloader-1.0.0.jar
On Mac (Make sure you have Mac javafx libraries downloaded):
java --module-path libs/mac/javafx-sdk-14.0.2.1/lib/ --add-modules javafx.controls,javafx.fxml,javafx.swing -jar odk-downloader-1.0.0.jar
Optional, You can use Maven (example for windows):
- install libraries:
mvn install -Pwin
- package jar:
mvn package -Pwin
- run application:
mvn javafx:run -Pwin
To install Maven: http://www.baeldung.com/install-maven-on-windows-linux-mac
- Process all records available in the Google Sheet by checking
Process all records in table
- Filter records to process by unchecking
Process all records in table
and picking your filter options:- Set
Column key
andcolumn value
to filter by column value, eg:treatment = road
- Set
From date
andTo Date
to filter bymetasubmissiondate
date column
- Set
To connect to the Sheets API you need client id and secret which are saved in src/main/resources/client_secrets.json
If you wish to use new credentials you need to:
- create OAuth 2.0 client ID here: https://console.cloud.google.com/apis/credentials?project=universitatbarcelonadoctorxlai
- Update the
client_secrets.json
file - Optional: Create a new runnable JAR file if you choose to run it using a JAR
- Dr. Shawn Kefauver
- Project Principal Investigator, University of Barcelona
- Jose Armando Fernandez Gallego
- Algorithm Development, University of Barcelona
- Alexi Akl
- Software Engineer, Postlight
Copyright 2018 Shawn Carlisle Kefauver
Licensed under the General Public License version 3.0