Work around for v6.4 broken sync

Got a problem with the Opacus Professional SugarCRM Outlook Plugin ? Please post it here
Post Reply
User avatar
opacus.daniel
Site Admin
Posts: 500
Joined: Thu Feb 04, 2010 5:01 pm
Contact:

Work around for v6.4 broken sync

Post by opacus.daniel » Wed May 09, 2012 8:26 am

If you are using SugarCRM 6.4 or above please try this to see if it fixes the problem.
To apply this workaround you will need access to the SugarCRM sourcode.


In file include/SugarSQLValidate.php on line 168 you will find an array called "$subpanel_allowed_tables".

Please add the following three tables to the array list.

meetings_users
contacts_users
calls_users

Save the file and try the sync process, if this fixes your problem please let us know.

Thanks.

Daniel.

sjakobsson
Posts: 3
Joined: Fri May 11, 2012 5:07 am

Re: Work around for v6.4 broken sync

Post by sjakobsson » Fri May 11, 2012 5:21 am

This solution worked a treat for us

markpickford
Posts: 56
Joined: Sat Feb 13, 2010 11:44 am

Re: Work around for v6.4 broken sync

Post by markpickford » Mon May 14, 2012 8:23 am

Hi Daniel,

I'm pleased that you seem to have fixed the add-in. Great work.

I am happy to give this a try but need to clarify a couple of points first. At line 168 I have:

'email_addr_bean_rel' => true,
'email_addresses' => true,
'emails' => true,
'emails_beans' => true,
'emails_text' => true,
'teams' => true,
'team_sets_teams' => true);

Would I add the following to my file:

'meetings_users' => true,
'contacts_users' => true,
'calls_users' => true,

Finally, should I add this at the start of the list (above the first entry)?

I look forward to hearing from you.

markpickford
Posts: 56
Joined: Sat Feb 13, 2010 11:44 am

Re: Work around for v6.4 broken sync

Post by markpickford » Mon May 14, 2012 10:01 am

I have applied the fix as I described in my previous post and it works for us.

Thanks.

markpickford
Posts: 56
Joined: Sat Feb 13, 2010 11:44 am

Re: Work around for v6.4 broken sync

Post by markpickford » Mon May 14, 2012 10:54 am

Upgraded from v6.4.3 to 6.4.4 this morning.

The modification is NOT upgrade safe; however, I can confirm that the mod works on:

Sugar 6.4.3 and 6.4.4
Outlook 2007 (on a PC)
Outlook 2007 (in Parallels on a Mac)

I hope this helps.

User avatar
opacus.daniel
Site Admin
Posts: 500
Joined: Thu Feb 04, 2010 5:01 pm
Contact:

Re: Work around for v6.4 broken sync

Post by opacus.daniel » Tue May 15, 2012 2:32 pm

Thanks for confirming this works guys.
We will have a fully working version for 6.4 and 6.5 which wont require this hack in the near future.

sfarzo
Posts: 1
Joined: Mon May 21, 2012 3:15 pm

Re: Work around for v6.4 broken sync

Post by sfarzo » Mon May 21, 2012 3:23 pm

opacus.daniel wrote:Thanks for confirming this works guys.
We will have a fully working version for 6.4 and 6.5 which wont require this hack in the near future.
You have to add also this rows in order to works, or the address search in PRO version will not works:
'accounts' => true,
'accounts_contacts' => true,

Without these rows the search will be not performed into Contacts but only in Leads module.

Where are evaluating your products for a new project based on SugarCRM 6.4. When do you think you will release a new stable version for your plugin?

Thanks,
Fabrizio

Luc
Posts: 1
Joined: Fri Jun 29, 2012 7:30 am

Re: Work around for v6.4 broken sync

Post by Luc » Fri Jun 29, 2012 12:26 pm

Good afternoon,


This method is not working for us. can you tell us when did you plan to have a release working with the 6.4 version of SugarCRM ?

Many thanks,

Luc.

markpickford
Posts: 56
Joined: Sat Feb 13, 2010 11:44 am

Re: Work around for v6.4 broken sync

Post by markpickford » Wed Jul 25, 2012 9:18 am

Hi,

I have had a quick look at the code in Sugar 6.5.2 and I am happy to report the fixes above seem to be an integral part of the new version.

Kind regards,

Mark

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest