...

Rolling out this Grouper integration with LSoft is in its early phases and so far the experience has been positive. When we have integrated more lists and kicked the tires a little more we will post specifics on the wiki on how things are configured and the template code needed to make this work.
Stay tuned on the incommon-grouper slack channel!

-------------

Earlier planning notes 

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

Image Removed

Tables

Groups

Image Removed

Users

Image Removed

Memberships

Image Removed

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 

Image Removed

Start with configuration

Image Removed

Full configuration

Externalized text for metadata

Image Removed

Image Removed

Sync emails from listserv to database

L is email list, M is moderator, O is owner, Q is quiet owner

...