SIMS Photo Exporter

A utility to export pupils or staff photos from SIMS into a folder, either the entire cohort or a subset. You can then use them to export into other systems, such as Active Directory. There’s a number of options to control where the photos are saved and the names of the files.

Utility Information

Highlights

Quickly export Staff photos from Sims

Quickly export Pupil photos from Sims

Filter by cohort / year

Filter by surname

Utility detail

The SIMS Photo Exporter is a free utility to export pupils or staff photos from SIMS into a folder, either the entire cohort or a subset.
You can then use them to export into other systems, such as Active Directory.

The utility has a number of options to control where the photos are saved and the names of the files.

For copyright purposes you must ensure that you have the permission of the photographer before exporting any images with this utility.

Instructions

These instructions are also available in the README.txt file in the download, or by running: PhotoExport.exe /?

For copyright purposes you must ensure that you have the permission of the photographer before exporting any images with this utility. By using this utility you take full responsibility for any copyright or data protection issues. SalamanderSoft does not provide any guarantees, warranty or support with this utility. Use of the utility is entirely at your own risk.

The utility must be ran from a command line and supports the following parameters:

PhotoExport.exe username password outputFolder [/staff] [/year:x] [/nameAsId] [/format:xxx] [/names:filename] [/thumbnail] [/filter:xxx]
 

ParameterDescription
usernameThe sims username to log in as
passwordThe password to use
outputFolderThe folder to save the images in
/staffAn optional parameter which if present and is staff will output the staff photos
/year:xAn optional parameter which if present will limit the extract to the specified year.
Replace x with the year required.
/nameAsIdAn optional parameter which if present will name the files as the internal Sims database ID rather than admission number and staff code.
/format:xxxAn optional parameter which if present will convert the images to the appropriate format.
/names:filenameAn optional parameter which if present will save the images as specified names. The filename is the full or relative path to a csv file which has 2 columns, the 1st one being the admission number of a student or the staff code of a staff member, and the second the name to save the image as.
/filter:surnameAn 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

To Use:

  1. The utility must be run on a machine where Sims.net workstation or server is installed and working.
  2. First run GenerateConfigFile.bat. You must also run this everytime Sims.Net is updated. If Sims.Net is not installed in c:\program files\Sims\Sims .Net, you will need to modify the bat file.
  3. Copy a connect.ini into the folder.
  4. Run PhotoExport.exe from the command line with a minimum 3 arguments, ‘username’, ‘password’ and ‘outputFolder’.
  5. If you wish to export staff photos add another argument staff e.g. PhotoExport.exe myUsers myPassword myFolder staff
  6. PhotoExport will then export the photos into the folder.

Note: If you pass in an invalid year the output will contain a set of valid years.

If you have any problems please email photoexport@salamandersoft.co.uk

Download

Copyright © 2020 SalamanderSoft Limited