Updating Existing Soft Credit Amounts Via Import

Karintha Marshall

Hi,

I have over 1500 records that I updated the gift amount for. I realized after the import that the soft credits didn't dynamically update with that change. So I'm in import trying to update the amounts for the existing soft credit recipients. I choose when starting the import to Update existing records, I do not leave it on the default of creating new records. I also leave the option for the import to create new records unchecked.

I map all fields available in guide except SoftCredit Import ID (see screenshot below) because I don't know where to find that. Even when I do populate that header, RE Import isn't picking it up as a mapped field for reference. I'm not sure if that's a factor in this problem or not.

I get the same validation error every time: “Cannot have duplicate soft credits.”

My understanding from this message is that the import thinks I'm trying to add a second soft credit for the existing recipient to the same record. I'm not I'm trying to update the amount of the existing entry. This is why I thought that Soft Credit Import ID may be a factor but I don't know where to find that field in query.

Has anyone used import for this specific scenario with success. Or do you have any guesses/pointers? I'm on my third Blackbaud support rep trying to troubleshoot and not having much luck.

Update/Clarification: If I try to import using the Gift template fields, I get the error message above. If I try to import using the Soft Credits template, I get told the Import ID is required (even though I already have it populated in GftLnk). I tried adding that same import ID in a second column and mapping that as the Soft Credit Import ID, and the import runs, but fails, saying that Soft Credit Import ID doesn't exist.

This phantom import ID for soft credits is making me batty, because where is it?! >:-/

#softcredits #imports #importing #ImportingGifts #softcreditimporting

Karintha Marshall

2023-05-23 08_40_09-Help for The Raiser's Edge Enterprise - __Remote.png@Karintha Marshall

Adding screenshot as attached file in case it's easier to see that way.

Dariel Dixon

@Karintha Marshall I don't think you need to try to find that field in query. You may have to create an import file for this import using your query. That will allow that field to populate.

Karintha Marshall

@Dariel Dixon thanks, when you say create import file do you mean the option on a fresh import to create an import file, vs linking to a csv to update values?

Edit: Disregard, that question was redundant.