Surendra Sharma

Surendra Sharma

Search This Blog

Showing posts with label sitecore 9. Show all posts
Showing posts with label sitecore 9. Show all posts

Friday, September 6, 2019

How to install Sitecore 9.0 with SIF 2.1.0

As you know to install Sitecore 9.0 , you need SIF 1.2.1. But with below modifications you can install Sitecore 9.0 with SIF 2.1.0 as well. For this

  • Modify xconnect-createcert.json -> Find the CreateRootCert task -> Change the StoreLocation from CurrentUser to LocalMachine
  • Modify xconnect-solr.json and sitecore-solr.json -> Find the CreateCores task in each file -> Change the "Name" attribute in Params > Action to lowercase "name".

So now with single SIF version 2.1.0, you can install 9.0 and 9.2 instance.

Wednesday, June 12, 2019

Search in Sitecore JSS

Happy to share that SUGCON India 2019 videos are published on Youtube. I conducted session on "Search In Sitecore JSS". I am sharing here recorded session on the same.

Friday, January 25, 2019

Sitecore error - You must remove all users with password before setting the containment property to NONE

I was installing Sitecore 9 and received some SOLR CORE errors so I again re-execute the script and this time received new error “You must remove all users with password before setting the containment property to NONE”.
I google it and found out that it’s because of users are exist in Sitecore databases.

So I created this handy SQL script where you have to specify database prefix only and it will remove particular users from all necessary databases.

--Specify your Sitecore instance prefix here
DECLARE @prefix NVARCHAR(50) = 'sc9u2com';
SET @query = 'Use [' + @prefix + '_MarketingAutomation]; DROP USER [marketingautomationuser];'
SET @query = @query + 'Use [' + @prefix + '_Messaging];DROP USER [messaginguser];'
SET @query = @query + 'Use [' + @prefix + '_Processing.Pools];DROP USER [poolsuser];'
SET @query = @query + 'Use [' + @prefix + '_ReferenceData];DROP USER [referencedatauser];'
Select @query

I hope this script will help developers who are facing same issues.

Friday, November 16, 2018

Sitecore PowerShell script: Copy value of one field to another

I like Sitecore but I started to love Sitecore PowerShell. The way it’s interacting with Sitecore and allows developers to write command with C# code is amazing.

I have migrated SharePoint records in Sitecore in my earlier post.

This time I am bulk updating English and Arabic news items where news image field value is copied to another news fields “News List Image”.

$newsTemplateId = "{B69277AD-E917-4B9F-9136-A12E0A3E462F}"
$newsParentPath = "master:/sitecore/content/Habitat/Home/News"
$counter = 1

$allNewsItems = Get-ChildItem -Path $newsParentPath -Recurse
$filteredNewsItems = $allNewsItems | Where-Object { $_.TemplateId -eq $newsTemplateId }

foreach($newsItem in $filteredNewsItems) {
        if($newsItem.NewsListImage -eq "")
            #Update English content
            $newsItem.NewsListImage = $newsItem.NewsImage
            #Get Arebic Content    
            $newsArebicItem = Get-Item master: -ID $newsItem.ID -Language "ar-QA"
            #Check if Arebic content is exist
            if($newsArebicItem -ne $null)
                #Update Arabic content  
                $newsArebicItem.NewsListImage = $newsArebicItem.NewsImage
            $counter = $counter + 1
            Write-Host "Image exist for item id " $newsItem.ID " and name " $newsItem.Name

Feel free to use this script for bulk updating field values.