@Pcoombe Is this something you can help with?

No, it's nothing to do with me

Oh shoot, they must have changed their lookup site. I'll try to determine the new URL.

I've submitted a Zendesk ticket with Affinaquest (new name for HEPData/SSBInfo) and marked it as high priority. Will follow up with emails if they don't get back to us by this afternoon. @KHaggard could you please disable the matching gift information emails in Acoustic until we can update those links?

could it be https://www.matchinggifts.com/wikimedia_iframe

Thanks @jgleeson! Looks like that search form does work and has our logo on it, but I can't see how to get a direct link to a single company's matching policies like they previously had.

Yeah, me neither. I guess we should wait for the provider to come back with the direct links.

Looks like it's a big VueJS app that gets ALL the details to render the form in the search results coming back from that autocomplete, then displays the form with a handleClickedMatch function. I don't see their code looking at querystring values anywhere to allow us to pass in the company ID.

If they don't have the ability to display a company-specific page on a direct link, we could replicate it with the data from their API, it'll just mean another template to build and maintain.

Posting the HEP data API instruction here in case it is helpful: https://drive.google.com/file/d/0B9-LAjOGdvsTRU1fbnJTTkVFcEtYdVB1T080RE5nTlB0ZEhz/view?resourcekey=0-aXNbUiv6yGuMRNNKi103Sg

Thanks @EMartin ! It's possible we'll have to fall back to using their API and rendering the whole policy summary page ourselves, but hopefully they still have a way for us to link to one specific company policy summary on their site. On Zendesk they just suggested the same iframe as @jgleeson found, but that would require donors to search again.

@Ejegg Hi, I just deactivated that program in Acoustic.

No further replies from their support team. Shall we edit the Acoustic emails to just point to the https://www.matchinggifts.com/wikimedia_iframe form and have the donor search again? It's pretty self-explanatory, though it requires them to type a few letters of their employer and select it from the autocomplete before it shows the information that the other page showed up front.

@MDemosWMF since you work with matching gifts, do you want to weigh in here? Is it better to restart sending emails with a less convenient link, or to wait, hoping we get a solution to restore the direct link to the policy summary of the employer that the donor has already selected on the donation form?

@Ejegg Hi Elliott. I'm personally doing the matching right now with Rakhi (not Melanie) and it I think we should have the donor search again. I think send the emails with a less convenient link. The time for matching is now so I want to avoid losing gifts, particularl since we just did some PR around this program. Many thanks

@nisrael and I just figured out that the full link is in the database rather than being dynamically generated in the Acoustic template.

So I'll update those links in Civi and make sure that all the relevant contacts are marked as updated, to get them re-exported to Acoustic tonight. Tomorrow morning once we spot check a few of those in the Acoustic db we should be good to turn the emails back on.

Change 980930 had a related patch set uploaded (by Ejegg; author: Ejegg):

[wikimedia/fundraising/crm@master] Update matching_gifts_provider_info_url

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

Change 980930 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Update matching_gifts_provider_info_url

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

OK, the data is updated in Civi and the associated donors have been marked as updated so they will go out with tonight's export. It'll be an extra 137k rows on top of the 870k ish rows that would normally go out due to recent donations, so not a huge bump. We can check some records tomorrow and make sure it came over right before we turn the campaign back on.

Great! Thanks @Ejegg

OK, the data looks good in Acoustic, all except for 51 contacts whose emails are shared in Civi. I'll make sure those 51 get exported tonight, but we can turn the campaign back on today.

Looks like the email campaign is running again in Acoustic - gonna call this done. There's a follow-up task to host this link on our own domain in the future, to make it a lot easier for us to switch the content when there's breakage, and to allow us to easily switch providers: T352898: Host matching gift info form on our domain

Sorry @Ejegg wanted to add one more thing. I'm adding our Trilogy rep Brian Sisolak's concern below. He was looking at this relational table (see image)

//Find out where the mapping of ID to names came from. Someone there has it.

Here is my concern, there are IDs you are putting in the database, that don't match to the IDs in that relational table.

Short version - find out who in FR tech knows anything about this. //

Do they match the IDs in the main database, _all_Wikimedia ?

I thought we were using our main database for all fields (therefore not using relational table). The fields in _all_Wikimedia:
employer_name
employer_id
matching_gifts_guide_url
matching_gifts_online_form_url
matching_gifts_provider_info_url

Yep @KHaggard, we are using the field on the main database, and can get rid of that relational table