ÌÇÐÄVlog

Skip to main content

Import Users/Rosters - Roster Students to Existing Classes

Learn how administrators roster new and existing students to existing classes using the Import Users/Rosters bulk upload tools.

Tags

This article applies to Manual Rostering districts. Manual Rostering means that teachers manually redeem program content and roster their own classes.

Ìý

SSO applies to districts that use an SSO portal, district website, or Learning Management System (LMS) to access ÌÇÐÄVlog digital programs, and Direct Login means that teachers, students, and administrators log in at my.mheducation.com.

Not sure which Access Service your district uses? ClickÌýÌýto learn more about the four Access Services that we support.

This article walks Organization Administrators through rostering students to existing classes.

For a full page view of the demo, .

For a Spanish version of the demo, .

Using the Import Users/Rosters bulk import process does not allow you to remove students, teachers, or classes from the organization account. For steps on dropping staff from the organization account, refer to the Manage Users for Manual Rostering Districts article. For steps on archiving classes, refer to the Admin Tools - Archive Classes article.

To ensure you are completing each field correctly, we recommend having the Import Users/Rosters - Template Instructions opened as well.

Article Contents

Access Import Users/Rosters

Enter New Student Info

Add Existing Student Info

Enter Class Info

Upload Users/Rosters File

Access Import Users/Rosters

1.

Note: If you have both the Teacher and Administrator roles, you'll need to switch to your Administrator role on your Profile menu to access the Admin Tools. For steps on toggling between roles, refer to the How to Access Roles, Organizations, and Profile Setting article.

2. Click on Import Users/Rosters from the navigation menu.

3. Click on the Select School drop-down and select the school you want to complete the import for.

If you are a School Organization Administrator, you will need to select the school you want to complete the import for from your Profile menu in the Organization section.

Enter New Student Info

This section should only be completed by district that are Direct Login and Manual Rostering district.

Direct Login means that teachers, students, and administrators log in atÌý. Manual Rostering means that teachers manually redeem program content and roster their own classes.ÌýIf you are unsure which Access Service applies to your district, please see this articleÌýfor more information.Ìý

1. Click on the desired file format for the Blank Template. The document will download to your device.

We highly recommend downloading theÌýExport Teachers & Students file to verify the students do not yet have an account created. If they do have an account, follow the steps in the next section.

2. For every new student you need to roster, you must enter a User ID, Role, First Name, and Last Name.

3. Enter a Grade Level for every student. This is an optional field.

4. We recommend entering an Email for each student if they have one assigned to them. This is also an optional field.

5. Entering aÌýUsername and Password for each student is optional. The system will generate a username and temporary password for each student if you leave these fields blank.

6. Leave the User GUID field blank, as the system will generate one for each new user.

7. If you would like to also add existing student info to the same file, refer to the Add Existing Student Info section. Otherwise, navigate to the Enter Class Info section.

Add Existing Student Info

This section can be completed by any district using Manual Rostering, this includes SSO districts.

Manual Rostering means that teachers manually redeem program content and roster their own classes.ÌýIf you are unsure which Access Service applies to your district, please see this articleÌýfor more information.Ìý

1. On the Import Users/Rosters page, click on the desired file format for the Blank Template.Ìý

If you already downloaded the file from the Enter New Student Info section, you do not need to do so again. You can add existing student info to the same file.

2. Download the Export Teachers & Students file.

3. On the Export Teachers & Students file, scroll, use CTRL + F, or use Filters to locate the students you want to add to the class.

4. Copy the User GUID, Role, First Name, Last Name, Grade Level, Email, and Username for each student you want to add to the class (columns A-H).

5. In your Blank Template, paste the copied student information into fields A-H.

Enter Class Info

To add existing class information, navigate back to the Import Users/Rosters page.

1. Download the desired file format for Export Class List.

2. From the Export Class List file, copy the Class GUID, Class ID, Class Name, Class Grade Level, Class Start Date, and Class End Date fields (columns J-O) for the class you want to roster.

3. On your Blank Template, paste the copied class information into columns J-O for each student that needs to be assigned to that class.

4. If the copied class did not have an existing Class ID, you will need to create one.

You can add multiple classes to one file.

To assign the students to multiple classes on one file, copy the student's information into an additional row for each class they need assigned to.

5. If you leave the Master Code field blank, the students will be assigned to the class only.

For older programs, those that are housed on the ConnectED Platform, to assign students to the Student Edition, you will want to enter the Student Edition Master Code to the field.

Master Codes can be found on the Manage Products page in the Admin Tools.

6. Save your roster file somewhere easy to locate on your device.

Upload Users/Rosters File

1. On the Import Users/Rosters page, click the Choose File button and select the completed copy of the template from your device.

2. Click the Upload button.

The page will automatically navigate to the Upload History page. Depending on how large the file is, the time will vary on the upload process.

TheÌýStatusÌýof your importÌýshowsÌýits current stage of processing:ÌýÌý

  • QueuedÌýmeans that the import will be processed as soon as possible but has not started yet.ÌýÌý

  • In ProgressÌýmeans that the import has started processingÌýÌýÌý


To check the status of your import, click the RefreshÌýbutton at the top-right.Ìý

Once the status changes to Completed, your file has finished processing. If you see Completed with ErrorsÌýin theÌýStatusÌýcolumn, this means a portion of your file was unable to process some of the entered data.

You can click theÌýActionsÌýicon to download the Uploaded File, Completed File, or Error File.Ìý

  • °Õ³ó±ð Uploaded FileÌýis the exact file that you uploaded (minus account passwords if you included those on your original file). It's available so that you can access it later if needed.Ìý
    Ìý

  • °Õ³ó±ð Completed FileÌýis a summary of all student, teacher, and class information that was processed successfully. Ìý

    • Each account created via the import process now has a system-generated User GUID.ÌýÌýÌý

    • If you left the username and password columns blank, the file contains the system-generated usernames along with a temporary password for each account. 

      • The temporary password will expire when it is initially used; theÌýstudentÌýwill be required to set their own permanent custom password once they log in to their account.

      • If the student(s)Ìýdon't access their account within 90 days of the temporary password being set, an administrator or teacher will need toÌýmanually reset their password.ÌýÌý

    • Share the usernameÌý(and password, if applicable)Ìýon this file withÌýthe teachersÌýso they can access their accounts as well as provide the students with their logins.
      Ìý

  • °Õ³ó±ð Error FileÌýis a summary of the students, teachers, and/or classes that did not process successfully. It shows the rows that triggered the error and the specific reason why these rows failed in theÌýErrorÌýcolumn on the far right.ÌýÌý

    • If the data was partially processed and aÌýstudent, teacher,Ìýand/or class was created, the ErrorÌýfile will include the relevant GUIDs for thoseÌýstudent(s), teacher(s), and/or class(es).ÌýÌý

    • You can review the error message(s) and correct the information.ÌýCorrectÌýthe issues described in the error message,Ìýsave the updated file to your computer, and re-import it.

Top