Page MenuHomePhabricator

KHaggard (Katie Haggard)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Nov 9 2018, 10:42 PM (196 w, 5 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
KHaggard (WMF) [ Global Accounts ]

Recent Activity

Fri, Aug 12

KHaggard updated subscribers of T315102: Custom field "AF_has_active_recurring_donation" is showing false positives.
Fri, Aug 12, 5:49 PM · Fundraising Sprint Overused petting Zoo Memetics, Fundraising-Backlog
KHaggard updated the task description for T315102: Custom field "AF_has_active_recurring_donation" is showing false positives.
Fri, Aug 12, 5:49 PM · Fundraising Sprint Overused petting Zoo Memetics, Fundraising-Backlog
KHaggard created T315102: Custom field "AF_has_active_recurring_donation" is showing false positives.
Fri, Aug 12, 5:48 PM · Fundraising Sprint Overused petting Zoo Memetics, Fundraising-Backlog

Jun 21 2022

KHaggard added a comment to T281731: Spanish Latam donors seeing English survey.

@krobinson Could it be possible that the donor's browser has some kind of extension that is translating the page by default (like Google Translate)?

Jun 21 2022, 4:05 PM · Thank-You-Page, Fundraising-Backlog
KHaggard added a comment to T281731: Spanish Latam donors seeing English survey.

Hi @krobinson, from my understanding, SurveyMonkey doesn't geolocate on its own - it just picks up the geolocation from the donation flow. If they see a Spanish TY page and click the survey, it should bring them to a Spanish survey because each link is unique.

Jun 21 2022, 4:01 PM · Thank-You-Page, Fundraising-Backlog

May 26 2022

KHaggard added a project to T309341: Zulu language does not appear in CiviCRM: FR-AutoTY-Email.
May 26 2022, 6:39 PM · Fundraising-Backlog, FR-AutoTY-Email

May 19 2022

KHaggard added a comment to T300817: Querying contacts from 'Reply Mail Block' events.

I think the main issue is that we haven't run the purges in Acoustic yet because I need the email address list in CSV format in order to run the purges the way I know how to do. The size is too huge to pull down from Civi, so the only thing I can think of is make the search results bite-sized and do one country at a time? Is there a way to parse the data like that in Civi so the download time is reasonable?

May 19 2022, 9:39 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T300817: Querying contacts from 'Reply Mail Block' events.

Hi @DStrine ! We're synced up. Uploading into Acoustic is no problem but we can't get the CSV downloaded from Civi to kick off the process.

May 19 2022, 4:37 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 16 2022

KHaggard added a comment to T300817: Querying contacts from 'Reply Mail Block' events.

Hi @nisrael ! Let me know when you're ready to start deploying this task.

May 16 2022, 8:45 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 12 2022

KHaggard added a comment to T308184: Currency sign missing from LATAM ty emails.

@krobinson I believe the issue with English was resolved through T306576 - but I thought the issue was only with the footer in USD, so that's why Eileen rolled out the fix of using {if $currency === 'USD'}{$currency} {/if}

May 12 2022, 6:30 PM · FR-AutoTY-Email, fr-donorservices, Fundraising-Backlog

May 11 2022

KHaggard updated subscribers of T308184: Currency sign missing from LATAM ty emails.

So, @TSkaff @MNoorWMF and I split the work for coding the English versions of the TY emails. I'm not sure who coded Spanish, but I believe localization team coded the translations. Hi @CDenes_WMF and @TomaszGorski ! Would you be willing to review Spanish TY email HTML and amend per Eileen's instructions in the Email Template UI?

May 11 2022, 11:16 PM · FR-AutoTY-Email, fr-donorservices, Fundraising-Backlog

May 10 2022

KHaggard closed T305483: Importing the Email Greeting field from Civi to Acoustic as Resolved.

Hi @Eileenmcnaughton - everything looks fine on my side after checking the import jobs today. Thanks for your help!

May 10 2022, 6:58 PM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

I'm just going to make sure everything runs normally tomorrow for the regular jobs and then I'll resolve the ticket here :) Thanks!

