Importing Student Data


This article will show you how to use the MySchoolID Web Portal to import your students' data and photos and generate passwords for each student.

Requirements:

  • Student data in CSV format (Template below)
Download Here
  • Zipped file OR a Dropbox folder location with student photos(PNG or JPG format; more info below)

  • Student ID number for each student entered in CSV MUST match that student’s photo filename. More information on this below.

  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. Under Import Type select School, then select the school you want to import to. Click Next.

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 ID number entered in your CSV file MUST match the filename of that student’s photo. (ex. John Adams Student ID number 54875, photo filename “54875.png”) Take a look at the 2 photos below; the first image is the CSV file with student IDs that match the photo 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.

Import Error

Import Error

Import Error

Password Generation

Once all student data and photos are uploaded you can generate and email a temporary password to each student. To do this click on Generate Passwords on the Import page.

Generate Passwords

This will send out a temporary password with a link to update it to each student with a valid email address.