TechToolbox

0.5.8

Bin/Monitor-EDIFailures.ps1

                                # Monitor-EDIFailures.ps1

# Monitors an Outlook inbox subfolder for EDI failure reports, extracts key info

# from attached PDFs, and logs to CSV.

#

# Author: (https://github.com/dan-damit)

[CmdletBinding()]

param(

    [string]$OutCsv,

    [string]$InboxSubFolder = "EDI Failures",

    [string]$ProcessedSubFolder = "Processed"

)

if (-not $PSBoundParameters.ContainsKey('OutCsv') -or [string]::IsNullOrWhiteSpace($OutCsv)) {

    $logsRoot = if ($env:TT_LogsRoot) { $env:TT_LogsRoot } else { (Join-Path (Split-Path -Parent $PSScriptRoot) 'LogsAndExports\Logs') }

    $OutCsv = Join-Path $logsRoot 'EDI_Failures\EDI_Failures.csv'

}

function Get-RegexGroup {

    param(

        [string]$Text,

        [string]$Pattern,

        [int]$Group = 1

    )

    if ([string]::IsNullOrWhiteSpace($Text)) { return $null }

    $m = [regex]::Match($Text, $Pattern, 'IgnoreCase')

    if ($m.Success -and $m.Groups.Count -gt $Group) { return $m.Groups[$Group].Value.Trim() }

    return $null

}

function Get-PdfText {

    param([Parameter(Mandatory)][string]$PdfPath)

    $scriptPath = Join-Path $env:TEMP "extract_pdf_text_pypdf2.py"

    # Create the python helper once (or overwrite; it's tiny)

    @'

import sys

from PyPDF2 import PdfReader

path = sys.argv[1]

reader = PdfReader(path)

out = []

for p in reader.pages:

    try:

        out.append(p.extract_text() or "")

    except Exception:

        out.append("")

print("\n".join(out))

'@ | Set-Content -Path $scriptPath -Encoding UTF8

    $psi = New-Object System.Diagnostics.ProcessStartInfo

    $psi.FileName = "python"

    $psi.Arguments = "`"$scriptPath`" `"$PdfPath`""

    $psi.RedirectStandardOutput = $true

    $psi.RedirectStandardError = $true

    $psi.UseShellExecute = $false

    $psi.CreateNoWindow = $true

    $p = New-Object System.Diagnostics.Process

    $p.StartInfo = $psi

    [void]$p.Start()

    $stdout = $p.StandardOutput.ReadToEnd()

    $stderr = $p.StandardError.ReadToEnd()

    $p.WaitForExit()

    if ($p.ExitCode -ne 0) {

        throw "PDF text extraction failed for '$PdfPath': $stderr"

    }

    return $stdout

}

# Ensure output folder exists

$null = New-Item -ItemType Directory -Path (Split-Path $OutCsv) -Force -ErrorAction SilentlyContinue

# Outlook COM (Classic Outlook required)

$outlook = New-Object -ComObject Outlook.Application

$ns = $outlook.GetNamespace("MAPI")

$inbox = $ns.GetDefaultFolder(6) # olFolderInbox

$ediFolder = $inbox.Folders.Item($InboxSubFolder)

# Create/ensure Processed subfolder

$processedFolder = $null

try { $processedFolder = $ediFolder.Folders.Item($ProcessedSubFolder) } catch {}

if (-not $processedFolder) { $processedFolder = $ediFolder.Folders.Add($ProcessedSubFolder) }

# Pull newest first

$items = $ediFolder.Items

$items.Sort("[ReceivedTime]", $true)

# Process unread items (or you can remove this filter and instead use folder move as idempotency)

