NS News & Views

By Clive Norman
List all 33 articles

| Tags: iSAMS MIS C# Database SQL

Firstly, let me register that I much prefer writing raw SQL when interrogating iSAMS than using the official iSAMS REST API - there, I’ve said it! However, I do entirely appreciate the necessity for an official API in order to cater for security, consistency, potential database schema changes & futureproofing etc. ➡️


| Tags: iSAMS PowerBI Database SQL MIS

Like many people, I’ve tinkered with Power BI over the years but have never really dug deep into the weeds; the same can also be said for the iSAMS REST API. ➡️


| Tags: Macro Excel Script MIS QuickTip

Recently, I was asked whether I could provide some assistance with manipulating data, that had been exported from a CAT results test. The problem, had slowly been driving a colleague of mine, very slightly crazy! ➡️


| Tags: iSAMS MIS JavaScript SSRS PowerShell

During the summer of 2014, we migrated the St Mary’s Shaftesbury MIS (Management Information System) from Schoolbase to iSAMS. Please note, that the reasons for instigating this major system change, and the processes involved (political & technical), are not covered in this blog post. ➡️


| Tags: Schoolbase MIS Crystal Reports

At St Mary’s Shaftesbury, one of the many additional functions we have built, to work alongside our Schoolbase MIS (Management Information System), is the automation of a weekly ‘Rewards and Sanctions’ report. ➡️


| Tags: Schoolbase MIS C# SysAdmin Devops

At St Mary’s we use Schoolbase from Furlong Solutions, for our MIS - we have done so for several years (indeed my understanding is that we were the second or third official school to have the system in production). ➡️


1 of 1