Set up infrastructure to send emails to supporting members in Donorbox
Closed, ResolvedPublic

Description

We need to communicate with our supporting members. To do that we need a way to send them emails. The communication includes quarterly newsletters, AGM invites, annual reports, etc.

Requirements:

  • Only people who are active supporting members get the emails (e.g. people who didn't pay their membership fee are not receiving them)
  • People can chose to opt out
lydia created this task.Apr 6 2023, 1:20 PM
lydia triaged this task as High priority.
lydia moved this task from Backlog to To Do on the Fundraising Working Group board.Apr 6 2023, 1:23 PM

Do we have anyone who can help with this? We need to send the next quarterly email to the members soon and need some infrastructure to make this happen.

Restricted Application added a subscriber: sysadmin. · View Herald TranscriptDec 16 2023, 4:43 PM

Are we able to get a CSV of people and their email addresses out of Donorbox that have ticked a box to receive quarterly updates?

If so, then feeding that into Mailman should be straight forward.

Everything except the last point :/
@ognarb @kcoyle Do you have ideas?

Hmm, I thought Donorbox had functionality to record that - https://donorbox.org/nonprofit-blog/ask-donor-subscribe-mailing-list?

lydia added a comment.Dec 16 2023, 7:34 PM

Argh. I thought that was only available in Donorbox Pro. And of course we hadn't enabled it...
Thanks for digging this up. I've now enabled it for the membership campaign.

Problem solved going forward I guess, but what do we do about those who are already members?

lydia added a comment.Dec 19 2023, 8:58 PM

Sorry for some reason I didn't get an email for your previous comment...
I think for now we leave them out and I'll think some more about how we can get them in later.

bcooksley closed this task as Resolved.Dec 24 2023, 1:13 AM
bcooksley claimed this task.

This has now been provisioned.

Please commit updated exports from Donorbox to https://invent.kde.org/teams/kde-ev-fundraising/donorbox-data
Access to that repository is only available to members of the KDE e.V. Fundraising Working Group (so if it gives you a 404 that is because you don't have access to the private repository).

They will subsequently be automatically processed overnight (Midnight UTC to be precise) and used to populate the membership of https://mail.kde.org/mailman/listinfo/kde-ev-supporters

If people wish to unsubscribe that should be done by updating their settings within Donorbox - they will then be unsubscribed on the next processing run once a fresh export is made.