How To Import Your Student Data


This article will show you how to use the MySchoolID Web Portal to import your students' data and photos into your school(s). This can be done as a DistrictAdmin or SchoolAdmin.

Requirements:

  1. Student data in CSV format (Template downloads and required fields below)

If you cannot download the above file create a new CSV file in Excel or a similar program and use the following required fields (as separate columns)making sure to use these fields exactly how they are typed below:

School import required fields:

  • DCID - A preset record identifier. This field is optional.
  • Last_Name - Students last name
  • First_Name - Students first name
  • Email - Students Email Address (Only needed if your students will be accessing the mobile app)
  • Grade_Level - Students grade level
  • Student_ID - Students ID number
  • Guardian_First_Name - Guardians first name (Optional)
  • Guardian_Last_Name - Guardians last name (Optional)
  • Guardian_Email - Guardians email address (Optional)
  • Guardian2_First_Name - Guardian 2 first name (Optional)
  • Guardian2_Last_Name - Guardian 2 last name (Optional)
  • Guardian2_Email - Guardian 2 email address (Optional)
  • Password - Preset password for students access to the mobile app (Optional)

District import required fields:

  • DCID - A preset record identifier. This field is optional.
  • School_Name - School you wish the data to be imported into
  • Last_Name - Students last name
  • First_Name - Students first name
  • Email - Students Email Address (Only needed if your students will be accessing the mobile app)
  • Grade_Level - Students grade level
  • Student_ID - Students ID number
  • Guardian_First_Name - Guardians first name (Optional)
  • Guardian_Last_Name - Guardians last name (Optional)
  • Guardian_Email - Guardians email address (Optional)
  • Guardian2_First_Name - Guardian 2 first name (Optional)
  • Guardian2_Last_Name - Guardian 2 last name (Optional)
  • Guardian2_Email - Guardian 2 email address (Optional)
  • Password - Preset password for student access to the mobile app (Optional)
  1. Zipped file OR a Dropbox folder location with student photos(PNG or JPG format; more info below)

  2. Student email address for each student entered in CSV MUST match that student’s photo filename. More information on this below.

Importing the Data

  1. Log in to your web portal.

  2. Click on the Import option in the left navigation pane.

MSID-Import

  1. Click Create Import

Create Import

  1. There are 2 types of imports: District and School. DistrictAdmins will have access to both and SchoolAdmins will have access to just their school.

District imports will allow you to choose which school to import each record into. See the District Import template above.

Select your import type and click Next

Import Type2

Import Type

  1. Under Image Source select whether you want to upload a ZIP file or use a DropBox folder. (Instructions for each are below.)

Image Source

In both cases, the Student email address entered in your CSV file MUST match the filename of that student’s photo. (ex. John Adams Student email address, photo filename “email@address.com.png”) Take a look at the 2 photos below; the first image is the CSV file with email addresses that match the filenames in the second image.

MSID-CSV

MSID-Filename

Uploading Photos via a ZIP file

  1. To create a ZIP file simply put all your student photos into one folder.

Photo Folder

  1. Right click that folder, hover over Send To then click Compressed(zipped) folder.

Send To

You can name the ZIP file anything you’d like. This will convert the folder to a ZIP file ready to be uploaded.

  1. Once you have the ZIP file click ZIP File under Image Source then click Next.

ZIP Import

  1. Click Choose File and select the ZIP file you created. Click Next.

ZIP

  1. Click Choose File and select the CSV with your student data. Click Submit.

ZIP

Uploading Photos via Dropbox

  1. Log into your Dropbox account.

  2. Find and hover over the folder containing your students photos and click the Share icon.

  3. Click Copy Link.

Copy Link

  1. Back in the MSID Web Portal, click Dropbox under Image Source. Click Next.

Dropbox

  1. Paste (CTRL+V) in the folder URL you copied from Dropbox. Click Next.

Dropbox Location

  1. Click Choose File and select the CSV with your student data. Click Submit.

CSV

Import Status

After you click Submit, you will be taken back to the Import page where you can see the status of your import. If successful, your student data and photos were all uploaded. If there is an error, click Edit to see a breakdown of each record you uploaded. Click Edit again next to any records with an error to see exactly what the error is so that you can make any needed corrections.

Common import errors include:

  • Duplicate email address or student ID number
  • Email address is in wrong format
  • Photo filename doesnt match student ID number in CSV file
  • A required field is missing from CSV file
  • Data in a required field in CSV file is missing

Import Error

Import Error

Import Error