Sims and other MIS Timetables into Google Calendar

Using the timetable data from your MIS, whether it is Sims, Progresso, Facility CMIS, iSAMS or any other MIS, Salamander Active Directory can update staff members’ and pupils’ Google Apps for Education calendars with their timetable. These calendars are updated each time Salamander runs, allowing the calendars to remain up to date with any changes to an individual’s timetable.

The events can be put into the main calendar or in a named calendar as below.

googleCalendar

This example is for a staff member so the subject is configured to be the name of the teaching group as a staff member will likely teach multiple classes for the same subject. For pupils it would usually be configured as the subject name as they typically only have one teaching group for each subject.

Salamander Active Directory can also synchronize other types of timetables from Sims and other MIS including:

· Cover timetables

· Sims Diary

· Room timetables

· Class timetables

· Sims Homework

· Behaviour timetable

· Exam timetable

Read More

Sims and other MIS Timetables into Exchange and Office 365 Calendars

Using the timetable data from your MIS, whether it is Sims, Progresso, Facility CMIS, iSAMS or any other MIS, Salamander Active Directory can update staff and pupils’ Exchange calendars with their timetable. These calendars are updated each time Salamander runs, allowing the calendars to remain up to date with any changes to an individual’s timetable. This works with any version of Exchange both on premise in the school, or Exchange Online including Office 365.

This example is for a staff member so the subject is configured to be the name of the teaching group as a staff member will likely teach multiple classes for the same subject. For pupils it would usually be configured as the subject name as they typically only have one teaching group for each subject.

 

timetable

An example of an event.

timetableEvent

 

Appointment Categorisation

timetableCategory

Events can be categorised to suit your needs. Here we have events which are categorised by Subject, but this could equally be the Year of the group or the Room.


 

Cover Timetables

The cover timetables can also be synchronised, allowing users to easily see what cover has been assigned to them day to day.

Other Timetables

 

Salamander Active Directory can also synchronize other types of timetables from Sims and other MIS including:

· Sims Diary

· Room timetables

· Class timetables

· Sims Homework

· Behaviour timetable

· Exam timetable

Read More

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

Sims-Technical-Partners-logo-read-write-02_v2

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

Free Utility to Check Email Addresses

Inspired by a discussion on Edugeek I’ve quickly knocked up a quick utility to check the format of email addresses in a csv file. You can download it from here.

This utility will iterate through an input file and check the validity of email addresses. Each line of the input file must be of the format identifier,email address. The identifier is used in the output message, and the email is of course checked.

Example input file

002345,info@salamandersoft.co.uk
002346,me@domain.com
002347,do not email
    

The utility will pick up the 3rd line as an invalid email address and output

POSSIBLY INVALID:002347:do not email

Internally it uses a regular expression to check the email. This is not perfect and will give false positives when compared to RFC 2822, but it is good enough for most purposes.

The regular expression used is: ^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$

To use:

  1. Run CheckEmails.exe inputFile
  2. inputFile is the relative of absolute path to the csv file

So to use to check your email addresses in Sims, first create a report which contains their Admission Number and email which saves to csv. The run the report and the use the resulting file as input to CheckEmails.

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

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