This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
powerschool:powerschool:studentportraits [2016/10/28 10:06] lokes |
powerschool:powerschool:studentportraits [2019/09/18 14:42] jrhea |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Student Portraits ====== | ====== Student Portraits ====== | ||
- | ITRTs or Guidance Counselors load the annual student portraits | + | ===== How to Prepare and Import Student Photos |
- | Within PowerSchool, | + | |
- | **View the Student Portraits** | + | 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. |
- | - Insert the Liftouch (or other company) Compact Disk into a computer. | + | |
+ | - 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: | ||
+ | |||
+ | ITRT's can assist you in loading the annual student portraits into PowerSchool to correspond with the student' | ||
+ | |||
+ | //Tip: Within PowerSchool, | ||
+ | |||
+ | ==== Preparing the Picture file as a Flat ZIP File ==== | ||
+ | |||
+ | So that you can import the photos all at once instead of individually, | ||
+ | |||
+ | - Insert the company' | ||
- 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 11: | 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 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. | ||
{{: | {{: | ||
**Create a Flat Zip File** | **Create a Flat Zip File** | ||
- Click the compressed (zipped) folder. | - Click the compressed (zipped) folder. | ||
- | - Within the same folder, a zipped folder icon is listed with the fist student' | + | - Within the same folder, a zipped folder icon is listed with the first student' |
- 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 " | + | - **Note: |
- | - The zipped file may be relocated to the desktop if desired. | + | - The zipped file may be relocated to the desktop |
//The student pictures labeled as **noid<> | //The student pictures labeled as **noid<> | ||
- | **PowerSchool | + | ==== 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 | ||
+ | |||
+ | To create the zipped | ||
**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 file when using LifeTouch | + | - Open the IDLINK.TEXT |
+ | Once the files are on the Desktop, proceed with the import. | ||
+ | {{: | ||
**Import the file into MS Excel using the Text Import Wizard** | **Import the file into MS Excel using the Text Import Wizard** | ||
- | {{ : | + | {{ : |
- | - Choose file type as Tab 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:** Ensure the file extension in column B is the same as the file extensions on the actual filename of each student picture. To change the file extensions, perform a find and replace. **Example: | + | - **Note: |
- | - Save the file as Text(Tab delimited) (*.txt) | + | - Highlight Column A. |
+ | - 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: | ||
+ | - 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. | ||
Line 51: | Line 78: | ||
**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/ | + | - Mapping Type - **Student/ |
- | - Click **Upload** | + | - Click **Upload**. |
{{: | {{: | ||
Line 67: | Line 94: | ||
- 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, | - Within PowerSchool, | ||
- | - Click on the student' | + | - Click on the student' |
- Click **Submit a new photo for this student** to load a single photo when identified from the noid<> | - Click **Submit a new photo for this student** to load a single photo when identified from the noid<> | ||
{{: | {{: | ||
+ | |||
+ | ==== 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. | ||
+ | |||
+ | 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. | ||
+ | |||
+ | |||
+ | |||
+ |