foreach ($item in @($items)) {

    try {

        if ($item.Class -ne 43) { continue } # MailItem

        if ($item.UnRead -ne $true) { continue }

        if ($item.Subject -notlike "*EDI Data with Error Notes*") { continue }

        $rows = @()

        foreach ($att in @($item.Attachments)) {

            # Only process PDFs

            if ($att.FileName -notmatch "\.pdf$") { continue }

            $tempPath = Join-Path $env:TEMP $att.FileName

            $att.SaveAsFile($tempPath)

            $pdfText = $null

            try {

                $pdfText = Get-PdfText -PdfPath $tempPath

            }

            finally {

                Remove-Item $tempPath -ErrorAction SilentlyContinue

            }

            # Parse fields (these patterns match report format)

            $partner = Get-RegexGroup $pdfText "Trading Partner:\s*([^\r\n]+)"

            $tset = Get-RegexGroup $pdfText "T-Set:\s*(\d+)"

            $ship = Get-RegexGroup $pdfText "Shipment ID:\s*(\d+)"

            $mapError = Get-RegexGroup $pdfText "Mapping Error:\s*'([^']+)'"   # quoted

            if (-not $mapError) {

                $mapError = Get-RegexGroup $pdfText "Mapping Error:\s*([^\r\n]+)"

            }

            if (-not $mapError -and $pdfText -match "Transaction will not be sent") {

                $mapError = "Transaction will not be sent (reason not captured)"

            }

            if (-not $mapError) {

                # Required-field / missing data cases

                $mapError = Get-RegexGroup $pdfText "(mandatory.*missing[^\r\n]*)"

            }

            if (-not $mapError) {

                # Abort-style failures

                $mapError = Get-RegexGroup $pdfText "(triggered Abort[^\r\n]*)"

            }

            if (-not $mapError) {

                # Specific LIN03 missing

                $mapError = Get-RegexGroup $pdfText "(Data element\s+'LIN03'.*?mandatory.*?missing[^\r\n]*)"

            }

            if (-not $mapError) {

                # General LIN segment error

                $mapError = Get-RegexGroup $pdfText "(The\s+'LIN'\s+segment.*?element\s+errors[^\r\n]*)"

            }

            # Final fallback

            if (-not $mapError) {

                $mapError = "Unknown"

            }

            $failureType = switch -Regex ($mapError) {

                "LIN03" { "MissingLIN03"; break }

                "mandatory.*missing" { "MissingRequiredField"; break }

                "Smart Condition" { "SmartConditionAbort"; break }

                "triggered Abort" { "AbortCondition"; break }

                "Transaction will not be sent" { "SuppressedTransaction"; break }

                default { "Other" }

            }

            $rows += [pscustomobject]@{

                Time        = $item.ReceivedTime

                Partner     = $partner

                TSet        = $tset

                Shipment    = $ship

                FailureType = $failureType

                Subject     = $item.Subject

            }

        }

        # Write results if any attachments are parsed

        if ($rows.Count -gt 0) {

            $rows | Export-Csv -Path $OutCsv -Append -NoTypeInformation

        }

        # Mark processed and move

        $item.UnRead = $false

        $null = $item.Move($processedFolder)

    }

    catch {

        # Don’t fail the whole run — tag the message so it can be reviewed later

        try { $item.Categories = "EDI-ParseFailed" } catch {}

        try { $item.UnRead = $false } catch {}

        # write a minimal line to CSV so you know it errored

        [pscustomobject]@{

            Time        = $item.ReceivedTime

            Partner     = ""

            TSet        = ""

            Shipment    = ""

            FailureType = "ParseFailed"

            Subject     = $item.Subject

        } | Export-Csv -Path $OutCsv -Append -NoTypeInformation

    }

}

# SIG # Begin signature block

# MIIfAgYJKoZIhvcNAQcCoIIe8zCCHu8CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCS7tPI4p9NSwCd

# ikYyR3TNT+AGJoOaorCWWArXxoTpyKCCGEowggUMMIIC9KADAgECAhAR+U4xG7FH

# qkyqS9NIt7l5MA0GCSqGSIb3DQEBCwUAMB4xHDAaBgNVBAMME1ZBRFRFSyBDb2Rl

# IFNpZ25pbmcwHhcNMjUxMjE5MTk1NDIxWhcNMjYxMjE5MjAwNDIxWjAeMRwwGgYD

# VQQDDBNWQURURUsgQ29kZSBTaWduaW5nMIICIjANBgkqhkiG9w0BAQEFAAOCAg8A

# MIICCgKCAgEA3pzzZIUEY92GDldMWuzvbLeivHOuMupgpwbezoG5v90KeuN03S5d

# nM/eom/PcIz08+fGZF04ueuCS6b48q1qFnylwg/C/TkcVRo0WFcKoFGT8yGxdfXi

# caHtapZfbSRh73r7qR7w0CioVveNBVgfMsTgE0WKcuwxemvIe/ptmkfzwAiw/IAC

