Profiles for Incoming 1Ls needed to be created around August 19. Here are the instructions:

1. Pull student submissions from Gravity Form: Submit a Photo for Our Class Roster. Export the following columns:
   • First Name
   • Last Name
   • Undergraduate Institution
   • Undergraduate Major
   • Photo
2. Open CSV file in Excel, remove duplicates (early submission) both in the CSV file and in Gravity Entries.
3. Clean up Undergraduate Institution and Undergraduate Major to make sure they are consistent. Capitalize names if they are not.
4. Sort by Student Type. Save as three different CSV files for: Incoming JD, Transfer, and Visitor.
5. From each individual Student Type, sort by Last Name in alphabetical order.
6. Open up an Excel template (previous version) with HTML columns, paste in the columns accordingly.
7. Copy all the rows and columns from the Excel file then paste into an HTML file template.
8. Open the HTML file in Chrome browser and check to see if the photos cropped properly. If a person’s head got cropped out, add a CSS class (class=crop-center) in the person’s img element: <img class=crop-center src=lastname-firstname.jpg>.
9. Once everything looks good, print from Chrome browser, then save as PDF.
10. Open the PDFs in Adobe Illustrator to add the Student Type label on the top right corner of the page. (The AI file with labels will be linked to the PDF. When the PDF is updated, it will also update in the IA file.)
11. Combine all PDFs, including the cover page, in Adobe Acrobat.
12. Put everything on the ShareDrive.