@prepsmith/material-xlsx-transformer

@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 ubuntu@120.132.6.226 -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