# Ib0E0BjiX4PySbwWy/QKy/qMXYY19xpRItVTKNBtXzADUtzPzUcFqJU83vM2gZFs

# Or0MhPvM7xEVkOWZFBAWAubbMCJ3rmwyVv9keVDJChhCeLSz2XR11VGDOEA2OO90

# Y30WfY9aOI2sCfQcKMeJ9ypkHl0xORdhUwZ3Wz48d3yJDXGkduPm2vl05RvnA4T6

# 29HVZTmMdvP2475/8nLxCte9IB7TobAOGl6P1NuwplAMKM8qyZh62Br23vcx1fXZ

# TJlKCxBFx1nTa6VlIJk+UbM4ZPm954peB/fIqEacm8LkZ0cPwmLE5ckW7hfK4Trs

# o+RaudU1sKeA+FvpOWgsPccVRWcEYyGkwbyTB3xrIBXA+YckbANZ0XL7fv7x29hn

# gXbZipGu3DnTISiFB43V4MhNDKZYfbWdxze0SwLe8KzIaKnwlwRgvXDMwXgk99Mi

# EbYa3DvA/5ZWikLW9PxBFD7Vdr8ZiG/tRC9I2Y6fnb+PVoZKc/2xsW0CAwEAAaNG

# MEQwDgYDVR0PAQH/BAQDAgeAMBMGA1UdJQQMMAoGCCsGAQUFBwMDMB0GA1UdDgQW

# BBRfYLVE8caSc990rnrIHUjoB7X/KjANBgkqhkiG9w0BAQsFAAOCAgEAiGB2Wmk3

# QBtd1LcynmxHzmu+X4Y5DIpMMNC2ahsqZtPUVcGqmb5IFbVuAdQphL6PSrDjaAR8

# 1S8uTfUnMa119LmIb7di7TlH2F5K3530h5x8JMj5EErl0xmZyJtSg7BTiBA/UrMz

# 6WCf8wWIG2/4NbV6aAyFwIojfAcKoO8ng44Dal/oLGzLO3FDE5AWhcda/FbqVjSJ

# 1zMfiW8odd4LgbmoyEI024KkwOkkPyJQ2Ugn6HMqlFLazAmBBpyS7wxdaAGrl18n

# 6bS7QuAwCd9hitdMMitG8YyWL6tKeRSbuTP5E+ASbu0Ga8/fxRO5ZSQhO6/5ro1j

# PGe1/Kr49Uyuf9VSCZdNIZAyjjeVAoxmV0IfxQLKz6VOG0kGDYkFGskvllIpQbQg

# WLuPLJxoskJsoJllk7MjZJwrpr08+3FQnLkRuisjDOc3l4VxFUsUe4fnJhMUONXT

# Sk7vdspgxirNbLmXU4yYWdsizz3nMUR0zebUW29A+HYme16hzrMPOeyoQjy4I5XX

# 3wXAFdworfPEr/ozDFrdXKgbLwZopymKbBwv6wtT7+1zVhJXr+jGVQ1TWr6R+8ea

# tIOFnY7HqGaxe5XB7HzOwJKdj+bpHAfXft1vUoiKr16VajLigcYCG8MdwC3sngO3

# JDyv2V+YMfsYBmItMGBwvizlQ6557NbK95EwggWNMIIEdaADAgECAhAOmxiO+dAt

# 5+/bUOIIQBhaMA0GCSqGSIb3DQEBDAUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK

# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV

# BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0yMjA4MDEwMDAwMDBa

# Fw0zMTExMDkyMzU5NTlaMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy

# dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lD

# ZXJ0IFRydXN0ZWQgUm9vdCBHNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC

# ggIBAL/mkHNo3rvkXUo8MCIwaTPswqclLskhPfKK2FnC4SmnPVirdprNrnsbhA3E

# MB/zG6Q4FutWxpdtHauyefLKEdLkX9YFPFIPUh/GnhWlfr6fqVcWWVVyr2iTcMKy

# unWZanMylNEQRBAu34LzB4TmdDttceItDBvuINXJIB1jKS3O7F5OyJP4IWGbNOsF

# xl7sWxq868nPzaw0QF+xembud8hIqGZXV59UWI4MK7dPpzDZVu7Ke13jrclPXuU1

# 5zHL2pNe3I6PgNq2kZhAkHnDeMe2scS1ahg4AxCN2NQ3pC4FfYj1gj4QkXCrVYJB

