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

2
votes

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)

2
dynamics-crmdynamics-crm-2013settings
If any down votes - please can you provide feedback so I can improve the question rather than just down voting.. – Andrew
This looks like a good question because according to site guidelines it is about "software tools commonly used by programmers and is a practical, answerable problem that is unique to software development" - Upvoted – Zach Mast
Thanks Zach, hopefully someone has some pointers to help out :) – Andrew
Are you actually able to set the date format for individual users in 2013? All I am seeing is the date format under the "Formats" tab in Administration->System Settings. – Zach Mast
Yes you can set it per User from settings – Andrew

2 Answers

3
votes

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

2
votes

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.