Making changes to classes and students via manual load method Follow
This article helps administrators make changes to Hāpara rosters when using the manual data load method.
In this article:
Quick steps:
Edit your Classes and Students spreadsheets, then reload them in Admin Console → Class rostering → Admin‑managed rosters → Roster data.
Always run the class load first, then the student load.
How it works
-
The Manual Loader overwrites class or student properties with the values in your newest spreadsheets.
-
Include all current enrollments for each student. If you omit a class from a student’s row, they’ll be removed from that class.
-
Mailbox IDs (class email addresses) must be unique and cannot be changed later.
Before you start
-
Use the latest Hāpara Classes and Students templates and required columns.
-
If teachers or students are outside your domain, enter full email addresses.
-
If you need to retire a class, delete it in the Admin Console and remove it from your Classes sheet so it is not recreated on the next load.
Steps to follow
1. Open your roster spreadsheets
Use the Admin‑managed roster templates for Classes and Students (Google Sheets or CSV).
2. Make your changes
Classes
-
Add a class: Add a new row with all required fields. Keep Name and Mailbox unique.
-
Delete a class: Use Delete Classes in the Admin Console, then remove the row from your Classes sheet.
-
Rename a class: Update the Name field (include your academic year/suffix if you use one).
-
Subject folders: In Subject Folders, add/remove comma‑separated folder names. For complex renames, contact Support.
-
Teachers: In Teacher, add/remove usernames (comma‑separated). Use full emails if cross‑domain.
Students
-
-
Add a student: Add their row and list all classes (comma‑separated).
-
Remove from a class: Remove that class from the student’s class list.
-
Remove from all classes: Omit the student’s row from the Students sheet.
-
3. Reload the spreadsheets
Go to Admin Console → Class rostering → Admin‑managed rosters → Roster data.
-
Click Load class data, choose your Classes file, then Start load.
-
Click Load student data, choose your Students file, then Start load.
4. Confirm the load
-
Open Bulk rostering history / Data logs to check success or errors.
-
Allow 30–60 minutes for changes to appear across apps due to caching.
Additional tips
-
Mailbox IDs cannot be changed after a class exists.
-
Subject folder renames with active classes may require Support assistance.
-
If you also use an SIS sync, stick to one rostering method per instance so syncs don’t overwrite manual changes.