+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, New SIMS database populated by School Merge utility in Technical; As a result of a school merger and changing to an academy we are to be given the 'opportunity' of ...
  1. #1
    NeilF's Avatar
    Join Date
    Mar 2008
    Location
    Blackpool, Lancs.
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    New SIMS database populated by School Merge utility

    As a result of a school merger and changing to an academy we are to be given the 'opportunity' of starting with a new, clean SIMS database and filling it with data from the School Merge utility. Does anyone have any experience of this process and are there any gotchas that we should be looking for? We've already been told to try to align our lookups, but I just wondered whether there was anything else that others have fallen foul of. If anyone has been through this, what timescale are we looking at for the re-creation of a working assessment system and did you plan in any rationalisation of the aspects/grade sets/templates or just import everything?

    Thanks in advance.

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Good luck.

    I would have thought you'd just CTF import the students and do everything else from scratch and just not bothered with the merge tool.

  3. #3

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,261
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    Am I missing something? Why merge a clean database with an existing one? surely you will end up with a copy of the database, and a few £££s lighter for the School Merge Utility.

  4. #4
    NeilF's Avatar
    Join Date
    Mar 2008
    Location
    Blackpool, Lancs.
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yes, that was an earlier conversation, but the merge utility was the chosen option. I am merely the data monkey.

    The merge is being done on two schools, the resultant merged database is what is being ported to the clean build.
    Last edited by NeilF; 3rd July 2014 at 09:23 AM.

  5. #5
    woody's Avatar
    Join Date
    Jun 2005
    Location
    Carlisle, Cumbria
    Posts
    624
    Thank Post
    3
    Thanked 21 Times in 17 Posts
    Rep Power
    24
    I presume they want to keep as much history as possible that won't be in the CTF but it sounds like a horrible job. Prepare for the worst (psychological trauma, migraines and nightmares) and then if it is any better than expected, you won't feel too bad....

  6. #6

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    It depends entirely on how much data you wish to preserve. CTF is clean but limited if you've been a power user.

  7. #7
    NeilF's Avatar
    Join Date
    Mar 2008
    Location
    Blackpool, Lancs.
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Woody: Yes, the idea is to get all students, teachers, contacts and agencies plus SEN and medical details then build on this. We then have to either import templates - which apparently have to be cloned if we wish to make changes, or, start creating all assessment templates from scratch.
    The schools databases will be sent to Capita when we break up about the 24th July, there is a 2 week turnaround for the merge and I have been informed that it will be completely unacceptable that there should not be a fully working assessment and reporting system in place at the start of the new school year in September. Hope for the best but plan for the worst - any data jobs in Lancs anyone?

  8. #8

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28° 31' 48.89", +28° 25' 37.42" ... if only.
    Posts
    3,261
    Thank Post
    182
    Thanked 375 Times in 304 Posts
    Rep Power
    183
    Quote Originally Posted by NeilF View Post
    The schools databases will be sent to Capita when we break up about the 24th July, there is a 2 week turnaround for the merge and I have been informed that it will be completely unacceptable that there should not be a fully working assessment and reporting system in place at the start of the new school year in September. Hope for the best but plan for the worst - any data jobs in Lancs anyone?
    Sounds like you are doing the right thing. You will need to be absolutely clear which data you want migrated.

  9. Thanks to creese from:

    NeilF (8th July 2014)

  10. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,523
    Thank Post
    375
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    If Capita are doing it, then brill. You don't have to worry about merging the data the right way for starters. They are very good a detailing what they will and will not do. Like @creese has said, be very, very clear what data you want migrated. Very clear.

  11. Thanks to matt40k from:

    NeilF (8th July 2014)

  12. #10
    NeilF's Avatar
    Join Date
    Mar 2008
    Location
    Blackpool, Lancs.
    Posts
    4
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Cheers everyone. I'll see how it goes.



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] New SIMS install not letting users log on
    By Number6 in forum MIS Systems
    Replies: 41
    Last Post: 13th April 2011, 08:17 AM
  2. Replies: 21
    Last Post: 18th January 2011, 01:20 PM
  3. [SIMS] Sims database structure
    By atfnet in forum MIS Systems
    Replies: 8
    Last Post: 12th October 2010, 11:13 AM
  4. Can't attach new blank SIMS database
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 4th July 2007, 02:49 PM
  5. New Sims Database
    By SimAda00 in forum MIS Systems
    Replies: 0
    Last Post: 10th January 2007, 12:27 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
  •