Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
03/09/2019 at 2:02 pm #486540
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!03/11/2019 at 10:41 am #486625
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?03/15/2019 at 12:53 pm #487095
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.03/15/2019 at 3:33 pm #487123
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
emailAddressesproperty directly which is a collection of email address objects.
Using these hooks you could do most of anything you wanted. Hope this helps!03/15/2019 at 5:33 pm #487127
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!03/18/2019 at 10:26 am #487295
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.
Thanks in advance for your time!
You cannot reply to this support topic. Please open your own support topic.