Differences

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

--- powerschool:powerschool:studentportraits [2019/09/18 14:03]
jrhea
+++ powerschool:powerschool:studentportraits [2020/01/20 14:46] (current)
lokes
@@ Line 47: / Line 47: @@
 To create the zipped mapping file, drag and drop the IDLINK.TEXT file to the desktop\\
 **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 (file when using LifeTouch) or similar name when using other portrait company
+  - 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.
@@ Line 58: / Line 58: @@
 **Import the file into MS Excel using the Text Import Wizard**
 {{ :powerschool:powerschool:comma_deliminated.png?500}}
-  - Choose file type as Delimited
+  - Choose file type as Delimited.
-  - Click Next
+  - Click Next.
-  - Choose Delimited by a **Comma**
+  - 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:** 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.
-  - Highlight Column A
+  - Highlight Column A.
-  - Choose the Data tab and select the Text to Columns data tool to access the Text Wizard window
+  - 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 1 of 3 select Delimited and click Next.
-  - In Step 2 of 3 select Comma and click Next
+  - In Step 2 of 3 select Comma and click Next.
-  - In Step 3 of 3 select General and click Finish
+  - 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).
+  - 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)
+  - Save the file as Text(Tab delimited) (*.txt).
-  - Confirm saving the file and the format changes for all the popup windows.
+  - 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**
@@ Line 78: / Line 80: @@
 **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|}}
@@ Line 94: / Line 96: @@
   - 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.
-  - 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.
 {{: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}}

Knowledge Base

User Tools

Site Tools

Differences

Page Tools