be able to add a query to the duplicate constituent tool

I want to be able to dedup records a group at a time. I have over 16,000 duplicate records. that is overwhelming. A large portion are from a database merge. I am in the process of importing new records that are from a specific county and if I was able to use a query to dedup them after importing it would be very helpful.

  • Guest
  • Dec 17 2013
  • Attach files
  • Guest commented
    March 17, 2016 23:27

    Why has the query option gone now? Please bring it back ASAP

  • Guest commented
    March 17, 2016 23:27

    I have however found a workaround for this. View the report, export to a CSV, delete all columns that are not the ConsID, use import to create a query using this.

  • Guest commented
    March 17, 2016 23:27

    I agree with Nicole's suggestion to merge.

    My issue has been more related to the need to do an import and then check for duplicates. The "check for duplicates" functionality in import doesn't work that well and can cause long imports to "hang" at the end.

    You can always create a static query in your de-duping process, and then add more helpful columns (suffix, birthdate, etc.) to your query output. I never print the reports anymore - just work through my potential duplicates using the query.

  • Guest commented
    March 17, 2016 23:27

    Unfortunately you now have to run the report in order to botch up a query - create a static query is no longer an option.
    I'm the same as I'd prefer to filter the list further so use query to run through it again. My workaround works for now but I still hope the create a query option will return soon.

  • Guest commented
    March 17, 2016 23:27

    I need a solution to this ASAP. It is incredibly frustrating to know that I have duplicates from a recent import (even with Import-O-Matic) and that I can't use the new duplicate record finder tool on just those records first.

  • Guest commented
    March 17, 2016 23:27

    Please fix this ASAP

  • Guest commented
    March 17, 2016 23:27

    Combine all the ideas that mention adding a query to the duplicate constituent tool so we don't have 25 different ideas with 40 votes each

  • Guest commented
    March 17, 2016 23:27

    Importing gifts (to existing members) is a basic functionality which seems to have been lost in NXT ('downgraded'?).

    When Importing 'New' Gifts to 'Existing' records, I have relied for years on the process described in full detail for all admins in Knowledge Base Article Number: 41186.

    In order to import new 'gift' records (or even School graduation Alumni records, etc.) to 'Existing' members, you need a unique Identification number- Import ID; Member ID- from your existing constituent records, so you can update the record with the new imported gift.

    Up until now I have used the above article, in order to:

    A) Import all members from any external database;
    B) Use RE's Duplicate Checker, find the dupes of the existing vs the Imported members in our database;
    C) Use Duplicate Checker's Output Query function (now suddenly gone?) so as to collect those dupes together, and identify the already existing members with an attribute, so I can...
    D) ...Export those constituent's unique Identifiers- their IDs;
    E) So I can re-import those IDs and update the existing constituents with the new gifts...

    It seems this fundamental functionality has been lost..?

    So, the Question: Since Duplicate Checker no longer allows you to create the needed output query, how do I now mark the existing contituents, so I can export their IDs- So I can update their existing records with the new gifts..?

    Don't say Omatic Software- This is 'basic' administrative functionality which is has existed since RE v6, and has been so routine in RE (and competing Software), as to make it's disappearance almost mysterious...

    Blackbaud, whatever are you thinking..?

    I know other people must be still importing gifts to existing records out there... so there must be a new way... Thanks again. GO