SugarCRM <--> Mautic Multi-Select Fields Sync Not Working - Different Formats

[stancel]

What type of report is this:

Q	A
Bug report?	Yes
Feature request?	No
Enhancement?	No

Description:

Multi Select fields correctly setup and configured in both Mautic and SugarCRM are not syncing properly. After a lot of testing and debugging I discovered this is happening because SugarCRM and Mautic, both store those values in a string but in different formats. The data is syncing and storing correctly, but the receiving program does not understand how to display the data and thus nothing shows up. Mautic stores the multi-select string in format as 'choice1|choice2|choice_3', while SugarmCRM/SuiteCRM stores the multi-select string in format as '^choice1^,^choice2^,^choice_3^'.

While debugging if this string format is manually changed to the format the receiving program understands then it is received and displayed properly in the receiving program (Mautic or SugarCRM)

If a bug:

Q	A
Mautic version	2.12.1
PHP version	PHP 7.0.22

Steps to reproduce:

1. Make sure a SugarCRM 6.x integration is properly setup and syncing
2. Setup a multi-select field in SugarCRM, take careful note of the values inputted
3. Setup a multi-select field in Mautic making sure to use the exact same values inputted in SugarCRM
4. Open an Account, Contact or Lead record in SugarCRM (whichever you setup the multi-select in) and edit the contact to choose one or more choices in the multi-select field.
5. Trigger the fetchleads console/cron job php app/console mautic:integration:fetchleads --integration=Sugarcrm --time-interval="1 minute"
6. Wait for the sync to complete and then check the corresponding record in the Mautic UI. Observe that nothing is displayed.
7. View that same Mautic record in the Mautic database and observe the the field did sync and the value stored there, but in a format that Mautic does not understand.
8. Feel free to also try steps 4 - 7 reversing the systems (editing in Mautic and then checking in SugarCRM). Observe the same behavior either way.

Log errors:

No errors are displayed at any time.

Please check for related errors in the latest log file in [mautic root]/app/log/ and/or the web server's logs and post them here. Be sure to remove sensitive information if applicable.