Takes CSV files exported from APS's SIS system, selects and reformats the data for Canvas, and uploads the data to a CanvasLMS system.
Both directory and upload destination are able to be modified with command line arguments (source and destination)
The files need to be encoded as UTF-8 to make sure they work!
- Find the CSV files posted to a directory by the SIS. (configurable directory)
- Import those CSV contents into the Postgresql database and crunch some datas
- Export to Canvas formatted CSV files from postgres. (Postgres creds in a database.yml)
- Zip the new CSV files (working directory stores temp CSV's)
- Post them and consume the body of the response. (destination configurable)
- Notify of failure (somehow)?
First make sure you setup your .env file with the right stuff. You'll need an API
access token for your canvas installation (go to http://canvas.aps.edu/profile/settings
and click the New Access Token button). You may need to install the ruby bundler:
$ sudo apt-get install ruby-bundler
Now install the dependencies (done locally here):
$ bundle install --path vendor/bundle
If you get errors with the JSON gem, then you may also need to install g++ and make.
Now update the shell scripts to be executable:
$ chmod +x sql_scripts/*.sh
Once those are set, to run the script:
$ bundle exec ruby sis_script.rb
- scripts assume the SIS import data will be stored in the same db that Canvas uses
- the user importing must be a superuser (so you may want a different account than Canvas uses)
- only users from schools that have subaccounts with SIS IDs in Canvas will be imported