Transitioning to a New Student Information System

Student Information Systems (SIS) are likely the most important database on campus. Even if they don’t do accounting, or fund-raising, they still handle the information and the work flow processes that are at the heart of the school– who are the families and the students, and what are their courses and schedules, and then reports, transcripts, attendance, and more.

We’ve been working on a transition to a new SIS for two years. Year one was researching all possible database solutions, including continuing to work with our current system. We reviewed 13 different options, and had full sales pitches from eight, and had a nice spreadsheet showing pros and cons of each. I can’t offer up that sheet online , since the numbers and costs and estimates were part of private conversations with the vendors, but at the end of the process we had a pretty good idea of where we needed to go.

We’ve had an in-house built FileMaker Pro 6 SIS for ten years. It was a great solution in many ways, because our in-house database developer could add wings off the system, and new reports, and new fields and functionality at will. The downside was that the system became so large that it became too difficult to upgrade on a consistent cycle. Secondly, FileMaker Pro 6 forced us to use interlinked database files (we reached about 200) that could only be opened in clusters, meaning that you could only open parts of the database at once, and we also had multiple user lists, meaning that people like myself were in the system multiple times (once as a parent, once as a staff member, etc.). In exports to Follett Destiny, for example, I have two accounts created.

In 2004, FileMaker Pro 7 was released, which enabled a unified database structure (not 200 interlinked files), but the problem was that all of the previous development work would have to be broken and rebuilt again to do the upgrade (about a year’s worth of work, with a new employee to cover regular database needs). However, there was a concern that even on FileMaker 7, 8, 9, 10, 11, we could have the same growth and renewal problems. Also, we would be building a full system based on only one school, and pretty much only one developer.

So, for six years, the school stayed on FileMaker 6, and each year we were concerned if Filemaker 6 would continued to run on the newer versions of OS X. In fact, we’re having problems on Snow Leopard at the moment with it…

To summarize, the school was used to a customized, easily changeable system. Those of you who have any of the big SIS systems from the main vendors probably know that “easily customized and changeable” isn’t an easy road.

Our choice was Veracross, because of its customization ability. The system can be customized school by school because of the way the do their the interface layers. Now, not all customizations are simply and fast, and new modules (such as the Transportation module we are having them build) are not free, but at least we have options going forward. Most importantly, it is a unified database with solid web interfaces for faculty, staff, parents and students that can be developed. Over time, we will fold in more modules that we need for counseling and other services into the unified system.

So, this year we started doing scripted exports of nearly all data out of FileMaker Pro 6, and documenting the data as best possible. These scripts are repeatable, so that when we do the real, final export at the end of this month, the same format with be retained but it will produce the latest data. Veracross has been working for several months on scripting theloading of the data into our Veracross system, and making changes as necessary to accommodate our data fields and structures we need. We are primarily moving to the logic used within the Veracross system (single user database, de-duplication routines), but they still need to know our special data management and analysis routines.

The main module we are having them build for us is Transport (which is integrated with our SIS for morning transport, attendance, after school daily sheets for students, athletic events management, one-off ride charges, taxis).

What will happen at the end of this month is that we will roll our database (sixth graders become seventh graders, etc.), export the final sets of data from the entire system, move our local system into read-only mode, and then Veracross will take our data for two weeks of scripted imports into Veracross (based on the scripts written over the past few months) and then de-duplicate and clean up our data (to achieve unification from the current disparate sources).

A great example of de-duplication is the problem of emergency contacts. In most system, emergency contacts in the SIS are “hanging records” about individuals who may have no other contact with the school. The bad part is that many or most emergency contacts are actually other parents, but the demographics entered for emergency contacts are never tied to the demographics in the parent records. Thus, phone numbers may change in one place, but not change in another. The Veracross system should de-duplicate the data (ether automatically or with human intervention), so that parents who appear as emergency contacts become “blue and underlined” and have their demographic data linked in both areas of the database, meaning a change to one automatically changes the other.

The other thing the Veracross system offers is ability for parents to directly update their demographic data online. The changes are directly processed into the system with no delay, but there is nightly polishing systems to clean up the data entry to school standards (ave. may be changed to Avenue). There are also change reports for the school to see all the online changes made, and roll-back the data if something is amiss. In fact, much or most of the entire system has an audit log, so that previous values can be seen and rolled back if needed. Our current system doesn’t have that, and accidental changes means going to back ups to see what the data used to be.

