+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 24
MIS Systems Thread, Siblings in SIMS in Technical; Hello, I am trying to tidy up our SIMS database in preparation for issuing parental logons for our learning platform. ...
  1. #1
    znova's Avatar
    Join Date
    Jan 2009
    Location
    Derbyshire
    Posts
    154
    Thank Post
    20
    Thanked 5 Times in 5 Posts
    Rep Power
    14

    Siblings in SIMS

    Hello,

    I am trying to tidy up our SIMS database in preparation for issuing parental logons for our learning platform. Unfortunately we don't have a data manager and everyone just inputs 'stuff' into sIMS without checking validity of the data. Obviously, this creates a problem when I want to issue parental logins for the learning platform - I found out about 1/3 of our data is incorrect - missing first names, missing parental addresses, duplicate entries. AAAHHH!

    The biggest headache though is missing siblings; you can't edit the family links tab so that leaves me with several logins for the learning platform! Is there any way to input this data and link siblings?

    Our NM thought the only way to link siblings was during the record creation process - please don't tell me I have to delete one of the records and add it again?

    Because that's so not going to happen! I can foresee me dishing out the parental logons: 'Here is one for your Y7 boy, one for his sister in Y10 and for good measure one for Y11 brother'....

    PLEASE help!

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    Siblings are automatically linked via the contact's parental status. If a sibling is wrong it is because the parental status is wrong. There is a tidy 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
    We have many schools who have created a new contact for a sibling joining, instead of linking to an existing contact. Then wondering why they wouldn't link. On investigation we have found at least 4maybe 6 'similar' contacts.

  4. #4
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    I had very similar problems before I could Provision Parents for SLG.
    I have physically trawled though most of our contacts. The issue of siblings not being linked is very often linked to duplicate contacts. This was my first starting point. Moving Linked Pupils to just one of the duplicate Parental Contacts and then deleting the Unlinked parent restores sibling links in SIMS.

    Most Duplicate Contacts arrive, not through errors by our admin staff, but via CTF or ATF imports. If the source data has the names of the contacts in a different format to what the school has, then issues of duplicate contacts can occur. When CTFs etc etc come in from different MIS Systems to the one that you are using then this is often also an issue.

    Sorry, I can't think of an easy way to solve this but to help you it is possible to run reports from SIMS to identify where duplicate contacts exist. The standard Report for this in SIMS is via Focus, Contact, Duplicate Contact Check. But you can clone this and, as with all other Reports, edit it to your own design.


    Incidently,
    If you have Parents who are also members of staff at the school, then I bet you have 2 instances of this person in SIMS. This is also incorrect and the two instances need rationalising. Provisioning both parents and staff for SLG produces two different log-ins which SLG cannot consolidate, as SIMS has no idea that the two are connected in any way. I assume that your learning Platform will have the same issue.
    Last edited by Sivadam; 10th December 2009 at 12:56 PM.

  5. 2 Thanks to Sivadam:

    bossman (10th December 2009), znova (10th December 2009)

  6. #5
    znova's Avatar
    Join Date
    Jan 2009
    Location
    Derbyshire
    Posts
    154
    Thank Post
    20
    Thanked 5 Times in 5 Posts
    Rep Power
    14
    Thanks everybody!

    I agree the issue is mostly Primary school imports; how do I solve it though?

    For example, our school admin lady also happens to have 2 kids in school - and you guessed it, they are not linked in SIMS. Now both have just 2 sets of records(1 for mam, 1 for dad) and they are almost identical so no duplicate info there! They are not completely identical though, so is this where the problem lies?

    Am I to understand that if I copy parents contact details from one record to the other it should link them? Or should I go through the Focus|Person|Contacts|Associated Students path(which looks longer!)

    Surely with LP deadline looming this must be a common problem?

  7. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Select the Contact that you think is most correct.
    Link (add) the pupils to this parent.
    Unlink (delete) the pupil links from the Contact you do not want to use.
    Run:- Housekeeping - Delete Unlinked Contacts.
    Your Siblings will then be linked via the correct Contact.

    I am afraid you have to do this with ALL Duplicate contacts individually.
    I do NOT think there is a Contact Tidy. There is for Addresses and for Agencies/Agents but not for Contacts - as far as I am aware.
    Last edited by Sivadam; 10th December 2009 at 03:18 PM.

  8. #7
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    You will need to tidy the addresses first as this causes a lot of the problems with duplicate contacts in the first place. I seem to remember that tidying the addresses may have resolved some of the dupliacte contacts, but couldn't guarantee that.

  9. #8
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    This is a matter of choice, I think.
    If the surplus Contacts are deleted first then some of the issues, but not all, with duplicate addresses are resolved. It all depends if the addresses of each of the Duplicate Contacts actually match or not.
    I think that whichever you do first helps the second process!

    The whole area is a minefield!

  10. #9
    znova's Avatar
    Join Date
    Jan 2009
    Location
    Derbyshire
    Posts
    154
    Thank Post
    20
    Thanked 5 Times in 5 Posts
    Rep Power
    14
    I am just hoping that our sims server doesn't buckle under the strain! Just removed 2 faulty memory sticks from it and new ones are not on the horizon cause we are broke!

    Discovered another problem - my job role does not give me enough access rights to sims, as I've just noticed(can't even scan for duplicate contacts!

  11. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Now that's where that implement in my avatar's hand comes into it's own - for extracting more rights out of the System Manager!

    The trouble is ............... that is also me!

  12. #11

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,268
    Thank Post
    380
    Thanked 388 Times in 343 Posts
    Rep Power
    150
    This document may be useful.
    Attached Files Attached Files

  13. Thanks to Sylv3r from:

    znova (10th December 2009)

  14. #12
    znova's Avatar
    Join Date
    Jan 2009
    Location
    Derbyshire
    Posts
    154
    Thank Post
    20
    Thanked 5 Times in 5 Posts
    Rep Power
    14
    Quote Originally Posted by Sylv3r View Post
    This document may be useful.
    Incredibly useful thanks!

    On another note, I shall be getting more access to SIMS in the morning - well the school can't believe their luck that someone actually wants to sort the mess out!

    But if I don't do it then the learning platform rollout will be a mess so here it goes!

    Thanks everone!

  15. #13
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,450
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Good Luck to you, zdenka.

    And watch out for the usual SIMS crash when you have edited so many on the trot without a break. It's just a deliberate ploy to prevent the 'heebie jeebies' kicking in and to also signify it's time for a much needed cup of coffee!

  16. #14

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,289
    Thank Post
    406
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    I must have spent about 3 weeks early this year tidying all our contacts throughout the database, must have deleted about 200 duplicates.... It better stay that way once I leave!

  17. #15
    znova's Avatar
    Join Date
    Jan 2009
    Location
    Derbyshire
    Posts
    154
    Thank Post
    20
    Thanked 5 Times in 5 Posts
    Rep Power
    14
    Similar question: where do these unlinked contacts come from? I am very much tempted to delete them all!..MWAAAhhaa

    I deleted a duplicate parent record from their student record - surprise, you can still find it when you search contacts. However, it doesn't appear in Unlinked contacts??? Confused?
    I would assume that's where it would go?



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 5
    Last Post: 16th September 2009, 05:34 PM
  2. SIMS edit pupils' details crashing SIMS.net
    By CadlaM in forum MIS Systems
    Replies: 12
    Last Post: 13th January 2009, 03:20 PM
  3. SIMS Report Class List with Siblings
    By mmuk08 in forum MIS Systems
    Replies: 1
    Last Post: 24th September 2008, 04:55 PM

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
  •