HCPosh

3.0.4.0

functions/data/Split-ObjectToFiles.ps1

function Split-ObjectToFiles {
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]
        [psobject]$Data,
        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]
        [string]$SplitDirectory
    )
    process {
        try {
            #create base directory
            New-Directory -Dir $SplitDirectory -Force
            
            #region CREATE DATAMART FILES
            $Exclusions = @('DatamartNoSpacesNM', 'Entities', 'SourcedByEntities', '_hcposh', 'MaxLastModifiedTimestamp')
            $Out = @()
            $Props = $Data.psobject.properties.name | Where-Object { $Data.$_ }
            forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                $OutObj = New-EmptyProperty
                $OutObj.Name = $Data.DatamartNM
                $OutObj.Property = $Prop
                $OutObj.Value = $Data."$($OutObj.Property)"
                if ($OutObj) { $Out += $OutObj }
            }
            $OutFile = "$($SplitDirectory)\_Datamart.csv"
            if ($Out) {
                $Out | Sort-Object Name, @{
                    e = {
                        if ($_.Property -eq 'ContentId') { 0 }
                        else { 1 }
                    }
                }, Property | Export-Csv $OutFile -Force -NoTypeInformation
            }
            #endregion
            #region CREATE SOURCE FILES
            $SourcedByColumns = @()
            forEach ($Entity in $Data.SourcedByEntities | Where-Object TableOrigin -eq 'External' | Sort-Object FullyQualifiedNM) {
                forEach ($Column in $Entity.SourcedByColumns | Sort-Object FullyQualifiedNM) {
                    $SourcedByColumn = New-Object PSObject
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name DatabaseNM -Value $Entity.DatabaseNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name SchemaNM -Value $Entity.SchemaNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name TableNM -Value $Entity.TableNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name ColumnNM -Value $Column.ColumnNM
                    $SourcedByColumns += $SourcedByColumn
                }
            }
            $ByDatabase = $SourcedByColumns | Group-Object DatabaseNM
            forEach ($db in $ByDatabase) {
                $db.Group | Sort-Object SchemaNM, TableNM, ColumnNM | Export-Csv -NoTypeInformation "$SplitDirectory\Sources-$($db.Name).csv" -Force | Out-Null
            }
            #endregion
            #region CREATE ENTITY FILES
            $Exclusions = @('Bindings', 'Columns', 'Indexes', 'SourcedByEntities', 'FullyQualifiedNames', 'LastModifiedTimestamp', 'DataEntryData', 'OverridingExtensionView')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    $Props = $Entity.psobject.properties.name | Where-Object { $_ }
                    forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Entity.FullyQualifiedNames.Table
                        $OutObj.Property = $Prop
                        $OutObj.Value = $($Entity."$($OutObj.Property)" -replace "`r`n", "")
                        if ($OutObj) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\Entities-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE BINDING FILES
            $Exclusions = @('BindingNameNoSpaces', 'UserDefinedSQL', 'SourcedByEntities', 'IncrementalConfigurations')
            forEach ($Group in $Data.Entities.Bindings | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Binding in $Group.Group) {
                    $Props = $Binding.psobject.properties.name | Where-Object { $_ }
                    forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Binding.BindingName
                        $OutObj.Property = $Prop
                        $OutObj.Value = $($Binding."$($OutObj.Property)" -replace "`r`n", "")
                        if ($OutObj) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\Bindings-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE SQL FILES
            forEach ($Binding in $Data.Entities.Bindings) {
                $OutFile = "$($SplitDirectory)\SQL-$($Binding.ClassificationCode)-$(Get-CleanFileName $Binding.BindingName -RemoveSpace).sql"
                $Binding.UserDefinedSQL | Out-File $OutFile -Encoding Default -Force
            }
            #endregion
            #region CREATE COLUMN FILES
            $Exclusions = @('Ordinal')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    forEach ($Column in $Entity.Columns) {
                        $Props = $Column.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = "$($Entity.FullyQualifiedNames.Table).$($Column.ColumnNM)"
                            $OutObj.Property = $Prop
                            $OutObj.Value = $($Column."$($OutObj.Property)" -replace "`r`n", "")
                            if ($OutObj) { $Out += $OutObj }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\Columns-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE INDEX FILES
            $Exclusions = @('IndexName')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    forEach ($Index in $Entity.Indexes) {
                        $Props = $Index.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = "$($Entity.FullyQualifiedNames.Table).$($Index.IndexName)"
                            $OutObj.Property = $Prop
                            if ($Prop -eq 'IndexColumns') {
                                $OutObj.Value = $(($Index."$($OutObj.Property)" | Sort-Object ColumnNM).ColumnNM -join " | ")
                            }
                            else {
                                $OutObj.Value = $($Index."$($OutObj.Property)" -replace "`r`n", "")
                            }
                            if ($OutObj) { $Out += $OutObj }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\Indexes-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE INCREMENTAL CONFIG FILES
            $Exclusions = @()
            forEach ($Group in $Data.Entities.Bindings | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Binding in $Group.Group) {
                    forEach ($Increment in $Binding.IncrementalConfigurations) {
                        $Props = $Increment.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = $Binding.BindingName
                            $OutObj.Property = $Prop
                            $OutObj.Value = $($Increment."$($OutObj.Property)" -replace "`r`n", "")
                            if ($null -ne $OutObj.Value -and $OutObj.Value -ne "") { $Out += $OutObj | Sort-Object { $_.Property, $_.Value } }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\IncrementalConfigurations-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE DATA ENTRY ENTITY FILES
            ForEach ($Entity in $Data.Entities | Where-Object { $_.ClassificationCode -eq 'DataEntry' }) {
                If ($Entity.DataEntryData) {
                    $OutFile = "$($SplitDirectory)\DataEntryData-$(Get-CleanFileName $Entity.DataEntryData.FullyQualifiedNM -RemoveSpace).csv"
                    if ($Entity.DataEntryData.Data_All) {
                        $Entity.DataEntryData.Data_All | Export-Csv $OutFile -NoTypeInformation -Force
                    }
                }
            }
            #endregion
            #region CREATE ISSUE FILES
            if (($Data.Entities.Bindings.SourcedByEntities.SourcedByPossibleColumns | Measure-Object).Count -gt 0) {
                $Out = @()
                forEach ($Binding in $Data.Entities.Bindings) {
                    forEach ($Issue in $Binding.SourcedByEntities.SourcedByPossibleColumns) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Binding.BindingName
                        $OutObj.Property = "Missing Alias - Unable To Parse"
                        $OutObj.Value = $Issue.FullyQualifiedNM
                        if ($OutObj.Value) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\_ISSUES-Bindings-MissingAlias.csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #Get-Date | Out-File $SplitDirectory\_lastmodified.txt -Encoding Default -Force | Out-Null
        }
        catch {            
            $ErrorMessage = $_.Exception.Message
            $Msg = "$(" " * 8)An error occurred while trying to split data object into smaller files :( --> $ErrorMessage"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
            Exit
        }
    }
}
# SIG # Begin signature block
# MIIcRgYJKoZIhvcNAQcCoIIcNzCCHDMCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAbhyvK4cCvAwAh
# lCxGft2f3+Ri/E0ljKdCvM6i190nWqCCCqAwggUwMIIEGKADAgECAhAECRgbX9W7
# ZnVTQ7VvlVAIMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK
# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV
# BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xMzEwMjIxMjAwMDBa
# Fw0yODEwMjIxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy
# dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lD
# ZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwggEiMA0GCSqGSIb3
# DQEBAQUAA4IBDwAwggEKAoIBAQD407Mcfw4Rr2d3B9MLMUkZz9D7RZmxOttE9X/l
# qJ3bMtdx6nadBS63j/qSQ8Cl+YnUNxnXtqrwnIal2CWsDnkoOn7p0WfTxvspJ8fT
# eyOU5JEjlpB3gvmhhCNmElQzUHSxKCa7JGnCwlLyFGeKiUXULaGj6YgsIJWuHEqH
# CN8M9eJNYBi+qsSyrnAxZjNxPqxwoqvOf+l8y5Kh5TsxHM/q8grkV7tKtel05iv+
# bMt+dDk2DZDv5LVOpKnqagqrhPOsZ061xPeM0SAlI+sIZD5SlsHyDxL0xY4PwaLo
# LFH3c7y9hbFig3NBggfkOItqcyDQD2RzPJ6fpjOp/RnfJZPRAgMBAAGjggHNMIIB
# yTASBgNVHRMBAf8ECDAGAQH/AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAK
# BggrBgEFBQcDAzB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9v
# Y3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGln
# aWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHow
# eDA6oDigNoY0aHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJl
# ZElEUm9vdENBLmNybDA6oDigNoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0Rp
# Z2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDBPBgNVHSAESDBGMDgGCmCGSAGG/WwA
# AgQwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAK
# BghghkgBhv1sAzAdBgNVHQ4EFgQUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHwYDVR0j
# BBgwFoAUReuir/SSy4IxLVGLp6chnfNtyA8wDQYJKoZIhvcNAQELBQADggEBAD7s
# DVoks/Mi0RXILHwlKXaoHV0cLToaxO8wYdd+C2D9wz0PxK+L/e8q3yBVN7Dh9tGS
# dQ9RtG6ljlriXiSBThCk7j9xjmMOE0ut119EefM2FAaK95xGTlz/kLEbBw6RFfu6
# r7VRwo0kriTGxycqoSkoGjpxKAI8LpGjwCUR4pwUR6F6aGivm6dcIFzZcbEMj7uo
# +MUSaJ/PQMtARKUT8OZkDCUIQjKyNookAv4vcn4c10lFluhZHen6dGRrsutmQ9qz
# sIzV6Q3d9gEgzpkxYz0IGhizgZtPxpMQBvwHgfqL2vmCSfdibqFT+hKUGIUukpHq
# aGxEMrJmoecYpJpkUe8wggVoMIIEUKADAgECAhAKRecO+XBAYPQ5XoaaebXrMA0G
# CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ
# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0
# IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMTcwNDEzMDAwMDAw
# WhcNMjAwNDE1MTIwMDAwWjCBpDELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcw
# FQYDVQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMVSGVhbHRoIENhdGFseXN0
# LCBJbmMuMR4wHAYDVQQDExVIZWFsdGggQ2F0YWx5c3QsIEluYy4xLzAtBgkqhkiG
# 9w0BCQEWIGFkbWluaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjANBgkq
# hkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAv8AEfB5imOv8J17fvW8w+WKuE0keRub9
# 1+QzkiI+nSa9y2yADr/ZCEXqxGqDKdg47CjlvpOmKg8K88NPaTPvGN5fm7p7avmn
# Cfp7IGXLGtutZ1RnFW2fYC8+kl86WinKVQ7eHLe7Rsvn9CyurIzttJpJcTikxqrr
# U45yE8Iw/H9ziiwP+grfm8AiGN3C2vuxbhs8YwG2pbbn2aa5hN5q4bbFzoQ4xHGO
# kFiqhRYVyGbVZNeoGTpkf/DNXJh07RuSDdcFXoh7whwwvfXhrk9Z5YzE6GEk2CUF
# adTjqWHuGyfpBpY7bYZ8/mbDTmUqLNeGsTQrVmowv4r+usyK6lz6LwIDAQABo4IB
# xTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0OBBYE
# FDCXth9LjWUWNRWEPkEw5VZAVdBSMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUEDDAK
# BggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdpY2Vy
# dC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2NybDQu
# ZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUwQzA3
# BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQu
# Y29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcwAYYY
# aHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8vY2Fj
# ZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNpZ25p
# bmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAkIewxl/k
# WdhH2w7hIW0jT2WXhasjLk/UVeJtON2V7uj6J5/geg9huBlF9UDASBN9Po3sULeE
# /WQ+Lxbd3BDLq+jcENPKdEE7v9NFOCzs142tBJ+tng5uSD4KCG7wStTggI8XElpu
# 0uraecK21bq4T4A2uGXpruEVNdS8DkANh34AwLJWanhaavbqunHZMkjQU0oluktS
# ikJ1BVeyROM0Xh11VBnM5nSftS4c8eC66ZXhsuc268wwzwb3eD81jKwXdli3SrvT
# zFKtAFqzh2/1bVIceq+iT7zketpGuFTg3BOkhbiJhIEjAS9pA3v+tVKrWcdTp/HC
# mT2XH0Xyeg2GhzGCEPwwghD4AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK
# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNV
# BAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0ECEApF
# 5w75cEBg9Dlehpp5teswDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEMMQIw
# ADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4wDAYK
# KwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg1WRkyzq7P9zuYsEWeBGmqr3ZwGfL
# keDSu43fkH/7Zq8wDQYJKoZIhvcNAQEBBQAEggEASr90GfWxu1B0YkfYjtqEXHa4
# 8wYaXjDOGWD4zxWJbfUjHymwGkH/4vHGXPavK+t1uGKEFDP+gYeybvbitH3vf7rr
# Hbt4Ktox0t1AIDYzdbCmqaaCwAbCygz6q+fHc1Z399XhYdmrfH2+XDdHL7+09LWu
# dRqxcWutEY8BmmEqV1tVpUcMrlXkmPiaH4cScicnYU+s/uqUJClvYGPjcCLuGStv
# wYz+Hfy/oEN7c93yWSfRUgPHa+bDH5md/VuSe0skN6Sqf/r6mUSCT1v884OBq0ql
# egAO2BXIEiR2g/KFABQJYB1LYFUxOjcuzOqtZg3y9xN079FYPDgBFh5IlNQkKKGC
# Dsgwgg7EBgorBgEEAYI3AwMBMYIOtDCCDrAGCSqGSIb3DQEHAqCCDqEwgg6dAgED
# MQ8wDQYJYIZIAWUDBAIBBQAwdwYLKoZIhvcNAQkQAQSgaARmMGQCAQEGCWCGSAGG
# /WwHATAxMA0GCWCGSAFlAwQCAQUABCBkhwjnvMQ+F48a6Jtb+SBu/BqnVRAF/oxw
# DKsL51mvdQIQBeItpqQWjIeV698CVpP30xgPMjAxOTAxMjMxODI2MDNaoIILuzCC
# BoIwggVqoAMCAQICEAnA/EbIBEITtVmLryhPTkEwDQYJKoZIhvcNAQELBQAwcjEL
# MAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3
# LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElE
# IFRpbWVzdGFtcGluZyBDQTAeFw0xNzAxMDQwMDAwMDBaFw0yODAxMTgwMDAwMDBa
# MEwxCzAJBgNVBAYTAlVTMREwDwYDVQQKEwhEaWdpQ2VydDEqMCgGA1UEAxMhRGln
# aUNlcnQgU0hBMiBUaW1lc3RhbXAgUmVzcG9uZGVyMIIBIjANBgkqhkiG9w0BAQEF
# AAOCAQ8AMIIBCgKCAQEAnpWYajQ7cxuofvzHvilpicdoJkZfPY1ic4eBo6Gc8Ldb
# JDdaktT0Wdd2ieTc1Sfw1Wa8Cu60KzFnrFjFSpFZK0UeCQHWZLNZ7o1mTfsjXswQ
# DQuKZ+9SrqAIkMJS9/WotW6bLHud57U++3jNMlAYv0C1TIy7V/SgTxFFbEJCueWv
# 1t/0p3wKaJYP0l8pV877HTL/9BGhEyL7Esvv11PS65fLoqwbHZ1YIVGCwsLe6is/
# LCKE0EPsOzs/R8T2VtxFN5i0a3S1Wa94V2nIDwkCeN3YU8GZ22DEnequr+B+hkpc
# qVhhqF50igEoaHJOp4adtQJSh3BmSNOO74EkzNzYZQIDAQABo4IDODCCAzQwDgYD
# VR0PAQH/BAQDAgeAMAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUH
# AwgwggG/BgNVHSAEggG2MIIBsjCCAaEGCWCGSAGG/WwHATCCAZIwKAYIKwYBBQUH
# AgEWHGh0dHBzOi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwggFkBggrBgEFBQcCAjCC
# AVYeggFSAEEAbgB5ACAAdQBzAGUAIABvAGYAIAB0AGgAaQBzACAAQwBlAHIAdABp
# AGYAaQBjAGEAdABlACAAYwBvAG4AcwB0AGkAdAB1AHQAZQBzACAAYQBjAGMAZQBw
# AHQAYQBuAGMAZQAgAG8AZgAgAHQAaABlACAARABpAGcAaQBDAGUAcgB0ACAAQwBQ
# AC8AQwBQAFMAIABhAG4AZAAgAHQAaABlACAAUgBlAGwAeQBpAG4AZwAgAFAAYQBy
# AHQAeQAgAEEAZwByAGUAZQBtAGUAbgB0ACAAdwBoAGkAYwBoACAAbABpAG0AaQB0
# ACAAbABpAGEAYgBpAGwAaQB0AHkAIABhAG4AZAAgAGEAcgBlACAAaQBuAGMAbwBy
# AHAAbwByAGEAdABlAGQAIABoAGUAcgBlAGkAbgAgAGIAeQAgAHIAZQBmAGUAcgBl
# AG4AYwBlAC4wCwYJYIZIAYb9bAMVMB8GA1UdIwQYMBaAFPS24SAd/imu0uRhpbKi
# JbLIFzVuMB0GA1UdDgQWBBThpzJK7gEhKH1U1fIHkm60Bw89hzBxBgNVHR8EajBo
# MDKgMKAuhixodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVkLXRz
# LmNybDAyoDCgLoYsaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl
# ZC10cy5jcmwwgYUGCCsGAQUFBwEBBHkwdzAkBggrBgEFBQcwAYYYaHR0cDovL29j
# c3AuZGlnaWNlcnQuY29tME8GCCsGAQUFBzAChkNodHRwOi8vY2FjZXJ0cy5kaWdp
# Y2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEVGltZXN0YW1waW5nQ0EuY3J0
# MA0GCSqGSIb3DQEBCwUAA4IBAQAe8EGCMq7t8bQ1E9xQwtWXriIinQ4OrzPTTP18
# v28BEaeUZSJcxiKhyIlSa5qMc1zZXj8y3hZgTIs2/TGZCr3BhLeNHe+JJhMFVvNH
# zUdbrYSyOK9qI7VF4x6IMkaA0remmSL9wXjP9YvYDIwFCe5E5oDVbXDMn1MeJ90q
# SN7ak2WtbmWjmafCQA5zzFhPj0Uo5byciOYozmBdLSVdi3MupQ1bUdqaTv9QBYko
# 2vJ4u9JYeI1Ep6w6AJF4aYlkBNNdlt8qv/mlTCyT/+aK3YKs8dKzooaawVWJVmpH
# P/rWM5VDNYkFeFo6adoiuARD029oNTZ6FD5F6Zhkhg8TDCZKMIIFMTCCBBmgAwIB
# AgIQCqEl1tYyG35B5AXaNpfCFTANBgkqhkiG9w0BAQsFADBlMQswCQYDVQQGEwJV
# UzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQu
# Y29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3QgQ0EwHhcNMTYw
# MTA3MTIwMDAwWhcNMzEwMTA3MTIwMDAwWjByMQswCQYDVQQGEwJVUzEVMBMGA1UE
# ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYD
# VQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQgVGltZXN0YW1waW5nIENBMIIB
# IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvdAy7kvNj3/dqbqCmcU5VChX
# tiNKxA4HRTNREH3Q+X1NaH7ntqD0jbOI5Je/YyGQmL8TvFfTw+F+CNZqFAA49y4e
# O+7MpvYyWf5fZT/gm+vjRkcGGlV+Cyd+wKL1oODeIj8O/36V+/OjuiI+GKwR5PCZ
# A207hXwJ0+5dyJoLVOOoCXFr4M8iEA91z3FyTgqt30A6XLdR4aF5FMZNJCMwXbzs
# PGBqrC8HzP3w6kfZiFBe/WZuVmEnKYmEUeaC50ZQ/ZQqLKfkdT66mA+Ef58xFNat
# 1fJky3seBdCEGXIX8RcG7z3N1k3vBkL9olMqT4UdxB08r8/arBD13ays6Vb/kwID
# AQABo4IBzjCCAcowHQYDVR0OBBYEFPS24SAd/imu0uRhpbKiJbLIFzVuMB8GA1Ud
# IwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMBIGA1UdEwEB/wQIMAYBAf8CAQAw
# DgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMIMHkGCCsGAQUFBwEB
# BG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsG
# AQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1
# cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5k
# aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRo
# dHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu
# Y3JsMFAGA1UdIARJMEcwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRw
# czovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAsGCWCGSAGG/WwHATANBgkqhkiG9w0B
# AQsFAAOCAQEAcZUS6VGHVmnN793afKpjerN4zwY3QITvS4S/ys8DAv3Fp8MOIEIs
# r3fzKx8MIVoqtwU0HWqumfgnoma/Capg33akOpMP+LLR2HwZYuhegiUexLoceywh
# 4tZbLBQ1QwRostt1AuByx5jWPGTlH0gQGF+JOGFNYkYkh2OMkVIsrymJ5Xgf1gsU
# pYDXEkdws3XVk4WTfraSZ/tTYYmo9WuWwPRYaQ18yAGxuSh1t5ljhSKMYcp5lH5Z
# /IwP42+1ASa2bKXuh1Eh5Fhgm7oMLSttosR+u8QlK0cCCHxJrhO24XxCQijGGFbP
# QTS2Zl22dHv1VjMiLyI2skuiSpXY9aaOUjGCAk0wggJJAgEBMIGGMHIxCzAJBgNV
# BAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdp
# Y2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBUaW1l
# c3RhbXBpbmcgQ0ECEAnA/EbIBEITtVmLryhPTkEwDQYJYIZIAWUDBAIBBQCggZgw
# GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0xOTAx
# MjMxODI2MDNaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFEABkUdcmIkd66EEr0cJ
# G1621MvLMC8GCSqGSIb3DQEJBDEiBCClkXsE0+OaQabptZfFyi4h/wUVeE7TfvxV
# ZkilaVBt+zANBgkqhkiG9w0BAQEFAASCAQB61Yv8kROc7ErR/r4Yr6D39K7wToyN
# GgW3fSQuWV03Z4aP5RIF22ji6RSAvUIWoK49a7U5v4q/A9UyvP8W+fedR09g2jNq
# 0hEUjzH1ND/qVFy2QkNznms3cyQff65n2XTh8ma08qbUA6cVtp+aaK+fcDyJ3ANO
# Vqx8BZHkTCo/stCRkCfCvoPsKJRP0f6dUsU6NmuvWD6E1QS4a/3C00XvzoRzQYjb
# aXrmCr3EUHhPeOsmAhGPga8Vptg+bW6Z4e+ldhbOxpqwmIPPyD5QEl2T5RQc6Gw/
# 1gcBWzA8+E/XvsuauGV1C2QkJ8lJ4mj7naWFvA3+ffNkmVddBSI4y6nn
# SIG # End signature block