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. ...
10th December 2009, 11:46 AM #1
10th December 2009, 12:28 PM #2
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.
10th December 2009, 12:33 PM #3
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.
10th December 2009, 12:35 PM #4
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.
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.
2 Thanks to Sivadam:
bossman (10th December 2009), znova (10th December 2009)
10th December 2009, 03:06 PM #5
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?
10th December 2009, 03:13 PM #6
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.
10th December 2009, 03:20 PM #7
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.
10th December 2009, 03:29 PM #8
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!
10th December 2009, 03:37 PM #9
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!
10th December 2009, 04:31 PM #10
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!
10th December 2009, 07:17 PM #11
This document may be useful.
Thanks to Sylv3r from:
znova (10th December 2009)
10th December 2009, 10:34 PM #12
Incredibly useful thanks!
Originally Posted by Sylv3r
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!
10th December 2009, 10:42 PM #13
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!
11th December 2009, 10:20 AM #14
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!
11th December 2009, 01:45 PM #15
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?
By mbyrew in forum MIS Systems
Last Post: 16th September 2009, 05:34 PM
By CadlaM in forum MIS Systems
Last Post: 13th January 2009, 03:20 PM
By mmuk08 in forum MIS Systems
Last Post: 24th September 2008, 04:55 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)