We restore our production database to our training environment weekly. I would like to change the name of the favorites menu for all users to indicate which environment they are in. I do not know how to manipulate the binary data in the SysPersonalization table. Is there a way to do this?
Hey,
I got it I also wen throw this.
What you have to do is to save the setting of each enviroment to a different file, just export them and save them with meaningful names.
you can create shourcut to those files and share it throw the network,
so it will be accessable for all users and if you change the setting it will be reflected to all users, it is a “do it once and play it any where” concept.
even you can do some additional effects, like
-
startup massege (from the client configuration)
-
assign diferent icons for each of the setting files (normally from windows- just right click the file and change it from properties dialog)
is this what are you looking for?
Mohammed,
Thank you for your good suggestions. Unfortunately we are using AX4.0 SP2 through Citrix server, so the users don’t have any client icons on their desktop which I can manipulate or share through the network. We do some things like changing the font in one environment, using the status bar text message, startup messages, and changing the favorites menu to differentiate between environments which works well. The problem is that then when we restore the production environment to be the test environment, they must remember to rename the favorites menu manually. I can update the status bar text and fonts via SQL, but I would like to also be able to change the name of the favorites menu inside AX4.0
Have you ever worked with the binary data in the SysPersonalization table?
Many thanks,
Teresa