[Murray Summers]

I’m trying to link my Connections database with my mailchimp list using an app called “Zapier”. This app knows how to link with a mailchimp list and can use an incoming email as a trigger to make the linkage. If Connections could send an email each time there is an edit in Connections that would make my version control task a bit simpler.

Thanks!

[Steven Zahm]

If you use the Form extension and only permit users to make edits via that frontend form, you can configure it to send you submission emails.

Would that help?

[Murray Summers]

I don’t think that’s going to do it for me, but I have an alternative. In my database, there is a table called “connections” that contains everything. That is the primary table used by Connections as a parent to the other subordinate tables, right? If so, then I can unserialize the email field, and write the necessary data into a new table which is used to build the mailchimp maillist.

[Steven Zahm]

If you are going the coding route… you could hook into the following actions:

• cn_save-entry :: Run before an entry is saved.
• cn_saved-entry :: Run after an entry is saved.
• cn_update-entry :: Run before an entry is updated.
• cn_updated-entry :: Run after an entry is updated.
• cn_delete-entry :: Run before an entry is deleted.
• cn_deleted-entry :: Run after an entry is deleted.

Each of these pass a single value, a Entry object. You can get the email addresses by calling the getEmailAddresses() helper method or interact with the emailAddresses property directly which is a collection of email address objects.

Using these hooks you could do most of anything you wanted. Hope this helps!

[Murray Summers]

Oh, that’s very helpful. I’ll see if I have the chops to make that work! :)

But in case I don’t, am I safe assuming that the contents of the connections table are the master data list?

Thanks!

[Steven Zahm]

Yes, the connections table is the primary table. I would however not recommend unserializing the email column sinc that is primary used as a cache to speed up entry queries and display. Instead, use a join and join the email table.

Another method you could use is navigate to the Connections : Tools admin page and click the Export tab. Scroll down to the Email export. You should be able to use that CSV file to import into MailChimp. Of course you’ll have to do this once and a while to ensure both Connections and the MailChimp list stay in sync.

Hope this helps!

If you have a moment, I would truly appreciate a review as they really do make a difference.

https://wordpress.org/support/plugin/connections/reviews/

Thanks in advance for your time!

[Author]

Posts