Skip to main content

#Nonprofit Success Pack22 discussing

We have finally (YAY!) integrated Give Lively with Salesforce. And we've started using Give Lively events for some programatic events that are free but with an option to purchase a $10 ticket to support the work. We love having everything flow directly into Salesforce. However the many $0 opportunities that are being categorized as "donations" are confusing our reporting. My tentative solution is to delete these $0 opportunities as we typically don't consider attending this event as something that gets an opportunity - only a campaign member added.  Has anyone had a similar situation?  I'm thinking a flow that identifies and deletes $0 opportunities created by Give Lively 

 

#NPSP  #Nonprofit Success Pack  #Give Lively  #Events

1 answer
  1. Aug 18, 7:19 PM

    Congrats on getting Give Lively wired up! I would steer away from deleting these, deletion is fragile, the sync usually just recreates them on the next pull and you lose the registration link. Treat it as a categorization problem instead. A few layers, best first: 

     

    1. Fix it at the source mapping if you can. Check whether Give Lively's Salesforce mapping lets you route free/0-dollar registrations to just a Campaign Member (or a non-donation object) instead of creating an Opportunity. If that toggle exists, it is the cleanest fix, the junk never gets created. 

     

    2. If the integration creates the Opportunity regardless, do not fight it, reclassify it. Put free/ticket registrations on a dedicated Opportunity Record Type (e.g. 'Event Registration' or 'Ticket'), separate from your 'Donation' record type. Then two things fall into place: 

    - Exclude that record type from NPSP donor rollups so it never inflates lifetime giving. NPSP lets you exclude specific Opportunity Record Types/Types from rollups (NPSP Settings > Donations for the legacy rollups; with Customizable Rollups you exclude via a filter group). That directly fixes the 0-dollars-counting-as-donations problem in your donor totals. 

    - Your donation reports and dashboards then filter to Record Type = Donation (or Amount greater than 0), so the free registrations drop out cleanly. 

     

    3. Track the free attendance where it belongs, as a Campaign Member on the event Campaign (which it sounds like you are already doing). That is the right home for 'attended,' and it keeps your engagement reporting intact without touching giving numbers. 

     

    Net: a dedicated record type + exclude-from-rollups + an Amount>0 (or record-type) report filter gets you clean donation reporting without deleting anything or losing the registration history. If free tickets keep coming through as donations even after that, revisit the Give Lively field mapping, that is where the record type gets stamped on the way in. 

     

    If this helps, please mark it as the Best Answer so it is easy for the next person to find. Thanks :)

0/9000

Attempting to uninstall NPSP Recurring Donation in a Sandbox, was able to resolve all Component Type dependencies that were blocking the uninstall, except  last one which reads: 

Component TypeName Problem

 

Custom Field | Recurring_Donation | Can't uninstall package because an external component is referencing a component in this package. Remove the reference, and then retry uninstalling this package. Workflow Rule Filter: 

 

There is no name associated with the Workflow Rule Filter: 

which makes it difficult to track down. I have downloaded all meta.xml files and reviewed all Flows and Triggers etc but can not find any reference to NPSP components. 

 

#NPSP

 

 

#Nonprofit Success Pack  #Uninstall NPSP

1 answer
  1. Aug 17, 5:15 PM

    Hi Babak - that 'Workflow Rule Filter:' with no name is the classic uninstall blocker, and the reason your Flow/Trigger review came up empty is that it isn't a Flow or a trigger - it's a classic Workflow Rule, which is a separate metadata type you haven't looked at yet. 

     

    What's happening: somewhere you have a Workflow Rule whose criteria (the 'filter') references a Recurring Donation field from the package. The uninstall error points at the filter but can't surface the parent rule's name, which is why it's so hard to trace. 

     

    How to find it fast: 

    1. Retrieve the Workflow metadata for all objects and grep for the field. Via CLI: sf project retrieve start -m Workflow (or retrieve the Workflow type in Workbench), then search the .workflow files for the Recurring Donation field's API name (it'll be in the npe03 or npsp namespace). That pinpoints the exact rule immediately - far faster than clicking through Setup. 

    2. Prefer the UI? Go to Setup > Workflow Rules (not Flows) and review every rule - and crucially the inactive ones too, since inactive workflow rules still block an uninstall. Check each rule's criteria for a Recurring Donation field, plus any Field Updates that target one. 

    3. Don't forget cross-object rules: the blocking rule might live on a different object but reference the Recurring Donation field in its criteria or a field update. 

     

    Once you find it, remove the field from the rule's criteria (or delete/deactivate the rule if it's obsolete), then retry the uninstall. 

     

    Two things that trip people up: (a) it's Workflow Rules specifically, not Process Builder or Flow, so the metadata type to retrieve is Workflow; and (b) inactive rules still count. The CLI-retrieve-and-grep in step 1 is by far the quickest way to end the hunt. 

     

    Hope that cracks it!

