Page MenuHomePhabricator

KHaggard (Katie Haggard)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

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

Recent Activity

Dec 4 2019

KHaggard added a comment to T239635: Investigation: Tracking the drop in _all_wikimedia contact source job total rows.

That makes sense. I'm attaching the most recent jobs from this morning below - and things seem to be running as normal again. Thanks for all your help here! I think we can close this.

Dec 4 2019, 5:11 PM · Fundraising Sprint YAMLton, the Musical, Fundraising Sprint X-rays, Fundraising-Backlog

Dec 2 2019

KHaggard updated the task description for T239635: Investigation: Tracking the drop in _all_wikimedia contact source job total rows.
Dec 2 2019, 5:46 PM · Fundraising Sprint YAMLton, the Musical, Fundraising Sprint X-rays, Fundraising-Backlog
KHaggard created T239635: Investigation: Tracking the drop in _all_wikimedia contact source job total rows.
Dec 2 2019, 5:45 PM · Fundraising Sprint YAMLton, the Musical, Fundraising Sprint X-rays, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Thanks! New ticket is here: T239635

Dec 2 2019, 5:44 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

I can open a new phab task - just confirming that: the contacts in the MSL should not be on the _all_wikimedia database contact source update job, is that correct? So when there’s an increase in the Master Suppression List, a decrease in the main database should be expected?

Dec 2 2019, 4:33 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

@Ejegg One thing I would like to ask about: even though the jobs are running smoothly again, the total # rows is still roughly 1 million below what it used to be. Just wondering if this is worth looking into further. Attaching the jobs from 11/21 (before the timing issue started). You can see the total is 17 mil and today's current total is 16 mil.

Dec 2 2019, 12:11 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 28 2019

KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Thanks - the jobs this morning ran without failure and the numbers look healthy to me. Attaching below.

Nov 28 2019, 5:26 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 27 2019

KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Hey @Ejegg I manually ran the import job again so it should be out of the way for the new file tomorrow, but would you be willing to confirm that it has been deleted from SFTP?

Nov 27 2019, 8:05 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Thanks @Ejegg I'll update this thread letting you know if the totals look healthy again tomorrow morning :)

Nov 27 2019, 5:26 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 26 2019

KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

We tell IBM to look for “DatabaseUpdate-*” and “Unsubscribes-*” which matches the beginning nomenclature of the FTP file. It then grabs the oldest file first since we don't specify the date. So in the case of multiple days backed up, we manually run the data job via that screenshot I added however many times it takes to catch up.

Nov 26 2019, 9:36 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Sure, let me know the best way I can show you, or I will try writing it out here and just let me know if it makes sense.

Nov 26 2019, 3:39 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard added a comment to T239126: Huge decrease in contacts from the main database update.

Updating that the _all_wikimedia data job runs successfully but the Master Suppression List does not, but I am able to manually run the MSL job with success.

Nov 26 2019, 3:19 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 25 2019

KHaggard triaged T239126: Huge decrease in contacts from the main database update as High priority.
Nov 25 2019, 5:06 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard created T239126: Huge decrease in contacts from the main database update.
Nov 25 2019, 5:05 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 19 2019

KHaggard triaged T238689: Civi to IBM export: Ensure CIDs ordered in reverse chronological order as Unbreak Now! priority.
Nov 19 2019, 8:52 PM · Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
KHaggard created T238689: Civi to IBM export: Ensure CIDs ordered in reverse chronological order.
Nov 19 2019, 8:52 PM · Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 8 2019

KHaggard closed T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM as Resolved.
Nov 8 2019, 1:19 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
KHaggard added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

False alarm, the import this morning is back to normal and pulling the correct date file. Sorry for flagging that too early! I think we are all good here. Thanks for your help and have a great weekend!

Nov 8 2019, 1:18 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 7 2019

KHaggard added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Thanks, Ejegg ! I checked again and the password expiration countdown banner has gone away for this user 😄 So I think this part is resolved. Thank you!

Nov 7 2019, 2:48 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 6 2019

KHaggard updated subscribers of T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Bumping this again, the silverpop data upload account is saying the password will expire in 5 days, so I think the password needs to be reset via a direct account log in before then.

Nov 6 2019, 8:50 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 5 2019

KHaggard reopened T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM as "Open".

We received a response to why the password keeps expiring every 7 days:

Nov 5 2019, 2:38 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 4 2019

KHaggard closed T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM as Resolved.
Nov 4 2019, 8:40 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
KHaggard added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Hi all, I was able to run the import jobs manually today and the totals look good.

Nov 4 2019, 8:39 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 1 2019

KHaggard added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Quick update: We can't manually run the file because the FTP file isn't there, and my thinking is that it wasn't there for the scheduled 9am GMT time either. Caitlin and I think maybe the file upload must have failed.

Nov 1 2019, 1:39 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
KHaggard triaged T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM as High priority.
Nov 1 2019, 1:07 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
KHaggard created T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.
Nov 1 2019, 1:06 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Oct 31 2019

