Co-founder of SugarOutfitters. Entrepreneur and Developer residing in Abilene, TX.
Support September 8th, 2017 @ 3:51 pm
Thanks again for the info. Looking forward to the chat on Monday.
I just updated the calendar event with the meeting link.
Have a great weekend!View Comment
Support September 8th, 2017 @ 2:04 pm
Hi again, thank you for the clarification. I think the best next step is to get on a call/screenshare together so we can debug together.
Please click this link to pick a day and time that works for you: https://calendly.com/fanaticallabs/sugarchimp-support
Support September 7th, 2017 @ 8:52 pm
Hello, thanks for joining the call today. It seems the "Unknown SSL protocol error in connection" curl error message is the current issue we need to resolve.
I researched the error message and found that some people have received the same error message when using a specific version of curl. See the accepted solution on this page: https://stackoverflow.com/questions/20988782/curl-unknown-ssl-protocol-error-in-connection-error-in-server-but-works-on-lo
Can you check to see what version of Curl you have installed?
It might be that the command line curl and php curl use a differently underlying curl (which is why command line works but php does not). Or the interface in php to curl is having issues. I would recommend seeing if there are any updates for curl.
Can you also go to your command line and run: curl -V
Please send me what the result is. Thanks!View Comment
Support September 7th, 2017 @ 8:21 pm
Thanks for taking the time to go through that.
One more thing to look for when you get a chance: Can you please go to the MailChimp list and search by the new email address. Do you find another subscriber with the new email address? (Please check again now if you already tried this earlier because sometimes the MailChimp search cache is slow on updates)
There is a scenario where a new subscriber might be created and the previous subscriber not update. I believe this happens if there are multiple records on the Sugar Target List with the same email address. For example, Contact Bob has email email@example.com and Sue has email firstname.lastname@example.org if Bob changes to email@example.com, we wouldn't want to completely remove Sue's email from the MailChimp list so we make a new subscriber instead. Maybe a situation like this is occurring.
Lastly, please use this link to setup a call. It is the easiest way to pick a day and time next week: https://calendly.com/fanaticallabs/sugarchimp-support
Thanks again!View Comment
Support September 7th, 2017 @ 6:36 pm
Sure thing, always happy to help. Thanks for the info. Here are few other things to check:
1) If you go to MailChimp and look at the list you have synced, can you find the Contact in Sugar with the old email address?
2) Go to the SugarChimp Health Status page and note how many records are pending to sync. Then go to the Contact in Sugar, change the email address and hit Save. Then immediately go to the SugarChimp Health Status page, did the number of records to sync increase? Or does nothing change?
3) When looking at the Contact in Sugar, is the new email address marked as the primary address? Is it marked as opted out or invalid?
4) Last thing to check would be the list here: https://www.sugaroutfitters.com/docs/SugarChimp/my-sugar-and-mailchimp-list-counts-do-not-match See if the contact is not being synced over because of these other reasons.
If there's still not a good explanation for why it isn't making it's way over to MailChimp, let's get a call scheduled so we can take a look at things together. This is default functionality for us, so it should be working. Please pick a day and time here: https://calendly.com/fanaticallabs/sugarchimp-support
Support September 7th, 2017 @ 5:26 pm
Hi Brad, thanks for reaching out. I'm happy to help with this.
Are you saying when you change a Contact/Lead's email address in Sugar, the new email address is not showing up in MailChimp? Or something else?
After making the change how long are you waiting to check MailChimp?
When changes are made in Sugar, they get queued up. Then every time the SugarChimp scheduler runs (usually every 10-15 minutes on Sugar On-demand) it works through that queue, so sometimes it takes a few minutes before the change is in Sugar.
If you go to Sugar > Admin, scroll to the SugarChimp section and click "Health Status". In the "Pending to MailChimp" section do you see any numbers there? If so, you may need to wait until that clears out before you see those changes.
Let me know what you find. Thanks!View Comment
Support September 7th, 2017 @ 5:20 pm
Hello again, thank you for the information. The warnings in the logs make me think SugarChimp did not install 100% successfully.
You said when you go to the module loader and try to install something you get a blank screen. Try this:
1) Make sure you have the correct SugarChimp package. Please download this zip file (do not unzip it) https://www.sugaroutfitters.com/download/6850
2) Go to Sugar > Admin > Module Loader, upload the zip file and click install. You should install the package for SugarChimp version 7.9.2.
If the module loader does not work and goes to a white screen with that package, please send me that last several lines from the php error log (all of them please, do not edit).
If the module loader installs the integration successfully, please run another Quick Repair and Rebuild (Sugar > Admin > Repair) and then see if the scheduler works properly.
Let me know how it goes. Thanks!View Comment
Support September 7th, 2017 @ 4:21 pm
Hello, sorry for the issues. We can help resolve this for you.
Can you post the exact error messages you're seeing in the php error log?
A couple things to try:
1) Can you please verify the permissions are correct on the SugarChimp modules in /modules and custom/modules?
We suggest you run this permissions script https://shanedowling.com/sugarcrm-permissions-script if you're not sure the permissions are correct.
One way to check is look at the permissions and owner of a file that comes out of the box with Sugar, then check the SugarChimp modules files to see if they are the same.
2) Try also running a quick repair and rebuild. You can find this by going to Sugar > Admin > Repair and click Quick Repair and Rebuild. After doing this check to see if the scheduler is able to run.
Please post the php error log messages when you can, and let us know if #1 & #2 help any.
Support September 6th, 2017 @ 2:14 pm
Got it, thanks for the information. I think we'll need to get on a call to take a closer look.
Please go here and pick a day and time we can chat: https://calendly.com/fanaticallabs/sugarchimp-support
Support September 5th, 2017 @ 3:47 pm
Hello, thanks for the extra information. If you go to your production instance (the one hosted internally), go to Admin > SugarChimp Configuration > go to step 2 "Validate".
Do you see a license key there? If not, paste your license key there and click "Validate". Does it validate successfully?
It sounds like your connection between Sugar and MailChimp is good, but something isn't right on the licensing side.
If it does not validate, can your internal server make an outbound call to sugaroutfitters.com? That is where the license needs to contact to validate the license.
Let us know what you find. Thanks!View Comment
Support August 29th, 2017 @ 12:44 pm
Thanks for the info. What you tried to do looks good. It's strange to me that your original try did not work on the Sugar to MailChimp sync.
If you go to Sugar, find the Target List that you were setting up with the date_entered query, is there anyone on it yet? If you already have your 600k people on the target list and you manually uploaded the 600k into MailChimp, you might already be done.
If there are not 600k in the Sugar Target List, you could try a MailChimp to Sugar sync, there are a lot of factors to determine if it's faster or slower than the other direction. You can initiate that from the bottom of the SugarChimp Health Status page.
It might be best for us to get on a call and look at this together. If you would like to do that, please pick a day and time that works for you here: https://calendly.com/fanaticallabs/sugarchimp-support
Support August 28th, 2017 @ 3:06 pm
Hi Brad, glad to hear it! I'm going to close out this case.
Definitely let us know if you need anything else. Have a great week!View Comment
Support August 28th, 2017 @ 2:58 pm
Hello, sorry for the issues and thanks for giving this a try. SugarChimp is made exactly for this and we have customers using it exactly how you are hoping to, so I know we can get this setup for you. I have a few questions to get us started:
Are the 600,000 contacts all of your contacts in Sugar? Or are they a subset?
Can you post the query you're trying to use here?
Can you check your sugarcrm.log file and the php error log on the server to see if there are any error messages being posted when the SugarChimp tries to run?
Lastly, it looks like your 30 day free trial was set to end this week. I went ahead and extended your trial to September 18th so that we can have plenty of time to get this up and running for you.
Let me know the answers to the questions above. Thanks!View Comment
Support August 21st, 2017 @ 4:55 pm
Hello sorry for the issue, based on the php error, it looks like this may be permissions related. I have a few questions that might help clear this up:
What version and edition of Sugar are you using?
Which SugarChimp package did you try to install?
Can you go to your server and see if modules/SmartList/SmartList.php exists in the file system?
Let us know what you find. Thanks!View Comment
Support August 21st, 2017 @ 4:53 pm
@Eddy can you please go to your web server and check the php error logs? When you receive a 500 error, it usually indicates a php error has occurred. That should tell us the reason it is not working and we will be able to address it from there.
Let us know what you find, thanks.View Comment
Support August 11th, 2017 @ 6:21 pm
Sure thing, happy to help.
That's exactly right. You'll be able to map fields from the Accounts module as well with Ultimate.
Let us know how it goesView Comment
chad has not rated any add-ons.
chad has not created any Wanted Add-ons.