User Tools

Site Tools


powerschool:powerschool:studentportraits

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
powerschool:powerschool:studentportraits [2019/09/18 10:10]
jrhea
powerschool:powerschool:studentportraits [2020/01/20 14:46] (current)
lokes
Line 1: Line 1:
 ====== Student Portraits ====== ====== Student Portraits ======
 +
 +===== How to Prepare and Import Student Photos into PowerSchool =====
 +
 +Before being able to mass import student photos into PowerSchool you must first provide the portrait company with a list of students along with their name and student number from Powerschool before picture day.  Once the portrait company provides you the photo and student number files you must prepare them before being able to import them into PowerSchool by creating these two things.
 +
 +  - A flat ZIP file containing all the Student photos you wish to import.
 +  - A tab-delimited text file that maps Student_Number to the exact filename of their Student photo.
 +
  
 **LIFETOUCH PORTRAIT ALERT:  LifeTouch is now providing images for PowerSchool via their web portal.  They have an option to download them in a format that is PowerSchool ready.  Once you go through the process of selecting and downloading the pictures all you will need to do is locate the zipped picture folder along with the IDLink file, then skip to the upload instructions near the bottom of this page.** **LIFETOUCH PORTRAIT ALERT:  LifeTouch is now providing images for PowerSchool via their web portal.  They have an option to download them in a format that is PowerSchool ready.  Once you go through the process of selecting and downloading the pictures all you will need to do is locate the zipped picture folder along with the IDLink file, then skip to the upload instructions near the bottom of this page.**
Line 5: Line 13:
 ITRT's can assist you in loading the annual student portraits into PowerSchool to correspond with the student's record. ITRT's can assist you in loading the annual student portraits into PowerSchool to correspond with the student's record.
  
-Within PowerSchool, search on "**PhotoFlag=0**" to find the students without a portrait.+//Tip: Within PowerSchool, search on "**PhotoFlag=0**" to find the students without a portrait.// 
 + 
 +==== Preparing the Picture file as a Flat ZIP File ==== 
 + 
 +So that you can import the photos all at once instead of individually, they will need to be packaged in a ZIP archive file.
  
