Automatisation Office 365 Language Settings

By using Office 365 you are syncing your local Active Directory with Azure AD which is comming together on Office 365.
For best practise of Microsoft the way to sync the informations we should use AADConnect.

 

Office 365 creates new users automaticaly with Default Language settings of O365 Tenant. For multi Language companies this can become a problem.
An Administrator or the User by itself needs to edit the Language settings for each user who do not work with the Tennant’s default Language.
In some cases this can be very dificult, if for example the Letters are Cyrilic, or Japanese instead of Latinic.

 

There is an easy way to prevent this issue:
Lets make an example how to prevent this problem…

 

We have a company whicj is named Contoso Ltd.
The Company’s locations are in Switzerland (DE), London (EN) and Moscow (RU)
The Tenant Language of the Company is set to english.

A new user joins the company in London office. The HR creates a new User object in the Active Directory called “User01”. The AADConnect is setted up to run every 60min a sync form the local AD to the Azure AD.
Because the default Language settings of the O365 Tenant is english, the user01 will also get his O365 profile in english. This is good so far if the User’s native language is English.

The User01 is not the only new employee who starts his job in the company. For the Office in Moscow ther is also a new worker, but he do not speaks or understands english.
The HR creates for this employee also a User object called “User02” and this account will also be synced to the O365 Cloud. Everything runs identical like by the User01, the Language settings will be set to english.
But as we know, the User02 don’t speaks or understands english at all.
To prevent problems or support Tickets you have to edit by creating a new user in the Active Directory the Default AD-Attribut “PreferredLanguage”.
If you fill in this Attribut with the right “CultureCode” or “Language Culture Name”, Office 365 will be able, to set the right default Language for the specific user.

(The table with the „Language Culture Name“ and „Culture Code“ I will present in the end of this article.)

If you have a multi Language organisation, I highly recommend you always to maintain this field. This ensures that everyone in the Office 365 has the correct language settings.
 

Attention: In this case is Not included:

Outlook Online (OWA):

Here every user will be asked after the very first start which Language he would like to use.

Region:

Unfortunately, the O365 profile attribute “Location” can not be controlled by On-Prem. The AD attribute “localeID” has no effect on the profile settings. This can be set up by means of a script.

 

 

 

 

Table for “Language Culture Name” and “Culture Code”

