Reporting from OSCAR eforms is difficult as the fields are added to a single table as key value pairs. This is a tool for quickly diplaying summary statistics by connecting to the database via SSH. It can also work on the csv file exported from the eForm Export Tool.
git clone https://github.com/dermatologist/oscar-eform-export-helper.git
cd oscar-eform-export-helper/src/main/
export GOBIN=$(pwd)
go get
sudo mv main /usr/local/bin/oscar_helper
- The above is for linux. Follow similar steps for other OS.
oscar_helper -file=output.csv
OR
oscar_helper -sshhost=xxx -sshport=22 -sshuser=xxx -sshpass=xxx -dbuser=xxx -dbpass=xxx -dbname=xxx -dbhost=localhost -datefrom=YYYY-MM-DD -dateto=YYYY-MM-DD -fid=1 -include
- Work in progress