May 10 2022, 1:59 AM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard closed T307811: Confirmation needed for database update export job as Resolved.

Confirming here that we ran a full database overwrite today, so everyone in the _all_Wikimedia database is fully up-to-date now. Potential problem is now solved! Thanks @Eileenmcnaughton and @MNoorWMF

May 10 2022, 1:56 AM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

We ran the big file and here's the data job summary report:

May 10 2022, 1:51 AM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

May 9 2022

KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

Actually, due to T307811, @Eileenmcnaughton and I are going to work on adding email_greeting before Thursday's email send.

May 9 2022, 8:23 PM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard added a comment to T307811: Confirmation needed for database update export job.

Thanks Moska for logging this! Hi @Eileenmcnaughton - we do have a small email send going out on Thursday this week, do you think we should run the full file + new custom field this week instead of next week?

May 9 2022, 4:31 PM · FR-Email, Fundraising-Backlog

May 6 2022

KHaggard added a comment to T300817: Querying contacts from 'Reply Mail Block' events.

Hi @Eileenmcnaughton - Yes I have to purge the on-hold list from _all_Wikimedia too because we have them labeled as "opt out" in that database too (along with the MSL database). There is no easy way to switch their label back to "opt in" inside _all_Wikimedia so we have to resort to bulk deletion, and then Civi will re-insert them properly as opt-ins again for 7 days.

May 6 2022, 7:24 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

Hi @Eileenmcnaughton ! I think we should wait until the maintenance week (May 16 - 20)

May 6 2022, 7:10 PM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard updated subscribers of T306576: Civi Message Template dynamic content is not populating currency code correctly.

Hello, I just got back from vacation. Thanks for looking into this @Eileenmcnaughton. Since this issue was flagged by Donor Relations, I'll loop them in to confirm if they for sure want the old format.

May 6 2022, 6:12 PM · Patch-For-Review, Fundraising Sprint High velocity swallows, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Apr 22 2022

KHaggard added a comment to T306582: Decide how to deal with acoustic-blocked prefixes.

Ok, so it sounds like there's minimal contacts that apply to this. Is it just marketing@ that you're requesting to remove, or are there more prefixes to consider?

Apr 22 2022, 12:11 AM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Apr 21 2022

KHaggard updated subscribers of T306582: Decide how to deal with acoustic-blocked prefixes.

For cid=43560023, their email address prefix has a "5" next to "marketing" so it's not triggering the block. I'm pretty sure all "marketing@" are disallowed from Acoustic.

Apr 21 2022, 9:37 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard updated subscribers of T306582: Decide how to deal with acoustic-blocked prefixes.

Hi @Eileenmcnaughton, that makes senes to me, though I'm unaware if there are any important reasons to not change the disallow list.
@bsisolak - what's your opinion on removing "marketing@" from the email blocking local prefix list?

Apr 21 2022, 7:47 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Apr 20 2022

KHaggard created T306576: Civi Message Template dynamic content is not populating currency code correctly.
Apr 20 2022, 11:01 PM · Patch-For-Review, Fundraising Sprint High velocity swallows, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Apr 19 2022

KHaggard added a comment to T300817: Querying contacts from 'Reply Mail Block' events.

I can answer the first question @nisrael !
We'll need Eileen or someone to un-hold the contacts once we're ready. We don't need to re-upload any records, we just need to purge all of the on-hold records out of the MSL and _all_Wikimedia, then the un-holded contacts will import back into Acoustic correctly the following day. The un-holding process triggers Civi to send them over to Acoustic for 7 days.

Apr 19 2022, 6:36 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Apr 8 2022

KHaggard closed T304909: From Name in Auto Thank You Emails needs update as Resolved.

Now that we can edit this ourselves, I'll resolve this ticket :) thanks!

Apr 8 2022, 4:11 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Apr 6 2022

KHaggard added a comment to T305588: Fundraising access request for Natalie Ngu .

Oh yeah, whoops I think I got mixed up with something else. I meant frdev1001 so that she can access mysql pgehres and statler

Apr 6 2022, 10:39 PM · fundraising-tech-ops, Fundraising-Backlog

