by Fanatical Labs

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.

Cancel at any time!
Free Trial

#1054 - Does the Basic plan support the transfer of contacts FROM Mailchimp?

Closed General Question created by FibreCRM Verified Purchase 4 years ago

We are testing the sync. Data is sent TO Mailchimp but not sent to CRM from Mailchimp. e.g. we have a Wufoo form which adds a subscriber to a MailChimp list. The list is connected to a Target List and the default module in Sugar TL is set to LEADS. Mailchimp subscribers are not being added to Sugar. The license key installed is valid. I have included an extract from the log files which might help (see below).

Sugar 6.5.20
Sugarchimp: 7.1.4 basic
Linux OS CENTOS 6
SugarChimp Health Status is all good (green) with nothing in the queue to sync back to sugar...

Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Instantiate SugarChimp_Job Driver SugarChimp_Job_AddWebhook
Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Run SugarChimp_Job_AddWebhook Start
Sat Jan 3 09:11:28 2015 [3][1][FATAL] SugarChimp:debug:1420276288: Run AddWebhook action for list d11a25cf0d with params: Array
(
    [0] => Array
        (
            [id] => 9c5d70df-f869-bc2b-749b-54a7b036ca5f
            [param1] =>
            [param2] =>
            [param3] =>
            [param4] =>
            [param5] =>
        )

)

Sat Jan 3 09:11:29 2015 [8864][-none-][FATAL] SugarChimp:error:1420276289: Mailchimp_Webhooks_Receiver cannot process webhook, no list id is provided
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Helper::add_webhooks_to_lists status: Array
(
    [success] => Array
        (
            [d11a25cf0d] => Array
                (
                    [id] => exists
                )

    )

[error] => Array
    (
    )

)

Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->delete_jobs delete the jobs that we just ran: DELETE FROM sugarchimp
                WHERE
                    mailchimp_list_id = 'd11a25cf0d' &&
                    name = 'AddWebhook'

            ORDER BY date_entered ASC
            LIMIT 500

Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 1
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Elapsed time 25
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time used 0.0833333333333
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->get_next_job_name_to_process get oldest job: SELECT name
                FROM sugarchimp
                WHERE
                    mailchimp_list_id = 'd11a25cf0d'
                ORDER BY date_entered ASC
                LIMIT 0,1
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_SugarToMailchimp->get_next_job_name_to_process There are no jobs to be processed for the list.
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 0
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Elapsed time 25
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time used 0.0833333333333
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end The scheduler ran successfully
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Original Start time 1420276264
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Current time 1420276289
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver Time since last check 0
Sat Jan 3 09:11:29 2015 [3][1][FATAL] SugarChimp:debug:1420276289: SugarChimp_Scheduler_Driver::end final result: Array
(
    [status] => success
    [message] => There are no more jobs to run.
    [elapsed_time] => 25
)

Sat Jan 3 09:11:45 2015 [3][1][FATAL] SugarChimp:debug:1420276305: SugarChimp_LogicHook List After Add Person e6c00887-0d6b-d048-6a1f-52be7c82dd4c
Sat Jan 3 09:11:45 2015 [3][1][FATAL] SugarChimp:debug:1420276305: SugarChimp_Helper::check_list_person_added the list is not synced with mailchimp, carry on
Sat Jan 3 09:11:46 2015 [3][1][FATAL] SugarChimp:debug:1420276306: SugarChimp_LogicHook List After Add Person e6c00887-0d6b-d048-6a1f-52be7c82dd4c
Sat Jan 3 09:11:46 2015 [3][1][FATAL] SugarChimp:debug:1420276306: SugarChimp_Helper::check_list_person_added the list is not synced with mailchimp, carry on

  1. fanaticallabs member avatar

    Fanatical Labs Provider Affiliate

    4 years ago

    Hi there, the basic edition does include support for MailChimp to Sugar syncing.

    The issue is that the changes on the MailChimp side are being made using the MailChimp API from Wufoo. Because of how the MailChimp webhooks are setup, it's possible for duplicate calls.

    It's recommended that you send the Wufoo form data directly to Sugar and then have SugarChimp send the data to MailChimp. No changes are required on the SugarChimp side to make it work this way.

    If it's not possible to do this with Wufoo, you can edit your List's Webhook in MailChimp by going to your list > Settings > Webhooks and under the "Only send updates when a change was made by..." field check the "via the API" checkbox. This will allow the webhooks to fire when calls are made from Wufoo via the API, the only issue is that it will also fire when SugarChimp makes API calls from Sugar. MailChimp may be smart enough to limit the amount of circular calls that come in, but this can act weird sometimes.

    Let me know if you have any other questions about this one. Thanks!

  2. fibrecrm member avatar

    FibreCRM Verified Purchase

    4 years ago

    Hi, yes the first option appears to works well. We'll keep an eye on it and if there are issues we will link Wufoo directly to Sugar. Thank you.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.