+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1

    Join Date
    Sep 2013
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Filtering & Removing duplicates

    Hi,

    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.

  2. #2

    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
    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.

  3. Thanks to vikpaw from:

    Potato2013 (9th September 2013)

  4. #3

    Join Date
    Sep 2013
    Posts
    2
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    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.
    Hi Vikpaw,

    I followed your suggestions and it worked brilliantly!

    Thanks!

  5. #4

    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
    to the wonderful world of EduGeek
    Introduce yourself in the New Users Thread and enjoy the tea and eduhobnobs.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 1
    Last Post: 17th January 2011, 02:36 PM
  2. Removing Duplicate Folders in a users home
    By Arcath in forum Windows 7
    Replies: 1
    Last Post: 24th February 2010, 03:43 PM
  3. Replies: 10
    Last Post: 5th October 2005, 06:01 AM
  4. Restricting the use of removeable storage - do you?
    By tarquel in forum School ICT Policies
    Replies: 16
    Last Post: 10th July 2005, 04:13 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
  •