Does anyone actually have Matic/SuiteCRM sync working with the SugarCRM plugin? Iāve been trying to get it to work for a few days now. The API works, the cron job runs without error, but I donāt get any contacts/leads pushed or pulled and no data is synced? Anyone actually have this working?
There are a couple of issues (at least) on the Mautic GitHub that are about SugarCRM/SuiteCRM integration. Since they recently added code to this integration, there could be new bugs. But at least hopefully youāll find people there who can answer questions.
1 Like
Thx. Yeah, Iāve been combing the Mautic forum for anything about SuiteCRM/SugarCRM integration. I found a lot of helpful stuff but still no joy. If I get it working Iāll post a complete tutorial for everyone!
2 Likes
@pgr @pstevens, Iām literally working on getting this setup as we speak and happened to come over here to see if there was any more movement on SuiteCrm codebase and saw your most recent posts.
This actually is working for me now. There are some caveats of course.
- I made the mistake of using the wrong integration name which doesnāt output an error that would let you know (i.e. OAuth error is really an integration name error)
Use āSugarcrmā as the integration
- Iām running v2.11.0 of Mautic with the sugar-bugs branch merged in
I know that Iām able to:
- Pull leads from SuiteCrm -> Mautic Contacts
- Push Contacts from Mautic -> SuiteCrm leads
- Pull changed lead data, SuiteCrm -> Mautic Contacts
- Follows sync path when conflict in data (i.e I change first name on Mautic, it was overwritten by First Name on SuiteCrm)
Iāll be doing more testing now. A big thing I want to make sure works is I was using āTimeline Linkā in salesforce when I would push the Mautic Timeline URL to a field in CRM in order to use it as a subpanel or link button.
P.s. the command Iām running:
./app/console mautic:integration:synccontacts -i Sugarcrm -a '2 hour'
1 Like
P.s. Iāll be updating information about it in the following PR: https://github.com/mautic/mautic/pull/5244
I know Iām so close. Youāre cron job set up looks a little different. Iāll try that. Iāve used a bunch of variations from the Mautic forum.
/app/console mautic:integration:synccontacts --integration=āSugarcrmā --time-interval=ā4 daysā
this is the current one, Iāve tried. Iāv tried with and without the āā and with different time intervals including negative ones. No luck. I have made the change on GIT in reference to ācontactsā vs ācontactā in the file. Iāll try your cron job script and see if that helps. Glad to know there is light at the end of the tunnel!
The notation should matter (i.e. -I vs --integration OR -a vs --time-interval). One frustrating thing I noticed is that the documented notation of ā-10 minutesā is wrong, it should be ā10 minutesā.
I tested running this script with I think ā700 daysā and it imported on my test setup everything I wanted it to.
How did you actually get it to sync? if I do -i Sugarcrm it runs but gives the following:
Executing console mautic:integration:fetchleads -i Sugarcrm
Command to fetch contacts from integration
Fetch contacts command is starting
Fetching contactsā¦
0 contacts were updated and 0 contacts were created
Fetching companies
Fetch companies command is starting
0 companies were updated and 0 companies were created
Updating/creating leads from Mautic to Sugarcrm
Number of contacts pushed: 0 updated, 0 created, 0 had errors and 0 were ignored (likely duplicates or didnāt match field criteria)
If I add a time interval like -a ā2 hourā like you have (or any other time interval) it tells me this:
Executing console mautic:integration:synccontacts -i Sugarcrm -a '2 hour ā
[Symfony\Component\Console\Exception\RuntimeException]
Too many arguments, expected arguments ācommandā.
mautic:integration:fetchleads [-i|āintegration INTEGRATION] [-d|āstart-date START-DATE] [-t|āend-date END-DATE] [āfetch-all] [-a|ātime-interval [TIME-INTERVAL]] [-l|ālimit [LIMIT]] [-f|āforce] [-h|āhelp] [-q|āquiet] [-v|vv|vvv|āverbose] [-V|āversion] [āansi] [āno-ansi] [-n|āno-interaction] [-s|āshell] [āprocess-isolation] [-e|āenv ENV] [āno-debug] [ā]
It appears that the formatting may be wrong for those quotes.
Try:
./app/console mautic:integration:synccontacts --integration="Sugarcrm" --time-interval="2 hours"Obviously, make sure youāve create a new Lead/Contact/Account or Contact/Company within the two hour window.
Ok Iāve got it pulling new leads and contacts. However, couple of issues.
If I select āCompany Nameā in the lead to be āAccountā in Mautic, it wonāt work. It only works if I leave the Account name blank.
Also, quick question, is this supposed to update? Like if i change something in SuiteCRM, lets say the address, will it update in Mautic?
Also if I the Points in Mautic change, will it update my Points field in SuiteCRM (Iāve created the field and mapped it pointing back to SuiteCRM).
Iāve only generally tested it quickly and not thoroughly so I havenāt seen the Account issue; although now Iāll make sure to look.
These are all great questions and I donāt have the answer, I would test each case and document them here: https://github.com/mautic/mautic/pull/5244
I know from my testing that changing a record in SuiteCRM after it had been pulled to Mautic did update it in Mautic; however, the reverse did not happen - in face it overwrote it. But I believe thatā show itās supposed to work as I chose the āsync directionā to be SuiteCrm -> Mautic.
Once again, Iām not sure about points; however, from my last statement, I bet you (should) be able to make the points field mapping having the sync direction be Mautic first and then it would continually update in SuiteCrm. At least thatās how I would think that should work.
Once again, I would test these, document it in the PR for Mautic.
Might even be able to setup some sort of integration testingā¦
I have installed SuiteCRM and Mautic Successfully. Also got SuiteCRM authorized successfully in the Mautic plugin Section. Also Checked features option of the plugin and mapped the required fields.
But when I create a new contact it doesnāt get pushed or pulled from The SuiteCRM or Mautic.
What might be the issue?
Please help
You have to set up a cron job to fetch:leads and sync:contacts. Check the documentation.
Are those jobs just for mautic?
Is this example correct?
php public_html/mkt/app/console mautic:fetch:leads > /dev/null 2>&1
php public_html/mkt/app/console mautic:sync:contacts > /dev/null 2>&1
You shouldnāt have to do both of those commands anymore. It would just be
./app/console mautic:integration:synccontacts --integration="Sugarcrm" --time-interval="2 hours"
1 Like
It works. I am using Mautic 2.12.2 and Suite 7.10.2
I got bi-directional updates working just by using the plugin as is.
1 Like
Really? Can you confirm. I can push contacts from SuiteCRM to Mautic and push contacts from Mautic to Suite CRM. However, if I update a field in Mautic I canāt get it to update SuiteCRM (I have made Mautic the āmasterā in the plugin configuration for this particular field).
Are you saying after a contact is pushed it does sync changes to records on both sides?
I can confirm that Suite-Mautic integration āworksā and is bidirectional as per Mautic 2.13.
I have conducted many tests and we are about to start using it in production.
However there are a number of small bugs that make it tricky to sync some specific field types (Mautic Points, Suite Booleans, Suite-Mautic Select fields and others)
Also some behaviours are now as expected.
Mautic 2.14 includes some improvements and fixes but I am not using it yet (was out of beta a week ago)
However the main issue with some field types didnāt make it to this release, hopefully it will be included and the integration will be far smoother after that.
Keep in mind that this integration can only sync Mautic contacts to Suite Leads. There is not yet any developement (that Iām aware of) for integrating Suite Contacts.
Does anyone have the activity sync working between Mautic and SuiteCRM? ie: do the āopen emailā records from Mautic go to the history tab in SuiteCRM? If so how did you accomplish this?
Sorry, never tried.
If it helps, what I usually do is add points to whoever reads and extra points to whoever clicks on a link, then I can use the Mautic_Points (custom field) to do whatever is neededā¦
Alternatively I guess you could add a custom field for the particular action you want to track and modify it in Mautic when the link is clicked (using a campaign) and pass that field to Suite.
1 Like