account-recon v1.0.0

Account Recon

This project takes an enrollment CSV extract from Infinite Campus and a student user list CSV for the climb.kippcolorado.org domain and produces CSVs of accounts (along with necessary metadata) to bulk create student accounts for new enrollees, suspend accounts that should no longer be active, and unsuspend accounts that were previously suspended. Following a create or update event, accounts should be moved to their correct Organizational Unit within Google (using the GAM tool).

Accounts that are created or unsuspended via this process share these properties:

• Passwords are reset to the student's 8 digit birthday, in the format MMDDYYYY
• If the student is grade 9 or above, they will be forced to change their password on first login

Source Data Files

Enrollment Data -- Infinite Campus

An ad-hoc report within IC has been setup to serve as the enrollment data source. The report can be found from the Ad-hoc Reporting > Data Export interface, in the folder m KIPP / student Current Enrollment

todo: example rows from enrollment.csv here

Current Student Accounts -- Google (GAM)

Follow the instructions on the GAM Github Wiki to download and install the command-line tool. This is useful for pulling user lists from Google by domain. If you're unable to install, configure, and authenticate GAM, someone from the Tech team will be able to provide this list (with suspended status fields) to you by executing:

# to capture output in a CSV file locally and send over email/slack/etc:
$ gam print users domain climb.kippcolorado.org fields suspended > google_climb.csv

# to create the file in Google Drive and send a link:
$ gam print users domain climb.kippcolorado.org todrive fields suspended

todo: example rows from google.csv here

Output Data Files

todo: example of create.csv here

todo: example of unsuspend.csv here

todo: example of suspend.csv here

Creating Accounts