Coladium

A script for collecting all the students on a course in SIDING (in all the course's sections) and placing them on a google sheets.

Credits

Thanks to @lileiva for collaborating and doing all base code for the siding side of the script.

Requirements

• Python 3.68+
• Poetry
• Google clouds api project (with google sheets)

Installing

Install pipenv.

pip install -U poetry

Install dependencies.

poetry install

Set up the environment variables.

touch .env

The .env should look like this.

SIDING_USERNAME = {siding admin username}
SIDING_PASSWORD = {siding admin password}
COURSE = {siding course name i.e IIC1103}
SHEET_ID = {google sheets id}

You should also download a credentials file from google cloud platform. For more information read the beginning of this

PLEASE MAKE SURE YOU RENAME THE FILE TO credentials.json, otherwise it won't work.

Usage

poetry run python main.py