SuiteCRM V8 and Mautic 5 Integration - Current Status

šŸ’¬ General Discussion
42

Iā€™m wondering why the integration isnā€™t working for us.

Auto Active ā†’ Yes. We have mapped all the required fields as suggested in your video.

image
image880Ɨ727 44.8 KB

43

That message only shows when you havenā€™t mapped a required field.

44

Yes, I know that but we do not see any required fields left by us.

Also, in your video you could easily move to next pages to view your other fields. Thatā€™s not working for us.

I am wondering, maybe the plugin got broke in Mautic v7.1.1.

What version are you using for your Mautic and SuiteCRM? Have you used new Mautic version with SuiteCRM v7.x?

45

Iā€™m on 7.7.1 and Iā€™ve used it on suitecrm 7 and 8 no issues.

You must have fields that are required in Mautic that are not populated. That is the only reason youā€™ll get that message. Iā€™ve tested and cleared a required field and I get the same message. I can only conclude you have a required field that is notmapped.

What are all your required fields in Mautic?

46

Wait, is that mean I need to map all the core fields from Mautic during integration?

47

No it means you need to map all the required fields in Matuic.

Hereā€™s my working screen shot from the latest mautic and SuiteCRM 8

image
image781Ɨ898 67.4 KB

1 Like
48

Thank you!

Are you able to view the other fields on the Contact Mapping and Company Mapping pages?

Also, do we need to create a database for Mautic, or is it created automatically during installation?

49

You definately need to create a database for Mautic. The fact that you can login means you have a database. Yes I can view contact and company mapping, but you need to select that in the settings or you wonā€™t see it.

50

Do we need to have https for Mautic to run successfully?

51

Probably, Iā€™ve never tried without it.

52

Okay, I think thatā€™s why it is not working for us.

Also, we have error in the console regarding the avatar.png. Mostly, It will go away if we add https cert.

53

Other error is likely file permission and ownership. SuiteCRM MUST be reachable from the Mautic install. I suspect the API to SuiteCRM enforces https.

54

Thatā€™s a bummer :melting_face:. I think weā€™ll need to check the integration again once we have Mautic running on HTTPS. :100:

55

If we only keep 2nd option tick and click on Save, then we do not get an error. But

Enabled features

:cross_mark: Triggered action push contacts to integration

:white_check_mark: Pull contacts and/or companies from integration

:cross_mark: Push contacts and/or companies to this integration

  • When we run the sync command on the terminal, it says no contacts created.
 php bin/console mautic:integration:synccontacts --integration=Sugarcrm --time-interval="10year"

Output

Command to fetch contacts from integration
Fetch contacts command is starting
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

  • When we reoprn the Sugarcrm from Manage Plugin menu, the Mautic field shows not mapped.
56

You havenā€™t correctly applied the patch. Thatā€™s the exact beheviour when you donā€™t apply the patch.

57

Is this correct?

Changes to make

File location:

  1. mautic/plugins/MauticCrmBundle/Integration/SugarcrmIntegration.php
  • around lines 906 and 1621

Remove the below line:

$this->integrationEntityModel->getRepository()->detachEntities($integrationEntities);

Add the below line:

$this->em->clear('Mautic\PluginBundle\Entity\IntegrationEntity');

So, code line in file

$this->em->getRepository(IntegrationEntity::class)->saveEntities($integrationEntities);
$this->em->clear('Mautic\PluginBundle\Entity\IntegrationEntity');
58

There are more changes where that line shows up from memory. Check out the github thread there are a few more changes than that.

59

Do we need to update these code files too? What are other code changes?

60

I donā€™t remember off hand, but the Mautic thread on Github has all the changes. Thatā€™s what I go back to every time I do an install. There are at least 3 places to revert the code if my memory serves me correctly. They are all in the thread.

Also if youā€™re ā€œsaveā€ of the fields is not sticking, you need to flush your Mautic cache and reset your permissions. Keep at it. Iā€™ve spent days trying to get the first sync to work.

61

Thank you, @pstevens. Yes, we have same code on lines 906 and 1621.

Do you recall editing the below file?

AbstractIntegration.php