Important Notes Before Beginning – Enrollment CSV (C+)
If you are working off the CSV template for students provided in your Class+ instance and have custom fields, you will need to add additional columns at the end of the columns in your file.
EX:
customfield_Reason
Regardless of how you build your starting template, please ensure you save your complete file as a CSV UTF-8 file before uploading. This file format is available through Excel when using the “Save as” function.
Below is a table of each column that is in the CSV along with its explanation and possible values (or reference list):
Name of Column | Explanation | Required? | Possible Values |
LastSyncDate | N/A | No, not applicable | N/A |
EnrollmentIndex | This field is only needed on CSV files intended to update existing enrollment records. | No for creating an enrollment, yes for updating an enrollment. | Genius will generate this number after enrollment creation. |
StudentIndex | This field is the index number of the student who you intend to enroll in a section. | Yes | Genius will generate this number after student creation. |
SectionIndex | This field is the index number of the section where you intend to enroll the student. | Yes | Genius will generate this number after section creation. |
StartDate | This is the start of the student’s enrollment in their section. Please note that this can be (but is not required to be) a different date than the section’s specific start date. | Yes | MM/DD/YYYY |
EndDate | This is the end of the student’s enrollment in their section. Please note that this can be (but is not required to be) a different date than the section’s end date. | Yes | MM/DD/YYYY |
Status | This is the status of the enrollment. | Yes | ACTIVE, DROPPED, DROPPED_GRACE, COMPLETED, BLOCKED, FUTURE. |
CurrentGrade | This is the current grade the student has in the enrollment. | No | Numeric value |
FinalGrade | This is the final grade the student has in the enrollment. | No | Numeric value |
CSV Columns that have pre-determined possible values:
Enrollment Index Values in Enrollment CSV (values are case sensitive)
Enrollment Index numbers are only generated AFTER an enrollment has been created in Genius. Subsequently, enrollments that do not currently have a Genius record do not need this field filled out in their relevant creation CSV file. However, to update enrollment records via CSV, you will need their Genius Enrollment Index number.
Student Index Values in Enrollment CSV (values are case sensitive)
When importing via CSV to Genius, an enrollment record needs a Student Index number for each row to identify the student being enrolled. Student Index numbers are only generated AFTER a learner has been created in Genius.
Section Index Values in Enrollment CSV (values are case sensitive)
When importing via CSV to Genius, an enrollment record needs a Section Index number for each row to identify the section where to enroll the student. Section Index numbers are only generated AFTER a section has been created in Genius.
Status Values in Enrollment CSV
Possible Values | Explanation |
ACTIVE | The student is actively taking the course. |
DROPPED | The student has dropped or failed out of the course. |
DROPPED_GRACE | The student was pulled out of the course with no punitive action taken. |
COMPLETED | The student has fully completed the course. |
BLOCKED | The student is blocked from taking or completing the course. |
FUTURE | The student is expected to take the course in the future. |