Updated Sims Photo Export Utility - Filter Staff by Surname

03 January, 2017 · less than a minute to read

Updated Sims Photo Export Utility–Filter Staff by Surname

I’ve just added the ability to filter staff by surname in our free PhotoExport utility for Sims. The reason was because a user was getting an out of memory exception loading all the staff photos at once. The Sims API we are using loads all the photos into memory before we can save them, so if they are large then it can take a huge amount of memory. Now, with the surname filter, you can export them by initial letter of the surname, which will hopefully keep the memory usage low enough to complete. If there are any particularly large photos, you can even filter by more than one letter, but I would start with one and then refine if you hit any further problems. Usage PhotoExport username password outputFolder [/staff] [/year:x] [/nameAsId] [/format:xxx] [/names:filename] [/thumbnail] [/filter:xxx]   /filter:surname An optional parameter which if present will filter staff based on their surname. You can either type the start of the surname or a T-SQL filter e.g. /filter:j will only export photos for staff whose surname begins with j e.g. /filter:j%s will only export photos for staff whose surname begins with j and also has an s in it. Note in this case. the s can be anywhere after the j and not necessarily at the end of the name.

Richard Willis headshot

Written by Richard Willis

Managing Director / Founder

Richard started SalamanderSoft in 2007 after a successful career as a software developer. Wanting to start his own company and with experience in integrating school systems he set out to build the best integration system for schools and to exceed customer expectations. He starting out on his own, doing all the coding, support and sales until finally the growing number of customers meant he needed to start growing the team. He is still heavily involved in coding the core Integration Suite product in addition to running the company and being the first point of contact for prospective customers.

Copyright © 2020 SalamanderSoft Limited