Language Culture NameDisplay NameCulture CodeISO 639x Value
af-ZAAfrikaans – South Africa0x0436AFK
sq-ALAlbanian – Albania0x041CSQI
ar-DZArabic – Algeria0x1401ARG
ar-BHArabic – Bahrain0x3C01ARH
ar-EGArabic – Egypt0x0C01ARE
ar-IQArabic – Iraq0x0801ARI
ar-JOArabic – Jordan0x2C01ARJ
ar-KWArabic – Kuwait0x3401ARK
ar-LBArabic – Lebanon0x3001ARB
ar-LYArabic – Libya0x1001ARL
ar-MAArabic – Morocco0x1801ARM
ar-OMArabic – Oman0x2001ARO
ar-QAArabic – Qatar0x4001ARQ
ar-SAArabic – Saudi Arabia0x0401ARA
ar-SYArabic – Syria0x2801ARS
ar-TNArabic – Tunisia0x1C01ART
ar-AEArabic – United Arab Emirates0x3801ARU
ar-YEArabic – Yemen0x2401ARY
hy-AMArmenian – Armenia0x042B
Cy-az-AZAzeri (Cyrillic) – Azerbaijan0x082C
Lt-az-AZAzeri (Latin) – Azerbaijan0x042C
eu-ESBasque – Basque0x042DEUQ
be-BYBelarusian – Belarus0x0423BEL
bg-BGBulgarian – Bulgaria0x0402BGR
ca-ESCatalan – Catalan0x0403CAT
zh-CNChinese – China0x0804CHS
zh-HKChinese – Hong Kong SAR0x0C04ZHH
zh-MOChinese – Macau SAR0x1404
zh-SGChinese – Singapore0x1004ZHI
zh-TWChinese – Taiwan0x0404CHT
zh-CHSChinese (Simplified)0x0004
zh-CHTChinese (Traditional)0x7C04
hr-HRCroatian – Croatia0x041AHRV
cs-CZCzech – Czech Republic0x0405CSY
da-DKDanish – Denmark0x0406DAN
div-MVDhivehi – Maldives0x0465
nl-BEDutch – Belgium0x0813NLB
nl-NLDutch – The Netherlands0x0413
en-AUEnglish – Australia0x0C09ENA
en-BZEnglish – Belize0x2809ENL
en-CAEnglish – Canada0x1009ENC
en-CBEnglish – Caribbean0x2409
en-IEEnglish – Ireland0x1809ENI
en-JMEnglish – Jamaica0x2009ENJ
en-NZEnglish – New Zealand0x1409ENZ
en-PHEnglish – Philippines0x3409
en-ZAEnglish – South Africa0x1C09ENS
en-TTEnglish – Trinidad and Tobago0x2C09ENT
en-GBEnglish – United Kingdom0x0809ENG
en-USEnglish – United States0x0409ENU
en-ZWEnglish – Zimbabwe0x3009
et-EEEstonian – Estonia0x0425ETI
fo-FOFaroese – Faroe Islands0x0438FOS
fa-IRFarsi – Iran0x0429FAR
fi-FIFinnish – Finland0x040BFIN
fr-BEFrench – Belgium0x080CFRB
fr-CAFrench – Canada0x0C0CFRC
fr-FRFrench – France0x040C
fr-LUFrench – Luxembourg0x140CFRL
fr-MCFrench – Monaco0x180C
fr-CHFrench – Switzerland0x100CFRS
gl-ESGalician – Galician0x0456
ka-GEGeorgian – Georgia0x0437
de-ATGerman – Austria0x0C07DEA
de-DEGerman – Germany0x0407
de-LIGerman – Liechtenstein0x1407DEC
de-LUGerman – Luxembourg0x1007DEL
de-CHGerman – Switzerland0x0807DES
el-GRGreek – Greece0x0408ELL
gu-INGujarati – India0x0447
he-ILHebrew – Israel0x040DHEB
hi-INHindi – India0x0439HIN
hu-HUHungarian – Hungary0x040EHUN
is-ISIcelandic – Iceland0x040FISL
id-IDIndonesian – Indonesia0x0421
it-ITItalian – Italy0x0410
it-CHItalian – Switzerland0x0810ITS
ja-JPJapanese – Japan0x0411JPN
kn-INKannada – India0x044B
kk-KZKazakh – Kazakhstan0x043F
kok-INKonkani – India0x0457
ko-KRKorean – Korea0x0412KOR
ky-KZKyrgyz – Kazakhstan0x0440
lv-LVLatvian – Latvia0x0426LVI
lt-LTLithuanian – Lithuania0x0427LTH
mk-MKMacedonian (FYROM)0x042FMKD
ms-BNMalay – Brunei0x083E
ms-MYMalay – Malaysia0x043E
mr-INMarathi – India0x044E
mn-MNMongolian – Mongolia0x0450
nb-NONorwegian (Bokmål) – Norway0x0414
nn-NONorwegian (Nynorsk) – Norway0x0814
pl-PLPolish – Poland0x0415PLK
pt-BRPortuguese – Brazil0x0416PTB
pt-PTPortuguese – Portugal0x0816
pa-INPunjabi – India0x0446
ro-RORomanian – Romania0x0418ROM
ru-RURussian – Russia0x0419RUS
sa-INSanskrit – India0x044F
Cy-sr-SPSerbian (Cyrillic) – Serbia0x0C1A
Lt-sr-SPSerbian (Latin) – Serbia0x081A
sk-SKSlovak – Slovakia0x041BSKY
sl-SISlovenian – Slovenia0x0424SLV
es-ARSpanish – Argentina0x2C0AESS
es-BOSpanish – Bolivia0x400AESB
es-CLSpanish – Chile0x340AESL
es-COSpanish – Colombia0x240AESO
es-CRSpanish – Costa Rica0x140AESC
es-DOSpanish – Dominican Republic0x1C0AESD
es-ECSpanish – Ecuador0x300AESF
es-SVSpanish – El Salvador0x440AESE
es-GTSpanish – Guatemala0x100AESG
es-HNSpanish – Honduras0x480AESH
es-MXSpanish – Mexico0x080AESM
es-NISpanish – Nicaragua0x4C0AESI
es-PASpanish – Panama0x180AESA
es-PYSpanish – Paraguay0x3C0AESZ
es-PESpanish – Peru0x280AESR
es-PRSpanish – Puerto Rico0x500AES
es-ESSpanish – Spain0x0C0A
es-UYSpanish – Uruguay0x380AESY
es-VESpanish – Venezuela0x200AESV
sw-KESwahili – Kenya0x0441
sv-FISwedish – Finland0x081DSVF
sv-SESwedish – Sweden0x041D
syr-SYSyriac – Syria0x045A
ta-INTamil – India0x0449
tt-RUTatar – Russia0x0444
te-INTelugu – India0x044A
th-THThai – Thailand0x041ETHA
tr-TRTurkish – Turkey0x041FTRK
uk-UAUkrainian – Ukraine0x0422UKR
ur-PKUrdu – Pakistan0x0420URD
Cy-uz-UZUzbek (Cyrillic) – Uzbekistan0x0843
Lt-uz-UZUzbek (Latin) – Uzbekistan0x0443
vi-VNVietnamese – Vietnam0x042AVIT

Leave a Reply

Your email address will not be published. Required fields are marked *