Updating with Importing Confusion

Brooke DennisLister
Brooke DennisLister
Fifth Anniversary Kudos 1 Participant Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions
I'm trying to update a group of records of constituents who attended an event. However, instructions say "Please note that when we are updating existing records, we will need an existing Import ID, Constituent ID, or SSN for the constituent and/or the item we are update"... Does that mean that in order to update these records I have to find each constituents ID or SS number?? That seems counter-productive; if I have to look up each constituent's ID # then I might as well just manually add the event they attended. This can't be correct... Please help!! 
Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions January 2026 Monthly Challenge
    For import, I second what Dariel Dixon‍ posted. 


    If you can create a query of the group of records (event attendees - edit those registered), you could possibly do a global change using that query. May depend on what you want to update.
  • Anna Zimmerman
    Anna Zimmerman
    Fifth Anniversary Kudos 2 Participant Facilitator 1
    I agree with all of this! 


    If you're adding NEW constituents, though, you won't need an ID or social. 
  • Madeleine Holdsworth
    Madeleine Holdsworth
    Tenth Anniversary Kudos 5 PowerUp Challenge: Product Update Briefing Feedback Task 3 Name Dropper
    It's still quicker to use import.  Also, be aware that some Import IDs are only accessible through export (I think Participant Import ID may be one of those), so you have to query then take it to export.  I usually separate participant imports into those that have constituent IDs and those that are new.  Check for the field info help at the bottom of the import screen and it will provide which fields are optional or required for the import.  Good luck!  It's clunky but once you figure it out, you will be fine.  I also save old import files for reference in case I need to look back at them to remember which fields that are needed....!

Categories