How to set default email client on users

Hi

Is there a way in the GUI to change the default email client for all users created from now on?

By default, it's Sugar:

but I need it to be "External Email Client"

Thanks,

KGM

Parents Reply Children
  • Hi ,

    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!