teachable-school-manager 1.5.6

Manage your Teachable school using the unofficial Teachable API

Teachable School Manager

A complete suite to (automatically) manage your Teachable school like a pro.

Note

This project was forked from maxbritto's project which was itself forked from buzkall's project (thanks guys!) because of major refactoring and added features which changes the goal of the original project. Pull requests are accepted if you want to add new features/apis.

Disclaimer

This project is unofficial and not supported by Teachable. It is published and made open source in order to help other teachers but it comes with no warranty whatsoever from the author or any contributor.

Teachable.com doesn't have an official API to manage your school. It has some webhooks to trigger events and use them with services like Zapier, but there is no fast and practical solution to manage your school, especially for large student groups. The website is done using Angular, and needs some api urls to load the content, so this project uses those api to collect data and perform actions as if you were using the web admin panel.

This mean that if Teachable changes their APIs, scripts from this project could stop working and potentially do damage to your school data. At any time. Please take that into consideration before using this project and don't come to me to ask for repairs afterwards ;)

Install and Config

Install as standalone python package

This script has been tested with python 3.9

In case you wanted just the python package you can find it on PyPi, that's how to install:

pip install teachable-school-manager 

After that you should copy the file that you find in /usr/local/etc/teachable/config_example.ini, rename it as config.ini and set your username, password and your teachable custom domain

[DEFAULT]
username=YOUR_TEACHABLE_USERNAME
password=YOUR_TEACHABLE_PASSWORD
site_url=https://YOUR_TEACHABLE_URL

alongside all the other variables that you find there

Docker

You will find a Dockerfile in case you want to build yourself your own docker image.

If you just want the pre-built app this is also available in Docker hub, you can pull it simply by:

docker pull instezz/teachable-school-manager:latest

Check the docker-compose.yml to configure your server to use this application.

Scripts

The package will install scripts in /usr/local/bin/ so you can just call them from cmdline. Each script is prefixed with teachable_ so you can simply write teachable_(PRESS TAB) and it will show you all the available scripts.

Enroll users to a course

