Author: rohitpandey

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.

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.

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()

}

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