Time zone setting for users

Hello @eqbstal 

In my case the field is active and can be selected.

Did you check if you have time zones set used in application?

That is @Furkan Zengin what I saw, but now each user that is new to the environment must set up manually this correct time zone, while the majority are not in London time but Amsterdam time. So looking for the view that holds the settings of all the users and bulk change them (using migration job) to one setting.

However then noticed that debug console has been implemented in a far different way.

Hello @eqbstal 

Can you try running this on SQL? This should set time zone as user’s browser time zone  setting

BEGIN
    User_Profile_Service_SVC.Do_Set_Client_Profile_Value(
        'User/General/Regional Settings', 
        'WorkingTimezone', 
        '\"#BROWSER#\"', 
        unbound## => ''
    );
END;

@Furkan Zengin Have to belief you that that is going to work. I have no access to the actual code, so can't build anything via the BuildPlace.

From the way it is written, I deduct that the setting is stored as xml and thus most likely in a blob or clob field. So that would make any migration job, that I have in mind, impossible.

Did I make the right assumption here?

Hello

I copied this piece code from browser inspect. I have not tested myself buy I believe this should work. Try to loop this for all users if you have access with SQL

Cheers

It’s possible to do via data migration, using CLIENT_PROFILE_VALUE_API as the method only mapping the columns PROFILE_ID, PROFILE_SECTION, PROFILE_ENTRY and PROFILE_VALUE and left the OBJID mapping in place.

As you say there are there are CLOB datatype columns but you can delete them out the job and leave the rest unmapped.