Changing Specific Primary Solicitor to Former Primary Solicitor

Brana Serafin
Brana Serafin
Third Anniversary
in Blackbaud Raiser's Edge NXT®: General Discussions

Hi all!

I need to change a specific Primary Solicitor to Former Primary Solicitor.

I have identified the segment in a query. However some records have more than one Primary Solicitor. So my problem arises when I am in Global Change and I try to replace the Solicitor Type: Primary Solicitor to the new Solicitor Type: Former Primary solicitor. If I just do this it changes ALL Primary Solicitors in my segment.

I want to be able to specify which Primary Solicitor I want to change in Global Change. Is this possible?

Comments

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions January 2026 Monthly Challenge

    As @Joanne Felci posted, this can be done by import.

    Unfortunately it can not be done by global change - real pain I've had to deal with several times. You're correct it will change all relationship types and/or put an end date on all open relationships.

    I admit I've had trouble with the getting the import correct so am bookmarking this thread so I can reference Joanne's post when I try it again. Just hired new MGO and will need to make some assignment changes. Have done it manually with a query and screen set to open on relationship tab. Wasn't too bad if not a huge # needing change. :)

  • Joanne Felci
    Joanne Felci
    Tenth Anniversary Kudos 5 Name Dropper Participant

    The assigned relationship Import ID is the ID for the actual relationship record (see screen shot of export below - these are the fields you want to include). The Solicitor Import ID is the Import ID of the solicitor's const record (not the con ID but the import ID - they are different). And this value would go into a field called Solicitor Key when you do the import and yes it will be the same value for every record assigned to that solicitor.

    Hope this helps.

    8cf30ca8796ad485ddb31b692185fc36-huge-as
  • Sheila Wortham
    Sheila Wortham
    Ninth Anniversary Kudos 2 Name Dropper Participant

    This is only possible if you have an end date set in RE or if you have the names of former solicitors to match with your criteria. This is how I've done it in the past and been successful in updating our system.

Categories