michaellwest

Import-Function -Name Invoke-SqlCommand

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$query = @"
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_ActivationLock]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_FieldIds]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_Languages]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobManifest]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobMetadata]

michaellwest

function Get-ItemUrl {
    param(
        [item]$Item,
        [Sitecore.Sites.SiteContext]$SiteContext
    )
    
    $result = New-UsingBlock(New-Object Sitecore.Sites.SiteContextSwitcher $siteContext) {
        New-UsingBlock(New-Object Sitecore.Data.DatabaseSwitcher $item.Database) {
            [Sitecore.Links.LinkManager]::GetItemUrl($item)
        }

michaellwest

# https://exiftool.org/TagNames/EXIF.html
# https://stackoverflow.com/questions/27835064/get-image-orientation-and-rotate-as-per-orientation
# http://fredericiana.com/2013/05/23/imagetwist-exif-rotation-addon/
# https://www.cyotek.com/blog/handling-the-orientation-exif-tag-in-images-using-csharp
enum ExifOrientation {
    RotateNoneFlipNone = 1
    Rotate90FlipX = 5
    Rotate90FlipNone = 6
}
#[System.Drawing.RotateFlipType]::Rotate90FlipNone

michaellwest

 docker image ls --format "{{json .Repository}},{{json .Tag}},{{json .ID}}" | 
  ConvertFrom-Csv -Header "Repository","Tag","Id" | 
  Where-Object { $_.Tag -ne "<none>" -and $_.Repository.Contains("/") } | 
  ForEach-Object { docker pull "$($_.Repository):$($_.Tag)"}

michaellwest

$connection = [Hangfire.JobStorage]::Current.GetConnection()
$recurringJobs = [Hangfire.Storage.StorageConnectionExtensions]::GetRecurringJobs($connection)

$props = @{
    Title = "Hangfire Recurring Jobs"
    InfoTitle = "Recurring Jobs Report"
    InfoDescription = "This report provides details on the currently scheduled recurring jobs."
    PageSize = 25
    Property = @(
        "Id",

michaellwest

<?xml version="1.0" encoding="UTF-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
    <log4net>
      <!-- Add a StringMatchFilter into the LogFileAppender -->
      <appender name="LogFileAppender" type="log4net.Appender.RollingFileAppender, Sitecore.Logging">
        <filter type="log4net.Filter.StringMatchFilter">
          <stringToMatch value="Results endpoint exception" />
          <acceptOnMatch value="false" />
        </filter>

michaellwest

michaellwest

<#
    .SYNOPSIS
        Data Import Wizard provides a way to generate or update content from an external file.
        
    .DESCRIPTION
        The import file uses the properties "Name" and "Id" to help match existing items.
        
    .NOTES
        Requires Sitecore PowerShell Extensions 4.6 or newer.
        

michaellwest

$sql = @"
SELECT DISTINCT i.* FROM [dbo].[Items] i
INNER JOIN [dbo].[VersionedFields] v
    ON i.ID = v.ItemId
WHERE v.[Language] = ''
--SELECT COUNT(*) AS COUNT FROM [VersionedFields] WHERE [Language] = ''

--DELETE FROM [VersionedFields] WHERE [Language] = ''
"@

michaellwest

$exifOrientationId = 0x112

if(!$items) {
    $items = Get-ChildItem -Path "master:" -ID "{5D50B0FD-AB2B-4872-88E5-463D6E2B31F2}" -Recurse | Where-Object { $_.TemplateId -eq "{DAF085E8-602E-43A6-8299-038FF171349F}" }
}
$records = [System.Collections.ArrayList]@()
$processedCounter = 0
$totalCounter = $items.Count
foreach($item in $items) {
    $processedCounter++