# MtfbBHMqbpEBfCFM1LyuGwN1XXhm2ToxRJozQL8I11pJpMLmqaBn3aQnvKFPObUR

# WBf3JFxGj2T3wWmIdph2PVldQnaHiZdpekjw4KISG2aadMreSx7nDmOu5tTvkpI6

# nj3cAORFJYm2mkQZK37AlLTSYW3rM9nF30sEAMx9HJXDj/chsrIRt7t/8tWMcCxB

# YKqxYxhElRp2Yn72gLD76GSmM9GJB+G9t+ZDpBi4pncB4Q+UDCEdslQpJYls5Q5S

# UUd0viastkF13nqsX40/ybzTQRESW+UQUOsxxcpyFiIJ33xMdT9j7CFfxCBRa2+x

# q4aLT8LWRV+dIPyhHsXAj6KxfgommfXkaS+YHS312amyHeUbAgMBAAGjggE6MIIB

# NjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTs1+OC0nFdZEzfLmc/57qYrhwP

# TzAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzAOBgNVHQ8BAf8EBAMC

# AYYweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdp

# Y2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNv

# bS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcnQwRQYDVR0fBD4wPDA6oDigNoY0

# aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENB

# LmNybDARBgNVHSAECjAIMAYGBFUdIAAwDQYJKoZIhvcNAQEMBQADggEBAHCgv0Nc

# Vec4X6CjdBs9thbX979XB72arKGHLOyFXqkauyL4hxppVCLtpIh3bb0aFPQTSnov

# Lbc47/T/gLn4offyct4kvFIDyE7QKt76LVbP+fT3rDB6mouyXtTP0UNEm0Mh65Zy

# oUi0mcudT6cGAxN3J0TU53/oWajwvy8LpunyNDzs9wPHh6jSTEAZNUZqaVSwuKFW

# juyk1T3osdz9HNj0d1pcVIxv76FQPfx2CWiEn2/K2yCNNWAcAgPLILCsWKAOQGPF

# mCLBsln1VWvPJ6tsds5vIy30fnFqI2si/xK4VC0nftg62fC2h5b9W9FcrBjDTZ9z

# twGpn1eqXijiuZQwgga0MIIEnKADAgECAhANx6xXBf8hmS5AQyIMOkmGMA0GCSqG

# SIb3DQEBCwUAMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMx

# GTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lDZXJ0IFRy

# dXN0ZWQgUm9vdCBHNDAeFw0yNTA1MDcwMDAwMDBaFw0zODAxMTQyMzU5NTlaMGkx

# CzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4

# RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcgUlNBNDA5NiBTSEEyNTYg

# MjAyNSBDQTEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC0eDHTCphB

# cr48RsAcrHXbo0ZodLRRF51NrY0NlLWZloMsVO1DahGPNRcybEKq+RuwOnPhof6p

# vF4uGjwjqNjfEvUi6wuim5bap+0lgloM2zX4kftn5B1IpYzTqpyFQ/4Bt0mAxAHe

# HYNnQxqXmRinvuNgxVBdJkf77S2uPoCj7GH8BLuxBG5AvftBdsOECS1UkxBvMgEd

# gkFiDNYiOTx4OtiFcMSkqTtF2hfQz3zQSku2Ws3IfDReb6e3mmdglTcaarps0wjU

# jsZvkgFkriK9tUKJm/s80FiocSk1VYLZlDwFt+cVFBURJg6zMUjZa/zbCclF83bR

# VFLeGkuAhHiGPMvSGmhgaTzVyhYn4p0+8y9oHRaQT/aofEnS5xLrfxnGpTXiUOeS

# LsJygoLPp66bkDX1ZlAeSpQl92QOMeRxykvq6gbylsXQskBBBnGy3tW/AMOMCZIV

# NSaz7BX8VtYGqLt9MmeOreGPRdtBx3yGOP+rx3rKWDEJlIqLXvJWnY0v5ydPpOjL

# 6s36czwzsucuoKs7Yk/ehb//Wx+5kMqIMRvUBDx6z1ev+7psNOdgJMoiwOrUG2Zd

# SoQbU2rMkpLiQ6bGRinZbI4OLu9BMIFm1UUl9VnePs6BaaeEWvjJSjNm2qA+sdFU

