Page MenuHomePhabricator

Benevity Import error message received
Closed, ResolvedPublic2 Estimated Story Points

Description

I import the most recent import file for Benevity and it got to about 70% and I received an error message, which is below.

Screen Shot 2020-03-04 at 12.20.53 PM.png (358×2 px, 84 KB)

I've tried all the tricks, breaking the file down to 3 separate files and it seems to hit the error at around row 3198 to 3200, but it doesn't look like all the gifts are in Civi. I can see the following:
gifts 4604 and $209,354 and the total amount to be import is $219k.

FYI - Leanne is due to her reconciliation for February soon.

Ive put the file on the server for you to take a look at.

Event Timeline

Change 580654 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Convert Civi-errors in munge to WMFExceptions

https://gerrit.wikimedia.org/r/580654

Change 580705 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Benevity import - create contact prior to calling shared functions

https://gerrit.wikimedia.org/r/580705

Change 581069 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Catch & handle exceptions on contibution tracking insertt

https://gerrit.wikimedia.org/r/581069

Change 580654 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Convert Civi-errors in munge to WMFExceptions

https://gerrit.wikimedia.org/r/580654

Change 580705 abandoned by Eileen:
Benevity import - create contact prior to calling shared functions

https://gerrit.wikimedia.org/r/580705

Just an update that the 3 contacts causing problems are the ones with email addresses & no supplied first & last names. I'm working on a fix for this scenario -but if you are in hurry you can make it importable by ensuring each of the 3 emails is already in the DB and there are no dupes on them (this will by-pass the bug)

@Eileenmcnaughton thanks for sharing this information. Can you share the row numbers for these contacts? I've searched the file and can't seem to locate these three contacts and want to make sure I'm adding the correct emails to the DB and deduping the correct contacts.

Thanks

@RLewis I updated them & re-imported - should be all in now & patch pending to fix this bug

Change 581069 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Catch & handle exceptions on contibution tracking insert

https://gerrit.wikimedia.org/r/581069