Ensure Person emails are in sync with MailChimp

[DawoudIO]

When a person updates their email address in the CRM and mailchimp is enabled we should call the mailchimp APIs to add/update the mailchimp system.

[crossan007]

Is this still an issue?

[DawoudIO]

yes until we move to save via ORM and synced call to Mail Chimp

[crossan007]

Looking through this, I think the best path to move forward is to create a "join table" between ChurchCRM groups and MailChimp lists.

This will allow arbitrary linking of one ChurchCRM group to one or more MailChimp Lists; not necessarily sharing the same name.

Initially, the sync mode will be one-directional; all users in a ChurchCRM group will be updated in MailChimp. All users in MailChimp, but not ChurchCRM will be removed from the MailChimp list.

Group roles will be mapped to MailChimp segments.

The sync action will take place in a similar manner as the background timer jobs for integrity check and remote database backup; storing a timestamp of the last sync action, and determining whether the interval between the last sync and the current time exceeds a threshold.

We can cause changes to a user's email attribute to "clear" the timestamp; and thus trigger a re-sync.

@DawoudIO, @dcassidy13 what do you think of this approach?

[dcassidy13]

@crossan007 that sounds great to me. Thanks very much indeed.

[dcassidy13]

@crossan007 just wondered if there was any new eta on this one please?

[dleigh]

Group roles will be mapped to MailChimp segments.

It would be good if that could be Category participation as well (and/or). At the moment categories becoming Mailchimp segments are more our need.