Lenovo.Client.RepositoryManager

1.0.3

Public/Import-LnvRMModel.ps1

                                function Import-LnvRMModel {

    <#

    .SYNOPSIS

        Bulk-imports Lenovo machine types into the configured model list from a CSV file.

    .DESCRIPTION

        Reads a CSV of models, validates every row before changing anything, then adds all

        valid rows to the configuration in a single write. 

        The CSV must have MachineType, FriendlyName and OS columns. OS values are normalised, so 'Win11',

        'Windows11' and '11' are all treated as 'Windows 11'.

        Every row is reported back with a Status of Added, Skipped or Invalid, so a bad row

        never silently disappears. Rows that already exist in the configuration are Skipped;

        rows that fail validation are Invalid and are not written.

    .PARAMETER Path

        Path to the CSV file to import.

    .PARAMETER Delimiter

        Delimiter used by the CSV file. Defaults to ','.

    .PARAMETER ValidateMachineType

        Verify each machine type against Lenovo's online catalog before adding it. A machine

        type with no catalog for the requested OS is reported as Invalid rather than added,

        which catches typos that would otherwise produce empty update searches. Requires

        internet access and makes one catalog request per unique model.

    .PARAMETER MaxConcurrent

        Maximum parallel catalog requests when -ValidateMachineType is used. Defaults to 8.

    .EXAMPLE

        Import-LnvRMModel -Path .\models.csv

        Imports every model in models.csv.

    .EXAMPLE

        Import-LnvRMModel -Path .\models.csv -WhatIf

        Validates the file and reports what would be added without changing the config.

    .EXAMPLE

        Import-LnvRMModel -Path .\fleet.csv -ValidateMachineType |

            Where-Object Status -ne 'Added'

        Imports the fleet and lists only the rows that were not added.

    .NOTES

        Expected CSV format:

            MachineType,FriendlyName,OS

            21NT,ThinkPad X1 Carbon Gen 11,Windows 11

            20FU,ThinkPad T470,Windows 10

        Accepted header aliases:

            MachineType  - 'Machine Type', 'MTM', 'MT', 'Type'

            FriendlyName - 'Friendly Name', 'Name', 'Model', 'Description'

            OS           - 'OperatingSystem', 'Operating System'

    #>

    [CmdletBinding(SupportsShouldProcess)]

    [OutputType([PSCustomObject])]

    param(

        [Parameter(Mandatory, Position = 0)]

        [ValidateNotNullOrEmpty()]

        [string]$Path,

        [Parameter()]

        [ValidateNotNullOrEmpty()]

        [string]$Delimiter = ',',

        [Parameter()]

        [switch]$ValidateMachineType,

        [Parameter()]

        [ValidateRange(1, 32)]

        [int]$MaxConcurrent = 8

    )

    # Builds one row of the import report. A scriptblock rather than a nested function so

    # it needs no approved verb.

    $newResult = {

        param($Line, $MachineType, $FriendlyName, $OS, $Status, $Reason)

        [PSCustomObject]@{

            Line         = $Line

            MachineType  = $MachineType

            FriendlyName = $FriendlyName

            OS           = $OS

            Status       = $Status

            Reason       = $Reason

        }

    }

    # --- Locate and read the file -------------------------------------------

    $resolved = Resolve-Path -LiteralPath $Path -ErrorAction SilentlyContinue

    if (-not $resolved) {

        Write-Error "CSV file not found: '$Path'"

        return

    }

    $csvPath = $resolved.ProviderPath

    if (Test-Path -LiteralPath $csvPath -PathType Container) {

        Write-Error "'$csvPath' is a directory. Specify the path to a CSV file."

        return

    }

    try {

        $rows = @(Import-Csv -LiteralPath $csvPath -Delimiter $Delimiter -ErrorAction Stop)

    }

    catch {

        Write-Error "Failed to read CSV '$csvPath': $_"

        return

    }

    if ($rows.Count -eq 0) {

        Write-Warning "'$csvPath' contains no data rows. Nothing to import."

        return

    }

    # --- Resolve columns ----------------------------------------------------

    $columnAliases = [ordered]@{

        MachineType  = @('MachineType', 'Machine Type', 'MTM', 'MT', 'Type')

        FriendlyName = @('FriendlyName', 'Friendly Name', 'Name', 'Model', 'Description')

        OS           = @('OS', 'OperatingSystem', 'Operating System')

    }

    $headers = @($rows[0].PSObject.Properties.Name)

    $columns = @{}

    $missing = @()

    foreach ($field in $columnAliases.Keys) {

        # -contains is case-insensitive for strings, so header casing does not matter.

        $match = @($headers | Where-Object { $columnAliases[$field] -contains $_.Trim() })[0]

        if ($match) { $columns[$field] = $match } else { $missing += $field }

    }

    if ($missing.Count -gt 0) {

        Write-Error ("CSV is missing required column(s): {0}. Columns found: {1}." -f `

            ($missing -join ', '), ($headers -join ', '))

        return

    }

    # --- Validate every row before touching the config ----------------------

    $config = Get-LnvRMConfig

    $existingKeys = @{}

    foreach ($m in @($config.Models)) {

        if ($m -and $m.MachineType) {

            $existingKeys["$("$($m.MachineType)".ToUpper())|$($m.OS)"] = $true

        }

    }

    $results    = [System.Collections.Generic.List[object]]::new()

    $candidates = [System.Collections.Generic.List[object]]::new()

    $seenInFile = @{}

    $lineNumber = 1  # line 1 is the header

    foreach ($row in $rows) {

        $lineNumber++

        $mt   = "$($row.($columns.MachineType))".Trim()

        $name = "$($row.($columns.FriendlyName))".Trim()

        $os   = "$($row.($columns.OS))".Trim()

        if ($mt -notmatch '^[A-Za-z0-9]{4}$') {

            $results.Add((& $newResult $lineNumber $mt $name $os 'Invalid' `

                'MachineType must be exactly 4 alphanumeric characters.'))

            continue

        }

        $mt = $mt.ToUpper()

        # Accept the common shorthands for the two supported OS values.

        $osKey = ($os -replace '[\s\-_]', '').ToLower()

        $osNormalized = switch ($osKey) {

            'windows10' { 'Windows 10' }

            'win10'     { 'Windows 10' }

            '10'        { 'Windows 10' }

            'windows11' { 'Windows 11' }

            'win11'     { 'Windows 11' }

            '11'        { 'Windows 11' }

            default     { $null }

        }

        if (-not $osNormalized) {

            $results.Add((& $newResult $lineNumber $mt $name $os 'Invalid' `

                "Unrecognised OS '$os'. Expected 'Windows 10' or 'Windows 11'."))

            continue

        }

        if ([string]::IsNullOrWhiteSpace($name)) {

            $results.Add((& $newResult $lineNumber $mt $name $osNormalized 'Invalid' `

                'FriendlyName cannot be blank or whitespace.'))

            continue

        }

        # Same character restriction Add-LnvRMModel enforces.

        if ($name -match "[^A-Za-z0-9 '\-_.(),]") {

            $results.Add((& $newResult $lineNumber $mt $name $osNormalized 'Invalid' `

                "FriendlyName '$name' contains special characters."))

            continue

        }

        $key = "$mt|$osNormalized"

        if ($seenInFile.ContainsKey($key)) {

            $results.Add((& $newResult $lineNumber $mt $name $osNormalized 'Skipped' `

                "Duplicate of line $($seenInFile[$key]) in this file."))

            continue

        }

        $seenInFile[$key] = $lineNumber

        if ($existingKeys.ContainsKey($key)) {

            $results.Add((& $newResult $lineNumber $mt $name $osNormalized 'Skipped' `

                'Already configured.'))

            continue

        }

        # Placeholder result; Status is finalised once the config write succeeds.

        $result = & $newResult $lineNumber $mt $name $osNormalized 'Invalid' 'Not processed.'

        $results.Add($result)

        $candidates.Add([PSCustomObject]@{

            Key    = $key

            Result = $result

            Model  = [PSCustomObject]@{

                MachineType  = $mt

                FriendlyName = $name

                OS           = $osNormalized

            }

        })

    }

    # --- Optional catalog validation ----------------------------------------

    if ($ValidateMachineType -and $candidates.Count -gt 0) {

        Write-Verbose "Validating $($candidates.Count) machine type(s) against Lenovo's catalog..."

        $probeJobs = @($candidates | ForEach-Object {

            $osTag = switch ($_.Model.OS) {

                'Windows 10' { 'Win10' }

                'Windows 11' { 'Win11' }

            }

            [PSCustomObject]@{

                URL = "https://download.lenovo.com/catalog/$($_.Model.MachineType)_$osTag.xml"

                Key = $_.Key

            }

        })

        $unreachable = @{}

        foreach ($probe in @(Invoke-LnvRMParallelWeb -Jobs $probeJobs -MaxConcurrent $MaxConcurrent)) {

            if ($probe.Error) { $unreachable[$probe.Job.Key] = $probe.Error }

        }

        if ($unreachable.Count -gt 0) {

            $verified = [System.Collections.Generic.List[object]]::new()

            foreach ($candidate in $candidates) {

                if ($unreachable.ContainsKey($candidate.Key)) {

                    $candidate.Result.Status = 'Invalid'

                    $candidate.Result.Reason = "No Lenovo catalog for this machine type and OS: $($unreachable[$candidate.Key])"

                }

                else {

                    $verified.Add($candidate)

                }

            }

            $candidates = $verified

        }

    }

    # --- Apply ---------------------------------------------------------------

    $approved = [System.Collections.Generic.List[object]]::new()

    foreach ($candidate in $candidates) {

        $target = "$($candidate.Model.FriendlyName) ($($candidate.Model.MachineType)) - $($candidate.Model.OS)"

        if ($PSCmdlet.ShouldProcess($target, 'Add model')) {

            $approved.Add($candidate)

        }

        else {

            # ShouldProcess also returns false under -WhatIf, where nothing was declined.

            $candidate.Result.Status = 'Skipped'

            $candidate.Result.Reason = if ($WhatIfPreference) { 'WhatIf - no changes made.' }

                                       else { 'Not confirmed.' }

        }

    }

    if ($approved.Count -gt 0) {

        # @(...) forces array context so a single-item Models list isn't unwrapped

        # to a scalar before the concat.

        $config.Models = @($config.Models) + @($approved | ForEach-Object { $_.Model })

        if (Set-LnvRMConfig -Config $config) {

            foreach ($candidate in $approved) {

                $candidate.Result.Status = 'Added'

                $candidate.Result.Reason = $null

            }

            Write-Verbose "Added $($approved.Count) model(s) from '$csvPath'."

        }

        else {

            foreach ($candidate in $approved) {

                $candidate.Result.Status = 'Invalid'

                $candidate.Result.Reason = 'Config write failed.'

            }

            Write-Error "Failed to save the configuration. No models were imported from '$csvPath'."

        }

    }

    $added   = @($results | Where-Object Status -eq 'Added').Count

    $skipped = @($results | Where-Object Status -eq 'Skipped').Count

    $invalid = @($results | Where-Object Status -eq 'Invalid').Count

    if ($invalid -gt 0) {

        Write-Warning "$invalid of $($results.Count) row(s) could not be imported. Inspect the Status and Reason on the returned objects."

    }

    Write-Verbose "Import summary for '$csvPath': $added added, $skipped skipped, $invalid invalid."

    return $results.ToArray()

}

# SIG # Begin signature block

# MIItugYJKoZIhvcNAQcCoIItqzCCLacCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUc0264SYSFgOlv1N2d6g3v7Zl

# 19uggibcMIIFjTCCBHWgAwIBAgIQDpsYjvnQLefv21DiCEAYWjANBgkqhkiG9w0B

# AQwFADBlMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYD

# VQQLExB3d3cuZGlnaWNlcnQuY29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVk

# IElEIFJvb3QgQ0EwHhcNMjIwODAxMDAwMDAwWhcNMzExMTA5MjM1OTU5WjBiMQsw

# CQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cu

# ZGlnaWNlcnQuY29tMSEwHwYDVQQDExhEaWdpQ2VydCBUcnVzdGVkIFJvb3QgRzQw

# ggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC/5pBzaN675F1KPDAiMGkz

# 7MKnJS7JIT3yithZwuEppz1Yq3aaza57G4QNxDAf8xukOBbrVsaXbR2rsnnyyhHS

# 5F/WBTxSD1Ifxp4VpX6+n6lXFllVcq9ok3DCsrp1mWpzMpTREEQQLt+C8weE5nQ7

# bXHiLQwb7iDVySAdYyktzuxeTsiT+CFhmzTrBcZe7FsavOvJz82sNEBfsXpm7nfI

# SKhmV1efVFiODCu3T6cw2Vbuyntd463JT17lNecxy9qTXtyOj4DatpGYQJB5w3jH

# trHEtWoYOAMQjdjUN6QuBX2I9YI+EJFwq1WCQTLX2wRzKm6RAXwhTNS8rhsDdV14

# Ztk6MUSaM0C/CNdaSaTC5qmgZ92kJ7yhTzm1EVgX9yRcRo9k98FpiHaYdj1ZXUJ2

# h4mXaXpI8OCiEhtmmnTK3kse5w5jrubU75KSOp493ADkRSWJtppEGSt+wJS00mFt

# 6zPZxd9LBADMfRyVw4/3IbKyEbe7f/LVjHAsQWCqsWMYRJUadmJ+9oCw++hkpjPR

# iQfhvbfmQ6QYuKZ3AeEPlAwhHbJUKSWJbOUOUlFHdL4mrLZBdd56rF+NP8m800ER

# ElvlEFDrMcXKchYiCd98THU/Y+whX8QgUWtvsauGi0/C1kVfnSD8oR7FwI+isX4K

# Jpn15GkvmB0t9dmpsh3lGwIDAQABo4IBOjCCATYwDwYDVR0TAQH/BAUwAwEB/zAd

# BgNVHQ4EFgQU7NfjgtJxXWRM3y5nP+e6mK4cD08wHwYDVR0jBBgwFoAUReuir/SS

# y4IxLVGLp6chnfNtyA8wDgYDVR0PAQH/BAQDAgGGMHkGCCsGAQUFBwEBBG0wazAk

# BggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsGAQUFBzAC

# hjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURS

# b290Q0EuY3J0MEUGA1UdHwQ+MDwwOqA4oDaGNGh0dHA6Ly9jcmwzLmRpZ2ljZXJ0

# LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcmwwEQYDVR0gBAowCDAGBgRV

# HSAAMA0GCSqGSIb3DQEBDAUAA4IBAQBwoL9DXFXnOF+go3QbPbYW1/e/Vwe9mqyh

# hyzshV6pGrsi+IcaaVQi7aSId229GhT0E0p6Ly23OO/0/4C5+KH38nLeJLxSA8hO

# 0Cre+i1Wz/n096wwepqLsl7Uz9FDRJtDIeuWcqFItJnLnU+nBgMTdydE1Od/6Fmo

# 8L8vC6bp8jQ87PcDx4eo0kxAGTVGamlUsLihVo7spNU96LHc/RzY9HdaXFSMb++h

# UD38dglohJ9vytsgjTVgHAIDyyCwrFigDkBjxZgiwbJZ9VVrzyerbHbObyMt9H5x

# aiNrIv8SuFQtJ37YOtnwtoeW/VvRXKwYw02fc7cBqZ9Xql4o4rmUMIIFkDCCA3ig

# AwIBAgIQBZsbV56OITLiOQe9p3d1XDANBgkqhkiG9w0BAQwFADBiMQswCQYDVQQG

# EwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNl

# cnQuY29tMSEwHwYDVQQDExhEaWdpQ2VydCBUcnVzdGVkIFJvb3QgRzQwHhcNMTMw

# ODAxMTIwMDAwWhcNMzgwMTE1MTIwMDAwWjBiMQswCQYDVQQGEwJVUzEVMBMGA1UE

# ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMSEwHwYD

# VQQDExhEaWdpQ2VydCBUcnVzdGVkIFJvb3QgRzQwggIiMA0GCSqGSIb3DQEBAQUA

# A4ICDwAwggIKAoICAQC/5pBzaN675F1KPDAiMGkz7MKnJS7JIT3yithZwuEppz1Y

# q3aaza57G4QNxDAf8xukOBbrVsaXbR2rsnnyyhHS5F/WBTxSD1Ifxp4VpX6+n6lX

# FllVcq9ok3DCsrp1mWpzMpTREEQQLt+C8weE5nQ7bXHiLQwb7iDVySAdYyktzuxe

# TsiT+CFhmzTrBcZe7FsavOvJz82sNEBfsXpm7nfISKhmV1efVFiODCu3T6cw2Vbu

# yntd463JT17lNecxy9qTXtyOj4DatpGYQJB5w3jHtrHEtWoYOAMQjdjUN6QuBX2I

# 9YI+EJFwq1WCQTLX2wRzKm6RAXwhTNS8rhsDdV14Ztk6MUSaM0C/CNdaSaTC5qmg

# Z92kJ7yhTzm1EVgX9yRcRo9k98FpiHaYdj1ZXUJ2h4mXaXpI8OCiEhtmmnTK3kse

# 5w5jrubU75KSOp493ADkRSWJtppEGSt+wJS00mFt6zPZxd9LBADMfRyVw4/3IbKy

# Ebe7f/LVjHAsQWCqsWMYRJUadmJ+9oCw++hkpjPRiQfhvbfmQ6QYuKZ3AeEPlAwh

# HbJUKSWJbOUOUlFHdL4mrLZBdd56rF+NP8m800ERElvlEFDrMcXKchYiCd98THU/

# Y+whX8QgUWtvsauGi0/C1kVfnSD8oR7FwI+isX4KJpn15GkvmB0t9dmpsh3lGwID

# AQABo0IwQDAPBgNVHRMBAf8EBTADAQH/MA4GA1UdDwEB/wQEAwIBhjAdBgNVHQ4E

# FgQU7NfjgtJxXWRM3y5nP+e6mK4cD08wDQYJKoZIhvcNAQEMBQADggIBALth2X2p

# bL4XxJEbw6GiAI3jZGgPVs93rnD5/ZpKmbnJeFwMDF/k5hQpVgs2SV1EY+CtnJYY

# ZhsjDT156W1r1lT40jzBQ0CuHVD1UvyQO7uYmWlrx8GnqGikJ9yd+SeuMIW59mdN

# Oj6PWTkiU0TryF0Dyu1Qen1iIQqAyHNm0aAFYF/opbSnr6j3bTWcfFqK1qI4mfN4

# i/RN0iAL3gTujJtHgXINwBQy7zBZLq7gcfJW5GqXb5JQbZaNaHqasjYUegbyJLkJ

# EVDXCLG4iXqEI2FCKeWjzaIgQdfRnGTZ6iahixTXTBmyUEFxPT9NcCOGDErcgdLM

# MpSEDQgJlxxPwO5rIHQw0uA5NBCFIRUBCOhVMt5xSdkoF1BN5r5N0XWs0Mr7QbhD

# parTwwVETyw2m+L64kW4I1NsBm9nVX9GtUw/bihaeSbSpKhil9Ie4u1Ki7wb/UdK

# Dd9nZn6yW0HQO+T0O/QEY+nvwlQAUaCKKsnOeMzV6ocEGLPOr0mIr/OSmbaz5mEP

# 0oUA51Aa5BuVnRmhuZyxm7EAHu/QD09CbMkKvO5D+jpxpchNJqU1/YldvIViHTLS

# oCtU7ZpXwdv6EM8Zt4tKG48BtieVU+i2iW1bvGjUI+iLUaJW+fCmgKDWHrO8Dw9T

# dSmq6hN35N6MgSGtBxBHEa2HPQfRdbzP82Z+MIIGsDCCBJigAwIBAgIQCK1AsmDS

# nEyfXs2pvZOu2TANBgkqhkiG9w0BAQwFADBiMQswCQYDVQQGEwJVUzEVMBMGA1UE

# ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMSEwHwYD

# VQQDExhEaWdpQ2VydCBUcnVzdGVkIFJvb3QgRzQwHhcNMjEwNDI5MDAwMDAwWhcN

# MzYwNDI4MjM1OTU5WjBpMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQs

# IEluYy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRydXN0ZWQgRzQgQ29kZSBTaWduaW5n

# IFJTQTQwOTYgU0hBMzg0IDIwMjEgQ0ExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8A

# MIICCgKCAgEA1bQvQtAorXi3XdU5WRuxiEL1M4zrPYGXcMW7xIUmMJ+kjmjYXPXr

# NCQH4UtP03hD9BfXHtr50tVnGlJPDqFX/IiZwZHMgQM+TXAkZLON4gh9NH1MgFcS

# a0OamfLFOx/y78tHWhOmTLMBICXzENOLsvsI8IrgnQnAZaf6mIBJNYc9URnokCF4

# RS6hnyzhGMIazMXuk0lwQjKP+8bqHPNlaJGiTUyCEUhSaN4QvRRXXegYE2XFf7JP

# hSxIpFaENdb5LpyqABXRN/4aBpTCfMjqGzLmysL0p6MDDnSlrzm2q2AS4+jWufcx

# 4dyt5Big2MEjR0ezoQ9uo6ttmAaDG7dqZy3SvUQakhCBj7A7CdfHmzJawv9qYFSL

# ScGT7eG0XOBv6yb5jNWy+TgQ5urOkfW+0/tvk2E0XLyTRSiDNipmKF+wc86LJiUG

# soPUXPYVGUztYuBeM/Lo6OwKp7ADK5GyNnm+960IHnWmZcy740hQ83eRGv7bUKJG

# yGFYmPV8AhY8gyitOYbs1LcNU9D4R+Z1MI3sMJN2FKZbS110YU0/EpF23r9Yy3IQ

# KUHw1cVtJnZoEUETWJrcJisB9IlNWdt4z4FKPkBHX8mBUHOFECMhWWCKZFTBzCEa

# 6DgZfGYczXg4RTCZT/9jT0y7qg0IU0F8WD1Hs/q27IwyCQLMbDwMVhECAwEAAaOC

# AVkwggFVMBIGA1UdEwEB/wQIMAYBAf8CAQAwHQYDVR0OBBYEFGg34Ou2O/hfEYb7

# /mF7CIhl9E5CMB8GA1UdIwQYMBaAFOzX44LScV1kTN8uZz/nupiuHA9PMA4GA1Ud

# DwEB/wQEAwIBhjATBgNVHSUEDDAKBggrBgEFBQcDAzB3BggrBgEFBQcBAQRrMGkw

# JAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBBBggrBgEFBQcw

# AoY1aHR0cDovL2NhY2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZFJv

# b3RHNC5jcnQwQwYDVR0fBDwwOjA4oDagNIYyaHR0cDovL2NybDMuZGlnaWNlcnQu

# Y29tL0RpZ2lDZXJ0VHJ1c3RlZFJvb3RHNC5jcmwwHAYDVR0gBBUwEzAHBgVngQwB

# AzAIBgZngQwBBAEwDQYJKoZIhvcNAQEMBQADggIBADojRD2NCHbuj7w6mdNW4AIa

# pfhINPMstuZ0ZveUcrEAyq9sMCcTEp6QRJ9L/Z6jfCbVN7w6XUhtldU/SfQnuxaB

# RVD9nL22heB2fjdxyyL3WqqQz/WTauPrINHVUHmImoqKwba9oUgYftzYgBoRGRjN

# YZmBVvbJ43bnxOQbX0P4PpT/djk9ntSZz0rdKOtfJqGVWEjVGv7XJz/9kNF2ht0c

# sGBc8w2o7uCJob054ThO2m67Np375SFTWsPK6Wrxoj7bQ7gzyE84FJKZ9d3OVG3Z

# XQIUH0AzfAPilbLCIXVzUstG2MQ0HKKlS43Nb3Y3LIU/Gs4m6Ri+kAewQ3+ViCCC

# cPDMyu/9KTVcH4k4Vfc3iosJocsL6TEa/y4ZXDlx4b6cpwoG1iZnt5LmTl/eeqxJ

# zy6kdJKt2zyknIYf48FWGysj/4+16oh7cGvmoLr9Oj9FpsToFpFSi0HASIRLlk2r

# REDjjfAVKM7t8RhWByovEMQMCGQ8M4+uKIw8y4+ICw2/O/TOHnuO77Xry7fwdxPm

# 5yg/rBKupS8ibEH5glwVZsxsDsrFhsP2JjMMB0ug0wcCampAMEhLNKhRILutG4UI

# 4lkNbcoFUCvqShyepf2gpx8GdOfy1lKQ/a+FSCH5Vzu0nAPthkX0tGFuv2jiJmCG

# 6sivqf6UHedjGzqGVnhOMIIGtDCCBJygAwIBAgIQDcesVwX/IZkuQEMiDDpJhjAN

# BgkqhkiG9w0BAQsFADBiMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQg

# SW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMSEwHwYDVQQDExhEaWdpQ2Vy

# dCBUcnVzdGVkIFJvb3QgRzQwHhcNMjUwNTA3MDAwMDAwWhcNMzgwMTE0MjM1OTU5

# WjBpMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xQTA/BgNV

# BAMTOERpZ2lDZXJ0IFRydXN0ZWQgRzQgVGltZVN0YW1waW5nIFJTQTQwOTYgU0hB

# MjU2IDIwMjUgQ0ExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAtHgx

# 0wqYQXK+PEbAHKx126NGaHS0URedTa2NDZS1mZaDLFTtQ2oRjzUXMmxCqvkbsDpz

# 4aH+qbxeLho8I6jY3xL1IusLopuW2qftJYJaDNs1+JH7Z+QdSKWM06qchUP+AbdJ

# gMQB3h2DZ0Mal5kYp77jYMVQXSZH++0trj6Ao+xh/AS7sQRuQL37QXbDhAktVJMQ

# bzIBHYJBYgzWIjk8eDrYhXDEpKk7RdoX0M980EpLtlrNyHw0Xm+nt5pnYJU3Gmq6

# bNMI1I7Gb5IBZK4ivbVCiZv7PNBYqHEpNVWC2ZQ8BbfnFRQVESYOszFI2Wv82wnJ

# RfN20VRS3hpLgIR4hjzL0hpoYGk81coWJ+KdPvMvaB0WkE/2qHxJ0ucS638ZxqU1

# 4lDnki7CcoKCz6eum5A19WZQHkqUJfdkDjHkccpL6uoG8pbF0LJAQQZxst7VvwDD

# jAmSFTUms+wV/FbWBqi7fTJnjq3hj0XbQcd8hjj/q8d6ylgxCZSKi17yVp2NL+cn

# T6Toy+rN+nM8M7LnLqCrO2JP3oW//1sfuZDKiDEb1AQ8es9Xr/u6bDTnYCTKIsDq

# 1BtmXUqEG1NqzJKS4kOmxkYp2WyODi7vQTCBZtVFJfVZ3j7OgWmnhFr4yUozZtqg

# PrHRVHhGNKlYzyjlroPxul+bgIspzOwbtmsgY1MCAwEAAaOCAV0wggFZMBIGA1Ud

# EwEB/wQIMAYBAf8CAQAwHQYDVR0OBBYEFO9vU0rp5AZ8esrikFb2L9RJ7MtOMB8G

# A1UdIwQYMBaAFOzX44LScV1kTN8uZz/nupiuHA9PMA4GA1UdDwEB/wQEAwIBhjAT

# BgNVHSUEDDAKBggrBgEFBQcDCDB3BggrBgEFBQcBAQRrMGkwJAYIKwYBBQUHMAGG

# GGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBBBggrBgEFBQcwAoY1aHR0cDovL2Nh

# Y2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZFJvb3RHNC5jcnQwQwYD

# VR0fBDwwOjA4oDagNIYyaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0

# VHJ1c3RlZFJvb3RHNC5jcmwwIAYDVR0gBBkwFzAIBgZngQwBBAIwCwYJYIZIAYb9

# bAcBMA0GCSqGSIb3DQEBCwUAA4ICAQAXzvsWgBz+Bz0RdnEwvb4LyLU0pn/N0IfF

# iBowf0/Dm1wGc/Do7oVMY2mhXZXjDNJQa8j00DNqhCT3t+s8G0iP5kvN2n7Jd2E4

# /iEIUBO41P5F448rSYJ59Ib61eoalhnd6ywFLerycvZTAz40y8S4F3/a+Z1jEMK/

# DMm/axFSgoR8n6c3nuZB9BfBwAQYK9FHaoq2e26MHvVY9gCDA/JYsq7pGdogP8HR

# trYfctSLANEBfHU16r3J05qX3kId+ZOczgj5kjatVB+NdADVZKON/gnZruMvNYY2

# o1f4MXRJDMdTSlOLh0HCn2cQLwQCqjFbqrXuvTPSegOOzr4EWj7PtspIHBldNE2K

# 9i697cvaiIo2p61Ed2p8xMJb82Yosn0z4y25xUbI7GIN/TpVfHIqQ6Ku/qjTY6hc

# 3hsXMrS+U0yy+GWqAXam4ToWd2UQ1KYT70kZjE4YtL8Pbzg0c1ugMZyZZd/BdHLi

# Ru7hAWE6bTEm4XYRkA6Tl4KSFLFk43esaUeqGkH/wyW4N7OigizwJWeukcyIPbAv

# jSabnf7+Pu0VrFgoiovRDiyx3zEdmcif/sYQsfch28bZeUz2rtY/9TCA6TD8dC3J

# E3rYkrhLULy7Dc90G6e8BlqmyIjlgp2+VqsS9/wQD7yFylIz0scmbKvFoW2jNrbM

# 1pD2T7m3XDCCBu0wggTVoAMCAQICEAhP3DNPfkVO28MPj/mSGDUwDQYJKoZIhvcN

# AQELBQAwaTELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMUEw

# PwYDVQQDEzhEaWdpQ2VydCBUcnVzdGVkIEc0IFRpbWVTdGFtcGluZyBSU0E0MDk2

# IFNIQTI1NiAyMDI1IENBMTAeFw0yNjA4MDUwMDAwMDBaFw0zNzExMDQyMzU5NTla

# MGMxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjE7MDkGA1UE

# AxMyRGlnaUNlcnQgU0hBMjU2IFJTQTQwOTYgVGltZXN0YW1wIFJlc3BvbmRlciAy

# MDI2IDEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC2e6byyf7NSvjU

# m0xls/04xjD4fAkOkbnGQi7+Wpx81iYxfzViaxSIctuH3KSl5YEYpMuFgGsA31N2

# D9ATMbfZdw5uaAhuWevQKhDdZIB4NnqcfpfpWQXJiQnDdAElETC+bhSEvNLGbA8D

# twUpFMQ4yyYQSPqomT92osQAv6hBi47ATZS6JfVWe6XxhF4jJZ3iSAuf2Cros1cz

# RSmWRHqMv9AfGZvp8ygYElhudpQjtcPpwoOl6QrZJUyV3iINvN4cO05prGV0fkjG

# 426xDr2d3z9lcSIHkdvGPdGUrXdxfVbgOUVcp2/8ISEzwKPW++Wa+E2ujI91EZtu

# kGWDJ/xZ27k3oHKEXBRGfRTqjOU+jE3ba/5++JSE/7oNHnjs5mekExYN96LV/mxU

# bCKJb8pBNY4r3uD7hEmk/M81XhVgwDA7aMzYC3LZBg9WY5BMmbSay5ecmtJuXaB/

# 0nKWmQmVZeqTVDgsmzHP5MQuhAJkiWNuC9MmCg9TZHXbJ2/yLVSov9p16UDTLtT0

# +aa1vN71fHeu1qMLlLNB3WOB/ADCxr3S/1hxI92Z6jKgEED/btwIvbfuXkNNhg8M

# tDg43c4tMZae9FvqMOt/9PvmAxF9TNIsIFB8G6yb36ZJZGUL8N/pL971DyLXcK6H

# M5PYnH5X+eVtczhCgHCVQCF6XDAlPQIDAQABo4IBlTCCAZEwDAYDVR0TAQH/BAIw

# ADAdBgNVHQ4EFgQUFMljijAu1Er7bpTz5uNAfvXszeIwHwYDVR0jBBgwFoAU729T

# SunkBnx6yuKQVvYv1Ensy04wDgYDVR0PAQH/BAQDAgeAMBYGA1UdJQEB/wQMMAoG

# CCsGAQUFBwMIMIGVBggrBgEFBQcBAQSBiDCBhTAkBggrBgEFBQcwAYYYaHR0cDov

# L29jc3AuZGlnaWNlcnQuY29tMF0GCCsGAQUFBzAChlFodHRwOi8vY2FjZXJ0cy5k

# aWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkRzRUaW1lU3RhbXBpbmdSU0E0MDk2

# U0hBMjU2MjAyNUNBMS5jcnQwXwYDVR0fBFgwVjBUoFKgUIZOaHR0cDovL2NybDMu

# ZGlnaWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZEc0VGltZVN0YW1waW5nUlNBNDA5

# NlNIQTI1NjIwMjVDQTEuY3JsMCAGA1UdIAQZMBcwCAYGZ4EMAQQCMAsGCWCGSAGG

# /WwHATANBgkqhkiG9w0BAQsFAAOCAgEAjcU6YR6dUgrfmawJgH59KECxa9Ji8sEi

# 2g10CBDaMiqsaxWyW5cwlT/6ZF5sFznazqVsoC85U9dqLOYqQwst+UQQoNlDHgKR

# La3xoc+OReFreFhnTXSG0Vrd2E2CZqUfm+5a+He1MJ/h+tNLuA+0Zzhn/Fo+FDYA

# HWZHx4R79ZsfRFYe9UiXpXBDf6DkUo183Y38NYmR/XfDYf7YZ+oR9t3flbDwK+hg

# GMs0gNNp1w9Z2CyOyI5or/sSwomAuNQ0hWC9xoU4stD8aWsD7RkcmgVRs6vlIk3z

# PKQ+ylcheWkMlj+CoVRlFE55pv0ZWCaFt04lwP/rdGHE9qEVQZtyRE42ox7oNgC/

# r+Y4bSlZ3dw9K2x1xLtu6PkPKeLBFjzKigwfqm3Hm+k/+lnME8F5kPZTgiy2HLEH

# klpryqs6QHnPXrRNeIzkAMyylnRN8P0wmirS0WkU+ywpEWFZ4QNg+9xS43tTuW9x

# 0eXh7NDc1P/sV+zWxHXKH8tFt1ncHdVzqrZaYPyYMLSn2TOXajveJW1L3joiQSPs

# WRGxkbDDW15jERFE4LvjnGu2O9zD1nLJSMdlYZEikl4w2w+q4IN/R+TIe0H4ngCI

# 1moJCTbevGH4punIxM1Uoi0nmX3ZK+XbRT01uowE5ViXWHng0RgsmrX/EdYUo80r

# 3TfMlkD0/YMwggdWMIIFPqADAgECAhAFfARoFtaNDha0m0G6FxiVMA0GCSqGSIb3

# DQEBCwUAMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFB

# MD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcgUlNBNDA5

# NiBTSEEzODQgMjAyMSBDQTEwHhcNMjYwNTE0MDAwMDAwWhcNMjcwNjE3MjM1OTU5

# WjBeMQswCQYDVQQGEwJVUzEXMBUGA1UECBMOTm9ydGggQ2Fyb2xpbmExFDASBgNV

# BAcTC01vcnJpc3ZpbGxlMQ8wDQYDVQQKEwZMZW5vdm8xDzANBgNVBAMTBkxlbm92

# bzCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBALVacqHydjmqo6bF2tHw

# cETPkOZLgPv1tJeIerpLcfmxLoX40GsUiY5l96B13bcfKjKBJQvHsj5D08RfGnif

# K+sGsAX8xCgaYNLxq0COKn51GgLLMNgzlE4rR/8mUMuWK2fKXs24dmn7teE2+e+2

# dz/GfHXgrAIPvIr4PN+dZAFeoj6/wfpLLHZXtQLxKVmtDFc7gQZkM6Z8o0HrH2eX

# 2MVNQwbZZWvSQhqRN66/LMcXxbLP8SAb6nKRCExflbI5i+MpEq+xOdiJxkP5dC5s

# rQ31JGLDdhbuAcUJEdXATzgP1pT9is3uWZm3fro71Kvfa0XLwBZWR2ut8sQ6KUhd

# 0Nsmd5c0f2PiD2uTd9mDWHQ34bu9mDunZaeWZrIlUP9MJ8TMM82ao/4tjFNK5m3T

# hZUbCGwoepenXq8yjbKMKqHHvcoJY0SmkAIlUzWoRBbRC+uN0TwcR048sZDPo+ZC

# gdONLPrjnsIU+NxuhfDMnj4UYbkRbtvnJ+U0O4Eu+ajRS87Li+jN2jHrABvAUXtP

# J7DkkxTTfaspzlfxueoqVKcGLnu4PUAthKg3g4hleGgeo7s+krEDAzyvdBnY+b8U

# dRH/BCxDr7G5ys/bCMPEzcUFT5LrrVBHO6N2U65iYkamzEo4okrrCNFDJPZC1G/p

# NleTeiIadSPTT0tJGPK+nDo1AgMBAAGjggIDMIIB/zAfBgNVHSMEGDAWgBRoN+Dr

# tjv4XxGG+/5hewiIZfROQjAdBgNVHQ4EFgQU7R8eucYUNncCkcWYWfCltSt/mxYw

# PgYDVR0gBDcwNTAzBgZngQwBBAEwKTAnBggrBgEFBQcCARYbaHR0cDovL3d3dy5k

# aWdpY2VydC5jb20vQ1BTMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUEDDAKBggrBgEF

# BQcDAzCBtQYDVR0fBIGtMIGqMFOgUaBPhk1odHRwOi8vY3JsMy5kaWdpY2VydC5j

# b20vRGlnaUNlcnRUcnVzdGVkRzRDb2RlU2lnbmluZ1JTQTQwOTZTSEEzODQyMDIx

# Q0ExLmNybDBToFGgT4ZNaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0

# VHJ1c3RlZEc0Q29kZVNpZ25pbmdSU0E0MDk2U0hBMzg0MjAyMUNBMS5jcmwwgZQG

# CCsGAQUFBwEBBIGHMIGEMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2Vy

# dC5jb20wXAYIKwYBBQUHMAKGUGh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9E

# aWdpQ2VydFRydXN0ZWRHNENvZGVTaWduaW5nUlNBNDA5NlNIQTM4NDIwMjFDQTEu

# Y3J0MAkGA1UdEwQCMAAwDQYJKoZIhvcNAQELBQADggIBAC0PiOF1B8Qdp2pcfb3P

# 6MuzaeTUw77bfMSCcnwY8xFtkyRRp9H6X4ZaSTdAQge3d6NG7OcHnGQ3FKraZqT3

# ugjNEXvH1MXr8SNgFb7t7TyKDK0RmRK9idsycLJfRsmbj0FSTL12jqrzyHrQqkTq

# KaDqYfIVan7VxP2On8gq3/OT368z1YJbRgfu/rNpXoYpXTKSfxaIXNE7rEiUwu+T

# vi8wgfLqC/a7ujC8vbYRWgaHHsz3bjFVN/h1p78adds2GdxPzYFoS12+JKq2cKGe

# Ma5Hbr2YQfHsbpQlzZglB3mGCci+uhN5YGaHleo3Ohd0BHci32RFOA1xdD8fS9TD

# pGRMGLKF9z5WTmiGZVR4x54Qwtf4clbA5V0P9d4ppmLZJKdeaHd/JKONVJ9nYV1H

# NA52CgvgRWpUc+jxnPL5A3J9qIvUXp98ZQifEyHBFX2VqWTdu9MldzklRo/eAT1k

# MUVheRAcd32yLDiFvn7lp2nasJs8Hh+6bUxfHKbKBrNrw7CmcTDzFK119BkykWS0

# vL7xsbCEbavLIhW/ZqEjWA9k/v2FS2wbBQ9YOC8F3magnslxWlZWsym3Dxdm0Hr1

# WKHbnFcBscMiBQ+fhLDAqIG8tPPnNhc7QhOOlxQlbfEDh8QmQbUo2H9hJJEGiHJS

# VwuAKbcWembFyAgLV02ASxS7MYIGSDCCBkQCAQEwfTBpMQswCQYDVQQGEwJVUzEX

# MBUGA1UEChMORGlnaUNlcnQsIEluYy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRydXN0

# ZWQgRzQgQ29kZSBTaWduaW5nIFJTQTQwOTYgU0hBMzg0IDIwMjEgQ0ExAhAFfARo

# FtaNDha0m0G6FxiVMAkGBSsOAwIaBQCgeDAYBgorBgEEAYI3AgEMMQowCKACgACh

# AoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQBgjcCAQsxDjAM

# BgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBSvU+gILv7A0ofbVmMgAy7uuwXD

# lTANBgkqhkiG9w0BAQEFAASCAgB3xAju4uzy2AA2jnW7o5FoQbhB0a2cFIW9ba/5

# EiJ2uLkPRQToAZiyKp5gfoo/31c53Eg3XcVQsZh7iYXKIdQs7P86ZU3V983SGXFN

# ZssD+6HIath7IquRAMppLkY3v7gE3xktar9jxF7QNOC4Ek7SN/GYSGjna5G3c+bW

# 6tuWixgOqq+XKefLES6Fm6DulIpKKarTu1F9T6H7HrF60NflyZErsVdlponoY2k5

# cGor8krDOFptVcrYs/VyUkjfij1DIZYB0XSybEpX7y2FgAGaImMJDvr1owh/hbsQ

# 5ooks/xYC6stHNdpDPM4Op9XQGbMdzZr70aonwonLpGIZZH/wsNj4TdknnfLoa/T

# JGBbpnyPYQtqAP7d64e82KJgWzbzWF79vrjn3JluWLgynRd95ElCzGjoz9er+YP4

# aIdGZvYW6fAU7MZOB/vUkDjeUW6LoLtZiZBu+ChYQA8WFLZW4VVCt/m5U2C98XpS

# LDEGjEPwDTzU9zmbx6P9n/rSmPzg0y7YWmaj46gc9tYJSxkufQ0lJEf/DHgd1OXB

# vdwlN4Y/QYQ3Any6f68axgD5w2bkiQkNo9STqc1wdsvYvEzDbklMh21Su29alT7r

# 3dKpPaYqjDIdTLxWYgdLOmRy7p6BNzdT3AFwx2U1V2gKxnAGUWVy3NLMF86aPmU8

# 0GlocqGCAyYwggMiBgkqhkiG9w0BCQYxggMTMIIDDwIBATB9MGkxCzAJBgNVBAYT

# AlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQg

# VHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcgUlNBNDA5NiBTSEEyNTYgMjAyNSBDQTEC

# EAhP3DNPfkVO28MPj/mSGDUwDQYJYIZIAWUDBAIBBQCgaTAYBgkqhkiG9w0BCQMx

# CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0yNjEwMDExMzI2MzBaMC8GCSqG

# SIb3DQEJBDEiBCB0p+1ghs8SVf5z+I3LE+R9/sPcyVZlcSb6H+hGx4aftzANBgkq

# hkiG9w0BAQEFAASCAgBfanMCnOHdpZ56yrUBTal0KPxCF2+qw7WTjvaG2OzovAKY

# 7yv5bc/Swzb4khfOZhz/eG+7PY4eRnDpZ7lreczFiKX9Z+22xbAwHtFdk1tDPAo5

# ySLASKUvUVhOXSv2g5HSuyqD/M1qz6np1uCDKY0qXYn16bpgGfAplWdFu4Gi/RAr

# J5GD3mrpYCAxl0xJ5+SUc+ESaZQZAY3ItY111/EAwo8j0nENe043ACyTMBQ4NKzT

# sVxrfdklR1K+uLzO9C3vpW0IopfNUNsT2BSw/z1ZEThfJWwqztK9D/IBtfEpLser

# Be82GdIBnPsM49EGSN2siGJxWZg+yv8GmTljC07a+zCkLIhJ6sbr2InVrfmN1pXY

# jzJ1tQufJw/1/+JgIUAehvWie3fIaCYcRMi9nm+oRedwNYT9WUyIrYlDFFk7/UWl

# yIMUmTthRXkeVgwMc6EwuiyecHb/Troa7uCoZEmzL2HCyMrF245MjxnaJHcw+suk

# HdFg+peaFYdprHJuizXNRhRCKyZsqdWHitvYwgExtRc1q9HTKxsVKPH0DcGlLyFD

# uzQxCX+OiozDTW/LP2P/xpMORxII+y6u/x9R6wCUAw5tMx5XSmaqh1E03dXx0AwL

# HYgvQzSpwxtgCiU5Pl9fenOK5Tg3rBOxF7/pEduwRavAc1PKnfeAIFYtigUI2A==

# SIG # End signature block