radon-ble-rd200/tools/data-input-conversion

convert from google spreadsheets

shell script for generating SQL intsert statements

{ echo 'INSERT INTO radonLog (id, time, reading) VALUES ('; sed 's/|/ /g' radon-from-eye.psv |awk '{print "(\047R\047, " $2 ", " $3 "),"}'; echo ");"; }
|tee radon-from-eye.sql

convert from hand-written

use the page-converter-pro parsing script to parse the file radon-page-4.md to get various SQL insert statements