-**View the Student Portraits** +  - Insert the company'Compact Disk into a computer.
-  - Insert the Liftouch (or other companyCompact Disk into a computer.+
   - Open folder to view files.   - Open folder to view files.
   - Navigate to the Company Name/IMAGES folder.   - Navigate to the Company Name/IMAGES folder.
Line 14: Line 25:
   - Open IMAGES folder on desktop.   - Open IMAGES folder on desktop.
   - Within IMAGES folder, highlight all the student pictures that are named by the student ID numbers. (Ctrl-A)   - Within IMAGES folder, highlight all the student pictures that are named by the student ID numbers. (Ctrl-A)
-  - **Note:** Search for and omit teacher pictures with a student number as the file name.+  - **Note:** Search for and omit teacher pictures as well as teacher portraits with a student number as the file name if applicable.
   - Right-click over one of the highlighted pictures to access the menu.   - Right-click over one of the highlighted pictures to access the menu.
   - Choose **Send to...** from the list.   - Choose **Send to...** from the list.
 +  - Then choose Compressed (zipped) folder.
 {{:powerschool:powerschool:send_to_menu.png?500|}} {{:powerschool:powerschool:send_to_menu.png?500|}}
  
Line 24: Line 36:
   - Rename the zip folder to create a new .zip extension.   - Rename the zip folder to create a new .zip extension.
   - After clicking to rename the folder, the list will appear alphabetically.   - After clicking to rename the folder, the list will appear alphabetically.
-  - **Note:** //The zip file must be "flat" which means no other folders or subfolders exist inside the zip folder just the image files only.//+  - **Note:** //The zip file must be "flat" which means no other folders or subfolders exist inside the zip folder. Just the image files only.//
   - The zipped file may be relocated to the desktop for easier access, if desired.   - The zipped file may be relocated to the desktop for easier access, if desired.
  
 //The student pictures labeled as **noid<>.jpg** will need to be identified visually and uploaded into PowerSchool on an individual basis.// //The student pictures labeled as **noid<>.jpg** will need to be identified visually and uploaded into PowerSchool on an individual basis.//
  
-**PowerSchool requires a Mapping file** +==== Preparing the Mapping File as a Tab-Delimited Text File ==== 
-To create the mapping file, drag and drop the IDLINK.TEXT file to the desktop\\+ 
 +PowerSchool needs you to tell it which photo belongs to which Student. To do this, you must make a Mapping file that you will import at the same time as the photos. 
 + 
 +To create the zipped mapping file, drag and drop the IDLINK.TEXT file to the desktop\\
 **Note:** Photo Genius uses XREFDATA.TEXT-NOTEPAD **Note:** Photo Genius uses XREFDATA.TEXT-NOTEPAD
-  - Open MS Excel +  - Open MS Excel. 
-  - Excel expects specific file extensions (.xl; .xlsx; .xlm; etc.) +  - Excel expects specific file extensions (.xl; .xlsx; .xlm; etc.). 
-  - Change the file format to search All Files (*.*)   +  - Change the file format to search All Files (*.*). 
-  - From within MS Excel, select Open and change the file type to All Files (*.*) +  - From within MS Excel, select Open and change the file type to All Files (*.*). 
-  - Open the IDLINK.TEXT (or similar name such as IDLINK.TXT) file when using LifeTouch+  - Open the IDLINK.TEXT (file when using LifeTouch) or similar name when using other portrait company.
  
 Once the files are on the Desktop, proceed with the import. Once the files are on the Desktop, proceed with the import.
Line 43: Line 58:
 **Import the file into MS Excel using the Text Import Wizard** **Import the file into MS Excel using the Text Import Wizard**
 {{ :powerschool:powerschool:comma_deliminated.png?500}} {{ :powerschool:powerschool:comma_deliminated.png?500}}
-  - Choose file type as Delimited +  - Choose file type as Delimited. 
-  - Click Next +  - Click Next. 
-  - Choose Delimited by a **Tab** +  - Choose Delimited by a **Comma**. 
-  - Click Next+  - Click Next.
   - Select General in the Column data format section.   - Select General in the Column data format section.
-  - Click Finish +  - Click Finish. 
-  - **Note:** Ensure the file extension in column B is the same as the file extensions on the actual filename of each student picture. This includes case sensitivity. To change the file extensions, perform a find and replace. **Example:**Find *.img and Replace with *.jpg or Find *.jpg and Replace with *.JPG (if file extensions in the picture file are capitalized). +  - **Note:** If both the student number and picture file name are in one column separated by a comma rather than in two columns you will need to split them into two columns.  If so, start with the next step.  If not, skip to Step 13. 
-  - Save the file as Text(Tab delimited) (*.txt) +  - Highlight Column A. 
-  - Confirm saving the file and the format changes for all the popup windows.+  - Choose the Data tab and select the Text to Columns data tool to access the Text Wizard window. 
 +  - In Step 1 of 3 select Delimited and click Next. 
 +  - In Step 2 of 3 select Comma and click Next. 
 +  - In Step 3 of 3 select General and click Finish. 
 +  - Ensure the file extension in column B is the same as the file extensions on the actual filename of each student picture. This includes case sensitivity. To change the file extensions, perform a find and replace. **Example:**Find *.img and Replace with *.jpg or find *.jpg and Replace with *.JPG (if file extensions in the picture file are capitalized). 
 +  - Save the file as Text(Tab delimited) (*.txt). 
 +  - Confirm saving the file and the format changes for all the popup windows. The example below is how the final mapping file should look. 
 + 
 +{{:powerschool:powerschool:portrait_mapping_file.jpg}}
  
 **Strip off the Header and Footer** **Strip off the Header and Footer**
Line 57: Line 80:
  
 **Upload the images into PowerSchool** **Upload the images into PowerSchool**
-  - Open PowerSchool +  - Open PowerSchool. 
-  - Choose the appropriate school for the image import +  - Choose the appropriate school for the image import. 
-  - Under //Setup//, click **System** +  - Under //Setup//, click **System**. 
-  - Click //Photo Management// +  - Click //Photo Management//. 
-  - Click //Import Pictures// +  - Click //Import Pictures//. 
-  - Select Group: **Students** +  - Select Group: **Students**. 
-  - Zip File - browse and open the zip file with the pictures +  - Zip File - browse and open the zip file with the pictures. 
-  - Mapping File - browse and open the mapping file +  - Mapping File - browse and open the mapping file. 
-  - Mapping Type - **Student/Staff Number** +  - Mapping Type - **Student/Staff Number**. 
-  - Click **Upload**+  - Click **Upload**.
  
 {{:powerschool:powerschool:failures.png|}} {{:powerschool:powerschool:failures.png|}}
Line 73: Line 96:
   - The list of Import Failures will identify those with no ID associated with the photo.   - The list of Import Failures will identify those with no ID associated with the photo.
   - Within PowerSchool, search on "**PhotoFlag=0**" to find the students still without a portrait.   - Within PowerSchool, search on "**PhotoFlag=0**" to find the students still without a portrait.
-  - Click on the student's name, then select **Photo** under //Information//+  - Click on the student's name, then select **Photo** under //Information//.
   - Click **Submit a new photo for this student** to load a single photo when identified from the noid<>.jpg files.    - Click **Submit a new photo for this student** to load a single photo when identified from the noid<>.jpg files. 
  
 {{:powerschool:powerschool:addsinglephoto.png}} {{:powerschool:powerschool:addsinglephoto.png}}
 +
 +==== Troubleshooting ====
 +
 +If importing staff portraits there must be a separate mapping file for students and separate mapping file for staff.
 +
 +If the filename of the photo contains leading zeros (Example: 001.jpg), your mapping file must also contain leading zeros.
 +
 +If the filename of the photo uses the .jpeg extension, your mapping file must also use the .jpeg extension. By the same token, if the filename of the photos uses the .jpg extension, your mapping file must also use the .jpg extension.  The mapping file is also case sensitive.
 +
 +You may have additional columns in your mapping file while you're constructing it, but you should save the final version with only two columns.
 +
 +If the mapping file contains quotation marks after you've created it you can remove them by going to Edit > Replace in Notepad.
 +
 +The photos must be in a ZIP file.  Other compression types such as .SIT, .RAR, and .7z are not accepted.
 +
 +{{ :powerschool:powerschool:adding_student_pictures_to_lifetouch_using_lifetouch.docx}}
 +
 +
 +
 +
powerschool/powerschool/studentportraits.1568815858.txt.gz · Last modified: 2019/09/18 10:10 by jrhea