cca/libraries_syllabus_notifications

send email reminders to upload syllabi from a CSV

libraries_syllabus_notifications's Issues

automate course JSON download as part of update usernames script

See the TODO in the readme. Could either be shelling out to gsutil or using a Google Python library.

sentence on course inaccuracies

Add a sentence to the first reminder about correcting inaccurate course information, since we're planning to send the week before classes start and those will likely be more numerous.

migrate project to libraries' wagtail site

Right now, we run these scripts on a random locally-hosted server running openEQUELLA simply because it's what I have ssh access to. Since it's python, it makes sense to incorporate it into the Wagtail website, as we have done with other utilities like the Summon deletes task.

switch to pytest

Going to be easier to test the CLI aspect as well as functions. See the Flask tutorial for an example of working with pytest.

update email sig to be Dominick Tracy's

Dominick is handling the syllabus collection this year & not Tom.

use Mailgun's SMTP to send mail

Can't we just authenticate with CCA's SMTP server and run this locally, not on a CCA VM at all? I don't remember if I tried this already but it seems like an obvious oversight.

can we add schema.org actions to emails?

https://developers.google.com/gmail/markup/?hl=en

These highlight actions right from the inbox, you don't even need to click into the email. Could link up the Syllabus contribution form via a login.do?page= link. A ViewAction seems to be the specific type of markup we'd want.

Our emails are plain text which makes me think we may not be able to add the markup.

chair VAULT links per term

Send program chairs an email (≈a week after the final faculty reminder) linking to their syllabi from the present term. The VAULT links look like this:

https://vault.cca.edu/logon.do?page=%2Fhierarchy.do%3Ftopic%3D17c784ec-650f-4381-8492-f1a3edf7d8c0%3ACERAM%2Cf416503d-ff0a-47f3-aaaa-93b7ea083873%3AFine%252BArts%252BDivision%2C289af057-1502-498a-b73a-259f26b968c0%3ASpring%252B2024%26sort%3Dname

this is for Ceramics under the Fine Arts Division for Spring 2024. You can see those strings in the URL; all we need to do is adjust the parameters for other programs/semesters.

Use the "Academic Chair Assignments" Workday report to determine chairs.

move more logic from cli.py to reminders app

The cli should really be a light wrapper over the different components of the reminders app with no business logic itself. So the bit about skipping over invalid faculty names and filtering to the right courses should be broken out into something else.