KHaggard added a comment to T234925: Problem with email opt-outs reaching Civi as unsubscribes.

Thanks for the heads up @Ejegg ! It definitely did spike this morning :)

Oct 31 2019, 12:32 PM · Fundraising Sprint Visual Basic Instinct, Fundraising Sprint Usual Subscripts, Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-Banners, Fundraising-Backlog

Oct 23 2019

KHaggard added a comment to T236073: Contact Source job failed..

Hi @Ejegg - The imports ran successfully this morning 🙌🏼 Thanks for your awesome work and speedy replies!

Oct 23 2019, 3:00 PM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog

Oct 22 2019

KHaggard added a comment to T236073: Contact Source job failed..

Thanks for investigating! Ok I will keep the current 9am GMT run time for IBM and will let you know if it is successful tomorrow :)

Oct 22 2019, 3:22 PM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog
KHaggard updated subscribers of T236073: Contact Source job failed..
Oct 22 2019, 3:21 PM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog
KHaggard added a comment to T236073: Contact Source job failed..

Thanks, @Ejegg ! If the load time is not fixable, would fr-tech be willing to set the export time 2 hours earlier?

Oct 22 2019, 2:56 PM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog
KHaggard added a comment to T236073: Contact Source job failed..

Adding a quick update here that both imports failed this morning. I will wait a couple hours and then run the imports manually. Please let me know if you need me to hold off on doing that for any reason. Attaching screenshot below if it's helpful.

Oct 22 2019, 12:43 PM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog

Oct 4 2019

KHaggard added a comment to T233744: Update IBM with TargetSmart Age data.

z_birth_date has been added to the recurring import :) Thanks everyone!

Oct 4 2019, 5:19 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Oct 3 2019

KHaggard added a comment to T233744: Update IBM with TargetSmart Age data.

Got it - did not see it, so running today's import now and will try again tomorrow.

Oct 3 2019, 1:01 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard added a comment to T233744: Update IBM with TargetSmart Age data.

@CCogdill_WMF ok so I should be seeing birth_date when setting up the import today or do I manually add that in as a date field?

Oct 3 2019, 11:55 AM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Sep 24 2019

KHaggard triaged T233744: Update IBM with TargetSmart Age data as High priority.
Sep 24 2019, 5:24 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
KHaggard created T233744: Update IBM with TargetSmart Age data.
Sep 24 2019, 5:23 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Sep 10 2019

KHaggard added a comment to T231538: One-time import of target smart data into IBM -- how to do this?.

Hi @Eileenmcnaughton! Yes, it worked :) Thanks for the work you put into this!

Sep 10 2019, 8:12 PM · Fundraising Sprint Sysadmin Kane, Fundraising Sprint Rocky Horror Presentation Layer, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jul 17 2019

KHaggard triaged T228176: refresh CiviCRM SSL client certificate for Katie Haggard as Unbreak Now! priority.
Jul 17 2019, 8:05 PM · fundraising-tech-ops, Fundraising-Backlog
KHaggard updated subscribers of T228176: refresh CiviCRM SSL client certificate for Katie Haggard.
Jul 17 2019, 3:36 PM · fundraising-tech-ops, Fundraising-Backlog

Jul 16 2019

KHaggard created T228176: refresh CiviCRM SSL client certificate for Katie Haggard.
Jul 16 2019, 3:20 PM · fundraising-tech-ops, Fundraising-Backlog

Jul 5 2019

KHaggard added a comment to T227210: Mysql Pgehres query not rendering Unique Clicks for Japan.

Update: Looks like mysql pgehres is able to pull the clicks data today. Not sure what has changed, but the query no longer produces an empty set.

Jul 5 2019, 8:02 PM · Fundraising-Backlog

Jul 3 2019

KHaggard created T227210: Mysql Pgehres query not rendering Unique Clicks for Japan.
Jul 3 2019, 4:59 PM · Fundraising-Backlog

Jun 28 2019

KHaggard added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

@CCogdill_WMF Hello! Yes, I'm attaching a screenshot of yesterday's import next to today's import. Looks like the main database decreased by ~1k and the unsubscribes increased by ~1k also.

Jun 28 2019, 3:50 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog

Jun 5 2019

KHaggard added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

This morning, I just saw a slight decrease again. Please see attached screenshot.

Jun 5 2019, 6:37 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog

May 20 2019

KHaggard triaged T223935: SPIKE: Unsubscribes import decreasing in size over 2 days as High priority.
May 20 2019, 8:19 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog

Nov 13 2018

KHaggard added a comment to T209196: CiviCRM access for Katie Haggard.

Password received, thank you.

Nov 13 2018, 6:38 PM · fundraising-tech-ops
KHaggard added a comment to T209196: CiviCRM access for Katie Haggard.

Thank you. I have received the Civi cert via email but not the sms. Would you be willing to resend the text message password?

Nov 13 2018, 4:41 PM · fundraising-tech-ops