My First Major Sitecore PowerShell Extension Workout

One of my recent tasks was to make a content node with child items to fallback to "en" language version, for all existing languages.

Since there were lot of child items, I thought to use the Sitecore PowerShell module and do it using script.

Sitecore PowerShell Extension module can be downloaded from https://marketplace.sitecore.net/en/Modules/Sitecore_PowerShell_console.aspx

During my task, I faced several obstacles. But all solved using PowerShell scripts.

First thing I did was Google..

I found following article, which contains most of the functionality I needed.

https://mtgeekblog.wordpress.com/2016/11/30/first-blog-post/


Then, I needed to restrict the code to only change workflow state on all the language except "en" language.

I posted my question on Sitecore Slack Chat in #module-spe channel.

(In case if you are not yet a member of Sitecore Chat channel, you can send a request to access it using https://docs.google.com/forms/d/1bAVDgP5-FhFh8ohPchHtifq-rz7EBkuPojAzdEofJyo/viewform?edit_requested=true )

Luckily, Sitecore PowerShell module creates was on Sitecore Slack Chat Channel also. They helped with that problem.

get-childitem . -recurse -Language * | where-object { $_.Language -ne "en" }

Then, I faced another strange issue. When run the following script, it only returned few language versions per an item. But, I know there were lot of other language versions for this same ite.

get-item . -Language * | Format-Table Id, Name, Language, __Workflow, "__Workflow state", "__Default workflow"

What I find out was, we are using Sitecore "Language Fallback" feature on these items. When that "Language Fallback" checkbox is checked, it somehow only took few item versions.

But, No problem. I ran following script on the child items, which sets the "Enable Item Fallback" checkbox Un-Checked. Then run the scripts. Then again make the "Enable Item Fallback" checkbox Checked.


Another Issue I faced was, when I try to remove language versions from an item, the script didn't do anything.

That is also caused by the Language Fallback feature. So, When you are running version related scripts (EX: Checking the language versions, Removing language versions, etc), first make the "Enable Item Fallback" Un-Checked, before running the Script.


From todays experience with Sitecore PowerShell Extension module, I understand that it is a must have tool for Sitecore Developers.

I will post more about the things I learn with PowerShell Extension in coming days.

Happy Sitecore and Sitecore PowerShell :-)