MYPIBLOGs

Sitecore powershell is very useful module of any version of sitecore. We can do basic operation using Sitecore powershell like create items, update items name and fields values.

Today  I will explain about creating bulk items or creating large of items  and update the values on the fields in fews seconds, so this kind of quick operation can be only done by Sitecore powershell.

I will share a sitecore powershell script for it. It is going to do following job in it.

1. Import csv file (right format file)

2. Read all rows of csv file and get values to some powershell variables

3. There will be condtion flags(Skip or Update) to distinguish the type operation to be done.

Skip means: create item, remove or delete items.

Update: Update the values of existing items

4. Here, we create item and update values , so Skip flag will be in condition as well as in csv file first column.

5. Create item with the help of template item.

6. Manipulate the target item using created item and Update values on fields of the items.

May above steps not much clear but when you will dear to look at below powershell code, you will definitely get it. It is quite easy.

Lets I have to create 50 towns items and feed the values like name of town  into Town Name field.

We will prepare a csv file format.(Download Csv Sample Here)

Note:

1. No space Column Name in csv file

2. Name of the column in csv file should exact same in script row variables

Ex:

Column name

CSV file:

Town_Name

in script:

$Town_Name= $row.Town_Name;

CSV file Format

Column Name

1. Update_Check: Skip conditional flag will in all rows.

2.Item_name: Items will be created with this names

3.Item_Path: Items will navigate to path and create item.

4.Town_Name: town name fields values.

function RunQuery { #import Csv and create item and update value in one field . function RunQuery { $dataFolder = [Sitecore.Configuration.Settings]::DataFolder $tempFolder = $dataFolder + "\temp\upload" $filePath = Receive-File -Path $tempFolder -overwrite if($filePath -eq "cancel"){ exit } #Change encoding from ANSI to UTF-8 by reading and saving #-Encoding:String # = ANSI = Windows-1252 = iso-8859-1 #print content on screeen #Get-Content $filePath -Encoding:String | ft #convert to UTF-8. type is alias for Get-Content type $filePath -Encoding:String | Out-File $filePath"UTF8.csv" -Encoding:UTF8 #Import-Csv by default accepts UTF-8 Import-Csv $filePath"UTF8.csv" -Delimiter:";" | Where-Object {$_.UserID -ieq "ABC"} | ft Import-Csv $filePath"UTF8.csv" -Delimiter:";" | Where-Object {$_.UserID -ieq "ABC"} | Export-Csv $filePath"FilteredUTF8.csv" -NoTypeInformation -Delimiter:";" -Encoding:UTF8 $resultset = Import-Csv $filePath"UTF8.csv" # Reading csv file all rows/column and assign values to variables foreach ($row in $resultset) { $Update_Check = $row.Update_Check; $Item_Path = $row.Item_Path; $Item_GUID = $row.Item_GUID; $Item_name = $row.Item_name; $Town_Name= $row.Town_Name; #Here update_check is flag, It can be Skip or update #based on the condition it will proceed the operations If($Update_Check -ne "Skip") { If(($Item_GUID) -And ($Update_Check -eq "Update") -And (test-path $Item_Path)) { $i++ $targetItemID = $Item_GUID Write-Host " Item Updated $i" $targetItemID; } } else { #This section will create item using template id $i++ Write-Host $Item_Path ; $NItem = New-Item "$Item_Path" -Name "$Item_name" -type "{29193847-6135-4DBE-8E26-B3F6BD3F6DBD}"; $targetItemID = $NItem.ID; $targetItemName = $NItem.Name; Write-Host "Item Created $i "$targetItemID; Write-Host "Item Created $i "$targetItemName; } #Get target item and update values to fields $FTargetItem = Get-Item -Path master: -Id "$targetItemID" $FTargetItem.Editing.BeginEdit(); $FTargetItem."__Display name"="$Town_Name"; $FTargetItem.fields["Town Name"].Value="$Town_Name"; $FTargetItem.Editing.EndEdit() | Out-Null; } } RunQuery {}  

Paste this scrip to Sitecor powershell ise and execute it and select the csv file.

It will start creating items and also show you logs in powershell console.