@prepsmith/material-xlsx-transformer
v1.2.1
Published
Transform the Exam Material Data JSON to SmithSupply format XLSX file.
Downloads
5
Readme
@prepsmith/material-xlsx-transform
Transform the Exam Material Data JSON to SmithSupply format XLSX file.
Install dependencies
$ yarn install
Run demo
$ yarn demo
Dump material data from db
example:
# ssh forward postgres server port to local host
$ ssh -NL 127.0.0.1:5432:10.23.49.163:5432 [email protected] -vv
# in another terminal session to dump data
$ psql -h 127.0.0.1 -U root -P "footer=off" -P "tuples_only" ems_staging -c "select name, material_data from exams" > material_dump.txt
Generate XLSX files from dump data
example:
$ node batch.js /Users/michael/material_dump.txt