Student portraits need to be updated once per year. The import file should have the following attributes:
- Comma delimited w/ quotation marks
- Needs carriage return at end of last line (Windows CRLF)
- Unicode (UTF-8)
Export photo file names list from a folder
Use a Terminal command or simply copy/paste Finder items to a text editor.
Export table data from Registrar as xlsls > contents.txt
Student ID
Last name
First Name
Current Grade
Prepare file in Excel
- Copy/paste photo list output in column B
- Save as comma delimited CSV
Resulting data should now look like this:
StudentID , PhotoFileName , LastName , FirstName , CurrentGrade
ELIJ01 , jesus.jpg , Elias , Jesus , 6
Final changes to txt file in TextWrangler or other text editor
- Add quotations before and after all commas - Find & Replace
- Add quotation at beginning of each line — Find & Replace (Grep)
- Add quotation at end of each line — Find & Replace (Grep)
Finalized data should now look like this (notice line break):
"ELIJ01","jesus.jpg","Elias","Jesus","6"
¶
Upload using System Admin in Senior Systems
System Admin > File > Media Import > Student > New
Media Tab
Description = Photo (this is the display name of the file)
Category = Portrait
Publishing Tab
[x] Publish Documents[x] Visible to Parents (Parent 1 & Parent 2)
Click OK to continue.
Once successful, all portrait entries will be populated in the import list. Review all items and click Post.
Verify that we will be replacing any existing portraits if present. Click OK to start the import.