Where is chnaged data stored

[ocset]

Hi

This is hopefully a simple question for those well versed in Sugar.

Q,
If I change a heading for a dashlet from say 'Sugar News' to "Sugar Stuff', where are the changes stored?

I have exported the database and can't find it there and have grep'd for the change in the Sugar directory, also no luck. I must be blind

Does it get encrypted and then stores?

Thanks for any guidance.
O

[eggsurplus]

It gets packed into the user_preferences column in the users table. If you want to mass change anything in that column you need to create a php script that iterates through the users and sets the user preferences using the available functions that Sugar provides. You'll have to do some code digging to figure out the right way to do this. I saw an example long ago by sugardev.net on the forums here that may get you started.

[SugarDev.net]

Uhh, I don't get your point addison.marlin..

@ocset: The data is not encrypted, but it is encoded (slight difference). Using base64, the personal preferences are stored as serialized variables in the table as eggsurplus stated. If you want to change the name of these dashlets for new users, change their language labels in the Home module.