Category: Sitecore Powershell

Posted on

Powershell script to work on matching item names from external source

Many times there are scenarios when we are given with a excel file or csv from external source which has item names but not the item’s Sitecore IDs. Like we are given a excel with product names and other features which came from SAP resource.

Here the main challenge is to find the Sitecore item under a bucket folder which contains almost 8k items and then apply the logic(update or deletion) using a Powershell script. Getting the item based on item name will be slow and costly operation and the script will be too slow in making the updates. As the data is provided by external source so we don’t have the Item Ids which is the fastest way to find a item in Sitecore.

There are two ways to address this issue.

First way is manual way which requires some excel expertise of Vlookup.

First output a csv with item names and its id by using Powershell as below.

$allItems = Get-ChildItem “master:/sitecore/content/Products” -recurse | where-object {$_.TemplateID -eq “{B0707AC2-64D8-4CA1-AED4-3A1250208295}”}

foreach($itm in $allItems){write-host $itm.Name “;” $itm.ID}

Do a vlookup with the same column values. Here Item name and Product SKU (from SAP) has same column values and we can associate the Item IDs by vlookup from two excels files (one created from Sitecore and other one from external source).

VLOOKUP to populate associate Sitecore Item IDs

Once you have Ids you can quickly get the item in Powershell and do any kind of update operation on it.

Second way is fully automated way which I recently used to handle this scenario.

First create a hashtable of item names and its Ids and while reading the csv perform the key lookup which is the Product name(Item name in Sitecore) and get the ID. Again once you got the IDs you are free to do any manipulation at item level. It was quite fast and no manual intervention required. No excel expertise required.

foreach($itm in $allItems)
{
try{$hash.Add($itm.Name.ToLower(), $itm.ID) } catch { #Write-Host $itm.Name “;” $_.Exception.Message -BackgroundColor DarkRed }

}

foreach($row in $csv){

$key=$row.”ProducNameColumn”.Trim()

$ids = $hash[$key]

$sitecoreitm= Get-Item “master:” -ID $ids -ErrorAction SilentlyContinue

$sitecoreitm.Editing.BeginEdit()
$sitecoreitm.Fields[“Value”].Value = “some value”;
$sitecoreitm.Editing.EndEdit()

}

Posted on

Adding users in Sitecore with specific roles using Powershell

we can use Sitecore Powershell to create users in Sitecore. This is how we can create a single user in sitecore.

$username=”contentbuser”
$userpwd=”content@123″
$roles=”Author,Developer”
$email=”test@test.com”

Write-host “Creating User: $($username)”
New-User -Identity $($username) -Enabled -Password $($userpwd) -Email $($email) -FullName “$($username)”

Lets add some roles to it.

$($roles).Split(“,”) | ForEach {
Write-host “Adding user to role: $_ “
Add-RoleMember -Identity $_ -Members “$($username)”
}

If you you want to make it as an administrator

Set-User $($username) -IsAdministrator $true

Here you can assign multiple roles to it too.

Create Bulk users in Sitecore

Now Imagine a scenario where you have to create number of users where you have a csv file with the necessary information mentioned above like username, password, email and roles to be assigned. you can use below script to automate creating number of users

Upload a csv file from your local to sitecore upload folder. This is very important to note because you might get permission issue error if you want to write at some other location. This will be helpful.

$dataFolder = [Sitecore.Configuration.Settings]::DataFolder
$tempFolder = $dataFolder + “\temp\upload”
$filePath = Receive-File -Path $tempFolder -overwrite

if($filePath -eq “cancel”){
exit
}

$Usersdata = Import-Csv -Path $filePath

foreach($user in $Usersdata) {
    Write-Verbose "Creating User: $($user.Username)"
   New-User -Identity $($user.Username) -Enabled -Password $($user.Password) -Email $($user.Email) -FullName "$($user.Name)"
    
    #Set-User $($user.Username) -IsAdministrator $true
    
   $($user.Roles).Split(",")  | ForEach {
     Write-Verbose "Adding user to role: $_ "
     Add-RoleMember -Identity $_ -Members "$($user.Username)"
   }
}

here Username, Password, Email and Roles are csv fields.

Posted on

Adding Rendering to Item presentation using Powershell Scripting.

Scenario: Assume a new rendering is created and we need to assign this rendering to multiple items in the Sitecore content tree. while this can be done manually it will be time consuming and boring task for content authors. Again Powershell come to the rescue.

Get Item where rendring needs to be assigned.
$item=Get-Item -Path “master:” -ID “{3512740C-8965-4E40-A082-0F528A638111}”
Get rendering which needs to be assigned on the above item
$RenderingName = Get-Item -Path “master:” -ID {209B30A5-495C-4AF0-A670-8287E78107DE}
write-host “adding rendering…”
Add-Rendering -Item $Item -PlaceHolder “content123” -DataSource “” -Instance (New-Rendering -Item $RenderingName)
write-host “add rendering completed…”

Note: Here you can provide the Placeholder and Datasource too based on the requirement.

The same Process can be automated with multiple items and multiple renderings where you are reading the item IDs from a csv file and assigning the renderings in a foreach loop.

Posted on

Get All items based on specific template under bucket folder which got updated x days ago.

Scenario: Let assume that due to some wrong migration from external system lot of item fields got updated under Sitecore bucket folder. If we need to fix this kind of scenario we can use the Powershell scripting.

$allItems = Get-ChildItem “master:/sitecore/content/products” -recurse | where-object {$_.TemplateID -eq “{70E9D00C-2A10-41EE-BE6D-8441FD4C8C79}” -and $_.__Updated -gt [datetime]::Now.AddDays(-10) }

How to update one of the Fields.

foreach($item in $allItems){

write-host $item.ID “;” $item.Name
$item.Editing.BeginEdit()
$item.Fields[“FieldtoUpdate”].Value = “CorrectValue”
$item.Editing.EndEdit()

}

Posted on

Basic Sitecore Powershell commands

Get Item based on item id

Get-Item -Path “master:” -ID “{0DE95AE4-41AB-4D01-9EB0-67441B7C2425}“

Get item id based on path

Get-Item Path “master:/sitecore/content/Sites/Site Data/ACP Components/Sample Data”

Get item properties

Get-Item -Path “master:/sitecore/content/Sites/ Site Data/Components Data/sample data” | select Name, Id, __Updated,__Created

Get item based on template name

Get-Item -Path “master:” -Query “/sitecore/content/Sites/Site Data/Components//*[@@templatename=’Component Parmaters’]”

Get item or items based on template id

Get-Item -Path “master:” -Query “/sitecore/content/Sites/Site Data/ACP Components//*[@@templateid=’{A3AEC2DA-31A8-46F8-ADB3-07697886321A}‘]”

Show list view or download the output with required properties or fields directly on the Item

Here Product is Sitecore bucket folder and items are created by code automation and we are only interested in the items with specific template ID

$allItems = Get-ChildItem “master:/sitecore/content/Sitecore/SiteA/Product/2017” -recurse | where-object {$_.TemplateID -eq “{42B5CFEF-AB2D-4E1F-A8D0-7DCD6A3A9DEH}”}
$allItems | Show-ListView -Property Name, Id, __Updated,__Created