[00:00:10] cwd we need to unsubscribe old email addresses [00:00:19] which have been deleted in the non-log tables [00:00:53] also, when an email address is edited in place, and we have exported the old one previously, we want to put the old one on the unsubscribe list [00:01:00] and that only exists in the log tables [00:01:26] (Merged) jenkins-bot: Matching gifts import. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/334235 (https://phabricator.wikimedia.org/T115044) (owner: Eileen) [00:03:00] (Merged) jenkins-bot: Pass more error details to calling function. [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/336962 (owner: Eileen) [00:04:35] ejegg: but since the deleted joins on export_staging, won't it only remove things that also exist there? [00:05:16] *delete [00:05:22] right, we get all the emails that have ever existed in civi and put them on the suppression list [00:05:40] oooh yeah sorry [00:05:45] then we remove from the suppression list everything that is current and not opted out [00:05:55] (also, the addresses of civi users) [00:07:33] but since the list it's deleting from is made from the current table, how would it get addresses that are currently opted out? if they were a dupe of an address that had previously opted out? [00:08:24] the current addresses which are opted out are marked in the live tables [00:08:47] and we OR all the possible opt-out reasons into that one column in the staging table [00:09:08] yeah i noticed that [00:09:23] so they may be in staging, but they only get exported (and only get removed from the suppression list) if opt_out=0 [00:10:25] todo: better synonyms for 'staging' [00:11:28] cwd does that make sense? [00:13:34] my brain is grinding [00:13:51] hehe, that export tends to have that effect [00:14:25] heh [00:14:32] I'm folding up the lappy for now, but I'll be on email on the public transit in a bit if you have more questions [00:14:37] yeah i can see that this is a labor of love [00:15:06] I think archive.org might actually be able to use this out of the box [00:15:07] and there are subtle reasons for all the things i think i can fix [00:15:22] that would be cool [00:15:24] oh wait, no, wmf_contribution_extra stuff [00:15:48] we should get the original currency etc into core [00:16:41] k, heading out. have a good weekend! [00:16:54] you too! good luck with immersing [16:50:01] (PS3) Ejegg: Shake up message normalization in PayPal job [wikimedia/fundraising/SmashPig] - https://gerrit.wikimedia.org/r/335742 (https://phabricator.wikimedia.org/T107372) [18:00:31] fr-tech: Fanaticism consists of redoubling your effort when you have [18:00:31] forgotten your aim. [18:00:31] -- George Santayana [18:00:31] -- discuss.