This repository has been moved to https://lab.civicrm.org/extensions/mailchimpsync
There's also now some documentation published at https://docs.civicrm.org/mailchimpsync/en/latest/
CiviCRM Extension providing Mailchimp Sync
License: Other
This repository has been moved to https://lab.civicrm.org/extensions/mailchimpsync
There's also now some documentation published at https://docs.civicrm.org/mailchimpsync/en/latest/
There was a bug whereby:
I'm documenting this here because it's a very tricky situation and there could be lots to complicate it further.
7d87183 added a failing test
Currently the incremental sync only works for contacts whose group membership has changed since 2 hours before the last sync.
It means if someone's group membership has not changed, but other data has (e.g. email taken off hold) then they never get included in sync again.
Providing a button on the contact record that could mark their cache record as todo
would, I think, include them in the next sync run.
When a batch webhook result is processed it updates the cache table with status OK etc. but it does not update the table with mailchimp status and mailchimp updated date. This means the status display loses count of people - it says "ok" in the sync status yet it's in Civi but apparently not in Mailchimp.
I think the status should be updated.
Create account » Create batch webhook » Save
Create sync connection » Create webhook » Save - not saved!
This repository has been moved to https://lab.civicrm.org/extensions/mailchimpsync
There's also now some documentation published at https://docs.civicrm.org/mailchimpsync/en/latest/
Pinging @danaskallman as you are watching this repo.
because originaly we had civicrm_status
and now we have the serialized civicrm_groups
that can't sensibly be searchd by sql and certainly not by the basic get api.
Initial sync (or since=ever
) will now fail because Mailchimp sees this as 2 people, so:
Issues:
The status says "in sync" despite there being people who can't be sync-ed. It's more that it's 'reconciled' rather than actually in sync.
Some failures are longstanding and uninteresting, e.g. the person who has 2 email addresses on one contact record, one email is unsubscribed at Mailchimp and the other is subscribed. They can safely be left as faliures.
But others might need investigation, especially when they're recent.
Showing a count per list of recent failures might help people who monitor these things iron out awkward cases.
Something like this:
select count(*)
from civicrm_mailchimpsync_cache mc
inner join civicrm_mailchimpsync_update u on mc.id = u.mailchimpsync_cache_id
and u.error_response is not null and u.error_response != ''
inner join civicrm_mailchimpsync_batch b on u.mailchimpsync_batch_id = b.id
where b.completed_at >= CURRENT_TIMESTAMP - INTERVAL 1 WEEK;
This is a tricky policy area.
I think that if an email is on hold in Civi then it should not cause a subscription at Mailchimp, but instead should put the sync into 'fail' status.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.