Andrew
Andrew

Reputation: 10033

CRM 2013 - Bulk Update User Setting for 'Current Format' (UK Date format..)

Does anyone know of a way of bulk updating Dynamics CRM 2013 Users to have the UK date format selected under the 'Current Format' User Setting? Either via code or using an existing tool.

I did have a tool that I used for CRM 2011 but this doesn't seem to be available any more. The XrmToolbox has a settings update tool but doesn't allow changing of this setting.

Alternatively does anyone know if their isn't a tool if this can be updated manually from the UserSettings table? (although I know this is unsupported)

Upvotes: 2

Views: 2021

Answers (2)

Mike Feingold
Mike Feingold

Reputation: 368

I once wrote some code to do something similar.

To update the settings for an individual user, you should be able to do something like (although I haven't tried it):

Entity us = new Entity("usersettings");
us["systemuserid"] = Row.systemuserid;
us["localid"] = 2057;  //UK
CRMservice.Update(us);

List of localid's is available from https://msdn.microsoft.com/en-us/library/ms912047(WinEmbedded.10).aspx

Upvotes: 3

MarioZG
MarioZG

Reputation: 2087

Have a look at xrmtoolbox. There is tool called "user settings utility" that should allow you to modify user settings in bulk.

I believe usersettings table update should work as well, but I'd assume tool above uses SDK, which is more supported way.

Upvotes: 2

Related Questions