MIS Systems Thread, Filtering & Removing duplicates in Technical; Hi,
Our school has recently implemented a piece of software which requires a feed from Groupcall's Xporter program. We've been ...
5th September 2013, 02:20 PM #1
- Rep Power
Filtering & Removing duplicates
Our school has recently implemented a piece of software which requires a feed from Groupcall's Xporter program. We've been told that our feed may begin experiencing issues if we do not remove duplicate records in our database.
The records were:
Duplicates in StudentContacts(StudentContactId) Found
16784-15318 X 2
16792-16874 X 2
16833-13572 X 2
16855-16872 X 2
How would I remove duplicates from these ranges?
Sorry if this is a trivial task, but I've suddenly been given responsibility for SIMS and will need to learn fast!
Thanks for any help
Last edited by Potato2013; 5th September 2013 at 03:09 PM.
9th September 2013, 11:48 AM #2
You could do with knowing the details of the duplicates.
Make sure you have third party reporting access group and basic access to student / contact info.
Make a report based on student focus and include their name / reg, contact name, and from third party reporting part of the tree, ID, student ID and contact ID.
Hopefully one of these matches and will give you a name to work with.
You need to find and unlink duplicate contacts. We have this quite a lot. A parent adds their neighbour as an 'other contact' and instead of checking if that person is already on the system, say as a parent, they get created fresh. later on that record is linked to one of their younger kids who joins later, and suddenly families aren't linked together and duplicates abound.
With the name, you can look for them in the contacts area and check who they are linked to. Pick the correct one to stay, unlink the duplicate records. When that is all done, there is a routine in house keeping to delete unlinked contacts.
Hope that gets you somewhere close.
Thanks to vikpaw from:
Potato2013 (9th September 2013)
9th September 2013, 12:46 PM #3
- Rep Power
Originally Posted by vikpaw
I followed your suggestions and it worked brilliantly!
9th September 2013, 01:48 PM #4
to the wonderful world of EduGeek
Introduce yourself in the New Users Thread and enjoy the tea and eduhobnobs.
By browolf in forum Scripts
Last Post: 17th January 2011, 02:36 PM
By Arcath in forum Windows 7
Last Post: 24th February 2010, 03:43 PM
By Roger in forum Windows
Last Post: 5th October 2005, 06:01 AM
By tarquel in forum School ICT Policies
Last Post: 10th July 2005, 04:13 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)