Creates a list of delayed announcements specified in a CSV or Excel file. Useful for when you need to create a large number of similar messages over a period of time. Author(s): Jeremy H.
-
If you do not have Python, install it. If you have no experience with it, I recommend installing it through https://www.anaconda.com/download/.
-
Clone this GitHub repository.
-
Install all the dependencies using pip (first time use only). Use the command pip install -r requirements.txt through the command shell in the directory of your cloned git repo.
-
Open the format_example.csv to see how you need to format your CSV or Excel file to work with the script (file to be read by script must be in same directory as script). Each column is formatted in a specific fashion (column names have to be same as in format_example.csv):
- date(m/d/y) must be in mm/dd/yyyy format (e.g. 11/21/2018)
- message is written in HTML
- title is plain text
- time is in 24-hour format (e.g. 1:30 PM = 13:30)
-
Run the script. It will prompt you for your token, course id, and CSV/Excel file name.