+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Transfer to server in Technical; Hi everyone Well i have worked in many schools and its the first time i have came across Serco Facility ...
  1. #1

    Join Date
    Apr 2012
    Posts
    97
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    6

    Transfer to server

    Hi everyone

    Well i have worked in many schools and its the first time i have came across Serco Facility MIS system. Now the situation is that the school have pulled out of the local council,so we have just brought some new computers to replace these ones. How the council setup serco was just to create a partition on the computer it self and run it from there then before the receptionist goes home she pops in a backup tape.

    I wanna move all this data off this computer and put it on the server so it will be backup on a weekly basis.What would be the recommended way to do this?

    map a drive with everything from that drive?

  2. #2
    robk's Avatar
    Join Date
    Nov 2005
    Location
    Ashbourne
    Posts
    544
    Thank Post
    183
    Thanked 130 Times in 109 Posts
    Blog Entries
    1
    Rep Power
    49
    There is most likely a SQL database on that machine somewhere which will need moving etc, If the school has no support from the LA perhaps a call to serco may be in order? Moving the database and re-installing the software (and assocated client files) is something that is very doable, but you will want to be able to back up the system and have support in the process.

  3. #3
    themightymrp's Avatar
    Join Date
    Dec 2009
    Location
    Leeds, West Yorkshire
    Posts
    1,276
    Thank Post
    218
    Thanked 236 Times in 204 Posts
    Rep Power
    75
    If CMIS has been installed on a workstation it is possible it may have been setup to work off an Access Database. Either way, if its Access or SQl, moving it onto a server should be straightforward. On the server, assuming you are going to use SQL, you will need an appropriate SQL plugin for your backup software i.e. Backup Exec. This will allow backups to run whilst the system is running which makes life easier. To automate CMIS backups you have to use a SQL backup procedure, the built in Facility software backup feature is manual only

  4. #4

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    3,102
    Thank Post
    885
    Thanked 610 Times in 479 Posts
    Rep Power
    281
    I'd call serco and talk to them, you'll be paying enough for support, best get your money's worth. If you explain the situation i'm sure they will be helpful.

  5. #5

    Join Date
    Apr 2012
    Posts
    97
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    6
    I have called serco there have refused to help because im not part of the school on their system.

    I think this may be more trouble then i expected haha

  6. #6

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    3,102
    Thank Post
    885
    Thanked 610 Times in 479 Posts
    Rep Power
    281
    In which case you need to get someone higher up the foodchain to call them and explain whats going on, because if you aren't supported you won't get updates and eventually the school will get into all kinds of grief with the DfE as the data exports won't give the info required as the updates change what gets exported. They will probably have to part with money.

  7. Thanks to Oaktech from:

    vikpaw (27th May 2012)

  8. #7
    themightymrp's Avatar
    Join Date
    Dec 2009
    Location
    Leeds, West Yorkshire
    Posts
    1,276
    Thank Post
    218
    Thanked 236 Times in 204 Posts
    Rep Power
    75
    +1 for what @Oaktech said. You need to be supported in order to get the updates to be able to do Census reports etc. There should be somebody higher up with details registered with Serco (the head maybe?) who will have to have you added onto the system.

    I can give you a fairly good set of instructions to do the data move but you need to get yourslef sorted with Serco first

  9. #8

    Join Date
    Apr 2012
    Posts
    97
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    6
    Quote Originally Posted by themightymrp View Post
    +1 for what @Oaktech said. You need to be supported in order to get the updates to be able to do Census reports etc. There should be somebody higher up with details registered with Serco (the head maybe?) who will have to have you added onto the system.

    I can give you a fairly good set of instructions to do the data move but you need to get yourself sorted with Serco first
    Basically no one has details registered with serco, the local council took the agreement out with serco for there schools, there support. There installed for the school prt of the support cost.

  10. #9

    Oaktech's Avatar
    Join Date
    Jul 2011
    Location
    Bournemouth
    Posts
    3,102
    Thank Post
    885
    Thanked 610 Times in 479 Posts
    Rep Power
    281
    then you need to speak to the LA or get the head to write a letter to serco explaining, to get your details registered so they will speak to you. I think, if you've come away from the LA you will need to get your DfE number re-registered with serco so you become your own entity with them. This WILL cost money!
    Last edited by Oaktech; 21st May 2012 at 04:14 PM.

  11. #10

    Join Date
    Jul 2009
    Posts
    294
    Thank Post
    8
    Thanked 43 Times in 37 Posts
    Rep Power
    16
    hi ryan it looks like you might need to look at the bigger picture here.
    you are running a MIS with NO external support and no Local authority support, correct?

  12. #11
    themightymrp's Avatar
    Join Date
    Dec 2009
    Location
    Leeds, West Yorkshire
    Posts
    1,276
    Thank Post
    218
    Thanked 236 Times in 204 Posts
    Rep Power
    75
    Quote Originally Posted by andydis View Post
    hi ryan it looks like you might need to look at the bigger picture here.
    you are running a MIS with NO external support and no Local authority support, correct?
    Good point!

  13. #12

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    634
    Thank Post
    99
    Thanked 134 Times in 104 Posts
    Rep Power
    68
    Ryan,

    This sounds like a recipe for disaster long term. If the school have pulled out of support with the LA, they will need support from us and they'll need new releases etc otherwise they won't be able to completely legal requirements such as census returns. Given that there was one last week it's possible theyre behind already and don't even know it.
    Please PM me your details so that I can put the right people at Serco in touch with the right people at the school, and the authority. Let's fix the roof before it rains rather than waiting for a downpour and everyone involved getting soaked.

    Thanks
    Mic Sanderson
    Customer Success Manager
    Serco Learning



    The above post is my own and does not represent the opinions of my employer or their associates.

  14. 3 Thanks to michael2k6:

    john (21st May 2012), Oaktech (21st May 2012), vikpaw (27th May 2012)

  15. #13

    Join Date
    Apr 2012
    Posts
    97
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    6
    Quote Originally Posted by michael2k6 View Post
    Ryan,

    This sounds like a recipe for disaster long term. If the school have pulled out of support with the LA, they will need support from us and they'll need new releases etc otherwise they won't be able to completely legal requirements such as census returns. Given that there was one last week it's possible theyre behind already and don't even know it.
    Please PM me your details so that I can put the right people at Serco in touch with the right people at the school, and the authority. Let's fix the roof before it rains rather than waiting for a downpour and everyone involved getting soaked.

    Thanks
    Mic Sanderson
    Customer Success Manager
    Serco Learning



    The above post is my own and does not represent the opinions of my employer or their associates.
    Just to let you know its working fine now. Cmis is only run off a excel database so no sql needed. Mapped a drive and then put the shortcuts on the users desktop.

    Its working great there now.

    The school are moving over to RM mis system in the summer holidays,so this will do until then

  16. #14

    Join Date
    Jun 2007
    Location
    Wakefield, West Yorkshire
    Posts
    634
    Thank Post
    99
    Thanked 134 Times in 104 Posts
    Rep Power
    68
    Hi,

    It's either not Serco software or it's not running in Excel - just for anyone else out there, it might be running in access on a peer to peer system if in a primary school rather than putting SQL on one of the clients.
    Sounds like you've found a solution in the interim, if you've got any issues post back. Bear in mind that if one of the other machines on the peer to peer still has an open connection to the database then any automated backup of the mdb file you have isn't going to do much.

    If i were you i'd be looking to set a startup in the BIOS of that machine at a particular time followed by a scheduled batch file of xcopy to ship it over to the server, then another scheduled batch to shut said machine down.
    Or move it to the server, point the dsn at that, and schedule a shutdown script on the client machines so that if there's anything left on overnight it's shutdown before the normal server backup takes place.

    Mic



SHARE:
+ Post New Thread

Similar Threads

  1. Teacher Access to Server Rooms
    By robinhood in forum School ICT Policies
    Replies: 22
    Last Post: 27th March 2007, 11:03 AM
  2. NT4.0 to Server 2003 Profiles
    By TSCNUK in forum Windows
    Replies: 3
    Last Post: 21st November 2006, 11:34 AM
  3. Transfer Accounts & Passwords from NT4 PDC to Server 2003
    By OutToLunch in forum How do you do....it?
    Replies: 11
    Last Post: 24th July 2006, 03:03 PM
  4. Upgrading a server to server 2003 R2
    By tosca925 in forum Windows
    Replies: 4
    Last Post: 28th June 2006, 10:39 PM
  5. Cant add HP 1100 DTN to Server 2003
    By ChrisH in forum Hardware
    Replies: 1
    Last Post: 8th December 2005, 11:53 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •