Page MenuHomePhabricator

KHaggard (Katie Haggard)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

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

Recent Activity

Mon, May 3

KHaggard updated subscribers of T274146: Civi: Contact records can be opted in even when on the Master Suppression List.

@DStrine and @Eileenmcnaughton - Brian found a lot of things in the MSL purge, so I've summarized it a Google Doc for now. Please let me know if this should be broken out in a new task or a series of tasks. https://docs.google.com/document/d/13PCYOVyUpOmm64YCpzgS621VK8bN8j0dmttZm7v1dqM/edit?usp=sharing

Mon, May 3, 5:56 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T281731: Spanish Latam donors seeing English survey.

@DStrine TY page survey only - no surveys sent through email recently and no TY page survey updates recently. I've checked the es-419 and es TY pages and the survey links are correct and in Spanish for each. I'm seeing new responses come in for the es-419 survey.

Mon, May 3, 4:14 PM · Fundraising-Backlog

Fri, Apr 30

spatton awarded T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic a Party Time token.
Fri, Apr 30, 5:12 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard closed T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic as Resolved.

Thanks @Eileenmcnaughton ! With that confirmed, I think we're good to resolve this ticket.

Fri, Apr 30, 2:40 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Thu, Apr 29

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Ok, confirming that the full update is complete and the other job was just the regular smaller "7-day" file.

Thu, Apr 29, 4:44 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Thanks @Eileenmcnaughton and @Dwisehaupt - I'm manually running the job in Acoustic now and it grabbed the DatabaseUpdate-20210429005351.csv file first and it's about halfway through processing now. It also grabbed another file and it's currently "in waiting" in the Acoustic data job queue: DatabaseUpdate-20210429032733.csv, which I'm assuming is the regular 7-day update file?

Thu, Apr 29, 3:58 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Ok, great thank you so much. I'll temporarily disable Acoustic's job to process files at 9am UTC just so that I have more control when it's time to try processing this again tomorrow.

Thu, Apr 29, 1:05 AM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@Eileenmcnaughton If you wouldn't mind generating without that field if that's what it usually look like, that would be great! Acoustic has it's own modified date field anyway and re-mapping isn't as quick as it used to be. If you could please give me a ping here when the file is ready, I could kick it off again.

Thu, Apr 29, 12:56 AM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@Eileenmcnaughton No, sorry what I said wasn't clear. To clarify, Acoustic is set to read postal_code as a text field but it's being sent as a date field from Civi. Since the jobs have been running ok everyday with no bad data, I'm assuming that the issue is in the file. If you could confirm that the export file has postal_code as a text data field, then that will point to the issue being in Acoustic and then Brian and I can investigate further tomorrow.

Thu, Apr 29, 12:42 AM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@Eileenmcnaughton Oh it looks like it's attempting to read the postal_code as a date field instead of a text field.

Thu, Apr 29, 12:11 AM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@Eileenmcnaughton I can't remember if Acoustic provides much detail on which fields have dates not in that format, but I'm attempting to download a results log of the issues and maybe I can find more info for you.

Thu, Apr 29, 12:05 AM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Wed, Apr 28

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Ok @Eileenmcnaughton some good news and bad news:

  • It's running the correct file now which will take a while to finish
  • Bad news is that so far it's reporting 6.5 million rows of bad data, the reason for which is "Date provided is not a valid date/format. Valid format: MM/dd/yyyy"
Wed, Apr 28, 11:52 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Yes - running it again now

Wed, Apr 28, 11:37 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Oh no, looks like it just ran DatabaseUpdate-20210428125329.csv again. I tried manually running it a second time and it failed (which means it didn't find anything on the FTP). Do you know of a way to have your file be first in the queue? I'm not sure why Acoustic isn't picking up both.

Wed, Apr 28, 11:06 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Thanks @Eileenmcnaughton - I'm making Acoustic run the job again and it's picked something up so I'll let you know if it completes successfully.

Wed, Apr 28, 11:01 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Thanks @Eileenmcnaughton - I just ran the job manually but getting a confusing result:
File Name: DatabaseUpdate-20210428125329.csv
Job ID: 183474622
Job Type: Recurring Contact Source Import @ Wednesday, April 28, 2021 at 7:51:04 PM GMT
Total Rows: 200560
Total Valid Rows: 200521
~
I'm only getting 200k rows. The File Name matches what already processed earlier this morning so I tried running it again but it's saying there's nothing on the FTP. Would you be willing to confirm the filename for the export you just sent?

Wed, Apr 28, 8:05 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Thanks @Eileenmcnaughton ! Let me know when the file is uploaded on FTP and I can manually process it on Acoustic's side.

Wed, Apr 28, 4:19 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Fri, Apr 23

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Hi @Eileenmcnaughton. Confirming that I received the larger update in the Acoustic data job summary on April 22nd (pasted job below). If I recall correctly, I think the full export size used to be around 19 million rows.

Fri, Apr 23, 1:32 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Wed, Apr 21

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

@DStrine I've let Brian know we'll have a full data file coming soon. Can you confirm if the deployment will be this week or next?

Wed, Apr 21, 4:36 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Thu, Apr 15

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Cool thanks, @DStrine - heads up that I'm floating those April WMF holidays to this weekend so I'll be around again starting next Tuesday.

Thu, Apr 15, 3:00 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Apr 8 2021

KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Got it! Sounds good to me, thanks!

Apr 8 2021, 3:42 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.

Hey @DStrine ! We have no emails today or tomorrow, so I'm around to process the full export if that works for your team. I'm also going to be working Monday and we have no emails going out that day either.

Apr 8 2021, 3:19 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Mar 31 2021

KHaggard added a comment to T274146: Civi: Contact records can be opted in even when on the Master Suppression List.

Quick update that I received some answers on these definitions:

Mar 31 2021, 8:25 PM · FR-Email, Fundraising-Backlog

Mar 23 2021

KHaggard closed T277366: Civi to Acoustic export: Confirming value for Total Duplicate Addresses as Resolved.

Following up that my previous comment is still accurate and I can resolve this task now. It seems this was a one-time occurrence and unfortunately there's nothing we can do to ensure that we will get external communications ahead of time from Acoustic.

Mar 23 2021, 8:07 PM · Fundraising Sprint File Systems Stage Show, Fundraising Sprint Esperantoland, FR-Email, Fundraising-Backlog

Mar 22 2021

KHaggard added a comment to T277366: Civi to Acoustic export: Confirming value for Total Duplicate Addresses.

Hey everyone I'm back! I'm meeting with Brian tomorrow to talk through everything that happened last week, so I'll comment here again after that to wrap up and resolve this ticket.

Mar 22 2021, 5:46 PM · Fundraising Sprint File Systems Stage Show, Fundraising Sprint Esperantoland, FR-Email, Fundraising-Backlog

Mar 13 2021

KHaggard created T277366: Civi to Acoustic export: Confirming value for Total Duplicate Addresses.
Mar 13 2021, 12:31 PM · Fundraising Sprint File Systems Stage Show, Fundraising Sprint Esperantoland, FR-Email, Fundraising-Backlog

Mar 10 2021

KHaggard added a project to T271883: Civi: EoY recurring receipt email – 2021 catchall for retro: FR-AutoTY-Email.
Mar 10 2021, 9:02 PM · FR-AutoTY-Email, Wikimedia-Fundraising-CiviCRM, fr-donorservices, Fundraising-Backlog

Feb 24 2021

KHaggard updated the task description for T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.
Feb 24 2021, 5:58 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T273833: Silverpop - update our list of database ids.

Hi @Eileenmcnaughton - I've just deleted the 20180828_Advocacy database in Acoustic, so we no longer need privacy erase requests going to ID: 20285807

Feb 24 2021, 3:14 PM · Fundraising Sprint Downed power line jump rope, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Feb 16 2021

KHaggard added a comment to T273833: Silverpop - update our list of database ids.

Hi @Eileenmcnaughton - I've just deleted the 20180208_StrategyEmailList database in Acoustic, so we no longer need privacy erase requests going to ID: 19429406

Feb 16 2021, 8:16 PM · Fundraising Sprint Downed power line jump rope, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Feb 8 2021

KHaggard updated the task description for T274146: Civi: Contact records can be opted in even when on the Master Suppression List.
Feb 8 2021, 2:20 PM · FR-Email, Fundraising-Backlog
KHaggard updated the task description for T274146: Civi: Contact records can be opted in even when on the Master Suppression List.
Feb 8 2021, 2:18 PM · FR-Email, Fundraising-Backlog
KHaggard created T274146: Civi: Contact records can be opted in even when on the Master Suppression List.
Feb 8 2021, 2:17 PM · FR-Email, Fundraising-Backlog

Feb 4 2021

KHaggard raised the priority of T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic from Low to Medium.

Updating here that the data for foundation_has_recurred_donation within Acoustic has been altered, so we currently can't use this field in our queries until we get a full Civi file ran through Acoustic. This issue will be fixed by default when the capitalization is fixed, but I'm bumping the priority up a notch since the has_recurred_donation field is now no longer usable in Acoustic.

Feb 4 2021, 8:47 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard added a comment to T273833: Silverpop - update our list of database ids.

Hi @Eileenmcnaughton ! Thanks for logging this. Everything you listed in still there in Silverpop, so please keep sending to all 6 privacy erase requests. Here's what each one is going to:

Feb 4 2021, 2:58 PM · Fundraising Sprint Downed power line jump rope, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Feb 3 2021

KHaggard closed T273764: Missing today's files on FTP - Civi to Acoustic as Resolved.

Cool, this is now fixed. Thanks much @jgleeson ! Resolving this phab now :)

Feb 3 2021, 2:44 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T273764: Missing today's files on FTP - Civi to Acoustic.

Thanks so much, @jgleeson ! Feel free to ping me on IRC when the job's complete. :)

Feb 3 2021, 2:22 PM · FR-Email, Fundraising-Backlog
KHaggard added a project to T273764: Missing today's files on FTP - Civi to Acoustic: FR-Email.
Feb 3 2021, 2:06 PM · FR-Email, Fundraising-Backlog
KHaggard triaged T273764: Missing today's files on FTP - Civi to Acoustic as Unbreak Now! priority.
Feb 3 2021, 2:06 PM · FR-Email, Fundraising-Backlog
KHaggard created T273764: Missing today's files on FTP - Civi to Acoustic.
Feb 3 2021, 2:06 PM · FR-Email, Fundraising-Backlog

Feb 1 2021

KHaggard closed T269294: Matching Gifts: Add fields to all_wikimedia from SSI database as Resolved.

Hello! Just writing to confirm that the export/import process ran smoothly over the weekend with no failures. :) thanks so much for your help on this @jgleeson I'm resolving the ticket now.

Feb 1 2021, 5:16 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 29 2021

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

@jgleeson - I just finished mapping the fields for _all_Wikimedia. The summary report looks good and I'm posting it below:

Jan 29 2021, 3:49 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 28 2021

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Hi @jgleeson ! Thanks for this update. I saw it before logging off today, so I went forward with doing a test run with our fake database.

Jan 28 2021, 11:29 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Update:
@jgleeson and I met and discussed a game plan for the Matching Gifts fields. We decided to play things on the safe side and do a test run of importing the fields to a fake database, before running the real job on _all_Wikimedia.

Jan 28 2021, 8:14 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 27 2021

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

@jgleeson Yeah sounds great - let's do that. I'm free to hop on a call anytime between 1:30pm - 7pm UTC

Jan 27 2021, 9:07 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

We can try talking it out here, but I'm happy to jump on a call tomorrow too if you prefer.

Jan 27 2021, 8:50 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

hi @jgleeson - email team's last email deployment for this week is tomorrow, Thursday Jan 28th at 16:00 UTC. So, if things are ready on your side, I'll be ready to receive the new civi export file after 16:00 tomorrow. :)

Jan 27 2021, 7:51 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 26 2021

KHaggard added a comment to T266599: As an email reporter, I need to know how to pull domain reports in Civi for soft bounces.

Thanks, I appreciate that. Confirming that resolving this task makes sense and we can move over to email or Slack about any followups. Thanks!

Jan 26 2021, 5:21 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T266599: As an email reporter, I need to know how to pull domain reports in Civi for soft bounces.

Hi @EYener - thanks for circling back! This was a one-off request that I don't believe we need anymore. However, the main idea of this task was to see if I can learn how to pull a longitudinal report from Civi. If I can learn how to do that, I won't need to loop in multiple stakeholders in order to give Trilogy a report. Is that a possibility?

Jan 26 2021, 2:07 PM · FR-Email, Fundraising-Backlog

Jan 20 2021

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Thanks @DStrine ! Either option works for me. Thanks for the update :)

Jan 20 2021, 5:32 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Hey @jgleeson ! Thanks for grabbing this task. Just wanted to say that pretty much any Thursday after 4pm UTC will work for me in regards to uploading the CSV file to FTP. I can remap the fields in my Thursday evenings and QA check it on Fridays. Let me know which Thursday sounds good for you and I'll plan for it :) Thanks!

Jan 20 2021, 5:18 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 13 2021

KHaggard added a comment to T270341: As a database manager, I need a GDPR Erasure API call for Acoustic's Master Suppression List.

Sure, I can document on this phab. Brian did some digging on his end and found this in GDPR law:

Jan 13 2021, 4:46 PM · FR-Email, Fundraising-Backlog

Jan 12 2021

KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

Yeah 450 days sounds correct to me too. Thanks so much for your work on this! @Eileenmcnaughton

Jan 12 2021, 10:12 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog
KHaggard closed T270341: As a database manager, I need a GDPR Erasure API call for Acoustic's Master Suppression List as Invalid.

Hi folks, I heard from @bsisolak that we can actually cancel this phab task, due to additional info we learned about GDPR law. It's best to keep an email address as opted out even if they request data erasure, to avoid the possibility of said person resubscribing.

Jan 12 2021, 8:47 PM · FR-Email, Fundraising-Backlog

Jan 11 2021

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Hey all, I'm back and catching up on everything. Are there any new developments on this phab before I remap the _all_wikimedia database?

Jan 11 2021, 5:00 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Dec 22 2020

KHaggard triaged T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic as Low priority.
Dec 22 2020, 7:03 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog
KHaggard created T270731: Civi export data for 2 fields are preventing accurate data validation reports in Acoustic.
Dec 22 2020, 7:03 PM · Fundraising Sprint Interstitial ads halfway down the coaster hill, Fundraising Sprint Humongous bacteria petting zoo, FR-Email, Fundraising-Backlog

Dec 21 2020

KHaggard closed T270449: Acoustic maintenance notice: No need for Civi export as Resolved.
Dec 21 2020, 7:14 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T270449: Acoustic maintenance notice: No need for Civi export.

Talked with fr-tech about this phab on standup. Fr-tech cannot split up the civi export "bundle" (without extra coding work) and there's no real need for fr-tech to stop sending the files. We agreed to keep the exports running as is, and I will have Acoustic catch up when I'm back around on Jan 11th.

Dec 21 2020, 6:28 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

@Eileenmcnaughton I don't think we cancel emails very often, so I don't see a blocker from my side. Is it possible to allow cancelled sends in Superset for this specific date range?

Dec 21 2020, 5:28 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog

Dec 17 2020

KHaggard updated subscribers of T270449: Acoustic maintenance notice: No need for Civi export.
Dec 17 2020, 11:00 PM · FR-Email, Fundraising-Backlog
KHaggard updated subscribers of T270449: Acoustic maintenance notice: No need for Civi export.
Dec 17 2020, 11:00 PM · FR-Email, Fundraising-Backlog
KHaggard created T270449: Acoustic maintenance notice: No need for Civi export.
Dec 17 2020, 10:56 PM · FR-Email, Fundraising-Backlog

Dec 16 2020

KHaggard created T270341: As a database manager, I need a GDPR Erasure API call for Acoustic's Master Suppression List.
Dec 16 2020, 9:16 PM · FR-Email, Fundraising-Backlog

Dec 15 2020

KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

@EYener may be able to elaborate more on those ^questions, but some quick context about Superset:

Dec 15 2020, 10:17 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog

Dec 11 2020

KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

It's the 5th subject line segment from the "Recent" target group send on Dec 7th. It's just one single mailing_id (sp69308812) and the mailing name is R2-5b_20201207_UnitedStates(US)_English(en)_Email3_SL-Copy-DifferentCircumstances_Recent (2)

Dec 11 2020, 7:54 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog
KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

Thanks for the tag! I would set this as a medium or low priority. I would very much like this to show up in Superset at some point, but it's not a blocker for our processes. I can pull the stats up the old fashioned way for now. The send size for this segment is 15k. Thanks all!

Dec 11 2020, 6:30 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog

Dec 9 2020

KHaggard updated the task description for T269811: As an email stats updater, I need to find results for a send that is missing from Superset.
Dec 9 2020, 11:25 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog
KHaggard updated the task description for T269811: As an email stats updater, I need to find results for a send that is missing from Superset.
Dec 9 2020, 11:22 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog
KHaggard renamed T269811: As an email stats updater, I need to find results for a send that is missing from Superset from As a email stats updater, I need to find results for a send that is missing from Superset to As an email stats updater, I need to find results for a send that is missing from Superset.
Dec 9 2020, 11:17 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog
KHaggard created T269811: As an email stats updater, I need to find results for a send that is missing from Superset.
Dec 9 2020, 11:16 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, Patch-For-Review, FR-Tech-Analytics, FR-Email, Fundraising-Backlog

Dec 2 2020

KHaggard added a comment to T269294: Matching Gifts: Add fields to all_wikimedia from SSI database.

Quickly chiming in here that _all_Wikimedia already has been mapped with employer_id and employer_name from the civi export.

Dec 2 2020, 9:35 PM · Fundraising Sprint Bee Wheel, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week.

@MSuijkerbuijk_WMF Yes, I sent over a training doc I had via email.

Dec 2 2020, 4:20 PM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard added a comment to T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week.

Thanks for that clarification, @Eileenmcnaughton !

Dec 2 2020, 1:48 AM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard added a project to T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week: FR-Email.
Dec 2 2020, 1:13 AM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard closed T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week as Resolved.

Hopped in IRC with talked it through with @Eileenmcnaughton and @DStrine.

Dec 2 2020, 1:11 AM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog

Dec 1 2020

KHaggard updated the task description for T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week.
Dec 1 2020, 9:55 PM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard renamed T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week from As a database manager, I need a full file of _all_Wikimedia sent over this week to As a database manager, I need a full file civi export for _all_Wikimedia sent over this week.
Dec 1 2020, 9:37 PM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard triaged T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week as High priority.
Dec 1 2020, 9:36 PM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog
KHaggard created T269170: As a database manager, I need a full file civi export for _all_Wikimedia sent over this week.
Dec 1 2020, 9:36 PM · FR-Email, Fundraising Sprint Xtreme Lolcats, Fundraising-Backlog

Nov 24 2020

KHaggard added a comment to T266475: matching gifts values don't match between databases.

Moska is out of office, but I'm pretty sure QA checks are almost complete except one last thing Briana needs Moska for. That's all I know for now, but Moska returns tomorrow so she may be able to chime in then. Thanks!

Nov 24 2020, 9:54 PM · Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising-Backlog

Nov 12 2020

KHaggard closed T265352: Civi to IBM export: Yesterday's files were sent today as Resolved.

Thanks @jgleeson ! I checked out the recurring import jobs and they processed yesterday's again but also the correct day's files right after. We're all set today for sending out emails :)

Nov 12 2020, 2:25 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog

Nov 11 2020

KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

Sure thing, @DStrine ! Apologies, I was under the impression that re-using the same task was preferred, as the issue replicates the same way on the Acoustic side. I'll make new tasks from now on. Shall I resolve this one now and make a new task for tomorrow if needed?

Nov 11 2020, 7:22 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard lowered the priority of T265352: Civi to IBM export: Yesterday's files were sent today from Unbreak Now! to High.
Nov 11 2020, 5:17 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

Issue is resolved for today! Big thanks to @Ejegg and @jgleeson. From what I read in the chat and email today, it seems that in the short-term, fr-tech will need to fix data manually for each query before re-running the export job. @jgleeson will kindly check back in tomorrow to see if the export needs redoing then. Thank you, Jack!

Nov 11 2020, 5:15 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

