Rostering information can be uploaded in the digital platform in bulk via spreadsheet. You can use a OneRoster CSV file or an Excel file. The OneRoster file is exported from your SIS with all your data already populated. If you don't have access to OneRoster, you can manually populate an Excel file instead.
Recommendation
If you'll be filling out an Excel file: Ask your CSM for the Group ID for each of your schools. You'll need to enter the Group IDs in the file.
To upload a rostering file in Sonday System Digital:
- Log in to Imagine Sonday Sytem Digital and select a group if you have more than one group.
-
Click the hamburger menu in the top right corner of the page and then select Roster Management.
Note
If you do not have Roster Management in your list of options, be sure you have selected the district-level group from your Admin Dashboard. If you still need access, contact your CSM or sondaysupport@imaginelearning.com.
-
Click Manage Settings to verify that the business rules will be applied to your file appropriately. You have options to keep or to deactivate entities not listed in your files, and these rules can be applied differently for different entity types (students, teachers, classes, etc.).
Tip
Most customers prefer to use the Course Title option as a naming convention for new classes.
- Click Create New Import Batch.
-
Excel file users: Obtain the Excel file template via the Example Spreadsheet and/or Blank Spreadsheet buttons. Download the Example Spreadsheet for specific instructions for each column, along with sample data.
Note
The Excel files will not download from an incognito browser in Google Chrome.
-
Excel file users: Fill out the spreadsheet with your rostering data and save the file. You will need to get the Group ID for each school from your CSM and enter that in the SCHOOL_ID or SCHOOL_ID_LIST columns in the various tabs of the spreadsheet.
Tip
Format your spreadsheet to remove hyperlinks from email addresses. The email addresses must be plain text in order to process correctly.
-
All users: Upload the spreadsheet in the Create New Import Batch window.
- First, select a Batch Type. (Select OneRoster if have a OneRoster CSV file; select Imagine Sonday Excel File if you're populating a template from scratch.)
- You can leave the Batch # field blank and it will auto-populate.
- Then, enter a Batch Name and click Choose File to select and upload a file.
- Finally, click Create and Import Batch Now.
- If there are errors with the file, you'll receive an explanation as to what went wrong. Fix the file and try again.
- Once your file is error-free, you're taken to the Roster Batch Detail page.
In the Files in This Batch section, you'll be given a preview of the first 20 rows of what will be uploaded. - After verifying that all tabs contain the information you expected, click Start Processing Wizard.
- The Wizard provides mapping information about each type of entity—students, teachers, etc. On Step 1, click Save & Next.
- As you go through the wizard, answer any questions you are asked. Each time your file contains changes or additions to an entity type, you'll process that portion of the file individually. Click Save & Process Data, then click Go To Next Step. (If there are no changes or additions, you will only have the Go To Next Step button).
For any section with a yellow/warning background, click VIEW to learn more.
-
Step 9 is the processing summary. Click View Full Log to see a list of log actions; click View by each action to see specific entity names (students, teachers, etc.). Click Exit when you're done reviewing the information.
Recommendation
Spot-check that rostering was completed correctly by visiting Manage Students, Manage Teachers, and Manage Classes from your Admin Dashboard and verifying that the entities you were expecting were successfully created.