If you want to enroll a whole list of users to a new course, you can do it with teachable_enroll script that receives a user list Excel or CSV file (you'll only need 2 columns: fullname and email) and a course id.

Typing --help will show the parameters info

usage: teachable_enroll [-h] input_file courseId
    
Mass enroll users from Excel or CSV file into a specified course
  
positional arguments:
  input_file  Excel or CSV file. The only needed columns are 'fullname' and 'email'
  courseId    The id of the course they should be enrolled in
    
optional arguments:
  -h, --help  show this help message and exit

If your file is Userlist.xlsx and course id is 1234 you can enroll all the users in the file into this course by typing :

enroll path/to/file/Userlist.xlsx 1234

If some of thoses users are already enrolled in the course, Teachable API currently ignores them.

Get User Reports

Use teachable_user_report. Typing --help will show the parameters info

usage: teachable_user_report [-h] [--emails EMAILS [EMAILS ...]] [--output_file [OUTPUT_FILE]] [--search [SEARCH]] [--format [FORMAT]] [--detailed]

Get your Teachable students report. By default it will generate a progress summary report of all the students that are enrolled in all your courses. Pay
attention if you have a lot of students because this will be rate limited at some point

optional arguments:
-h, --help            show this help message and exit
--emails EMAILS [EMAILS ...], -e EMAILS [EMAILS ...]
                    list of emails (separated by spaces) - cannot be used with -s
--output_file [OUTPUT_FILE], -o [OUTPUT_FILE]
                    Output file
--search [SEARCH], -s [SEARCH]
                    Searches specific text in name or email. For instance -s @gmail.com or -s *@gmail.com will look for all the users that have an
                    email ending in @gmail.com. Or -s Jack will look for all the users that have Jack in their name (or surname) - cannot be used with
                    -e
--format [FORMAT], -f [FORMAT]
                    Output format (txt or csv)
--detailed, -d        Get detailed progress report

By default it will generate a progress summary report on screen of all the students that are enrolled in all your courses.

If you add a specific email it will generate the student summary for the specific email or emails on screen.

teachable_user_report -e STUDENT_EMAIL
teachable_user_report -e STUDENT_EMAIL1 STUDENT_EMAIL2

Specifying the output file won't output anything to the screen and will save it into a file:

teachable_user_report -e STUDENT_EMAIL -o FILENAME.txt

You also can choose to export as a csv file (comma separated values):

teachable_user_report -e STUDENT_EMAIL -o FILENAME.csv -f csv

If you want a detailed report of the activity of a student or all the students just use the -d flag. For instance:

teachable_user_report -e STUDENT_EMAIL -o FILENAME.csv -f csv -d

If you want to do a lazy search of all the students with a specific name or email you can use the flag -s (which can't be used with the flag -e). For instance if you want to search for all the users with a @gmail.com address or named Martin:

teachable_user_report -s @gmail.com -o FILENAME.csv -f csv -d
teachable_user_report -s Martin -o FILENAME.csv -f csv -d

Get Leaderboard directly from Teachable site

With the script teachable_leaderboard you can get the Leaderboard, i.e. the Summary of the progress report for all the students enrolled in a specific course with just one API call.

Calling teachable_leaderboard --help will show:

    usage: teachable_leaderboard [-h] [--search [SEARCH]]

Get a Leaderboard CSV in just one command. It will save as many leaderboards CSV as you have courses.

optional arguments:
  -h, --help            show this help message and exit
  --search [SEARCH], -s [SEARCH]
                        Searches specific text in the name of the course
  --output-file [FILENAME], -o [FILENAME
                        Specify the output file

By default this will generate leaderboards for all the courses in your school. If you want to generate the leaderboard for a specific course you can use

teachable_leaderboard -s PART_OF_THE_NAME_OF_YOUR_COURSE

You can also specify an output file name by using the -o:

teachable_leaderboard -o leaders.csv

Remind people to take a course

This is taken care of by the teachable_remind script:

usage: teachable_remind [-h] [--dryrun]

Polls Teachable and sends reminders to those that haven't started a course or haven't done a lesson in a week.

optional arguments:
  -h, --help    show this help message and exit
  --dryrun, -d  Don't send the messages for real, just do a dry run

There's a host of variables that you will find in config_example.ini that will help you send automatic reminders to people that are enrolled but are inactive (and have not done 100% of the course).

The first part deals with sending emails:

# the username you use to login to your emailserver
smtp_user = [e-mail]
# the password you use to login to your emailserver
smtp_pwd = asfagrbsfva
# your emailserver
smtp_server = smtp.email.com
# emailserver port
smtp_port = 587
# The from friendly name you will use in your emails
smtp_from = 'Your Friendly User (Company)'

Then there is a section dedicated to configure some parameters that help you decide who will receive notifications

# the frequency of the reminders (days) you will config below
freq = 7
# the amount of days of inactivity you want to give a user before sending a
# reminder
alert_days = 7
# The amount of days that we wait before flagging to the contact person that
# a user is not working enough 
warning = 21

And finally you can add as many sections as you want for as many companies you are serving through with your course. This can also be configured to send emails to everyone but pay attention, if you have plenty of users it's going to be expensive.

[ACMEINC]
# the frequency of the reminders (days), in case different than the default
# freq = 7
# what domain to search for the users of the specific company have in Teachable
emailsearch = @acme.com
# the contact person email you are going to send company reports to 
contact_email = [e-mail]
# the contact person name you are going to send company reports to 
contact_name = Friendly Contact
# The course IDs these users are signed up to, comma separated
# course_id = 123513, 1243151, 235345, ...
course_id = 134135

Once you have configured all of this you only have to fire the right script (first run with --dryrun to see what happens)

teachable_remind -d
# and then if all goes well...
teachable_remind

You will find logs for all of this in /usr/local/var/log/teachable.log

If you are using the Docker image this script will run every week via the teachable_scheduler.

Get your earning statements (and email them to you)

You can regularly poll Teachable to get your earning statements as an Excel (default) or CSV file using the teachable_statements script.

By using the --email option the statements will be automatically sent to your email address (the one you use for sending the email that you have configured in config.ini)

usage: teachable_statements [-h] [--email] [--all] [--format [FORMAT]] [--ofile [OFILE]]

Get the latest earning statement as Excel (default) or CSV. Optionally send them over email to the school owner

optional arguments:
  -h, --help            show this help message and exit
  --email, -e           [Optional] Send the statements to the school owner
  --all, -a             [Optional] Get all the statements, not just the last one
  --format [FORMAT], -f [FORMAT]
                        Output format (excel[default], csv)
  --ofile [OFILE], -o [OFILE]
                        [Optional] Output file name

If you are using the Docker image this script will run every week via the teachable_scheduler.

Scheduler

If you are like me you want to automate as much as possible your school management and put things in auto-pilot (which is the whole reason why I have built this suite of management scripts ;) ).

That's why we have teachable_scheduler which should be pretty much self-explanatory:

schedule.every().saturday.at("13:15").do(remind)
schedule.every().saturday.at("13:15").do(statements)

Once you install the package you will find the code at /usr/local/lib/python3.9/site-packages/teachable/scripts/scheduler.py (and if you want to change the schedule the only way is to edit scheduler.py itself, I didn't find any other way)

Cache and rate limits

To avoid reaching any rate limit, the script caches the courses' data into a file using Shelve.

The default cache file expiration is set to 3 days in the config_example.ini, but you can configure that how you want.

Enjoy, Stefano