Download Clever Student Participation, Resource Usage, and emails reports from Clever FTP.
- Python3.7
- Pipenv
- Clone this repo
$ git clone https://github.com/kippnorcal/clever_logs.git
- Install Docker
- Mac: https://docs.docker.com/docker-for-mac/install/
- Linux: https://docs.docker.com/install/linux/docker-ce/debian/
- Windows: https://docs.docker.com/docker-for-windows/install/
- Create .env file with project secrets
# Database variables
DB_TYPE=
DB_SERVER=
DB=
DB_SCHEMA=
DB_USER=
DB_PWD=
# Clever variables
CLEVER_USER=
CLEVER_PW=
# Clever FTP connection
FTP_HOST=
FTP_USER=
FTP_PW=
FTP_PORT=
# Mailer config
SENDER_EMAIL=
SENDER_PWD=
EMAIL_SERVER=
EMAIL_PORT=
RECIPIENT_EMAIL=
- Create table in database using definition file in sql folder
docker build -t clever .
docker run --rm -it clever
docker run --rm -it -v ${PWD}/:/code/ clever
- No annual rollover is required
- This script can be paused during summer break and restarted when school starts.