Hi
Is anyone successfully running the Contribution Import Utility in v15? I have a support ticket open but getting frustrated with the process. We have now established there is a known defect with the Import Utilities (all I think) since v15.1.16 which is not fixed until v16. The defect info is a bit vague, but I've managed to confirm the Default Address is not working and so you need at least a postcode (and I've found also an email address!) before it will run. I've tested it with a single row of test data using only Last Name, Postcode, email address, contribution date, contribution amount and received amount. This ran, but when I posted the batch, it has only created a transaction/payment entry, but no contribution entry. I assume it should create a Contribution? It has also not imported the postcode, so the Constituent address is completely blank.
I then ran it using the same data file with 10 rows of actual data including full address details, and now it is saying there is a mismatch between the data file and format file, even though these are effectively the same as I ran with one row. Screenshot below. So I'm thinking it's an address issue, given the known defect is something to do with address data?
If anyone has any insights to share, I'd be very grateful! NB I'm running this in TEST, so am aware of the need to log in without Windows Authentication, so am using my alternative non-WA Tessitura account (this is only fixed in PROD, not TEST).
Many thanksBest wishesDawn
Hi Dawn,
We do use this utility in v15 and so far haven't had an address issue. One small thing I've found is that if you even click into a cell or tab outside of your data rows when you are preparing the data file that it can then cause a 'mismatch' to the format file. You might already know this stuff but it sticks in my mind as the most infuriating thing I've had to troubleshoot about import utilities!Good luck, Katie
Hey Dawn,
All the import utilities can be a problematic in this way and like my esteemed collegues suggest the "out of sync" can often relate to one of the cells having unsuitable data or a separator (column or tab) too many that is throwing your rows out.
To get a better eye over mismatching for invisible characters, it's worth giving your file a look in Notepad++ and turning on View > Show Symbol > Show all characters.
As they say in the Contribution Import TroubleShooting doc it can also mean your XML file and data file are mismatched. You are using a txt file and I assume both the earlier one that works also is TXT.