Details about this thread
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 293 subscribers
  • Views 812 views
  • Users 0 members are here
Related content from around SugarClub

Bulk Change the "Name Display Format" in Locale Settings under User Administration

Stella Wong

Hello,

Does anyone know how to do a mass update on the Name Display Format in Locale Settings under User Administraton ?

I would like to change the Name Display Format from "Dr. David Livingstone" to  "Livingstone, David" for all users.

I am using SugarCRM Enterprise version 6.5.

Thanks,

Stella

Parents
  • 0

    Stella,

    This setting is stored in the user_preferences table within the database.  Specifically within the global category.  The "content" column is base64 encrypted and contains other preference settings for the specific user as well.  If you are able to get past the decryption/encryption aspect, I do not believe you can mass update just this one preference for all users without affecting settings preferences  that other users have selected.

    Hope this helps,

    Lori

Reply
  • 0

    Stella,

    This setting is stored in the user_preferences table within the database.  Specifically within the global category.  The "content" column is base64 encrypted and contains other preference settings for the specific user as well.  If you are able to get past the decryption/encryption aspect, I do not believe you can mass update just this one preference for all users without affecting settings preferences  that other users have selected.

    Hope this helps,

    Lori

Children