Start a new topic

Gift Import - Invalid Fund

Hello,

I am trying to import a gift with credit card information into Raiser's Edge (Blackbaud). But, I got the following error message.

Line 1: Invalid Fund:  Fund Id [Object: 'CGiftSplit', PK: '-1', Import ID: '', Field: 'Fund Id', Value: 'Membership Clearing'] -->BBREAPI.CGiftClass.Save()-->#=qQYgSnTb6lltL2nBHyHagrA==(Int32 #=qStooiAOuyCAb_b9C0Ht0Xw==, CFieldDefaultServer #=qtitxOw9Oadh5bB6VNMZW9g==, Int32 #=qwVVbDs6CIvGDBW40IkzW_Q==, Int32 #=qlNyj3sGLYmkMGoyAqFd9WQ==, Int32 #=qslg5_5VfA0UZMKO5_Igraw==, IBBConstitUIHelper #=qkGXVJCN4TB2KeE9TH5yXRw==, String #=qQP2ZjicwNFaeSXM34E52w==, Int32& #=qzm5s$oPahUvzxd9XELjy2NoF4pZwfLyTJqIbb76n7oY=, StreamWriter& #=qbXoIFw01sHijyckn$XFEwA==, StreamWriter& #=qs2

Here is my data file:
ConsID GFTAmt GFDate Campaign Appeal Package Fund GFType GFPayMeth Credit Card Type Cardholdername Credit Card Number CC Expiry Date EFT GFPostDate GFPostStat GFRcpt GFRcptAmt GFSubType
1000 10 08/15/11 M 2011 New 2011 WEB 2011 99999 Recurring Gift Credit Card Visa Joe Smith 1234567890123456 09/01/2013 YES ######## Do Not Post Not Receipted 5.00 Visa

Please let me know what's wrong with my data file? 

Thanks,
Jackie

ConsID GFTAmt GFDate Camp Appeal Package Fund GFType GFPayMeth Credit Card Type Cardholdername Credit Card Number CC Expiry Date EFT GFPostDate GFPostStat GFRcpt GFRcptAmt GFSubType
1000 10 08/15/11 M 2011 New 2011 TELE 2011 Membership Clearing Recurring Gift Credit Card Visa Joe Smith 1234567890123456 09/01/2013 YES 15-Aug-11 Do Not Post Not Receipted 5.00 Visa


Fund in my data file should be "Membership Clearing". When I post the first message, I manually changed it to 99999.
Hi Jackie,
It looks like you have mapped the Fund Description and not the Fund ID. You can either create a dictionary to translate the fund description into the fund ID or change your RE settings to accept the fund description (Tools, User Options, Records tab to see if it set to use Fund IDs or Descriptions).
Please let us know if this helps!
Many thanks,
Stephanie Johnson
IOM Support
Thank you very much, Stephanie.

I went to user options and changed my setting. It works! Yay!

Jackie
Login or Signup to post a comment