# eEY0qVjPKOWug/G6X5uAiynM7Bu2ayBjUwIDAQABo4IBXTCCAVkwEgYDVR0TAQH/

# BAgwBgEB/wIBADAdBgNVHQ4EFgQU729TSunkBnx6yuKQVvYv1Ensy04wHwYDVR0j

# BBgwFoAU7NfjgtJxXWRM3y5nP+e6mK4cD08wDgYDVR0PAQH/BAQDAgGGMBMGA1Ud

# JQQMMAoGCCsGAQUFBwMIMHcGCCsGAQUFBwEBBGswaTAkBggrBgEFBQcwAYYYaHR0

# cDovL29jc3AuZGlnaWNlcnQuY29tMEEGCCsGAQUFBzAChjVodHRwOi8vY2FjZXJ0

# cy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkUm9vdEc0LmNydDBDBgNVHR8E

# PDA6MDigNqA0hjJodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVz

# dGVkUm9vdEc0LmNybDAgBgNVHSAEGTAXMAgGBmeBDAEEAjALBglghkgBhv1sBwEw

# DQYJKoZIhvcNAQELBQADggIBABfO+xaAHP4HPRF2cTC9vgvItTSmf83Qh8WIGjB/

# T8ObXAZz8OjuhUxjaaFdleMM0lBryPTQM2qEJPe36zwbSI/mS83afsl3YTj+IQhQ

# E7jU/kXjjytJgnn0hvrV6hqWGd3rLAUt6vJy9lMDPjTLxLgXf9r5nWMQwr8Myb9r

# EVKChHyfpzee5kH0F8HABBgr0UdqirZ7bowe9Vj2AIMD8liyrukZ2iA/wdG2th9y

# 1IsA0QF8dTXqvcnTmpfeQh35k5zOCPmSNq1UH410ANVko43+Cdmu4y81hjajV/gx

# dEkMx1NKU4uHQcKfZxAvBAKqMVuqte69M9J6A47OvgRaPs+2ykgcGV00TYr2Lr3t

# y9qIijanrUR3anzEwlvzZiiyfTPjLbnFRsjsYg39OlV8cipDoq7+qNNjqFzeGxcy

# tL5TTLL4ZaoBdqbhOhZ3ZRDUphPvSRmMThi0vw9vODRzW6AxnJll38F0cuJG7uEB

# YTptMSbhdhGQDpOXgpIUsWTjd6xpR6oaQf/DJbg3s6KCLPAlZ66RzIg9sC+NJpud

# /v4+7RWsWCiKi9EOLLHfMR2ZyJ/+xhCx9yHbxtl5TPau1j/1MIDpMPx0LckTetiS

# uEtQvLsNz3Qbp7wGWqbIiOWCnb5WqxL3/BAPvIXKUjPSxyZsq8WhbaM2tszWkPZP

# ubdcMIIG7TCCBNWgAwIBAgIQCoDvGEuN8QWC0cR2p5V0aDANBgkqhkiG9w0BAQsF

# ADBpMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xQTA/BgNV

# BAMTOERpZ2lDZXJ0IFRydXN0ZWQgRzQgVGltZVN0YW1waW5nIFJTQTQwOTYgU0hB

# MjU2IDIwMjUgQ0ExMB4XDTI1MDYwNDAwMDAwMFoXDTM2MDkwMzIzNTk1OVowYzEL

# MAkGA1UEBhMCVVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJE

# aWdpQ2VydCBTSEEyNTYgUlNBNDA5NiBUaW1lc3RhbXAgUmVzcG9uZGVyIDIwMjUg

# MTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBANBGrC0Sxp7Q6q5gVrMr

# V7pvUf+GcAoB38o3zBlCMGMyqJnfFNZx+wvA69HFTBdwbHwBSOeLpvPnZ8ZN+vo8

# dE2/pPvOx/Vj8TchTySA2R4QKpVD7dvNZh6wW2R6kSu9RJt/4QhguSssp3qome7M

# rxVyfQO9sMx6ZAWjFDYOzDi8SOhPUWlLnh00Cll8pjrUcCV3K3E0zz09ldQ//nBZ

# ZREr4h/GI6Dxb2UoyrN0ijtUDVHRXdmncOOMA3CoB/iUSROUINDT98oksouTMYFO

