Change language of custom columns in a list via PoSh or GUI

by simark at 2013-03-19 07:51:42

Hi guys,

I have a German language pack installed beside the default English pack. I have created a few custom columns in a list with names such as "Availability", "Status", … etc. When I change the language from English to German, then of course SharePoint does not translate these custom column names.
I did some searching and found out that SharePoint uses *.resx files to store some sort of Resource values in xml format. These files contain the language definitions for several parts and objects in SharePoint. These resource files can be found in several folders throughout the SharePoint hive:
[list]
\14\Template\Features&lt;Feature Name>\Resources<br>\14\Resources<br>\14\Config\Resources\
…etc
[/list]
My question is: How can I manage to use different strings (German if German language and English if English language is selected) on a custom column in a list with PowerShell?

Many posts were talking about creating your own resource files with Visual Studio 2010 (or later), but that seems a bit complex and tricky. My idea was to simply create a some sort of xml file where I define the appropriate values, but I don’t know how to manage that.

Looking forward for your replies!

Regards,
Mark
by AlexBrassington at 2013-03-19 10:56:32
You’re about right but you’re in dangerous ground. Never try to edit the resource files directly, it doesn’t automatically bring you out of support but it’s bad practice and very risky. At best MS might overwrite your version without notice or appology.

You can set a resource specific value for the Site Column pretty easily using the MUI.

http://technet.microsoft.com/en-us/libr … =office.14).aspx#Section3

From what i’ve read you can get SharePoint to automatically update the region specific names by getting a Site Collection admin to switch to the appropriate language and then update the site column name. I haven’t tested this but it should be more or less that easy. Do not try to edit the resource file directly or create them directly without going through the SharePoint API.

(Possibly of interest: http://technet.microsoft.com/en-us/libr … =office.14).aspx#Section3 - slide deck by Gary Lapointe on MUI including some PS to enable it)
by simark at 2013-03-19 11:27:23
Hi Alex,

Thank you for the fast response and for the notification regarding the risks.
The MUI approach works perfectly! The only drawback that I do it manually through the GUI because as I read through the http://msdn.microsoft.com/en-us/library/ff800886%28v=office.14%29.aspx it looked a bit deep to dive in from a coding perspective.
You have written two URLs, but both of them is broken. Could you please copy them again?
by AlexBrassington at 2013-03-19 12:32:34
http://technet.microsoft.com/en-us/library/ff805062(v=office.14).aspx#Section3 And the second one should have been http://www.thelapointes.com/blog/presentations/sptechcon/Variations_and_the_MUI_in_SharePoint2010.pdf but i’d just C&P’d the same one twice.
by simark at 2013-03-19 13:06:35
Thanks for the links.
Currently I am satisfied with the manual modification of the columns as site col admin. If in the future I will accomplish the task with PowerShell, I will share it here too.

Have a nice day!