Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
requests-topic
Plugin Request: Newsletter / mass-mail based on user groups
Avatar
RedZone Racing
Norway
Member
Free Members
sp_UserOfflineSmall Offline
Jan 26, 2013 - 4:55 am

Hi,

I run a website for a Car club.
I have the need of sendeing e-mails to members of different usergroups in our forum.
Today we send all e-mails, to all users in the DB.

If a member resigns from the club, I don't want to delete the account in case he/she returns in the future.
But the former members does not want to receive all our e-mails we send to all users either.
So as of now, I have to delete the ones that resign from the user DB.

Normal newsletter plugins for WP are based on the user subscribing.
And receiving our e-mails is not optional.

Solution:
Create the forum group "Former Members"
The group list would then look like this:
| Group 1 - Guests | Group 2 - Members | Group 3 - Former Members | Group 4 - Moderators |

Now I can remove access to the forum without the need to delete the user account.

All we need extra is the ability to choose which groups to send e-mails to.
And this is the basis of my request for a new plugin.

I imagine something simple like:

    Checkboxes to select which usergroups to include
    E-mail Topic
    Message contents
    Plain text / HTML switch

Is this a plugin you can create for Simple:Press?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 26, 2013 - 6:29 am

Speaking personally, without consulting my colleagues here, I don't really see this as a forum function. Yes - it could be a useful plugin but could be tricky to put together. The data selection is the easy part. Sending bulk email can be fraught...

What I would suggest firstly - is to review all of the current WP plugins available that might do what you want. If they are any good and really written very well, they might (and really should) include the option to filter the recipient list via custom code. If you find one that allows for that then I would see no issue in us looking to write an interface plugin for selecting and filtering the users. This would be a better option from our point of view and quite possibly offer a broader and more sophisticated end result than we would be likely to choose to implement should we ever plan on such a plugin.

andy-signature.png
YELLOW
SWORDFISH
Avatar
RedZone Racing
Norway
Member
Free Members
sp_UserOfflineSmall Offline
Jan 26, 2013 - 6:55 am

Well I have one I use today.
It is called Mass Mail , works great but is an abandoned project.

It first asks me for these 3 options:
Table name: My value = wp_users
Table email field: My value = user_email
Sender email: sender@modomain.com (example)

Then I can enter the following:
Subject:
Message Text:
Seconds between messages: 0.1 (default)

I used it on a previous site also.
There I wrote a SQL statement which created a new table in the DB based on the forum groups.
The problem being that this was a manual procedure which I had to repeat every time the user groups were modified. (delete table and re-create based on the SQL statement)

All this got to be a pain in the end bacause of so much manual work each time.
So a plugin that does everything for me would be nice.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 26, 2013 - 7:47 am

We can resolve that one easily enough.

Instead of creating a TABLE for each user group - create a VIEW. In that way the data is dynamic and will always return the current data set at the time it is run.

andy-signature.png
YELLOW
SWORDFISH
Avatar
RedZone Racing
Norway
Member
Free Members
sp_UserOfflineSmall Offline
Jan 26, 2013 - 12:20 pm

Hmm, interesting.

And a view is something easily made in PHPmyAdmin? (or did I misunderstand that one?)
Do you have some links to the documentation? (yes, I like learning new stuff)

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 26, 2013 - 1:50 pm

Take whatever the SQL statement is you have now to create your user group based table and turn that into a standard SELECT statement.

Then add to the front of that CREATE VIEW view_name AS SELECT etc...

This will create a View which is, in effect, a stored query - so it is dynamically run every time you use it. But it will act and behave like a table which itself can be queried. So when asked for the table name in your mail plugin - you just supply the view name instead. And voila - up to date data.

Just create individual VIEWs for all of the user groups - or indeed any grouping - you wish to use.

andy-signature.png
YELLOW
SWORDFISH
Avatar
RedZone Racing
Norway
Member
Free Members
sp_UserOfflineSmall Offline
Jan 27, 2013 - 5:30 am

Thanks. Worked great.
Even got it working with multiple and individual groups.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 27, 2013 - 8:28 am

good work... thanks for the update...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79607