PowerShell with Sitecore and Installation: Part-1

-

PowerShell is a modern command-line shell, or we can say Scripting language framework.  It is a more influential tool compare to the command prompt. Sitecore PowerShell module increases your productivity, performance and saves your development time. It’s developed by Adam Najmanowicz and Michael West. It does not install OOTB therefore you need to install it manually. Using this module, you can perform serval operations on Sitecore Items like Add/Update/Delete, Get Child Items, Bulk Updates, Publish Items, Delete Items on specific conditions, etc.

Install SPE Module:

  1. Go to the Sitecore Download website from here and select the Sitecore Version. Once you elect, it will redirect to the download section. Here I am selecting Sitecore Experience Accelerator 10.1.0, click on the link and it will redirect you to the download section.
  2. Download the Sitecore PowerShell Extension for Sitecore.
    PowerShell-with-Sitecore-1
  3. Install the Sitecore PowerShell Extension (SPE) module. For more information about Install Sitecore Module and Package, see the blog post How to Install Sitecore Module or Package.
  4. After completing the installation, you can find the below options in the Sitecore Desktop and Launchpad.
    • Sitecore -> PowerShell Console
    • Sitecore -> PowerShell Toolbox
    • Sitecore -> Development Tools -> PowerShell ISE
    • Sitecore -> Reporting Rules -> PowerShell Reports 
PowerShell-with-Sitecore-2
PowerShell-with-Sitecore-3

Below are the major tools that come with the PowerShell Extension Module:

  1. PowerShell ISE: You can open it by Sitecore Launchpad or Sitecore -> Development Tools -> Sitecore ISE. It opens an Integrated Scripting Environment for you. You can perform the below listed operation:
    • Execute your PowerShell Commands.
    • Create, Save, Run and Debug your scripts and perform operations on Sitecore Items.
    More details you can find here. For example, I am executing the “Get-Help” command in ISE shown below:
    PowerShell-with-Sitecore-4 I will discuss with you in detail PowerShell Command and Scripts in my next blog.

  2. PowerShell Console: You can open it through Sitecore -> PowerShell Console.  It gives you the same PowerShell interface as Windows PowerShell. You can execute your solo command and see the output. More details you can find here. For example, here I am assigning values into variable “str” and displaying the value of the variable in the next command.
    PowerShell-with-Sitecore-5

  3. PowerShell Toolbox: You can access it via Sitecore -> PowerShell Toolbox. It provides you some predefined modules like Create Anti-Package, Index Viewer, Task Manager, etc. More details you can find here. 

    PowerShell-with-Sitecore-6

  4. PowerShell Reports: It's accessible by Sitecore -> Reporting Rules -> PowerShell Reports. It provides you out-of-the-box reports like Broken Links, Locked Items, Recently Logged in User, etc. More details you can find from here: 

    PowerShell-with-Sitecore-7

In my next blog, I will discuss with you "PowerShell Scripts and Commands".

Reference: 

Happy Sitecoreing ðŸ˜Š

Comments

Post a Comment

Popular posts from this blog

Sitecore Installation Error: Failed to Start Service 'Sitecore Marketing Automation Engine'

-
Image
 Error: [------- XConnectXP0_StartServices [2] : ManageService -----------------------] [XConnectXP0_StartServices [2]]:[Updating] sc903xconnect.dev.local-MarketingAutomationService Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing Automation Engine - sc903xconnect.dev.local-MarketingAutomationService (sc903xconnect.dev.local-MarketingAutomationService)' to start... Waiting for service 'Sitecore Marketing ...
Read more

Import CSV Data in Sitecore Using PowerShell: Part-3

-
Image
In my previous blog , we had discussed Sitecore PowerShell Command and Scripts. In this blog, I am discussing with you about How to Import CSV Data in Sitecore using PowerShell Scripts? To do the same you need to read the CSV file rows and create Sitecore Items into the Content Tree for each row then assign the column values of the row into the respective Item Field. There are two options: Write your own customized PowerShell Script and Import CSV Data. Use the inbuilt Data Importer tool that comes with Sitecore PowerShell Extension .  Option 1: Perform the Below steps to Import the CSV Data into Sitecore: First, you will need a CSV file. If you have Excel Sheet, then go to the File Menu and click on Save As option and change the format and save it into CSV format. Suppose you have a CSV file with the number of rows and each row has several columns with predefined values. Here I am taking the below CSV file for an...
Read more

Sitecore : The database principal owns a schema in the database, and cannot be dropped message

-
Image
While upgradation to Sitecore 10.2, I was to restore the database on the Managed Cloud Service Azure SQL Server. I have connected the Azure SQL server on my local SSMS and started to import the Database using the option Import Data-tier Application. While importing the database using the above option you need a BACPAC file instead of a .bak file. So I was to create a BACPAC file of the database from my local. Go to the database, right-click and select the Export Data-tier Application option under the Task menu. After clicking on the next, while creating the BACPAC file you may get the below error: Solution: Go to the Users in that Database. Your Database => Security => Users Find the user, right click and delete it. If you are unable to delete the user and encountered a new error as below: It means the user you are going to delete owns a schema in the database and owners. First, you need to search which schemas own...
Read more