# nHoRh6+86Ltc5zjPKHW5KqCvpSduSwhwUmotuQhcg9tw2YD3w6ySSSu+3qU8DD+n

# igNJFmt6LAHvH3KSuNLoZLc1Hf2JNMVL4Q1OpbybpMe46YceNA0LfNsnqcnpJeIt

# K/DhKbPxTTuGoX7wJNdoRORVbPR1VVnDuSeHVZlc4seAO+6d2sC26/PQPdP51ho1

# zBp+xUIZkpSFA8vWdoUoHLWnqWU3dCCyFG1roSrgHjSHlq8xymLnjCbSLZ49kPmk

# 8iyyizNDIXj//cOgrY7rlRyTlaCCfw7aSUROwnu7zER6EaJ+AliL7ojTdS5PWPsW

# eupWs7NpChUk555K096V1hE0yZIXe+giAwW00aHzrDchIc2bQhpp0IoKRR7YufAk

# prxMiXAJQ1XCmnCfgPf8+3mnAgMBAAGjggGVMIIBkTAMBgNVHRMBAf8EAjAAMB0G

# A1UdDgQWBBTkO/zyMe39/dfzkXFjGVBDz2GM6DAfBgNVHSMEGDAWgBTvb1NK6eQG

# fHrK4pBW9i/USezLTjAOBgNVHQ8BAf8EBAMCB4AwFgYDVR0lAQH/BAwwCgYIKwYB

# BQUHAwgwgZUGCCsGAQUFBwEBBIGIMIGFMCQGCCsGAQUFBzABhhhodHRwOi8vb2Nz

# cC5kaWdpY2VydC5jb20wXQYIKwYBBQUHMAKGUWh0dHA6Ly9jYWNlcnRzLmRpZ2lj

# ZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNFRpbWVTdGFtcGluZ1JTQTQwOTZTSEEy

# NTYyMDI1Q0ExLmNydDBfBgNVHR8EWDBWMFSgUqBQhk5odHRwOi8vY3JsMy5kaWdp

# Y2VydC5jb20vRGlnaUNlcnRUcnVzdGVkRzRUaW1lU3RhbXBpbmdSU0E0MDk2U0hB

# MjU2MjAyNUNBMS5jcmwwIAYDVR0gBBkwFzAIBgZngQwBBAIwCwYJYIZIAYb9bAcB

# MA0GCSqGSIb3DQEBCwUAA4ICAQBlKq3xHCcEua5gQezRCESeY0ByIfjk9iJP2zWL

# pQq1b4URGnwWBdEZD9gBq9fNaNmFj6Eh8/YmRDfxT7C0k8FUFqNh+tshgb4O6Lgj

# g8K8elC4+oWCqnU/ML9lFfim8/9yJmZSe2F8AQ/UdKFOtj7YMTmqPO9mzskgiC3Q

# YIUP2S3HQvHG1FDu+WUqW4daIqToXFE/JQ/EABgfZXLWU0ziTN6R3ygQBHMUBaB5

# bdrPbF6MRYs03h4obEMnxYOX8VBRKe1uNnzQVTeLni2nHkX/QqvXnNb+YkDFkxUG

# tMTaiLR9wjxUxu2hECZpqyU1d0IbX6Wq8/gVutDojBIFeRlqAcuEVT0cKsb+zJNE

# suEB7O7/cuvTQasnM9AWcIQfVjnzrvwiCZ85EE8LUkqRhoS3Y50OHgaY7T/lwd6U

# Arb+BOVAkg2oOvol/DJgddJ35XTxfUlQ+8Hggt8l2Yv7roancJIFcbojBcxlRcGG

# 0LIhp6GvReQGgMgYxQbV1S3CrWqZzBt1R9xJgKf47CdxVRd/ndUlQ05oxYy2zRWV

# FjF7mcr4C34Mj3ocCVccAvlKV9jEnstrniLvUxxVZE/rptb7IRE2lskKPIJgbaP5

# t2nGj/ULLi49xTcBZU8atufk+EMF/cWuiC7POGT75qaL6vdCvHlshtjdNXOCIUjs

# arfNZzGCBg4wggYKAgEBMDIwHjEcMBoGA1UEAwwTVkFEVEVLIENvZGUgU2lnbmlu

