Sitecore PowerShell : Part 3

By Er. Pranshu Katiyar (Software Engineer) -

 Sitecore PowerShell Examples:

Task 1: PowerShell Script which will show the report of Selected Item i.e. Item Name, Children, Language, Version, Id, Template Name etc.

Script:

$sampleItemTemplateId = "Item ID”

$sampleItemTemplateItem = Get-Item -Path "master: Item Path " -ID $sampleItemTemplateId

Get-ItemReferrer -Item $sampleItemTemplateItem

Output:



Task 2: PowerShell Script which will show the report of Item child i.e. Child Name, Children, Language, Version, Id, Template Name

Script:

Method 1:

Get-ChildItem -Path master: Item Path -Recurse| Where-Object { $_.TemplateName -ne "Page"}

Output:



Method 2: To Find Data for Selected Language.

$path = "master: Item Path "

@(Get-Item -Path $path -Language "en*" -Version *) + @(Get-ChildItem -Path $path -Language "en*"  -Version * -Recurse)

Output:


Task 3: PowerShell Script Export Sitecore data into excel

Script:

Method 1:

Import-Function -Name ConvertTo-Xlsx

[byte[]]$outobject = Get-ChildItem master: Item Path |

    Select-Object -Property Name, ProviderPath, id, Language, Varsion, Content |

    ConvertTo-Xlsx

Out-Download -Name "report-$datetime.xlsx" -InputObject $outobject

 Output:


Method 2:

Import-Function -Name ConvertTo-Xlsx

 [byte[]] $data= Get-Item -Path master: -ID "Item Id" | Select-Object -Property Title,Content , TemplateName | ConvertTo-Xlsx

Out-Download -Name ReferrerInfo.xlsx -InputObject $data

Output:


Task 4: PowerShell Script to Update the item fields/content

Script:

$item = Get-Item -Path master: -ID "Item Id"

$item.Editing.BeginEdit()

$item.Fields["Title"].Value = "XYZ"

$item.Editing.EndEdit()

Output:

Before: 


Script Execution:


Result:


Task 5: PowerShell Script to Update the media reference

Script:

$item = Get-Item -Path "master: Item Path"

$item.Image = Get-Item -Path "master: Source Image Path

Output:

Before Execution:


Script Execution:

Result:


Task 6: PowerShell Script to find All Item Report/ Website Report

Script:

$itemList = Get-ChildItem "master: Item Path "

$reportProps = @{

    Title = "Report Title"

    InfoTitle = "This is a heading of the report."

    InfoDescription = "Total entries found: $($itemList.length)"

    PageSize = 25

}

