How to set default email client on users

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

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)

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!

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!