Skip to content

Tag: Drupal

Nightmare of segmenting Techcelerate, CapsuleCRM and Mailchimp Databases whilst keeping them cleaned and in sync

How do you segment multiple databases, keep them clean and in sync? If you know an easy way, please do let me know. Techcelerate maintains 3 vital databases among many for operational management. These being: 1. Techelerate.org (Drupal 5) with 1893 community profiles used predominantly for event registration 2. Mailchimp for weekly newsletter with 1844 profiles. 49 profiles seems to be missing. 3. Capsule for sales conversion and membership renewal management. Unfortunately, Capsule does not easily display total number of profiles held. Mailchimp automatically updates when a new profile is created on Techcelerate website, which makes life lot easier. Unfortunately,…