How can I extract a list of 'User Photo' URLs (contact card photo)? Can I use these to make a photo directory?

Note: As of July 9, 2018, Blackbaud's School Management solutions (which include Core, onBoard, onCampus, onMessage, and onRecord) are utilizing a new top level navigation. This primarily affects users performing administrative tasks-constituent navigation for most parents, students, faculty, and alumni will remain the same.  
We appreciate your patience as we work to update our documentation. If you are seeing this message, the content of this solution is still being vetted for possible updates. Please refer to this mapping document if you need assistance finding a task in the new navigation.


We would like a list of User Names, and the URLs where their user photos are stored. It'd be great if these could be made into a photo directory.
Step 1:
To
Create a list that will output the Username and their User photo's filename:
  1. Navigate to Lists > Manage Lists.
  2. Click the Manage basic and advanced lists block under List Actions.
  3. Click on the List Templates tab.
  4. In the Template Category drop down, select Constituent Information.
  5. Click to Page 2.
  6. Click View/Copy to the right of "Users with Photos".
  7. If this list should only include certain roles: in the 'Filters' tab, change the Global Filter: User Role.Role condition to the appropriate role(s) (Parent, Student, Teacher, etc)
  8. To exclude results that do not have a photo: In the 'Filters' tab, add a Global Filter for: User Photo.Large Filename with a condition of 'is not null'.
  9. Under the 'Display Fields' tab, click the 'x' to the left of User Role.Role, as this does not need to be displayed
  10. Give your list a Name (required).
  11. Give your list a category (optional but recommended).
  12. Click Save.
  13. Click Preview to view your list's results.
  14. Click Export to save your list as a .CSV (Excel) file
  15. Save & Exit
To obtain the 'File Path Prefix' to pair with the filenames from the advanced list:
  1. Navigate to Core > People Finder, and select any user with a photo
  2. Right-click on their photo and select 'Open image in new tab'
  3. The URL in your browser will appear similar to: https://yourschool.myschoolcdn.com/ftpimages/513/user/large_user4999480_3080892.png?_=1521731969145&resize=200,200
  4. Copy the portion that comes before the filename, such as: https://yourschool.myschoolcdn.com/ftpimages/513/user/
  5. This field can be pasted into the Excel file (Sample Photo Directory) attached to this article, as the 'File Path Prefix'. This value (column H) will be the same for all rows
To prepare the output for HTML:
  1. Download and open the attached excel file
  2. Add the output from your advanced list to columns A through E
  3. Paste your File Path Prefix from Step 5 of the prior instructions into cell H2, then click and drag as shown to populate all rows in Column H with this same value
    Excel
  4. The pre-existing formulas in columns F, G, and I will populate automatically. These can be extended downward in the same fashion as step 3 to cover more rows of data
To finalize this information into a simple webpage appearance:
  1. Select all information in column I and copy
  2. Open a text editor, such as Notepad
  3. Paste all information
  4. 'Save As' any filename, with '.html' as the extension
  5. Open the file in your web browser. Results will appear as here:
    HTML Output example
These images are pulled from the site, and as such, will only populate your HTML output file while signed in as a user with access to view the photos.
  Sample Photo Directory.xlsx

Was this article helpful?