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
Thanks
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
Hmmm. Thanks. Guess I have to ask: MM3 uses Mysql, why? Whats the diff. between a sql table and a flat file then?
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)
On 2/27/19 4:32 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?
MM3 core uses SQLAlchemy to support various back-end databases, e.g. Sqlite3, MySQL and PostgreSQL. Postorius and HyperKitty use Django which also supports various database backends.
Databases have several advantages over flat files, not the least of which are the ability to abort and rollback partial changes and concurrent update protection without locking entire files.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
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>
On Wed, Feb 27, 2019, at 8:43 PM, chucka@blackforest-co.com wrote:
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
You could use the API to create mailing lists on-demand with the list of members, which you can get by executing SQL queries in whatever way you want. Then you can send the emails and re-create the mailing lists everytime your list of members change (monthly?).
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>
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)
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:
- 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
participants (4)
-
Abhilash Raj
-
chucka@blackforest-co.com
-
Mark Sapiro
-
Stephen J. Turnbull