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.

Read More

Sims Accreditation 2014 – 2015


We are pleased to announce that we have passed our Sims Technical Accreditation for 2014-2015. This covers Read and Write access to Sims.

From the Capita web site at http://www.capita-sims.co.uk/accreditation:

SIMS Accreditation is an annual review of how a partner application interfaces with Capita SIMS products and we validate these methods as supportable.

Once the detail has been submitted, it is reviewed by our Partner Development Support Team and approved or referred as applicable. Partners will be required to complete this process annually to maintain the most recent Accreditation status which will be published below.

Read More

New Free Utility for Sims.Net – List Of All Reports

I have just created another free utility for Sims – a utility to export details of all reports in Sims into a csv file. That’s reports as in the reporting engine, not student reports. This will allow you to easily see what reports are in Sims, who created them and hence whether you want to remove any. Inspired by this thread on EduGeek.

To use:

  1. The utility must be run on a machine where Sims.net workstation or server is installed.
  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 SimsReportList from the command line with 3 arguments, Sims username, Sims password and output folder.
  5. SimsReportList will then save the report details into the file.

You can run SimsReportList.exe /? for a brief help summary.

Download Here.

Read More

Bulk Loading Photos From Sims Into SharePoint

I now have a way to script bulk loading of photos from Sims into SharePoint, for example to enable the use of the Learning Gateway My Children web part.

The script is in 2 parts. First extract the photos from Sims using our free Photo Export tool

PhotoExport.exe simsuser simspassword outputFolder /names:mapping.csv

where mapping.csv is a csv file mapping admission numbers to Active Directory login names

The use the PowerShell script in my last blog entry Using PowerShell to Bulk Upload Files to SharePoint to upload the images to SharePoint.

You could even set up a scheduled task to automatically upload them on a predefined schedule.

Read More

Updated Sims Photo Export Utility – Choose image format, Save as Different Name

I’ve updated the free Sims Photo Extract Utility to have the following extra functionality:

  • Choose image format to save as
  • Ability to read a csv list of names to save images as. Useful for example if you want to save the images with their network login name – you would just have to provide a csv linking their Admission Number to login name
  • Display list of years if an invalid year is passed

Details of how to use these are detailed in the README.txt file and by running PhotoExport /?.

    I’ve also fixed a bug where the wrong extension was used in some circumstances.

You can download the updated version from http://www.salamandersoft.co.uk/free-utilities/.

Read More

Updated Free Photo Export From Sims

I’ve uploaded a updated version of the free photo export from Sims utility. There are 2 changes:

  1. Option to save the photos named as the internal sims ID rather than Admission Number and Staff Code. Run PhotoExport /? for help on how to do this.
  2. It now handles the cases where the Staff Code contains characters which are not valid characters for a file name. It replaces these characters with –.

You can download the utility from http://www.salamandersoft.co.uk/free-utilities/.

Read More