However, the flexible reporting in FileMaker posed a problem for the transition. Users are used to centralized, heavily customized reports (like class photo lists, labels for school events, and customized and stylized reports for over 100 occasions). Veracross can do this for major reports (like transcripts, report cards, etc.) and generic reports of data, but not for dozens and dozens of uniquely customized and formatted reports, which often need minor adjustments all the time.

To side-step this issue, will will continue to use FileMaker 11 as a type of Crystal Reports for users. Using the API of Veracross, we will have a “mothership” FileMaker 11 database continually updating core data-sets to our server room for use for local databases. (Veracross is a hosted system running out of RackSpace data centers). Thus, FileMaker 11 will be on users desktops, with a single menu for a range of in-house built and customized reports. (Core reports will stay in Veracross.)

Using the local data store,we will also post-process data for other exports, such as to Moodle, Destiny, Catering and Security systems. Secondly, the local data store should give us enough information to be an emergency fall-back in case our cross-Atlantic connectivity to Veracross was interrupted for any significant length of time. Most of us could run on paper for a few days if needed, and the local data store could facilitate that.

Okay, that’s enough for now. Wish us luck– this is going to be a major change. As noted in our planning, we will lose some functionality and ways of doing things because of this transition, but the real value will be in the ways a unified system should help use enable better use and management of the data. Also, the system is designed to enable users to become more sophisticated in their use of information outside of the database, such as in the creation of Word merges that can be integrated back in the user interface. A web interface will be used by nearly all faculty, students and parents, but most staff users will use both the web interfaces and a light, local client.


Sorry for the dearth of posts, but we’ve been busy.  We’re in the final approach to land the ’09-’10 school year.

Best quote I heard this week from a colleague: “Our work is cyclical.  We do it again and again.  In working with kids, we have a tendency to want to rush ahead, but we have to remember that for each them, it’s always the first time.”

As noted, we’re plowing ahead on Veracross cut over this July, cut over to a new 100 mbit fiber this summer, launching a rather large SharePoint 2010 server (with web apps), starting up a centralized document management system with SharePoint, improving security on wireless, setting up a tablet pc pilot program, wasting time with iPads, and dreaming of Summer 2011, when we might be able to take some time off.

Cycling home after work, it’s time for a cognitive break, but instead we spend hours looking for a new flat because our landlord is bouncing us out of home of three years because he needs to move back in.  Thus, we need a new place by the end of July, and it isn’t easy to find a good three-bed flat in North London at the moment.  Also, after three years of third floor walk-up living with a cramped kitchen, we dream of ground floor flats with private gardens and superior ease of getting a bicycle out to ride.

So we dream on, study flat listings the instant they appear, and hope not to end up on the streets.  If need be, we’ll sail SR up the Thames and live aboard for a while at St. Katherine Docks.

Summer plans?  We don’t need no summer plans…  Basically, we have many expensive plane tickets bought to fly the USA place, but now all is up in the air since we have to move.  Ugh.  Could be a long summer.

Son turned back in his seventh grade laptop yesterday, and he feels fine about it.  I actually consider that a small victory.  I had a good talk with an Australian 1:1 expert yesterday (1000 student laptops, starting back in 1995), and it surprised me how so much of our tech planning is now about working on “balanced” technology use.  Yes, that was the theme of the ECIS Tech Conference we held two years ago, but it’s still the main question.  I’ve seen burn out, I’ve seen sometimes too much use, but what’s really needed is a good, healthy balance of digital info-loading, sharing, creation and enjoying the company of others, being challenged by nature, and sometimes just sitting in the sun.

Without the balance, the tools make no sense, since the ideas still come from us.  John Cleese stated this well.

Okay, time to get outside, or start packing boxes, one of the two…

7 visitors online now
1 guests, 6 bots, 0 members
Max visitors today: 7 at 12:57 am UTC
This month: 9 at 09-20-2017 05:23 pm UTC
This year: 38 at 05-27-2017 07:36 am UTC
All time: 84 at 05-06-2013 07:12 am UTC