MailChimp revisited

I committed updates to the Mailchimp plugin for the new API a few months ago, with support for the new 'interests' stuff. It's deployed on a couple of our direct client sites, working fine.

https://github.com/Fabrik/fabrik/tree/master/plugins/fabrik_form/mailchimp

I also added a new feature a few days ago to optionally use a checkbox on your form instead of the one added by the plugin to the bottom of the form.

I would have let you know, but I couldn't remember who it was had been asking me about it.

-- hugh

 

Take out a paid sub for a month.

-- hugh

 

Do a full github update. See the wiki if you haven't done one before.

-- hugh

 

That JSON doesn't look right - that looks like the old groups format with the group name, not the new Interests format. Interests should be an ID that look something like this:

[{"58d1ec4981":true}]

As per the tooltip, you have to get the Interest ID from their API "playground". It's ridiculously difficult, they don't provide an easy way to find out the ID. Here's a Stack Exchange discussion on the topic:

https://stackoverflow.com/questions...chimp-interest-group-id-without-using-the-api

And here's a little screencast showing you where I got the id for the example above.

https://www.screencast.com/t/rEhkavrM

Another wrinkle is that if you have more than 10 lists, the Playground UI only shows you the first 10 and no obvious way to paginate. I managed to work round that on another account, but I can't exactly remember how.

It really is insane that they don't make that ID visible anywhere in the dashboard, and if you Google the subject, you'll find it's been an issue many people have complained about since v3 was introduced.

-- hugh

 

At some point I may get froggy and add a special JForm field type to grab the interests and groups through the API (using the key specified in the settings), so I can provide a dropdown of available ID's, with their coresponding names, so you can just pick from a list. But that's a couple of hours coding, which I can't justify until there's a significant number of people subscribing to use this code.

-- hugh

 

As per the tooltip, you can add as many interest ID's as you want, and use element placeholders to set the values. The way the new interests work is that they are either 0 or 1 (or true or false). And as the tooltip says, "is the value of the placeholder is anything but empty or 0, the interest will be selected".

So, for example, to set two interests, one always set, and the other dependent on an element ...

[{"58d1ec4981":true,"67fg848c746":"{yourtable___yourelement}"}]

So say yourtable___yourelement is a checkbox, with values of 0 and 1, a selection of 1 will enable that interest, 0 will disable. And it should work in edit mode, ie. if they've already submitted the form, then edit and submit again, unselecting 'yourelement', they will be removed from that interest.

Note that you'll probably need to append _raw, as usual with placeholders for elements with "value" and "label", so get the value.

-- hugh

 

Yes. And to re-iterate, a value of 0 or an empty string is "false", anything else is "true". So 1, Yes, 321, Some Random Text, etc are all "true". Only 0 or nothing are "false".

Nope. It's a one way thing, updating MailChimp from a Fabrik form submission.

-- hugh

 

Not sure what you mean.

As mentioned above, a value of 0 is "false" for a given interest, anything else is "true". So if your "Group 1" interest is ID 1234567, and you have a radio button "group1" for "Yes" or "No" (values 0 and 1) to sub to that group ...

[{"1234567":"{yourtable___group1_raw}"}]

Are you trying to combine multiple interests into a single radio button? Like a radio for "Group 1" or "Group 2" or "Group 3"?

If so, I haven't tried it, but this might work:

Set the value of the radio selections to the interest ID, so "Group 1" is "1234567", and ...

["{yourtable___group1_raw}":"1"}]

Note however that this wouldn't un-sub them from the other group(s). So if they submitted with Group 1, then edited the form and re-submitted with Group 2, they would then wind up sub'ed to both.

-- hugh