How to import particular year students from SIMS

[genesis]

Hi

 

One of our staff want to import the photos of Year 11 students from SIMS as individual files.

Is there a way to achieve this? If so any tutorials would be really great.

 

Thanks in advance

[LukeC]

If you mean exporting them from sims i know a guy who used to use this software

 

Free Utilities | SalamanderSoft Limited

[vikpaw]

+1 for Salamander, used them before, works a treat and will name them by admission code if required.

For import, there is a built in tool that can be filtered by year group.

[SimonHooker]

Most likely this isn't an option for you, but if you have access to the underlying SIMS database you will find student photos within the "sims_photo" table. They are fairly easily extracted there, joining across to sims_person. They are stored as base64-encoded binary data, so pretty easily converted back into actual files. Have had to do similar within NodeJS.