# ZwIQEflOMRuxR6pMqkvTSLe5eTANBglghkgBZQMEAgEFAKCBhDAYBgorBgEEAYI3

# AgEMMQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisG

# AQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMC8GCSqGSIb3DQEJBDEiBCCA3xaZDIvD

# sEzoVUF4+xce1IKKs/pqf5/SFZ+uuNU/4TANBgkqhkiG9w0BAQEFAASCAgCVy60b

# 7f4E2trQe3vXqQQtAPmXZOYHML8YAOhbE3LEgHMZq3aQhJqXaJLWkGEAUUu9//13

# xIsGu25cqjc553JjiKcxuaeBZyOZ+XhKcTEmbMmdIynPJrQBxEb3nxuTidvA1Snr

# DccBbv4dYPjB/mcgnZJQ+77SYjg52UefnrZCnFDfft73irf9/Lg5WS6memyM8m6i

# +28j739JZclNm+uqYqEbrojlGzo60rni46WpCnzypjhnBdD1N8PIisH80N9lOCg/

# zu1H2LlI+gLpBCZDm9CrWmAGbaj7RXtv/6XxDYoqlunGxR5+ALtAv974fADYeud3

# R86e828aQVQ6TcI4euNILMxp4sBJqQxr5RYP5xKjInNPXQS7IVmPNhSh1nnYEEhr

# QGuSrC/u64qbAX/3azjFGowTVs15WY19jifC5pJ9uMj/KgAPZICgFeXfBYCkO9US

# zRInqLABZh2fdH/QbPs6K/FyIUvBGxupZ4VTza276/TJwybIxNRPpw372rJODKPy

# y0zF8ebJnWcNlzreFJ/DSvFJ+3yk9bJxgIS6RIEUykeYAix45405y21VH0R213U5

# PBl+RAtMispWOodaBto2t+OohYecKbozQFDJG4OIW8Gn9m5XuAzRfqrGaAr6azlY

# TAETucR/z+6wnIiGUT4Eq/5XhzgqORaDi1l/06GCAyYwggMiBgkqhkiG9w0BCQYx

# ggMTMIIDDwIBATB9MGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwg

# SW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcg

# UlNBNDA5NiBTSEEyNTYgMjAyNSBDQTECEAqA7xhLjfEFgtHEdqeVdGgwDQYJYIZI

# AWUDBAIBBQCgaTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJ

# BTEPFw0yNjA2MDExNTAxMTRaMC8GCSqGSIb3DQEJBDEiBCCSVLrMUP/a8g/KzHVR

# W0t2pUh0PhwS/PuiCZXyz5rKazANBgkqhkiG9w0BAQEFAASCAgBrDiZ5Oa/VnLj7

# fci3fufMK/DzJs+h2z+k6xSFwk7bkg3suiCpCQpoCeU3+2V0niAHs+l/lGO//yVz

# wp9GB6xaGPoOljU6T+1PPQWl3yFCjMksFk/9I2G5ViOBxlZcPcysKA2GuNQUyG+Y

# 1dRYcrvO3ztBjTa9eQSozr4x6r0kzawulc6/dvT+NtO0aYd+cPaCz3j+lgQPZY1U

# Hvr1c+M/IDgwVJd1speS50jLYL7re6wH6rptzafocme7Qd/wn1+A4yYYtL8RoRP9

# Ep5NTvgzbf/h6WgFM8LVY6m9caepJPwLE6A8eTVpJpVya/Iy993ZHH9IMpHLWzfc

# qxSvdBg/8mwUd64VTx1g34nfVXYZQqUH9yFPNUKLoqOsnQXGTgN3hBU/q36fVWSP

# rODIi/+dgxSMkNK6D/+Z3xRTuqwgDIvbzaPWrZvhTY8+3LfJlsHnhzmw3pCKKOej

# wUjZW1vQcqHN4QxcfXgdPsMDF50yHpE7OzrweTtus4T3cT39ZagINgrZvZohabSl

# BUSTu1oUYg+SQwTaXL4vt/Ei5sAv/p/R3E627kj4zQ76va1paLwYZ4xZMp4TiaCK

# g5kXkwBw5PjNspqPfGp69A+orAqlE5FCgjvBUp3cdpih+x1skVQvmGpMuBLDA/Vk

# EZKhX7ADKm/LTUUHmwdXJUItPIKcGw==

# SIG # End signature block