This would also be resolved by https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/+/1106343, but we will use this ticket to dig a bit further for why we lost email during the paypal recurring process

It looks like the # of CIDs without emails is 1930 from the /referrals list. The scale of this kind of snuck up on us and I'm wondering, what is the best way to fix this before the EoY recurring TY email goes out?

Can Fr-Tech do anything to populate these emails? If not, is it possible to generate a dedupe query from the /referrals list?

@MBeat33 I can take a look but re the 'dedupe query' - what would you do with that? There are the merge links at the left - isn't that kinda the same?

Thanks @Eileenmcnaughton I hadn't seen those links before.

@MBeat33 yeah - I hoped it would make for a quick way to work through them - I seem to have merged about 20 just in my poking around :-)

Thank you. I sorted the referrals list by clicking the column heading for original donor -primary Email, which seemed to be the best way to isolate the ones missing email addresses. The first few I've tried yield this error:

Error
Cannot merge because one contact (ID 62536623) has been deleted.

Is there a better way to use this, @Eileenmcnaughton ?

Also, does everthing on the /referrals list need merging? I exported the results and there were over 21k, but only 1930 were missing an email address in one of the columns.

One thing that struck me looking at them is that I hit a handful where the older contact had opted in & the newer one hadn't - I'm gonna raise this

@MBeat33 we are on https://meet.google.com/rvq-ygtd-xgm?authuser=0 atm - do you want to jump on?

Notes for me to create a new phab...

• Reply email block - is it too much - eg https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=5530613&selectedChild=omnimail
• primary when they donate on one & received on the other

I created this regarding the ones who appear to have opted out inadvertently https://phabricator.wikimedia.org/T383189

I created https://phabricator.wikimedia.org/T383191 to cover the question for the ones that entered DIFFERENT emails

I added https://phabricator.wikimedia.org/T383193 for the Comcast issue

Hi @SHust - I see nearly half of these have been resolved now - I'm gonna move this to done at our end & leave in your camp. Let me know if you need more

Ok to close this ticket and the entire list will be done by tomorrow. Thanks again, @Eileenmcnaughton!