MIS Systems Thread, Is this correct? in Technical; Originally Posted by box_l
You have just listed the four options I suggested a couple of weeks ago.
The reason ...
2nd October 2013, 12:48 AM #16
Originally Posted by box_l
Ask the LEA,
When we became an academy we technicaly had NO RIGHT to our predecessor data, we archived the data and gave it to them on CD. That covered that base. Technicaly thought we had a Virtual machine which was switched off with the old MIS lying dormant in case we needed it. Good job realy as the LEA lost the CD!
if you need the data then 1 or 2 is the only real option... But as your already in battle for 2013 option 2 would require reconstruction of new data from the new year..
So option 1 is probbaly more favourable.
You could get a second DIRTY SIMS build with all the previous data but capita will charge you for that too, last experince was that it would cost the same as the running live build.
Building your own front end to the data will cost more than the other options..
2nd October 2013, 09:44 AM #17
If it stores SEN data that you don't have archived elswhere, it's a lot more than 7 years.
2nd October 2013, 01:08 PM #18
The DfE changed their minds on that one, they used to say you had to request exactly what you wanted from the LA under the DPA if you were a type 1 (labour) academy - along with a new MIS, but now they said you can keep it as it was too costly to schools to create a new MIS on top of all the other costs.
Originally Posted by twin--turbo
2nd October 2013, 01:22 PM #19
I can confirm that in many cases new academies are allowed to keep the old school's data. However census returns have to be adjusted to exclude data from the previous school.
2nd October 2013, 10:52 PM #20
There are only a few tables you need for accessing the basic data you need. Just write a script to pull it into excel or access and go from there. You can do that straight into the db without much fuss. If those aren't skills you have, any DBA worth their salt will be able to work it out without any issues. That would be a lot cheaper, even if you had to pay for it doing, than the license fee to retain the software.
Just to clear up, Advanced Business Solutions purchased Serco Learning from Serco in a large acquisition on Jan 1st 2013. With that, all of the contracts migrated. Serco generally used to just let you continue with whatever version you had at the time, for read only purposes. Advanced don't take that view, and it was never part of the contract previously, the software is licensed on a yearly basis.
3rd October 2013, 11:12 AM #21
You could also look at 3rd party online reporting systems to see if they could fit your needs. Just for internal use by staff in this case of course.
Originally Posted by twin--turbo
3rd October 2013, 02:27 PM #22
I understand that Serco (Now Advanced Learning) have always provided their non-cloud (why would Phil Neal even mention cloud?) Facility MIS has always been provided to individual schools on a 'lease' type agreement. Am I also correct in thinking that SIMS is also licenced on exactly the same basis for schools / acadamies buying direct from Capita and not under an LA agreement?
3rd October 2013, 02:35 PM #23
In this instance a licence for Facility would be required - easier I would have thought to move all of the data into SIMS - that way no additional software is required
Originally Posted by jcs808
3rd October 2013, 03:54 PM #24
@APC it was my mistake - I didn't read the first post carefully enough and just assumed it was a cloud issue. This is rather different and strange!
3rd October 2013, 04:51 PM #25
You mention the school was concluding the contract with SERCO, was this before the takeover? is there any finalisation documentation, maybe something is covered there, even if in spirit not in writing, but chances are ACS won't have to honour that.
I would have thought that the data is yours, and they have a responsibility to give it to you in a reasonable format, especially if you are leaving. The problem is, if you've left it too late....
3rd October 2013, 09:16 PM #26
We do have copies of the exported data from when the contract ended and it looks like we still have the full exports that were given to the SIMS migration team.
We are going to ask them to import ALL the data into a "dirty" database so we still have access.
This will cost the school, but no where near as much as a license to use facility.
Relatively small?, 60% of the normal license fee!
Not everyone wants their data in the "cloud", I don't. It belongs on the schools site IMHO.
I don't make many threads on here, but when I do, I appreciate comments like your first and second paragraphs. You provided useful information.
The third paragraph is a sales pitch and not required.
Thanks to everyone for their input.
3rd October 2013, 09:21 PM #27
Another thought occurred to me, rather than using Access or Excel, just download and use SSRS. Report builder 3 would be a good option on the back of that too.
And Steve, it's nice to finally see some formal presence on here, I tried to get us some senior input for years, beginning to wonder if I should have stayed just to see this! Be careful with the sales pitch though, the mods can get grumpy quickly; the reputation of the company in terms of customer service and communication will massively improve if there's some positive input on the boards.
3rd October 2013, 09:27 PM #28
Can't blame the guy, must be losing schools faster then pens from the store cupboard. I think EduGeek's tagline should be "beating corporate MD's with common sense since 2005", that's the second MIS MD to take a beating today.
@michael2k6 - be awesome if we had a common report tool with a proper data warehouse across multiple MIS solutions, make switching MIS dead simple.
3rd October 2013, 09:45 PM #29
The CMIS database schema is relatively open and easy enough to navigate and at that level it is your data, so I can't see they can demand you delete the MSSQL database. Still, time to have a look at the licence - especially since we are on a countdown to potentially replacing CMIS.
Originally Posted by box_l
3rd October 2013, 10:08 PM #30
Disclaimer: we're an MIS supplier. OK, so out of interest, how would you guys envisage the switching process works? Should you be allowed to keep historical data free of charge?
Clearly in a cloud based solution this has cost implications for the supplier so a charge would not be unwarranted. We've never yet had a school leave us, but if/when that day does happen, we'd probably offer a package whereby we'd host the customers data indefinitely for a small annual charge if they wanted to go down that route. In our contracts, it states THE SCHOOL OWNS THE DATA. With non cloud based solutions I don't know why a supplier would charge you, since they are no longer going to be providing support or updates and it costs them nothing for the old software to simply sit there. To my mind that's just profiteering, but hey, I would say that.
Aside from those solutions, a good reporting engine would allow for most data to be exported. You might lose a bit of data that you simply can't get out, but transcribing that manually would be a lot cheaper than paying your old supplier for years to come. That's the route I suggest for the OP. A good DBA would get that data out no problem in a couple of weeks into a format you can probably make do with for historical data. Another option might be to ask the new supplier to migrate all your historical data into your new system. Some suppliers offer that service and some don't. Whilst more expensive, at least you'd have it all in one place.
By Mr.Ben in forum Coding
Last Post: 26th March 2013, 07:57 PM
By 2097 in forum Thin Client and Virtual Machines
Last Post: 19th June 2012, 05:19 PM
By MattDLEA in forum Licensing Questions
Last Post: 9th December 2011, 03:42 PM
By iSteve in forum Windows Server 2008
Last Post: 12th July 2011, 01:42 PM
Last Post: 12th December 2005, 04:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)