Before importing pictures into PowerSchool, you will need to prepare the pictures and the import map file. Use a tab-delimited text file that includes the Student_Number field from the Students table and the name of the picture. It is recommended that this file be created in a spreadsheet application and then saved as a tab-delimited text file. Do not use comma delimiters, and do not save the file in its "native" format; Excel and other spreadsheet applications often save special formatting information in their files which can prevent the file from being properly read by PowerSchool
Example: A student has a student_number of 12345, and his corresponding picture is 67890.jpeg; the first record in your import map file will look similar to the following:
In this example, the Student_Number value is in the first column, and the name of the image file is in the second column.
- Make sure that if the image file name is using leading zeros like 0067890.jpeg that the map file also contains the leading zeros.
- Make sure the image file names matches the image file name as documented in the map file. For instance, if your images have the JPEG extension, use JPEG and not JPG in your map file. The file name is case sensitive.
- Remove any extraneous columns from the spreadsheet when importing, all that is needed is two columns, one for the Student_Number and the other for the name of the corresponding picture.
- Staff/Teacher import requires the "TeacherNumber" value from the "Teachers" table and the name of the corresponding picture in two separate columns.
Preparing the Pictures
Image files must be in the JPEG/JFIF format, with a file extension of .jpg or .jpeg.
It is recommended that the image files be 200 pixels wide by 300 pixels high.
All student photos should be in a flat zip. All staff photos should be in a flat zip file separate from the student photos. Important : Other file types such as .sit are not valid. The file must be in the .zip format.
The map file should be separate from the flat zip file, and should be formatted as described in the previous section.
Photos must not be in a subfolder in the zip file. Make sure to verify the zip software you are using does not place the files in a subfolder.
Importing the Pictures
- On the start page, choose System from the main menu.
- Click Photo Management. The Photo Management page appears.
- Click Import Pictures. The Import Pictures page appears.
- Indicate the group for which you want to import photos by choosing either Student or Staff.
- Enter the file path and name of the zip file or click Browse to select the zip file.
- Enter the file path and name of the mapping file or click Browse to select the mapping file.
- Choose Student/Staff Number from the pop-up menu.
- Click Upload. The Import Photos Results page displays a summary of the processed records and any failures.
If the pictures were prepared by a third party vendor, the third party may be able to provide you with the map file based on the current specifications. Please contact your vendor for additional information.