$itemList | Show-ListView @reportProps -Property `

    @{ Label = "Item Name"; Expression = { $_.DisplayName } },

    @{ Label = "Path"; Expression = { $_.FullPath} }

Close-Window

Output:


Task 7: PowerShell Script to find all products that are active or Not

Script:

Method 1:

Get-Childitem master: Item Path |

   Where-Object { $_.Active -ne "1" } |

    Format-Table # or do something with them

Output:


Method 2:

Get-Childitem master: Item Path -Recurse |

    Show-Listview -Property Name, ProviderPath, @{Label="Active"; Expression={$_.Active -eq "1" }}

           

 Output:


Task 8: PowerShell Script to Delete All Subitems Under Items

Script:

$folderItem = Get-Item -Path 'master: Item Path'

Get-ChildItem -Path $folderItem.FullPath |

    ForEach-Object {  

            Write-Host "Deleting: " $_.Name

            $_ | Remove-Item -Recurse

        }               

Write-Host "Done"

Output:


Task 9: PowerShell Script to Delete All Folder with Subitems Under Item

Script:

Method 1: gci -path 'Item ID' -recurse | ri

        or

Method 2: gci -path 'Item ID' | ri -recurse

Task 10: PowerShell Script to Delete Subitem from Particular Template

Script:

gci -path ‘Item Path’ | where-object{$_.'Templateid' -eq 'Template Id'} | ri

 

 Note: More Read About Sitecore PowerShell Follow Part 1 & 2

Part 1: Sitecore PowerShell : Part 1

Part 2: Sitecore PowerShell : Part 2

Thanks For Reading My Blogs

You Can Also Continue Your Learning By Reading These More Blogs - 

Comments

Post a Comment

Read More Blogs Here....

Sitecore JavaScript Services

By Er. Pranshu Katiyar (Software Engineer) -
Image
  Sitecore JavaScript Rendering SDK (JSS) What Is Sitecore Jss: Sitecore JSS offers front-end developer of whole new way of working and interacting with Sitecore. Building a JavaScript app on top of Sitecore has never been easier. Simply use your Favourite JavaScript framework and leverage the Sitecore capabilities to power your applications. What is Headless Development: Sitecore Headless Development is based on a rendering host front end and a Sitecore instance back end. This decoupling of logic domains makes a Sitecore solution easy to develop, maintain, scale, and upgrade. Sitecore ASP.NET   Rendering SDK - https://doc.sitecore.com/xp/en/developers/hd/200/sitecore-headless-development/sitecore-asp-net-rendering-sdk.html Getting started with the latest version of Jss Application To develop a JSS application, you need: Ø   An operating system supported by Node (Mac, Windows, Linux). Ø   Node. We recommend using the latest long-term support (LTS)...
Read more

LaMDA Software

By Er. Pranshu Katiyar (Software Engineer) -
Image
  LaMDA Software Introduction: ·     LaMDA is a family of conversational large language models or AI-driven chatbot developed by Google . Originally developed and introduced as Meena in 2020, the first-generation LaMDA was announced during the 2021 Google I/O keynote, while the second generation was announced the following year. it's basically an advanced form of a chatbot.            ·         The acronym stands for " Language Model for Dialogue Applications ". Built on the seq2seq architecture , transformer-based neural networks developed by Google Research in 2017, LaMDA was trained on human dialogue and stories, allowing it to engage in open-ended conversations. ·         Google will release LaMDA to small groups of people in batches, test the app, and work on feedback to make it better, before making it available to the general public. ·     ...
Read more

Component In Sitecore / Create One Column Component In Sitecore:

By Er. Pranshu Katiyar (Software Engineer) -
Image
What is Component / What are Sitecore components: A component defines a part of the page. It can contain layout information, for example, content fields and placeholders, and their positions on the page, as well as business logic or metadata for the page.  In Sitecore, a page consists of a page layout and components. The page layout defines the overall structure of the page. A developer creates the page layout, which can contain placeholders where you can insert components. A component defines a part of a page. Typically, you reuse components on multiple pages. If the component displays content, you can save the content to the page item or to a separate content item. You assign a content item to the component on the page, and you can reuse the content item on other pages. Simple Steps for How to Create one Column Component (For Beginners) Step 1 -   Create a Template name “ ColumnTemplate” Location :   /sitecore/templates/Feature/Composites/ColumnTemplate Step 2 - Cre...
Read more

Blockchain Technology

By Er. Pranshu Katiyar (Software Engineer) -
Image
Blockchain Definition: Ø   A blockchain is a digitized, distributed, consensus-based secure storage of information protected from revision and tampering over the peer-to-peer network. Ø   Most often used in association with cryptocurrencies like BitCoin, blockchain is a digital, distributed, public-ledger technology designed to record transactions in a secure, tamper-proof, yet publicly accessible way that resists tampering or modification. Ø   Blockchain was first introduced in the white paper for Bitcoin in 2009 by unknown person named as Satoshi Nakamoto. Currently, blockchain is used by multiple organizations to tackle their problems and provide a better solution. What exactly is Blockchain: The blockchain is general terms is defined in following manner:   A technology that permits transactions to be recorded permanently.    A technology that removes intermediaries and create trust through the algorithm. A technology that cryptographically secure...
Read more

Sitecore PowerShell : Part 1

By Er. Pranshu Katiyar (Software Engineer) -
Image
  Sitecore PowerShell Extension: Sitecore PowerShell Extensions (SPE) is a module for Sitecore that enables scripting and automation capabilities using PowerShell. PowerShell is a scripting language and shell designed for task automation and configuration management . With SPE, you can create and execute PowerShell scripts within the Sitecore context, allowing you to automate various tasks and operations. Here are some key aspects of Sitecore PowerShell Extensions: Installation You can install SPE using the Sitecore Installation Wizard or install the module manually by copying files to the appropriate directories. Integration with Sitecore SPE integrates with the Sitecore Desktop and Content Editor, providing a PowerShell console directly within the Sitecore interface. Scripting Environment SPE provides a scripting environment where you can write, edit, and execute PowerShell scripts. You can use these s...
Read more

Contact Me/Any Suggestion

Name

Email *

Message *