0/9000

Considering how long I have been in the ecosystem, I am actually embarrassed to ask this question. (In my defense, it's not something I look at often). Anyway, when adding a spouse/partner to a Household account, via the Manage Household button, I noticed that after adding the person, and then going to their contact record, on the Account related list, it is NOT showing the Household account, it just shows as "0". On the contact record itself, the related Account record is there, it's just not showing up on the Account related list.  

 

Why would that be?  

 

The contacts are not marked as private, I don't have any dup rules that would prevent creation, etc. So I am a bit baffled. 

 

#NPSP #Household Accounts #Systems Administrator #Nonprofit #Nonprofit Success Pack

4 answers
0/9000

If a contact/account isn't found in the lookup of the gift entry screen, but is actually existing in Salesforce already, where do I configure the matching rules so that this match occurs when the dry run/processing happens.

I am offered matching choices when doing an NPSP Data Import batch from that screen, but the options don't show as part of the Process Batch process for Gift Entry. Which rules is it using? Do I have any control over them?

7 answers
  1. Aug 4, 3:29 PM

    Go to Setup > Custom Settings > "Manage" next to "Data Import Settings" > Edit. In the "Contact Matching Rule" field, you can type your desired matching behavior. The valid values, I. believe, are: 

     

    • Firstname,Lastname,Email
    • Lastname,Email
    • Firstname,Email
    • Firstname,Lastname
    • Email
    • Firstname,Lastname,Phone
    • Contact Duplicate Rules
0/9000

Looking for suggestions on how to deal with Address Management in NPSP. Specifically, around mass updating addresses. We got an updated list from NCOA and I am trying to determine the best way to add/verify the new addresses.  In some spot checking, we do already have the address that NCOA gave us, but it's not the default address anymore, at least in our SF. So I would not want to "add" a duplicate address.  So I am wondering what others do?  I mean there has got to be a way. Any upload tools out there that would help with this?  I have XL-Connector and I know I could export and do some vlookup's, etc to help, but I just looking for any short cuts to help, beside manually reviewing all of the records 

 

#NPSP #Nonprofit Success Pack #Nonprofit #Systems Administrator

3 answers
  1. Aug 3, 12:56 PM

     If you are working with a mail house/print service provider and intend to continue using them, make sure to send your list with the account id so you can match them up after the fact.  Having said that, using a Mail house and moving your address quality initiatives downstream prior to mailing is the absolute worst place to manage data quality.  IMO, data quality is best managed at the record of truth proactively.   This includes building a custom app or using a managed package like NCOA 4 Salesforce which is available now and in the process of getting in the app exchange.  The process handles the entire data set (not just what you are mailing) and works with a few clicks.  You can choose how to import and avoid duplication.  Happy to show it to you or can see a common demo: Typical NCOA 4 Salesforce demo to a nonprofit organization 

0/9000

Does anyone have a solution for integration? Or would we need a third party like Zapier to handle transactions? I assume we'll need to have a Square account first too? Apple Pay seems to be only available if we have Stripe as a payment processor. 

 

#Salesforce Admin  #NPSP  #Nonprofit Success Pack  #Nonprofits

1 answer
  1. Jul 31, 1:56 PM

    Hey Michelle - few notes here:  

     

    Apple Pay isn't Stripe only - Square supports it through there web payments SDK, so you don't have to switch providers if you already have Square - yes you would need to have a Square account to use it for payment processing.  

     

    I'm assuming your goal here is to be able to accept donations from an Experience Cloud site? With that, there are two options - embedding a Square checkout page on your site, or just having a link to an external Square checkout page.  

     

    If trying to embed on your site, Square would work, but I think you are going to have trouble with Apple Pay. My understanding is that Apple requires that verification file to be served at one exact URL path, and Salesforce's multi-tenant platform doesn't let you just put a file there. There are workarounds (a URL rewriter Apex class, or a CDN in front of a custom domain), but it's real developer work and it tends to be fragile.  

     

    So if you are trying to embed on your site (using the Web Payment SDK in an LWC), I would suggest using Square without Apple Pay. If just adding a link to a Square page, Apple Pay would work fine. The user experience for the second option would be a Donor clicks a button, is redirected to a Square page, pays with Apple Pay / Google Pay / Credit Card / etc, then is redirected back.  

     

    Zapier would not be needed in either case. Square sends the webooks natively. You would just set it up on the Square Developer Dashboard and point it at a Salesforce endpoint. You would have to set up a public endpoint to receive the webhooks though - that would mean a RestResource Apex class exposed through your SF Site with get user acccess. You can add some sort of signature verification to ensure you are not accepting posts from any random sources. You could use Zapier if you wanted - to basically outsource this signature verification - but that would have a cost associated with each transaction.  

     

    Hope this was somewhat helpful - I'm happy to talk through this further if you would like. 

     

    Steve

0/9000
1 answer
0/9000

We currently create our donor research profiles in Word and attach them as Files to Account records. The profile contains Contact info (name, email, phone, mailing address), some giving history, and data from external sources. We would like to transition this to Salesforce. My preliminary idea is a custom object with fields for data that doesn't already live somewhere else, then some sort of mail merge tool (we have Apsona) that merges it all together in one document. Has anyone built anything like this,or used a third party tool they recommend?  

 

We are on NPSP with no immediate plans to move to NPC.

@Nonprofit Success Pack #Nonprofit Success Pack

9 answers
  1. Jul 13, 2:46 PM

    This was one of the first things I set up at my current role when I joined, and we admittedly haven't used it in years, but I went the Visualforce render as PDF route. Link from Account, pulls in Household fields and a couple related lists. A mail merge template definitely seems like a more sustainable approach esp since you have the tools already!

0/9000

I am trying to connect Microsoft Power Automate to our Salesforce instance and receive the following:

Test connection failed. Details: Test connection has failed. Please check connector documentation and verify that your Salesforce instance meets connector limitations. clientRequestId: 7bae6fa8-7c6d-8fdc-c21d-afd383c1841a

I am trying to connect using Salesforce API version 47.0, which is the highest version available in the list. I have checked our API version and we are on v50.0 (Winter '21).

Is this version mismatch causing the error? If so, is there a workaround since selecting V50 doesn't appear to be an option?

This is the first time I have tried to connect Salesforce to Microsoft via Power Automate (Flow).

8 answers
  1. Jul 7, 2:53 PM

    Hi, I'm facing the same issue. I've disabled the option 'Lock sessions to the IP address from which they originated' in the session settings and I've also granted access to 'Approve Uninstalled Connected Apps' but still no luck. Any idea how I can resolve this error?

0/9000

Can anyone please suggest some better alternatives?

 

1) Picture Uploader really only works in Classic because it uploads to the Notes & Attachments related list, which is deprecated by Salesforce Files in Lightning since Winter '18. Once you use Magic Mover to convert all your Classic legacy notes and attachments to Salesforce files for Lightning, and enable "Files uploaded to the Attachments related list on records are uploaded as Salesforce Files, not as attachments" (as recommended during Lightning migration), it breaks the link and the image no longer display.

 

2) https://developer.salesforce.com/blogs/developer-relations/2015/11/create-lightning-component-drag-drop-profile-pictures.html (You'll get 2 compile errors regarding the "return null"...more deprecated code -- see https://help.salesforce.com/articleView?id=000269952&language=en_US&type=1 -- I couldn't make enough sense of this to understand how fix the code, so instead I just commented out lines 9 and 23, and then it compiled... However, it's very basic, drag and drop only, not even "Upload", "Edit" or "Delete" buttons so users can easily understand how to use it.)

 

Could a developer here modify the Apex code above to build a more user-friendly app with a resizable Lightning component, Upload/Edit/Delete buttons, etc. and post to the AppExchange... Please??

 

@Salesforce.org System Administrators

@Nonprofit Success Pack

@Nonprofit Hub

4 answers
  1. Jul 7, 11:00 AM

    Hi,

     

    If you're still looking for a native-looking option, we recently launched an AppExchange component for this.

     

    It lets users upload, crop, and display images or logos directly on standard or custom Salesforce record pages, alongside selected record fields so everything stays in one place.

     

    Might save you some time if you don't want to build and maintain a custom LWC just for image upload and display.

     

    Here’s the link:

    https://appexchange.salesforce.com/appxListingDetail?listingId=a0NKX000001VLyT2AW

0/9000