We will provision email lists to a SQL table, and have a job to pull those memberships and populate lists in listserv.
Associate a group with an email list
Tables
Groups
Users
Memberships
View for integration
CREATE VIEW listserv_integration_emails_v as SELECT lig.EMAIL_LIST_NAME, liu.EMAIL FROM LISTSERV_INTEGRATION_GROUPS lig , LISTSERV_INTEGRATION_USERS liu , LISTSERV_INTEGRATION_MSHIPS lim WHERE lig.GROUP_UUID = lim.GROUP_UUID AND liu.PENN_ID = lim.PENN_ID AND liu.EMAIL IS NOT NULL
Start with configuration
Full configuration
Externalized text for metadata
Sync emails from listserv to database
L is email list, M is moderator, O is owner, Q is quiet owner
List code | Description |
---|---|
L | Email list |
M | Moderator |
O | Owner |
Q | Quiet owner |