Page MenuHomePhabricator

Figure out why sp60563358 is not imported - Emjois?
Closed, ResolvedPublic

Description

I noticed this mailing is missing & separately I noticed that a mailing with emjois in it the title won't save - creating this to track & address

 SELECT count(*), m.id FROM civicrm_mailing_provider_data mp  LEFT JOIN civicrm_mailing m ON m.hash = mp.mailing_identifier WHERE mp.mailing_identifier = 'sp60563358';
+----------+------+
| count(*) | id   |
+----------+------+
|    86186 | NULL |

Details

Related Gerrit Patches:

Event Timeline

Change 553234 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Strip emojis from imported mailings to prevent fatal errors.

https://gerrit.wikimedia.org/r/553234

Change 553234 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Strip emojis from imported mailings to prevent fatal errors.

https://gerrit.wikimedia.org/r/553234

@CCogdill_WMF I noticed when digging into other stuff that not all mailings were in CiviCRM - the one I was digging into turned out to be emjoi related & is hopefully sorted but at the time I noticed & logged this one too.

I can see recipients have taken actions related to mailing 60563358 (opens etc) but I can't seem to retrieve it and the report doesn't show it as sent - https://engage4.silverpop.com/reportsSummary.do?mailingId=60563358

However, I see the word 'control' in the mailing name (2019_France(FR)_French(fr)_Track1_Email2_Control (3)) - perhaps this is just how it is for control mailings? Any insight? I'm thinking I might close this as 'nothing to see here'

Actually I guess the action-to-close should be to document this somewhere

Hmm, that mailing is a remind me later mailing. Those are special cases
because they're sent as automated programs on timers based on user
behavior, rather than as bulk sends. We use different reports to get the
performance data for automated programs. Maybe that's why you can't see the
sent numbers?

@CCogdill_WMF I guess so - even the text doesn't get downloaded when I try - not sure how much it matters

Eileenmcnaughton closed this task as Resolved.Jan 7 2020, 9:04 PM