Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Not Answered
  • Replies replies
    3
  • Subscribers subscribers
    168
  • Views views
    332
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How do I determine a user's locale, calendar or timezone when not specified in User account??

PM Thompson

A user account has settings for their locale, preferred calendar and timezone.  Those same settings are available in a group's "preferences" settings and can, theoretically, apply to all members of that group.  In addition, the SBM AE server's TimeZone is available in the System Settings table (ts_SystemSettings).  This setting could be considered a "last resort" when trying to determine a user's TimeZone.  No such defaults are available for locale or calendar ID, but could be added for reference purposes to the System Settings table (not supported by OpenText).

Given a user account where the locale, calendar or timezone is NOT set in the user settings, and where the user is a member of multiple groups and several of those groups have conflicting local, calendar or timezone settings, what is the search order of those groups to determine the user's locale, calendar or timezone???

Example,

The TS_USERS table entry for User ID 123 ("W. Flintstone") does not have "locale", calendarID or TimeZone selected.

User ID 123 is a member of the "Bedrock" Group ID #321 where locale="EN-US", CalendarID=1 and TimeZone="EST5EDT".  That user is also a member of the "bowling league" Group ID #987 where locale is not set, CalendarID=2 and TimeZone="Africa/Casablanca".  Which Group takes precedence, and therefore which calendarID and Timezone are selected for the user?

  • 0  

    I believe it goes like this....

    • User's own settings take top priority.
    • If user does not have these settings, they come from the group.
    • If the user is in more than one group, it might be looking at App Admin > Work Center > Work Center Settings > Side Menu Priority to see which group (which this user is a member of) has the highest priority and uses the settings from that group. However, this may literally only control side menu options of conflicting groups and nothing with the locales. It is more likely that it would use the "first" group (the first one assigned to the user, or maybe group with smallest TS_ID number for automatically created or copied users). I've never had any need to figure this out. It would take some trial and error testing, but I'll guess it's one of those two.
    • If all of that is missing, it uses the System Administrator > Options > Settings > Locale. I believe this defaults to the OS locale of the server, but technically it can be changed. (I think this is also what you see in the TS_SYSTEMSETTINGS table.)
    • Finally, there are the locale settings on the Windows OS.

    Does that help at all?

  • 0   in reply to   

    so, in the example above, I will guess the user will get the locale from the "bedrock" group because it has a smaller TS_ID

  • 0 in reply to   

    Vickie:

    Thanks for the response.  I'll admit that figuring out the Group stuff is a bit of a challenge.  I'm preparing a demo of SBM Calendars for our team.  I'm hoping that SBM 11.8 Patch 11 finally fixed the Calendar problems that have been plaguing us for a long time.

    I don't know of any way to establish the "priority" of the Groups of which a User is a member.  This is kind of important because it sets the search order for a User's settings and preferences when that user doesn't have user-specific settings.  As you suggested, we can search the Groups as ordered by Group TS_ID.  Other options that have occurred to me:

    • Search groups by count of members (least populated group is first or last???)
    • Search by the order in which that User was added to the Groups
    • Search groups by AccessType (External, Occasional, Normal, Managed Admin)

    Obviously (as you pointed out), any user-specific settings or preferences take priority over any system defaults or settings inherited through Group memberships. 

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.