Parse Android Blood Glucose Tracker App Data To CSV

BloodGlucoseTracker.md

Parse Android Blood Glucose Tracker App Data To CSV

Settings -> Manual backup & Restore -> BACKUP TO FILE -> Drive -> My Drive -> data.json

Blood Glucose Readings

$ jq -r '.entries[] | "\(.date),\(.concentration),\(.event),\(.notes)"' data.json | awk -F"," '{printf "%.0f", ($1/1000); print ","$2","$3","$4}' | awk -F"," '{("date -d @"$1" +%F\" \"%I\":%M%p\"")|getline $1; print $1","$2","$3","$4}' > data.csv
$ sed -i '1s;^;Date/Time,Value,Event,Notes\n;' data.csv

Blood Pressure

Weight