Page MenuHomePhabricator

bsisolak (Brian Sisolak)
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
Jan 7 2019, 9:36 PM (175 w, 3 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Bsisolak [ Global Accounts ]

Recent Activity

Fri, Apr 22

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

@Eileenmcnaughton Not having an email in the upload should not have stopped the Contact List from being built. What API calls are you making and with what parameters?

Fri, Apr 22, 5:12 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Thu, Apr 21

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

No real person should have that as their email address, I would leave it and opt the user out.

Thu, Apr 21, 7:51 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Jan 18 2022

bsisolak updated subscribers of T296054: Featured Request: Have Civi reflect when an email has been unsubscribed 90 days .
Jan 18 2022, 6:46 PM · fr-donorservices, Fundraising-Backlog

Jan 7 2022

bsisolak added a comment to T296054: Featured Request: Have Civi reflect when an email has been unsubscribed 90 days .

Something struck me on how you can get this data. If you run this API call each day:

Jan 7 2022, 11:16 PM · fr-donorservices, Fundraising-Backlog

Nov 23 2021

bsisolak added a comment to T296054: Featured Request: Have Civi reflect when an email has been unsubscribed 90 days .

Both, you can see who is snoozed in the UI and via an API export - but you can't get the date.

Nov 23 2021, 8:17 PM · fr-donorservices, Fundraising-Backlog
bsisolak added a comment to T296054: Featured Request: Have Civi reflect when an email has been unsubscribed 90 days .

You can export the current list of Snoozed records (which is currently 15,882) but not the date they will become un-snoozed.

Nov 23 2021, 6:45 AM · fr-donorservices, Fundraising-Backlog

Jan 19 2021

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

SENT_CANCELLED does not do anything with GetSentMailingsForOrg. What is the mailing ID of the canceled mailing?

Jan 19 2021, 5:00 AM · 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

Jan 13 2021

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

Your data retention policy is set to 450 days, you can see this under Organization Settings -> Archive Settings. I'll have to test that specific question. I would suggest you should cap all data at 90-120 days, anything after that is likely not real user activity, and has no chance of substantially changing the data. Frankly, I suspect if you had a cutoff of 60 days (or even shorter) that would capture 99.8% of all your data.

Jan 13 2021, 7:53 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

Jan 5 2021

bsisolak added a comment to T271187: Forget me failing.

I'm hoping once you get rid of all the extra databases, this issue will no longer occur. As this seems to never happen with the main database. There is no reason to open Support tickets on these as they are aware of the issue.

Jan 5 2021, 4:29 PM · fr-donorservices, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Dec 22 2020

bsisolak added a comment to T270602: Failing privacy request.

Same issue as before. As this only happens with the non _All wiki DB, I'm hoping once these other DBs are removed this issue will be resolved.

Dec 22 2020, 7:05 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Dec 21 2020

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

I found an email from 2015 wher eI outlined this API call. I forgot there is an unpublsied elements called SENT_CANCELLED. I'll reforward the email.

Dec 21 2020, 4:55 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

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

Ah yes, remove <SENT/> and that will return all types, included Canceled.

Dec 17 2020, 10:07 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 16 2020

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

Add List ID 9574332 and that should do it.

Dec 16 2020, 9:38 PM · FR-Email, Fundraising-Backlog

Dec 15 2020

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

Ah... ok. So let's look at the specific API call. Need the full XML. Thanks.

Dec 15 2020, 10:23 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
bsisolak added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

(a) what is Superset? (b) what is the API call you are making, do you have the XML?

Dec 15 2020, 9:43 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

Nov 18 2020

bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

I have opened a case up on these two jobs.

Nov 18 2020, 12:04 AM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Oct 30 2020

bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

No logs are stored more than four days (as that would not be GDPR complaint). I suspect you see the SUCCESS within 1-2 mins every time? Can you setup an alert that if don’t get that say within an hour, it sends us off an email?

Oct 30 2020, 7:38 PM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Oct 28 2020

bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Data job results are only retained for three days, so I can ask, but don't expect there is more infomraiton.

Oct 28 2020, 11:27 PM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

With an average of 68 GDPR data calls in the last three days (and the numbers are sequential) , that would make that ID around 50 days ago. Does that make sense?

Oct 28 2020, 10:14 PM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

That ID is a bit confusing. The current GDPR data job are IDs 33341 -> 33546, which all ran in the last three days and all are marked SUCCESS. Thought maybe this was a datajob ID, but that range is 173051574 -> 173776347. What was the API call make with this ID and when?

Oct 28 2020, 9:54 PM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T266599: As an email reporter, I need to know how to pull domain reports in Civi for soft bounces.

A 3% is normal for Verizon (aka, AOL/Yahoo). When I see blocks at Verizon it will be 100% soft boucning.

Oct 28 2020, 3:37 PM · FR-Email, Fundraising-Backlog

Oct 27 2020

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

You want to build this report by domain group, not domain. Example, RoadRunner no longer exists, it is now part of Spectrum Communications. I will build a mapping for domains -> domain groups to use.

Oct 27 2020, 8:28 PM · FR-Email, Fundraising-Backlog

Oct 22 2020

bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Each GDPR job has several subtasks. The job may get stuck after completing the subtask. This is a known issue. If a GDPR job does not complete within 60 minutes, just let me know and we can dig into it.

Oct 22 2020, 4:56 PM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

I'll have to ask if there are more details on the failures. When you get one that failed, are you able to re-run it? Did you mean the two from July 2019?

Oct 22 2020, 5:21 AM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Also, I recommend you merge all your data into a single database to simplfy GDPR requests. There are seven databases right now, and ten suppression lists.

Oct 22 2020, 4:55 AM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
bsisolak added a comment to T222287: Civi: make sure Forget Me requests reach IBM.

Reading back over the previous notes, wanted to mention "I realize RML contacts should have civi contacts" - there are several hundred thousands RML signups that are not in Civi. Some are historical, and some are recent. I'm unclear how you are getting RML contacts out of Acoustic into Civi, but happy to help debug that if you want.

Oct 22 2020, 4:53 AM · Patch-For-Review, Fundraising Sprint We all meet again, Fundraising Sprint Vagranty McVagrantface, Fundraising Sprint Upbeat Upholstery, fr-donorservices, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Sep 21 2020

bsisolak added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

Can we take one step back and sanity check that the Civi database has all the data from the Master Suppression List? I'm assuming (and this might be wrong) that there are emails on the Master Suppression List that are not marked as opt-outed in Civi. When you export the MSL, select the “Export Contacts, Opt-Outs, Snoozes and Undeliverables” option.

Sep 21 2020, 8:23 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog

Sep 17 2020

bsisolak added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

Rebuilding the Master Suppression List is very risky, and I would not recommend it. Anyone on that list should never be emailed. If Civi were missing any data, that could be catastrophic to your deliverability.

Sep 17 2020, 4:55 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog

Sep 16 2020

bsisolak added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

"there's a way to import the list of suppressed contacts to the main db with opt-out selected so that it just updates the contacts that are already in the main db" - Are you referring to Civi or the Acoustic database? For sure you can keep this all clean in Acosutic, but over time it will get out of sync again.

Sep 16 2020, 4:33 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog

Sep 15 2020

bsisolak added a comment to T261705: As a email manager, I'd like to see which contacts are suppressed.

A few notes to add. You can do anything mentioned here with the API, it's just up to you how you want to structure it. The link above about CRM integration does not apply here (that is for Acoustic accounts that sync with SFMC or MS Dynamics).

Sep 15 2020, 9:14 PM · Fundraising Sprint Upbeat Upholstery, fundraising sprint Theme songs for programming languages, Fundraising Sprint 🐍 is not a valid zipcode, Fundraising Sprint Raw data never hurt anyone, Fundraising-Backlog

Jan 22 2019

bsisolak added a comment to T210445: Stronger DKIM key for fundraising emails?.

IBM validated the DNS setting, and is using the new key:

Jan 22 2019, 10:42 PM · SRE, Mail, fundraising-tech-ops, Fundraising-Backlog

Jan 9 2019

bsisolak added a comment to T210445: Stronger DKIM key for fundraising emails?.

The key is correct, and IBM will validate it before turing it live. I would recommend in four months, you remove the old key.

Jan 9 2019, 9:28 PM · SRE, Mail, fundraising-tech-ops, Fundraising-Backlog