Save Your Team Countless Hours. SugarChimp syncs your lists in both directions so that you can work in your preferred application. Segment and Group your MailChimp subscribers based on SugarCRM data so you can market to the right people at the right time. Fully compatible with all versions and editions of Sugar and SuiteCRM.
#3834 - Problems using the options to sync records automatically to MailChimp: Filters or SQL Query
I have problems using the options to sync records automatically to MailChimp: Filters or SQL Query
Create Filters to automatically sync Leads to MailChimp.
I try to define simple filters and I get results, for instance: The current SmartList filters would allow 141 Leads on the list.
Write your own SQL Query to automatically sync Leads to MailChimp
The SQL sentence is right, for instance:
In both testings, the target list of SugarCRM keeps empty. The aren't records to sync to MailChimp so the list in Mailchimp keeps empty too.
Shouldn't the target list of SugarCRM shows the same number of records as the SQL's/Filter's result? Of course, if the emails aren't invalid or refused or there are duplicate emails.
If you try to add records (directly from the target List of SugarCRM) manually by report or filters (in listview) into SugarCRM, those records are added on the target list and everything works fine. The records are synced to MailChimp perfectly.
Using Filters or SQL sentences from SugarChimp, the sync doesn't work.
There're not pending queues because I've cleared both queues before my testings.
Maybe there is any kind of technic problem, isn't?
Please, could you help me? I'm not able to find the problem.
Thanks a lot and kind regards
Product Owner in redk
Other add-ons of interest
Glances - Integrate All Your Applications
Accomplish More Every Day. Spend your time on getting things done, not on finding information. Glances securely connects all of your apps and provides a simplified view of the data you need right when you need it, in real time.
Advanced Marketing Lists
Advanced Marketing Lists automatically fill Target Lists and keep updated the Campaigns to which they are associated.
KINAMU GDPR Module
The new GDPR, which enters into force on May 25, 2018, gives data subjects extensive possibilities to exercise control over their personal data. This results in a variety of obligations for data controllers. In order to be able to pursue this in a compliant and controlled manner KINAMU has developed...