Apr 5 2022

KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

Awesome. Thanks for your input, and I agree!

Apr 5 2022, 4:37 PM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

Oh nice, thanks @Ejegg and @Eileenmcnaughton ! @TSkaff - Looks like we can edit From Name ourselves. Let's check it out!

Apr 5 2022, 4:31 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T305483: Importing the Email Greeting field from Civi to Acoustic.

Thanks Rosie, Thea, and Erin!
@EYener - do you have a preference for how we name the field? Considering this for all future field additions until we have time to get together and match naming conventions for the existing fields.

Apr 5 2022, 4:15 PM · Fundraising Sprint High velocity swallows, fundraising sprint Genealogical theory of relativity, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Mar 31 2022

KHaggard closed T305170: Acoustic import jobs failed - missing files from FTP as Resolved.

Jobs ran and look good! Thanks for the help @Ejegg ! Resolving ticket now :)

Mar 31 2022, 6:58 PM · Fundraising Sprint Fibonachos, FR-Email, Fundraising-Backlog
KHaggard added a comment to T305170: Acoustic import jobs failed - missing files from FTP.

Thanks @Ejegg ! I'll manually run the jobs after I get out of next meeting :)

Mar 31 2022, 4:57 PM · Fundraising Sprint Fibonachos, FR-Email, Fundraising-Backlog
KHaggard triaged T305170: Acoustic import jobs failed - missing files from FTP as High priority.
Mar 31 2022, 3:57 PM · Fundraising Sprint Fibonachos, FR-Email, Fundraising-Backlog
KHaggard created T305170: Acoustic import jobs failed - missing files from FTP.
Mar 31 2022, 3:57 PM · Fundraising Sprint Fibonachos, FR-Email, Fundraising-Backlog

Mar 30 2022

KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

Oh good catch and thank you @Cstone ! Appreciate it :) Yay I'll tell Amy that it's up.

Mar 30 2022, 8:51 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard updated subscribers of T304909: From Name in Auto Thank You Emails needs update.

Thea made a test donation to the Endowment and she received Jimmy's copy with Lisa's From Name. I believe we followed all the steps correctly and the new copy is in the "current" tab for both the english and standard templates in the UI. I tried updating the "Original" tab but it's read-only and won't let me edit. Could you help us troubleshoot asap since the live version is not updating?

Mar 30 2022, 7:18 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

Ok, I'm ready to activate the draft for Endowment Thank You Email. Confirming that From Name is now going to be Lisa. I think the From email address is endowment@wikimedia.org already, is that correct? @Ejegg

Mar 30 2022, 6:08 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard updated the task description for T304909: From Name in Auto Thank You Emails needs update.
Mar 30 2022, 4:30 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

The more you know! Thanks for that explanation @Ejegg . I'll go ahead and remove the reply-to lines from the phab description. Heads up, I'm doing one last look over for the Endowment TY email and should be ready to activate it in the next few hours. Happy to log in to IRC and ping you there.

Mar 30 2022, 4:29 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

Sure thing, thanks @DStrine ! Right now the only urgent deadline we have is Endowment, so I think I'll be ready to change the endowment one in unison with you all tomorrow. I'll ping in IRC when I'm ready to go!

Mar 30 2022, 1:05 AM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Mar 29 2022

KHaggard updated the task description for T304909: From Name in Auto Thank You Emails needs update.
Mar 29 2022, 6:13 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard closed T304357: Remove voter party field from acoustic export as Resolved.

Hi @Eileenmcnaughton !
@Ejegg and I learned today that ignoring a field in Acoustic remapping will not stick if the export stops sending a field. Noted this for next time! Guess we'll always have to "push go" at the same time going forward for these tasks. Resolving this task since we've properly remapped and all is well. Thanks!

Mar 29 2022, 6:02 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog
KHaggard closed T304969: Most recent DatabaseUpdate Import is missing data as Resolved.

Resolving this now, thanks @Ejegg !

Mar 29 2022, 5:55 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog
KHaggard added a comment to T304969: Most recent DatabaseUpdate Import is missing data.

Got it, thanks for confirming that! By the way, I don't think we process the MatchingGifts-* file anymore, since we migrated the relevant MG fields to be in the DatabaseUpdate file, right?

Mar 29 2022, 5:48 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog
KHaggard added a comment to T304969: Most recent DatabaseUpdate Import is missing data.

Thanks! If this works, I'll add it to my notes that we'll have to remap at the same time when the field is taken out of the export file. Let me know when the files are ready to go @Ejegg :)

Mar 29 2022, 5:26 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog
KHaggard added a comment to T304969: Most recent DatabaseUpdate Import is missing data.

Yeah I remapped last Friday @Ejegg But since the field was still there when I remapped, I had to click a checkbox to ignore the voter_party field. It was working well over the weekend.

Mar 29 2022, 5:20 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog
KHaggard triaged T304969: Most recent DatabaseUpdate Import is missing data as Unbreak Now! priority.
Mar 29 2022, 3:54 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog
KHaggard created T304969: Most recent DatabaseUpdate Import is missing data.
Mar 29 2022, 3:53 PM · Fundraising Sprint e^🥧👀=yum, FR-Email, Fundraising-Backlog

Mar 28 2022

KHaggard renamed T304909: From Name in Auto Thank You Emails needs update from Change From Name in Auto Thank You Emails to From Name in Auto Thank You Emails needs update.
Mar 28 2022, 10:38 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T304909: From Name in Auto Thank You Emails needs update.

Does the info above look correct, @TSkaff ?

Mar 28 2022, 10:37 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard updated the task description for T304909: From Name in Auto Thank You Emails needs update.
Mar 28 2022, 10:36 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard created T304909: From Name in Auto Thank You Emails needs update.
Mar 28 2022, 10:35 PM · Fundraising Sprint Fibonachos, Wikimedia-Fundraising-CiviCRM, FR-Email, FR-AutoTY-Email, Fundraising-Backlog
KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Hello @Eileenmcnaughton ! Updating here that the imports ran successfully over the weekend. Acoustic now ignores the voter_party field sent from Civi. I'm working with Trilogy on deleting the field from Acoustic, but it no longer has any data and it is not tied with Civi anymore.

Mar 28 2022, 3:56 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog
KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Hello @Eileenmcnaughton ! Updating here that the imports ran successfully over the weekend. Acoustic now ignores the voter_party field sent from Civi. I'm working with Trilogy on deleting the field from Acoustic, but it no longer has any data and it is not tied with Civi anymore.

Mar 28 2022, 3:55 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog

Mar 25 2022

KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Ok @Eileenmcnaughton I've remapped the files today and ignored the voter_party field. Things should be working fine over the weekend but I'll update again on Monday to make sure the imports are processing successfully. Have a great weekend!

Mar 25 2022, 6:48 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog

Mar 22 2022

KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Sorry, one last update here @Eileenmcnaughton (@TSkaff for visibility). I see we added another Planned Giving email send to the calendar on Wednesday, so the soonest I will be able to initiate a remapping is Friday the 25th when we have no emails scheduled to send. Hope that's ok for the timeline here.

Mar 22 2022, 8:31 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog
KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Whoops @Eileenmcnaughton I overlooked that we have sends going out tomorrow - I can remap w/ignoring voter party starting on my Wednesday morning instead.

Mar 22 2022, 12:36 AM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog

Mar 21 2022

KHaggard added a comment to T304357: Remove voter party field from acoustic export.

Thanks @Eileenmcnaughton - I still rely on the nightly imports to "unmap" a field, but it's true that I can just pause the next scheduled import job and run it manually after mapping and choosing to ignore the voter party field. I can give that a try tomorrow morning.

Mar 21 2022, 11:11 PM · Wikimedia-Fundraising-CiviCRM, Fundraising Sprint e^🥧👀=yum, fundraising-tech-ops, Fundraising-Backlog

Mar 7 2022

KHaggard closed T303185: Deleting one database id for Forget Me requests as Resolved.

Yay! Thanks @Eileenmcnaughton :) I finally finished clearing out all of the enigmatic databases in Acoustic. Feels good 💃🏻

Mar 7 2022, 9:38 PM · Fundraising Sprint Discworld reformatted as ntfs, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard added a comment to T302286: Updating List of Database ids for Forget Me requests.

Quick update that database id 11851009 is now successfully deleted from Acoustic. Thanks!

Mar 7 2022, 6:37 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog
KHaggard created T303185: Deleting one database id for Forget Me requests.
Mar 7 2022, 3:33 PM · Fundraising Sprint Discworld reformatted as ntfs, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Feb 24 2022

KHaggard updated subscribers of T302286: Updating List of Database ids for Forget Me requests.

Thanks @Eileenmcnaughton . Just a quick update from my side: Acoustic kept blocking me from deleting database id 11851009. @bsisolak logged this with Acoustic support. They need to cleanup some things in order for the system to allow us to delete the database. Once that's complete I should be able to run the deletion job and I'll ping here when it's complete.

Feb 24 2022, 2:49 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog

Feb 22 2022

KHaggard added a comment to T302286: Updating List of Database ids for Forget Me requests.

@Eileenmcnaughton Ok, that makes sense to me. After we finish this phab, I'll work on creating a sandbox database. Would that also mean we would need to run ForgetMe requests on that new database too or could we keep it empty of contacts between use cases?

Feb 22 2022, 7:56 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog
KHaggard added a comment to T302286: Updating List of Database ids for Forget Me requests.

Hmm yeah I agree it might be better for me to create a new "sandbox" database for that testing purpose (let me know if that is in another phab somewhere) @Eileenmcnaughton

Feb 22 2022, 7:37 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog
KHaggard added a comment to T302286: Updating List of Database ids for Forget Me requests.

Whoops - spoke a little too soon about database id: 11851009. That one was mid-delete when I logged this ticket, but it failed for some reason so I'm digging into that now. Will ping again once that one is gone.

Feb 22 2022, 5:45 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog
KHaggard created T302286: Updating List of Database ids for Forget Me requests.
Feb 22 2022, 2:17 PM · Fundraising Sprint Cheese String Theory, FR-Email, Fundraising-Backlog

Feb 15 2022

KHaggard closed T301677: Master Suppression List Update Failed as Resolved.

Hi @Eileenmcnaughton The issue resolved itself today - the MSL ran this morning as scheduled and everything looks healthy. Only the Feb 15 files came through, so I think the files you uploaded might still be sitting there. For some reason, Acoustic doesn't see them.

Feb 15 2022, 3:21 PM · fundraising Sprint Black Hole Fillings, FR-Email, Fundraising-Backlog

Feb 14 2022

KHaggard added a comment to T301677: Master Suppression List Update Failed.

Hi @Eileenmcnaughton. I gave it an hour and tried again, but the system's saying there's no files on the FTP site.

Feb 14 2022, 10:25 PM · fundraising Sprint Black Hole Fillings, FR-Email, Fundraising-Backlog
KHaggard added a comment to T301677: Master Suppression List Update Failed.

Got it, thanks @Eileenmcnaughton. Are they located in the "Uploads" folder? I just tried running one of the files and it failed right away. I'll give it a few minutes and try again in case I ran it too early.

Feb 14 2022, 9:24 PM · fundraising Sprint Black Hole Fillings, FR-Email, Fundraising-Backlog
KHaggard triaged T301677: Master Suppression List Update Failed as High priority.
Feb 14 2022, 2:44 PM · fundraising Sprint Black Hole Fillings, FR-Email, Fundraising-Backlog
KHaggard created T301677: Master Suppression List Update Failed.
Feb 14 2022, 2:43 PM · fundraising Sprint Black Hole Fillings, FR-Email, Fundraising-Backlog

Jan 21 2022

KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

If we want to, then the best time to do so is when we're not having any fundraisers going. Purging the MSL and _all_Wikimedia really shuffles things around and we don't want to run purges when we have Italy fundraising emails going out.

Jan 21 2022, 12:36 AM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Jan 20 2022

KHaggard updated subscribers of T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Ok, just checked it out today, reviewed everything with Brian too, and it looks like purging the main database worked!

Jan 20 2022, 10:42 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard updated subscribers of T292247: Collaboration on RML data flow.

Hey @DStrine. Sure, I think @MSuijkerbuijk_WMF would know. @MSuijkerbuijk_WMF , would you be willing to post any RML-related documentation you have available?

Jan 20 2022, 9:43 PM · FR-Tech-Analytics, Fundraising-Backlog
KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Updating here again to say I kicked off the next purge job to remove the comcast CSV list from _all_Wikimedia temporarily, so that Civi can reimport those records as "opted in" tomorrow. Hopefully that works, I'll check in the morning if those records are restored properly. @Eileenmcnaughton @nisrael

Jan 20 2022, 1:26 AM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Jan 19 2022

KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Ok quick update - The purged records are still successfully removed from the Master Suppression List database, but they're still in status "opted out" within the main _all_Wikimedia database. The only workaround for this that I can think of is running the same purge job in _all_Wikimedia today, and checking tomorrow to see if the records get re-inserted as Opt-ins. I think this will work because those comcast records all received a change in their Civi record (unhold) so they should be in the databaseupdate-* export job for the next 6 days or so. Does that sound right to you @Eileenmcnaughton ?

Jan 19 2022, 4:48 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Jan 18 2022

KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Thanks @Eileenmcnaughton ! Ok I just ran the purge, it removed 28,912 records, which is 299 records lower than the full amount on the CSV. So it either didn't find 299 records in the Master Suppression list and/or maybe 299 records are bulk opted out of emails still after you removed the 'on hold'? Just my guesses though, so let me know what you think.

Jan 18 2022, 11:26 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Ok I downloaded that CSV to my computer. I think all those contacts are still marked as "on-hold" in Civi, correct? In order for the purge to take and not get overwritten, we need to have the Civi records be fully "opted in" and then I can purge the Master Suppression List of those records right afterward.

Jan 18 2022, 7:15 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Jan 13 2022

KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Thanks @Eileenmcnaughton ! I'll work on the purge next week, as I have a lot of tasks on my plate today and tomorrow! (Heads up @nisrael )

Jan 13 2022, 9:10 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

@Eileenmcnaughton Yes, unfortunately they would still be on the suppression list. So the final step would be that we would need to have a CSV w/ email addresses for me to purge them from the Master Suppression List, or if it's possible on your end, could we build an API to remove the selected contacts from the MSL?

Jan 13 2022, 4:44 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Jan 12 2022

KHaggard added a comment to T299011: Deal with EOY emails that did NOT go out.

Thanks for looping me in @krobinson ! And thanks @Eileenmcnaughton for this helpful overview!

Jan 12 2022, 9:30 PM · Patch-For-Review, Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Jan 3 2022

KHaggard added a comment to T298382: Acoustic MG import disabled?.

Sure, that sounds good. I'll go ahead and delete that job in Acoustic since it's outdated.

Jan 3 2022, 11:03 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard added a comment to T298382: Acoustic MG import disabled?.

Hi @Eileenmcnaughton - If you mean the MatchingGifts recurring data job, it should remain deactivated.

Jan 3 2022, 6:26 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Dec 13 2021

KHaggard added a comment to T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.

@Ppena wanted me to confirm that this doc with legal notes had been included in the EOY email:
https://docs.google.com/document/d/1nVcYH8GmlpZvdf04QRwRa4_EZUl6DtIJVxacN_AlRbU/edit

I see it linked in the google drive folder in the body of this task so I assume has been included but I think she was looking for confirmation.

Dec 13 2021, 6:21 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Nov 30 2021

KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Yeah it sounds like there's two different issues that result in the same dilemma, which requires us to go through and clean up data between databases. That other task got paused because it needs a lot of work and I think multiple full file pushes from Civi in order to split out the undeliverables from everything else.
Let's talk more about this task in our call later today! @nisrael

Nov 30 2021, 6:12 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard added a comment to T293587: Question about blocked contacts in Civi and how they sync to Acoustic.

