Importing Locker Information Into Student Records in PowerSchool

This method requires that you create a tab delimited file with the student locker information in either Google Sheets or in Microsoft Excel.

Creating the Tab Delimited File

1. In either Google Sheets or in Microsoft Excel, create a spreadsheet with 4 columns of information:
1. Column A title: Student_Number
   (this should be the ECSRD school number, not the ASN)
2. Column B title: Locker_Number
3. Column C title: Locker_Combination
4. Column D title: U_STU_LOCKER.LOCKSERIAL
   (this is the serial number on the combination lock)
   
2. Save this file for future reference or editing purposes. Then save another version of the file (tab delimited) that will be imported into PowerSchool.
1. If using Google Sheets:
   File > Download > Tab Separated Values (.tsv)
   
2. If using Microsoft Excel:
   File > Save As > Browse > choose a location > change the file type to Text (Tab delimited) (*.txt) > Save

Importing the Tab Delimited File into PowerSchool

1. From the Start Page in PowerSchool, click on Data and Reporting > Imports > Quick Import.
   
2. Change the Table value to: Students
   
3. Leave the default for the following fields:
1. Field delimiter: Tab
2. End-of-line-marker: CR
3. Character Set: UTF-8
   
4. Choose the file to import.
   
5. Suggest field map should be CHECKED.
   
6. Click Import.
   
7. On the new page, ensure that the column headers from the file are pointing to the correct fields in PowerSchool. Both sides of the comparison should show the exact same fields.
   
   
8. Check the box next to Check to exclude first row. This will allow the import process to skip the column titles in your file.
   
9. In the Advanced Import Options section, click the radial button for Update the student's record with the information from the file being imported.
   
10. Click Submit

You will be presented with a confirmation screen which displays the student information that was imported.

(Optional) Additional Verification of Imported Information

1. Select and copy all of the student numbers from your Google Sheet or Microsoft Excel worksheet.
   
2. Paste the copied student numbers into the Multi-Select window in PowerSchool. This will add all intended students to the selection list.
   
3. Choose List Students from the student selection drop down arrow.
   
4. Add the following fields to the report:
1. LastFirst
2. Student_Number
3. Locker_Number
4. Locker_Combination
5. U_STU_LOCKER.LOCKSERIAL
   
5. Add the Column Titles to match.
   
6. Click Submit.
   
7. Scroll through the list to scan for any blank fields.