Gift: Conversion from string “XXX” to type ‘Integer’ is not valid.

When importing gifts in the everydayhero plugin, users may notice an exception message that states: Gift: Conversion from string “XXX” to type ‘Integer’ is not valid.
We have discovered that the issue you reported with everydayhero is a defect in the one of the features added in the latest release of the plugin, adding the Fundraiser’s Constituent ID to the gift attributes.  The plugin incorrectly assumes that Constituent IDs are numeric.  If a constituent has any non-numeric fields in the Fundraiser’s constituent ID, then it doesn’t save the gift and gives the exception message. We are currently working on the fix for the issue. 

One possible way to resolve this exception is to update the constituent code for the fundraiser (which is defined in the exception error) to remove the non-numeric character.  For example, if the organization has a business rule to include the Current Year prefix and a separator like "-" when creating a new constituent record, you can just remove the "-" from the constituent code, and then the gift will update.

If you are unable to edit the constituent code, you will have to enter the gift manually.

Steps to Duplicate

1. Open the everydayhero Plugin
2. Click Download Gifts from everydayhero
3. Click Import File
4. Open the exception file and notice the exception

Environment

 Raiser's Edge
 7.95
 EveryDayHero

Was this article helpful?