How to set default email client on users

Hi Lori Arce - you´ve been so helpful to me   Do you have any pointers on this one?  Takk, KGM

Kristjan,

Unfortunately, there is no method within the UI that will enable you to set the default External Email Client setting for all users upon user creation.  You will need to manually set this for each user when the user is created.

I do not see an existing feature request for this, would you like me to request it for you?  Otherwise, on the bottom right section of your SugarCRM instance, within the footer section, there should be a feedback option that you can use to submit your feedback to our Product Management team.

Outside that, the only option is to create code-level customizations to meet this business need.

Kind Regards,

Lori Arce

Thank you for a speedy reply.

You are very welcome!!

Lori

Lori , can I ask in which mysql table are these settings saved ? Couldn't find in the users table

Caim,

This setting is stored in the user_preferences table within the Contents column.  This column uses the base64 encoding scheme.

Kind Regards,

Lori Arce

Found it !    Under Admin - User Management. Choose all users (or those to change) and click on Mass Update. Then change the email client option to desired and finally click on Update:

Just in case anyone finds this post the same way I did via Google, mass update for Email Client is currently broken in all current Sugar versions up to and including 12 as per defect 7705 (https://portal.sugarondemand.com/#supp_Bugs/b7b8c506-6ce3-497d-d110-57ab86b84a66)

good to know, thanks mate!

Hi Joe Davison,

I looked into some cases that have been associated with bug #77055 that you linked and found a workaround that has been helpful for others running into this issue if you have access to the Sugar DB. The workaround for this defect is to mass update the users with an SQL query like the one below. For example, to set all the Active Users as 'External Email Client':

UPDATE user_preferences JOIN users ON user_preferences.assigned_user_id = users.id SET user_preferences.contents = REPLACE(TO_BASE64(REPLACE(CONVERT(FROM_BASE64(user_preferences.contents) USING utf8), '"email_link_type";s:5:"sugar"', '"email_link_type";s:6:"mailto"')),"\n",'') WHERE user_preferences.category = 'global' AND user_preferences.deleted = '0' AND CONVERT(FROM_BASE64(user_preferences.contents) USING utf8) LIKE '%"email_link_type";s:5:"sugar"%' AND users.sugar_login = '1' AND users.status = 'Active' AND users.deleted = '0'

I have not tested this and would recommend running it in a staging environment and/or against a smaller subset of users before running it against all users. 

I hope this helps!