On 2/26/19 2:39 PM, chucka@blackforest-co.com wrote:

I'm trying to find out if I move my web site to a hosting company using MM Ver 3 - with SQL. If I have a membership list in MySql used by MM

• can I send an email to a select group? ["Your dues are due"].

Assumes the MM tables can be accessed? Anyhow what I want to do is: send message96 where expire > next month else send message95

Even if The particular Mailman instance uses MySQL for its database, the tables are very specific to Mailman. It is not possible to tell Mailman that some arbitrary membership table or the result of some arbitrary query is to be used to determine the recipients of a message.

-- Mark Sapiro mark@msapiro.net The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan

On Wed, Feb 27, 2019, at 4:33 AM, chucka@blackforest-co.com wrote:

Hmmm. Thanks. Guess I have to ask: MM3 uses Mysql, why? Whats the diff. between a sql table and a flat file then?

Mailman needs a SQL database to store a whole lot of data in a structured way.

Why should we be using a flat file instead?

---

Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/

-- thanks, Abhilash Raj (maxking)

I like the controls that MM uses. What I have and need: a member database [name, address, email, date dues paid, etc]. So I can do this 2 ways: 1) select name, email from members where xyz > file. Login to MM empty member list - which is kind of painful then load file and send the email. Then repeat for NOT xyz or 2) roll my own php script where I select from and if (xyz) Aemail else Bemail

Problem with #2 is I lose the discussion part. <sigh>

chucka@blackforest-co.com writes:

I like the controls that MM uses. What I have and need: a member database [name, address, email, date dues paid, etc]. So I can do this 2 ways:

1. select name, email from members where xyz > file. Login to MM empty member list - which is kind of painful then load file and send the email. Then repeat for NOT xyz or

This is an interesting idea, although it's more CRM than traditional MLM (and we have historically encouraged people to use CRM applications for CRM).

We are currently accepting applications for GSoC interns. If you could provide a little bit more explicit requirements, perhaps it would make a good GSoC project. I'm not sure this is as easy as Abhilash's "try the API", so if we could get a student to flesh it out it make be useful for a lot of admins who need more realtime list administration flexibility -- I can think of applications for myself -- and don't want to go full-on CRM or just would rather do it with Mailman.

Steve