michaellwest

$selectedForm = Get-Item -Path "master:" -ID ([Sitecore.ExperienceForms.Client.Constants.GeneralConstants]::FormsFolderId)

$props = @{
    Parameters = @(
        @{Name="selectedForm"; Value=$null; Title="Choose a form to filter out the results"; Tooltip=""; Editor="treelist";  Source="DataSource=$($selectedForm.ItemPath)&DatabaseName=master&IncludeTemplatesForDisplay=Folder,Form&IncludeTemplatesForSelection=Form"; },
        @{ Name = "startDate"; Value=[System.DateTime]::Now.AddDays(-30); Title="Start Date"; Tooltip="Earliest submitted entries to return"; Editor="date"; Columns=6; },
        @{ Name = "endDate"; Value=[System.DateTime]::Now; Title="End Date"; Tooltip="Latest submitted entries to return"; Editor="date"; Columns=6; }

    )
    Title = "Forms Report"

michaellwest

# First make your items inherit from /sitecore/templates/System/Geospatial/Coordinate
# Leave the existing IPoi there until after Go Live otherwise the data will be lost (or you have to run the import again)
# TODO : Update the import script to use the new field

# Change to the root ID for items which use the IPoi template
# Careers
#$rootId = "{B8208D4B-C25E-4381-A183-4177E47A9310}"
# POIs
$rootId = "{60365D59-F2F2-4C49-91DA-9C7B046178CF}"

michaellwest

$device = Get-LayoutDevice -Default
$sites = [Sitecore.Configuration.Factory]::GetSiteInfoList()
foreach($site in $sites) {
    $isTrackingEnabled = [Sitecore.MainUtil]::GetBool($site.Properties["enableTracking"], $true)
    if($isTrackingEnabled -or [string]::IsNullOrEmpty($site.TargetHostName)) { continue }
    $homeItem = Get-Item -Path "$($site.RootPath)/$($site.StartItem)".Replace("/sitecore", "master:")
    Write-Host "Checking $($homeItem.ItemPath)"
    foreach($rendering in $homeItem.Visualization.GetRenderings($device, $false)) {
        if($rendering.Settings.Rules.Count -le 0) { continue }
        $rendering

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

Import-Function -Name Invoke-SqlCommand

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

$query = @"
SELECT 
    a.[ID], 
    a.[Name], 
    a.[ParentID]
FROM [dbo].[Items] a

michaellwest

class BaseItem {
    [Sitecore.Data.Items.Item]$Item    
}

class LinkItem : BaseItem {
    [Sitecore.Data.Fields.LinkField]$LinkField
}

class TextItem : BaseItem {
    [Sitecore.Data.Fields.HtmlField]$TextField

michaellwest

<#
    .SYNOPSIS
        There is an issue with the authentication ticket cleanup for certain versions of Sitecore. Run this script as a scheduled task.
        
    .LINK
        https://kb.sitecore.net/articles/615926

$ticketIds = [Sitecore.Web.Authentication.TicketManager]::GetTicketIDs() | 
    ForEach-Object { $_.Replace("_", "") }

michaellwest

Import-Function -Name Invoke-SqlCommand
    
$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$text = '%' + 'Ã' + '%'
$query = @"
select [ItemID], [FieldID], LEN([Value]) AS [FieldLength] from [SharedFields] WITH (NOLOCK) where [Value] like @0
"@
$shared = Invoke-SqlCommand -Connection $connection -Query $query -Parameters @{"@0"=$text}
$query = @"

michaellwest

$linkItems = Get-ChildItem -Path "master:" -ID "{66FD3C09-517C-4691-82AF-E300AC6BA329}" -Recurse -Depth 2 |
    Where-Object { $_.TemplateId -eq "{41BAA575-6B15-4356-8F25-9CEE8F9D6D95}" }
foreach($linkItem in $linkItems) {
    try {
        [Sitecore.Xml.XmlUtil]::GetXmlNode($linkItem.NavigationLink) > $null
    } catch {
        $linkItem
    }
}

michaellwest

<#
  .SYNPOSIS
    Convert a PrivateKey from the certificate store into a PKCS8 formatted file.
    
  .LINK
    Found C# version here https://gist.github.com/chenrui1988/6b104a010172786dbcbc0aafc466d291/
    
  .NOTES
    Michael West
#>