Hi,
One of our consortium orgs always uses the contribution import utility for Giving Tuesday donations. Now that they have their data ready, when I try running this report, I keep getting errors.
This is the first since last year that I have tried to run this report. In May we went with Tessitura Merchant Services and the first error I got was related to PSPE. I commented out the Account Number, account Name and exp date in the xml file and deleted those columns since documentation mentioned utility would fail if Account Number and exp date fields were included. I then got the error "Expected row count is less than 1 or is undefined." I tried various things and even commented out all but the 3 minimum required fields as mentioned in the documentation, but I keep getting the 2nd error. I have confirmed that the import file and the xml file have the same three columns in each.
Has anyone had a similar issue with the contribution import utility? If so, what have you done to make it work?
Appreciate any recommendations.
T.C.
Hi there,
We'e having a very similar issue in that we are trying to import Giving Tuesday contributions using a format that has worked before. TN Support did suggest that it could be down to a known defect where the utility fails if the state is blank despite blank states being allowable in TR_COUNTRY. I tried adding that in as a column but it didn't help. I could only get it to work if I put a customer number in the data file, but not all of them had a record, and of course it should be able to match up to the existing record and import anyway. I have a call with them for next week so will let you know if I have a breakthrough, but hopefully you will have sorted it out before that!
I sympathise!
All best, Katie
Hi Katie,
Thanks for responding. Keep me posted. It sounds like you can get it to work with a customer number. (All of the ones I am trying to import have a customer number.)
Best,
I haven’t used the contribution import, but I know that the constituent import requires a postal code, even if you don’t have an address. I just put ours in and it does the trick (and it doesn’t end up on the record). Might be worth trying.