Ad Hoc Enrollments Scripts

Convert reports into Moodle enrollments CSVs.

Setup

Prerequisites:

• Access to "Students for Internship Review" report in Workday (ask AIS)
• Python 3
• Pipenv (brew install pipenv)

pipenv install
pipenv run test # run tests

Internship Enrollments Usage

Generate enrollments CSV for Moodle from Workday report.

1. Download the "Students for Internship Review" report
2. pipenv run python interns.py -r report.xlsx -s "Fall 2024"
   1. You don't need to pass a -r parameter if the report keeps its default name "Students_for_Internship_Review.xlsx"
   2. -s is the semester group for students
   3. Generate enrollments for a single program with -p $PROGRAM e.g. -p Architecture
3. Go to Moodle > Upload Users
   1. Select the CSV
   2. Don't modify user values (e.g. no updates, no default values, etc.)

NSO Enrollments Usage

This script is used to generate enrollments for the New Student Orientation courses. It lets you specify where in a provided CSV to look for the few pieces of information we need (email, type, international status). Example using CSV of Leave of Absence students: pipenv run python nso.py --infile loa.csv -e "Student Institutional Email Address" -t "Program of Study Status" --intl "Student is International" -c "NSO-2024SP"

Usage: nso.py [OPTIONS]

Options:
  -i, --infile TEXT   Input CSV file
  -o, --outfile TEXT  Output CSV file (default: nso.csv)
  -e, --email TEXT    Email column (default: CCA Email)
  --intl TEXT         International column (default: International?)
  -t, --type TEXT     Student type (First Year, Transfer, Grad, Non-Degree,
                      LOA) column
  -c, --course TEXT   Course shortname (e.g. NSO-2024SP)
  --help              Show this message and exit.

LICENSE

ECL Version 2.0