My Big Campus

Modified on Thu, Jun 29, 2023 at 10:03 AM

My Big Campus

Overview

This task will create 3 csv (comma-separated values) files. They are users.csv, groups.csv, and memberships.csv.

Options

The files can be saved to a path on the local machine, sent to an email address, or sent out via FTP (active, passive, or secure FTP).
When saved locally or sent via email, the files will first be zipped.
When sent via FTP, the files will not be zipped.
In the users.csv file, for students, the email column can be filled with the student's email address or left blank.
In the users.csv file, for staff, the username column can be filled with the staff member's 'Extra Data 1' field.
In the users.csv file, for students, the username column can be filled with any of the student's User Text Fields.
Schools can be selected by checking the box next to their names.

Support for Elementary Schools

The groups and memberships output files rely on scheduling information from Genesis. Elementary schools don't have scheduled courses in the way middle and high schools do. In order to include elementary students in those files we use the following process:

We look at each active student in each elementary school, and add their homeroom to a list of homerooms. This gives us a list of all the homerooms for elementary schools in the district. We then take each of those homerooms and associate them with all the students in the homeroom and all the teachers for that homeroom. With that we have enough information to populate the groups and memberships file.

Output

users.csv

Only Active students and teachers will be included.

Column	Notes
unique_sis_user_id	studentID / teacherID
username	studentID / teacher first initial + teacher last name
first_name
last_name
unique_sis_school_id	schoolCode
grade	blank for teachers
email	student email (optional) / teacher email
user_type	1 for students, 2 for teachers, 4 for principals

groups.csv

Every course section in the district will be included.

Column	Notes
unique_sis_group_id	courseCode + "-" + courseSection number
group_name	courseDescription
unique_sis_user_id	teacherNames from the courseSection
unique_sis_school_id	schoolCode of the section.
private	Not entered.

memberships.csv

For each course section, all of the students in that section will be included. Additionally, the teachers of each subsection will be included.

Column	Notes
unique_sis_group_id	As defined in the groups.csv file.
unique_sis_user_id	As defined in the users.csv file.
unique_sis_school_id	schoolCode of the section.