Skip to content

Instantly share code, notes, and snippets.

@keyan1603
keyan1603 / GetSXASiteCacheSettings
Last active April 30, 2024 07:09
Get Sitecore SXA Site Cache Settings
Import-Function Get-AllSxaSite
$sites = New-Object System.Collections.ArrayList
class ItemDetail {
[string]$ID
[string]$Name
[string]$Path
[bool]$Cacheable
[bool]$ClearOnIndexUpdate
Get-ChildItem Cert:\LocalMachine\My\
Get-ChildItem Cert:\LocalMachine\My\ | Select-Object NotAfter, Subject
@keyan1603
keyan1603 / GetSiteSettings.cs
Created September 20, 2023 18:43
Sitecore SXA – To get Site Settings for a Site
public static T GetValueFromSiteSettings<T>(IMvcContext mvcSiteContext, string TenantSiteSettingsTemplateId)
{
var query = "/sitecore/content//*[@@ID='" + mvcSiteContext.GetRootItem<Item>().ID + "']/*[@@templateId='" + TenantSiteSettingsTemplateId + "']";
var settings = mvcSiteContext.SitecoreService.Database.SelectSingleItem(query);
if (settings == null)
{
return null;
}
return mvcSiteContext.SitecoreService.GetItem<T>(settings);
}
@keyan1603
keyan1603 / Coveo.SearchProvider.Custom.config
Created September 20, 2023 18:38
To add a new Coveo index in Sitecore (tested on Sitecore 9.2)
<index id="Coveo_pub_index" type="Coveo.SearchProvider.ProviderIndex, Coveo.SearchProvider" patch:before = "*[3]">
<param desc="p_Name">$(id)</param>
<configuration ref="coveo/defaultIndexConfiguration" />
<locations hint="list:AddCrawler">
<crawler name="ContentCrawler" type="Sitecore.ContentSearch.SitecoreItemCrawler, Sitecore.ContentSearch">
<database>pub</database>
<root>/sitecore/content</root>
<stopOnError>true</stopOnError>
</crawler>
<crawler name="MediaLibraryCrawler" type="Sitecore.ContentSearch.SitecoreItemCrawler, Sitecore.ContentSearch">
@keyan1603
keyan1603 / SitecoreHelixLoggingFramework.config
Created September 20, 2023 18:37
Sitecore Helix – Feature based logging framework - Config update
<?xml version="1.0"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/" xmlns:env="http://www.sitecore.net/xmlconfig/env/">
<sitecore>
<log4net>
<appender name="MySite.Feature.Products" type="log4net.Appender.RollingFileAppender, Sitecore.Logging">
<file value="$(dataFolder)/logs/MySite.Feature.Products.log.{date}.txt" />
<appendToFile value="true" />
<rollingStyle value="Size" />
<maximumFileSize value="10MB" />
<maxSizeRollBackups value="-1" />
@keyan1603
keyan1603 / SitecoreHelixLogging.cs
Created September 20, 2023 18:37
Sitecore Helix – Feature based logging framework
using System;
namespace MySite.Foundation.Common
{
public interface ILoggerService
{
#region Debug
void Debug(string message);
void Debug(string message, Exception ex);
#endregion
@keyan1603
keyan1603 / ResetSitecoreAdminPassword.sql
Created September 20, 2023 18:35
Reset Sitecore Admin account password without logging into Sitecore
UPDATE
[aspnet_Membership]
SET
[Password]='qOvF8m8F2IcWMvfOBjJYHmfLABc=',
[PasswordSalt]='OM5gu45RQuJ76itRvkSPFw==',
[IsApproved] = '1',
[IsLockedOut] = '0'
WHERE
UserId IN (
SELECT UserId FROM dbo.aspnet_Users WHERE UserName = 'sitecore\Admin'
@keyan1603
keyan1603 / SitecoreAllowDuplicateName.config
Created September 20, 2023 18:34
Allow duplicate Item Names in Sitecore content tree at the same folder level
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/">
<sitecore>
<settings>
<setting name="AllowDuplicateItemNamesOnSameLevel" value="true" />
</settings>
</sitecore>
</configuration>
@keyan1603
keyan1603 / UpdateFields.ps1
Created September 20, 2023 18:33
Update fields in Sitecore for all items based on a specific Template in all languages using Powershell script – with Progress bar
#Get all Product from the Master index for all languages.
#You can change this to get data from specific language codes
#like 'en', 'fr', etc.
$searchCriteria = @(
@{ Filter = "Equals"; Field = "_language"; Value = "*"; }
@{ Filter = "Equals"; Field = "_templatename"; Value = "Product"; }
)
#This script executes against Sitecore master index
$searchProps = @{
@keyan1603
keyan1603 / blockiframecookiesexample.html
Created September 20, 2023 18:31
Block iFrame cookies
<iframe sandbox="allow-scripts" src="..."></iframe>