Bulk update to Users Profiles - set date/time formats

[Steven Cotterell]

Hi,

We would like to be able to perform a mass change to the 'date/time' & 'date' formats in our users profiles without having to go into the profile settings for each user and select the required setting/style.

Can anyone suggest a way forward please?

Thanks 

[Steve Giller]

If you're using the Data Import Tool you can set these as part of the import. Would that be a suitable option?

[Steven Cotterell]

Thanks for replying @Steve Giller, these are existing users.  Can we use the Data Import Tool for existing users?  I'm thinking we would need to do an export first to get a list of users with IDs and settings in some sort of CSV file, then re-import the users with the modified settings.

Am I on the right lines?

[Steve Giller]

@Steven Cotterell The Data Import Tool can be used to Create, Update, or both.

If you review the wiki documentation for your environment, it's a little different for Azure and AD, and then post back here with any further questions.

 

[Steven Cotterell]

@Steve Giller - Ah, that would be great if we'd set-up our users based off our Azure / O365 accounts.  However, we didn't.  We manually created them all during our Switch-on.  There must be a way that we can export settings and re-import with amendments....??

[Steve Giller]

@Steven Cotterell Ah - that would be the SQL import then; this can also import from CSV. If you need to export the Users then report with the Additional Data Format set to CSV on the Output Formats tab should be able to do that.