Thanks! @Ejegg looked into it and sent over the files again. I processed them on my side and so I think we are good. I do want to quickly note that the Unsubscribes file doesn't seem to be increasing (like it usually does) for the last few days. Dropping in yesterday's job and today's job:

Nov 11 2020, 3:33 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard reopened T265352: Civi to IBM export: Yesterday's files were sent today as "Open".

The civi export file failed again this morning, but we already had emails go out at 10:00 UTC. Donor services has been notified. We have another batch of emails scheduled for tomorrow, so it's urgent for us to have the export running today and tomorrow. Is there someone working today who is willing to look into this? Thanks!

Nov 11 2020, 2:22 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog

Nov 10 2020

KHaggard closed T265352: Civi to IBM export: Yesterday's files were sent today as Resolved.
Nov 10 2020, 6:33 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

This issue is now resolved. We had a bump in the road with manual exports failing a few times, and then a bad data issue with fields including a "b'" before the values.
Thanks for working on this today!

Nov 10 2020, 6:32 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard reopened T265352: Civi to IBM export: Yesterday's files were sent today as "Open".

Reopening this task. We had emails scheduled for today at 14:00 UTC, just unscheduled them. Could today's export be run asap? @jgleeson @Ejegg

Nov 10 2020, 1:28 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog

Nov 4 2020

KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

Noting this issue happened again today (Nov 4, 2020). @jgleeson noticed and kicked off a rerun this morning, so we are clear to send emails today.

Nov 4 2020, 1:20 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog

Oct 30 2020

KHaggard added a comment to T265700: all_Wikimedia database shows both_funds_donation_count as a decimal.

The conversation about the few un-updated contacts has been moved to this phab T254304 so we can "officially" close this one out. Thanks!

Oct 30 2020, 6:46 PM · Fundraising Sprint Upbeat Upholstery, Fundraising-Backlog
KHaggard updated subscribers of T254304: Conflicting fields in some Acoustic contact records.

Adding in some new mystery contacts from another phab (T265700) into this one to investigate why a small number of contacts did not get modified by a full database update and are also not on the Master Suppression List.

Oct 30 2020, 6:44 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard closed T265352: Civi to IBM export: Yesterday's files were sent today as Resolved.

Acoustic import ran successfully and looks good to me. Thanks for the help! Resolving this task now.

Oct 30 2020, 5:16 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard added a comment to T265352: Civi to IBM export: Yesterday's files were sent today.

Met with fr-tech team today! @Ejegg found that the "uploader" is being kicked off too soon before the "builder" is finished. He kicked off a new file for me and is working on making sure the uploads wait to deploy until after the building job completes. Let me know if I got that right :)

Oct 30 2020, 4:58 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard updated subscribers of T265352: Civi to IBM export: Yesterday's files were sent today.

Whoops, just realized Jack, Eileen, and Maggie are OOO today. @Ejegg - are you available to triage this?

Oct 30 2020, 1:56 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog
KHaggard reopened T265352: Civi to IBM export: Yesterday's files were sent today as "Open".

Hey @jgleeson. I'm opening this ticket again as the export sent over yesterday's files again. Luckily, there's no emails going out today, but we pick back up on Monday.

Oct 30 2020, 1:53 PM · fundraising sprint Theme songs for programming languages, FR-Email, Fundraising-Backlog

Oct 28 2020

KHaggard added a comment to T266599: As an email reporter, I need to know how to pull domain reports in Civi for soft bounces.

Also, just wanting to realign on the main issue of this task:
yahoo.com is bouncing at 3% now based on the latest enUS send we deployed, which seems alarming since it's the second most popular domain group in every email send. @EYener is it possible to pull a civi report tracking yahoo specifically?

Oct 28 2020, 3:33 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T266665: Civi to IBM export: No file on FTP.

Confirming that the import jobs completed successfully now and we are rescheduling emails. Do we want to keep this phab open for the re-try code or should I resolve this task?

Oct 28 2020, 2:41 PM · FR-Email, Fundraising-Backlog
KHaggard added a comment to T266665: Civi to IBM export: No file on FTP.

Just confirming that there was a send scheduled to go out in 30 mins for Major Gifts, we're unscheduling that send now.

Oct 28 2020, 1:31 PM · FR-Email, Fundraising-Backlog