How to manually load class and student data via spreadsheets Follow

In this article:

• Manual load overview
• How to manually load your data

Manual load overview

One commonly used data loading method, particularly for smaller schools, is a manual load. This article details the process for configuring spreadsheets for manual loads. View other loading options in this article.

The Admin managed roster page provides template class and student files for you to populate. Find these by clicking 'Load classes' or 'Load students' 

These templates are built to exactly match the settings specified in the Manual Configuration page, making the templates easier to populate.

How to manually load your data

To manually load your data, follow these steps: 

1. Log in to the Hāpara Admin Console.
2. Navigate to the Class rostering menu option.
3. Select Admin managed roster
4. From the Manual load section, click Edit configurations to select your manual load preferences.
5. Using the template class and student files (either Google Sheets or CSVs) provided by clicking 'Load classes' or 'Load students' under Roster data, populate the templates with your class and student data.
6. If you are using Google Sheets, verify your spreadsheets are shared with the Institutional Content Owner user (named school.apps.owner for most schools).
7. Use 'Load classes' or 'Load students' buttons to start the load of your class file (Google Sheet or CSV) into Hāpara.
8. Loading large files can take a while to complete. Use the Data logs page to monitor the progress of your load or to view the results of historic loads. You can also track any errors that may result from your data load. Also refer to the Data Logs page guide.

For additional tips on how to create your student and class spreadsheets view:

• Class and student data requirements
• Classes spreadsheet column headers
• Naming subject folders - recommendations

At the start of the school year, you will want the class and student files to contain all of your classes and students. During the school year, you may want to incrementally add classes, change teachers or update class rosters.

Note: Whenever you load an existing student, you must include each of that student's classes in your spreadsheet. If you only include one class for a student, they will be removed from every other class in Hāpara.

The article Making changes to classes and students explains additional steps for this process.