Importing RG Payments with Authorization Codes

Question

Dear all,

Does anyone know whether it's possible, and, if so, how, to import Payments for Recurring Gifts into BBCRM from a CSV file, with Authorization Codes?  We had a big problem with BBMS today, where it initially rejected thousands of RG payments, so they were deleted from our scheduled payments batch, then later it said that most of them had been Approved and some had results of 'Gateway decline'.  We are working with Blackbaud support to find a solution, but I thought I'd check if someone already has one.  I get an Invalid Application error if I try to import an Application of Recurring Gift.

Any ideas appreciated.

Kind regards,

David.

David Wanless · Answer

Dear @Crystal Bruce ,

I ended up using BVDL to import the authorised payments, using the Commitment Lookup ID (in an Application Collection, in the field Application Lookup ID 1, with Application = Recurring Gift).  I couldn't get it to work using standard BBCRM Import.

BVDL couldn't import the rejection reasons for the records which were declined, so those Recurring Gifts remain with the original spurious rejection reason from BBMS, but will probably get their real rejection reason when we retry them.

It was a lot of work and should never have been necessary, but it's all fixed acceptably now.

Blackbaud have filed a bug report for the Credit Card Processing process as it shouldn't have returned a result before BBMS had a final result.

Kind regards,

David.

Crystal Bruce · Answer

Hi @David Wanless I wanted to check in on this - saw you were were working with support and wanting to see if they helped you find a solution and if so, would you mind sharing it here? Thanks!