Thanks for looping me in @Eileenmcnaughton . I have latest_optin_response mapped to a custom Acoustic field that's also called latest_optin_response.

Nov 30 2021, 4:30 PM · Fundraising Sprint Anti-matter doesn't matter, fundraising sprint Yeet-coaster, Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Nov 29 2021

KHaggard added a comment to T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.

Chiming in here around the Date formatting point. We have YYYY-MM-DD in the original document that was approved. Also it's the universal date format as Eileen mentioned, so it would make sense to me to keep it consistent for all countries.

Nov 29 2021, 10:08 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Nov 16 2021

KHaggard added a comment to T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.

Thanks @Eileenmcnaughton - Makes sense to me to wait until they are on prod before continuing with QA. Does that sound good to you, @CDenes_WMF ?

Nov 16 2021, 3:22 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Nov 15 2021

KHaggard added a comment to T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.

Hi @Eileenmcnaughton. Since it's officially mid-November, just checking in on the status of these. Are we at a place where I can pass the ball to @CDenes_WMF for post-code translation review? Thanks!

Nov 15 2021, 8:19 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Nov 3 2021

KHaggard added a comment to T294488: Track where we got employer information and export that to Acoustic.

Quickly adding a note: I'd discourage us from adding fields to Acoustic in the middle of the English Campaign right now, because adding fields requires email downtime and we have sends scheduled to go out pretty much every day that we can't reschedule. I'd strongly encourage going the latter route : "use it as a filter to determine whether to export the HEPdata fields", since adding a new custom field won't be possible on our side until mid-December or later.

Nov 3 2021, 10:00 PM · Fundraising Sprint Visual C Saw, fundraising sprint Universal Cereal Bus, Wikimedia-Fundraising-CiviCRM, fr-matching-gifts, Fundraising-Backlog

Oct 19 2021

KHaggard updated subscribers of T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.

Hello, Quick update here:

Oct 19 2021, 6:40 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Sep 15 2021

KHaggard updated the task description for T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.
Sep 15 2021, 4:16 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Sep 8 2021

KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Awesome! Thanks so much for doing that @Eileenmcnaughton :)

Sep 8 2021, 9:15 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Sep 3 2021

KHaggard closed T283798: Recurring donors segmentation criteria Civi/Acoustic as Resolved.

^ As per my comment yesterday, I think we are good to resolve this task (feel free to re-open it if still needed @Eileenmcnaughton ).

Sep 3 2021, 8:04 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Sep 2 2021

KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Thank you so much @Eileenmcnaughton :) I really appreciate your hard work on this project, and I always enjoy the times we get to collaborate.

Sep 2 2021, 5:26 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard created T290253: Civi: EOY Auto Thank You Email Receipt - New content is ready for coding.
Sep 2 2021, 1:54 PM · Fundraising Sprint Xenomorph Petting Zoo, fundraising sprint Wireless Zipline, Fundraising Sprint Visual C Saw, Patch-For-Review, fundraising sprint Universal Cereal Bus, FR-Email, FR-AutoTY-Email, Fundraising-Backlog

Sep 1 2021

KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Thanks for amending those @Eileenmcnaughton !

Sep 1 2021, 3:15 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Aug 31 2021

KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Thanks @Eileenmcnaughton ! It looks like that worked for a lot of contacts, but I still see some CIDs that didn't change for some reason:
2179734
792888
1961177

Aug 31 2021, 2:01 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Aug 30 2021

KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Thanks @Eileenmcnaughton ! Here's some CIDs that have 'Yes' for AF_has_active_recurring_donation that should have 'No':
1720067
792888
625114
2187005
2203833

Aug 30 2021, 9:48 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard added a comment to T283798: Recurring donors segmentation criteria Civi/Acoustic.

Ok, so I checked out some rows. I want to verify definitions again so I have it correct for my notes. From what I'm seeing in the database:

Aug 30 2021, 3:58 PM · fundraising sprint Quantum Leapfrog, fundraising sprint Parallel processing roller coaster, Patch-For-Review, fundraising sprint onion pit, fundraising Sprint NULL calorie food cart, fr-donorservices, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog