Thank you for a great module. I have been manually co-ordinating mailman lists with Drupal permissions (so that Mailhandler and Listhandler can display postings in forums controlled by TAC) for years. This will do loads of that for me.

If I want to fill the mailman_users table with the current members of my pre-existing mailman lists, how would I do this in a way invisible to my users? It will only confuse them if they go to Mailing List Register and their own subscription options are not reflected accurately.

If there is no bulk method, can I do it manually in MySQLAdmin without breaking anything?

Many thanks
Nigel
www.headingley.org

Comments

samuelet’s picture

samuelet commented

No, there is any bulk method, but if your users have all the same subscription status, you could use sql to set it (just to be sure, MAKE A BACKUP OF YOUR DATABASE BEFORE TEST IT) :
First create and activate the mailman list.
Get its id value in the admin/settings/user_mailman_register table.
Finally set users status as subscribed with this mysql command:
insert into mailman_users (select uid,1,3,mail,'' from users);
The third select parameters is the subscription status, and means:
3 subscribed, 2 digest, 1 no mail, 0 unsubscribed

If they have different status, you could need a suitable WHERE clause in the above select statement or a script which automates the mailman status retrieving and database sync.

samuelet’s picture

samuelet commented
Status: Active » Closed (won't fix)
samuelet’s picture

samuelet commented
Status: Closed (won't fix) » Closed (duplicate)

In the current UMR dev release is implemented a way to import and syncronize subscriptions from a mailman server. It's still experimental so make always backups of your data:
#358532: Problems when users change their subscription with mailman manager