+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Restoring partial information from SIMS database in Technical; Hi gang, Back again to post something ONLY when I have a problem. Must stop doing this and post more ...
  1. #1
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    625
    Thank Post
    41
    Thanked 46 Times in 40 Posts
    Rep Power
    27

    Restoring partial information from SIMS database

    Hi gang,

    Back again to post something ONLY when I have a problem. Must stop doing this and post more often.

    Anyway, to the point, a teacher has been happily working on a marksheet in SIMS and has pretty colours on each person indicated marks, etc.
    Assessment Coordinator has added a couple of new columns and this has completely wiped all the colours off. Lots of work gone into this and it's all gone.
    Removing the columns doesn't bring the colours back, either, so the teacher in question has asked if I can restore the original from a backup.

    Now my understanding is that you can only restore a full SIMS database from backup or is there a sneaky way of extracting little bits?
    Or am I clutching at straws?

    Ta.

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,630
    Thank Post
    845
    Thanked 884 Times in 732 Posts
    Blog Entries
    9
    Rep Power
    326
    Is it possible to export marksheets? If so you, could build a new, temporary, SIMS server and restore your old DB to that just so you can export the working marksheets and import them?

    If not, alas I think you maybe clutching at straws.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    No partials, certainly not for something so intricate. A test db restore is best option but i'm not sure you'll be able to get the marksheet back. The best thing you can do is to check how it was set up and copy it.

    How was the teacher doing the colouring? I suspect just within the marksheet columns, rather than it being done at the template level, which is why the update to the template has effectively wiped out their marksheet and started it again. I think this could happen for any change as the marksheet is quite temporary.

    Exporting marksheets just dumps a spreadsheet (xml) file for importing data with.

    You could look at adding colour at template level, but then it will apply to all marksheets made from it.

  4. #4
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    625
    Thank Post
    41
    Thanked 46 Times in 40 Posts
    Rep Power
    27
    Ta gang,

    Kind of knew the answer but just wanted to confirm.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SQL2008 Attaching+Restoring Sims Database ERROR
    By ev32 in forum MIS Systems
    Replies: 14
    Last Post: 9th February 2012, 11:50 AM
  2. Replies: 47
    Last Post: 17th October 2011, 10:26 AM
  3. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  4. [SIMS] Sims database structure
    By atfnet in forum MIS Systems
    Replies: 8
    Last Post: 12th October 2010, 10:13 AM
  5. Restore sims database
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 8th April 2008, 10:39 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
  •