As we are in the process of looking at a new MIS I've been reading any threads on here and am concerned I'm missing something with some of the comments. We've seen Progresso, iSAMS and Aspen and liked all 3. I've seen the issues surrounding Progresso and that is putting a big question mark over them but we did like th elook of iSAMS and have had good reports from some local Independents using it. Am I missing something with it???? Aspen also looks very good even if there aren't many schools using it yet. I wopuld appreciate any feedback from those fo you that know what you're talking about
Last edited by vikpaw; 23rd April 2013 at 02:53 PM. Reason: error
SiobhanH (23rd April 2013)
Indeed Aspen MIS can be hosted on your site if you wish, even if it wasn't there are ways to get at your database we have customers who are doing that. Interested to know what you want to do with the database that means you need to get inside it, you have database level access from within Aspen, can run SQL scripts etc as much as you want. I suggest if you are wanting to modify the core database logic (which is all you would want to do and not be able to do in the application) then Aspen is not for you as we cannot support that... Not I imagine would many others.
What you gain in cost savings in having it in the cloud are worth investigating.
I should mention that as of our 4.9 release we are including dual factor authentication support. A big issue for cloud accessed products.
@PhilNeal what is the large African animal in the room you mention? :P
I would suggest you also check out our sticky thread on this forum or our dedicated support forum also hosted here on Edugeek - under Direct Support Forums. There is a raft of information here about the product I have already mentioned, and links to some YouTube demos.
Or just ask of you have any questions!
We simply have a large intranet that needs access to the timetable data, set data, examinations, pupil roll, pupil telephone numbers, doctors addresses etc. Currently I need to run scripts and programs to grab all this information from E1 and place it into an SQL database for our intranet to use. It would be much friendlier for our Intranet to simply access the required information from the MIS database directly.
In our experience cloud is bad for critical components. E1 was down pretty much all of yesterday for example, no cover could be scheduled, no exam information could be checked, registers couldnt be entered etc. If it wasnt for my intranet copying chunks of pupil information we wouldnt have had pupil contact numbers for emergencies. None of my core systems (intranet, email, moodle) have ever been down (short of a reboot at lunch time for planned reasons!).
With Schoolbase, you simply set the permissions for the appropriate people to look at what they want through Schoolbase. There is no need for Doctor's information, timetables, etc to beextracted on the intranet. The teacher logs in to schoolbase and can see their timetable, room bookings, mark the registers, emergency contact info (if allowed), etc through that.
Have you looked at iSAMS?
We're an independent and extra various bits of data from the MIS for use in several other systems.
Time to pull the quote out again!
Originally Posted by CAM
Without going into too much detail we have an inhouse .net developer who has built up our intranet for bits not normally found in an MIS - it isnt intended as a replacement as it only fills in bespoke requirements rather than an entire systems (it wont create census reports, registration, timetable, exams entry from secure results etc etc). For instance, our pupil report does the following:
Staff opens intranet which is SSO inside our perimeter. Opens the relevent report which changes depending on the time of year (sometimes a comment, sometimes simply grades, sometimes it is based on exam results). The exam results are automatically filled in at the appropriate times, other times we have effort target attainment with a trend displayed from previous reports and/or exams (colour coded for a weighting scale i.e. if a person has consistently underachieved). Automatic "clubs" reports are generated depending on what clubs have been attended vs signed up for. Attendance is calculated and appears next to the comment for the teacher to write about (attendance isnt shown as a figure on the report). Form tutors are emailed when all year reports are in and emailed at deadlines as to outstanding reports. Printouts are created as necessary with different layouts depending on the time of year and type of report (simply press print to preview after selecting the range). SMS is sent to parents automatically depending on the time of year, preference and exam results criteria.
That is just the pupil reports. We have pupil pastoral tracking that generates house colours, headmasters awards, music awards and automatically emails the correct people (autoprint was disabled as the paperbin using the card was used for something else, printing is done manually by clicking the link in the office email), clubs registration (outside of normal registration as clubs are not compulsory) which generates billing reports and emails to the correct admin staff, learning support referral system again emailing the correct LS staff based on the referral, specific learning difficulty generation linked to individual education plans and specific learning plan, EYFS tracking plus many many little foibles that certain teachers ask for (automatic excel spreadsheet generation for departmental reports), exam seating planner with archive (allows split rooms, external candidates not resident to the school) parents evening scheduler that allows single slots for siblings as appropriate.
Having access to the database simply makes this work. We have managed to make it work from the closed system that is E1 although chunks of data couldnt be grabbed effectively - timetable and exam results are particularly tricky but doable in a manual fashion (luckily these are predictable changes so I can run a manual update at these times!). Oddly enough I only extracted certain data as when we moved to E1 from phoenix we were promised all sorts of things with respect to extracting data via their PI sync tool (which turned out to be bunk), I then took to grabbing and replicating as much as I could in case of a connection failure. Good job I did....
coincidentally, the doctors information is used when creating trip forms on our intranet. You choose a set of recipients (or a preset list for the common trips taken such as sports fixtures), add the information about a trip and two sets of forms are generated, one to send to pupils regarding the trip with all the generic detail and one for the teacher to keep as a trip portfolio containing relevent medical information, contact details and special needs.
So for an MIS (for us) a modular system is good as we wont need to pay for bits never used (which is why schoolbase attracted me). Database access is good as we can use the database for our own "read only" needs.
If aspen can be hosted locally how is it you cannot get at the database data? Is it a bespoke database? encrypted with an private key? Is it the web files are hosted locally (say on our existing IIS system) but the core database is hosted externally? Does your SQL allow an "sp_addlinkedserver" approach thus I could link my own server in some way - I havent thought this through yet with regards to security and permissions assuming it is an IIS based system etc etc. Obviously the SQL link approach would need to be able to be scheduled as I dont like the idea of logging on to an MIS to run an update again.
Last edited by KK20; 24th April 2013 at 09:11 AM.
[QUOTE=KK20;959055If aspen can be hosted locally how is it you cannot get at the database data? Is it a bespoke database? encrypted with an private key? Is it the web files are hosted locally (say on our existing IIS system) but the core database is hosted externally? Does your SQL allow an "sp_addlinkedserver" approach thus I could link my own server in some way - I havent thought this through yet with regards to security and permissions assuming it is an IIS based system etc etc. Obviously the SQL link approach would need to be able to be scheduled as I dont like the idea of logging on to an MIS to run an update again.[/QUOTE]
You can access the database, I am saying that if you intent to make out of application changes to it then it is not supported.
Aspen's database is flat with little database logic at the core table level. Our logic is help within the application data dictionary level which offers distinct advantages for security and application processing, not to mention extremely flexible (because you never change the database, only the mappings and logic at the application, you can more or less do whatever you want within the database). The downside to this is if you want to tap into the SQL tables directly you bypass elements of record security (Don't worry, this doesn't make Aspen any less secure this way!!) as well as not having access to the table field names etc.
If you want to talk more on this, give me a ring we can go into detail.
I guess I would like to understand more about the requirements a known MIS cannot provide and see how much could actually now or with local configuration be met with Aspen MIS.
But why do you need database level access for extracting info if you can get access to all the data via the interface through reports which can be scheduled and automated?
The only reason for DB access would be to make your own bulk data edits, e.g. change all 01 numbers to 020 etc. but most modern systems let you do that through the interface too. Aspen does, iSAMS does, Engage does CMIS does . . .
If you really do want to change the structure of the DB, then that's scary ground, but from what i understand, Aspen let's you add lots of 'fields' for your own use through the interface too, as do all the other systems.
I'd be interested to compare a list of providers and see what info they don't let you access easily or in the right format.
I'm also interested to know why it seems Aspen cannot do what is needed within the application which would remove the need for the additional seperate interface. I get it if you want to pull data from other MIS systems... but if they were all in Aspen, Aspen has a top level trust layer that culminates all data from all schools, this sits above where other MIS systems usually sit, which is at the school level.
There are currently 1 users browsing this thread. (0 members and 1 guests)