HCPosh

3.0.12.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', 'Script', '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) {

                switch ($Binding.BindingType) {

                    'SqlBinding' { 

                        $OutFile = "$($SplitDirectory)\SQL-$($Binding.ClassificationCode)-$(Get-CleanFileName $Binding.BindingName -RemoveSpace).sql"

                        $Binding.Script | Out-File $OutFile -Encoding Default -Force

                    }

                    'RBinding' {

                        $OutFile = "$($SplitDirectory)\R-$($Binding.ClassificationCode)-$(Get-CleanFileName $Binding.BindingName -RemoveSpace).r"

                        $Binding.Script | 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

# MIIaxgYJKoZIhvcNAQcCoIIatzCCGrMCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCB8SvJMywMufgoO

# sNB3Y5h7FNSjxh2NVDiedoefsCqlMqCCCqMwggUwMIIEGKADAgECAhAECRgbX9W7

# 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

# aGxEMrJmoecYpJpkUe8wggVrMIIEU6ADAgECAhAMMCpTLsjxo9FR9hag8ePUMA0G

# CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ

# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0

# IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMjAwMzMxMDAwMDAw

# WhcNMjMwNTEwMTIwMDAwWjCBpzELMAkGA1UEBhMCVVMxDTALBgNVBAgTBFV0YWgx

# FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5

# c3QsIEluYy4xHjAcBgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjEwMC4GCSqG

# SIb3DQEJARYhYWRtaW5uaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjAN

# BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA2fY0HWdxDJezDOsbHp7f9u/lrrD5

# nuZ1mENMgvixlrtC/KXgBRXlcWH7ajIOKljKnWCSAZwlZy4nFGbMagKmMzohXUXg

# xo94u5nCdiBa/kgPazNGpL0AyGgX2VARMbcpm8Gdy+/uH3Kc7L91lcoGZVVBnVIt

# 1oj5iXURqmhL83TrMyYqyj3XOH0So8Y10FVLPSukocMzMqBIRgvn/7EP0iWtOjXx

# +o1wB5Ql+z9G3NCqF6CKE/Pn355XYbbmjF7BPzKoOjocHO6VU2uEflJWq1ZFb0QY

# /tAosyyLYi9kFfO1damtJfRbbsVqavwg2UeQkzhg9CpB6eSsmBXPlFHudQIDAQAB

# o4IBxTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0O

# BBYEFFjfHOOIre2C4m9NCk8TFJlDwMxUMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUE

# DDAKBggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdp

# Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2Ny

# bDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUw

# QzA3BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNl

# cnQuY29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcw

# AYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8v

# Y2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNp

# Z25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAsBxn

# 9yJAQi+9cJPZpJvOEV6iHaOBGv8898wNJCc4eB5g8WPziEY70GZVeqEdx3z0wS8U

# QQIr19Hkju2NFZjDtzB9z1jAc/9EgqFGoCZbPijv1EYAa2oOVAp1BPbLjqBSdXqu

# 2mzqo14CJ30oNom9ep9F6LGZ5zEoPsMrJejSbJGr4EacrksX8C8qeFklc7FzwiGk

# GX7IQxidrrhOm2fOvGGAAxnvNYAR0FqJK0LiWWPSt5R/j63H/6HQtqD2sLevI3+O

# bRP74TPchDobFmWlSogX9oB63E7fsbDAqecY0cRPQ6tVWK53Ke2sB514nahFjZDa

# mxsa3/acZWL659ly3jGCD3kwgg91AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD

# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv

# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC

# EAwwKlMuyPGj0VH2FqDx49QwDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEM

# MQIwADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w

# DAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg4A+0v4hiZ4n/d8BeyRzOvTFV

# hnJWIbItcBKAkNM0BPcwDQYJKoZIhvcNAQEBBQAEggEASilCnPGSwnS2shi5dzkE

# jytMBLJ2hhZKZUOEndLhESGO+F1JNZOiZ/HH0xp531znl1nXpnkhuUvWfm36HHOX

# XSncHmzL7eVNkJ9AmEQ2kF1oe1yIXo4dTh4tadD/PK7Q3SYkui725yYMihLg+yPI

# CnR4eYa/di+Nem9Ok1i6nD/ZWZtzH3lajX9fh7P2WNqqblLjH/ZYy+pbRGwaz+Ji

# gypfiVxW2Ew1XKzmcvTYmlNpYIjEF0YXz6HsaVlGHg1Cu4I3T1AfgjeeFpOVpDZY

# hGPqogg3mo0IStn5bTV4et8zLPwKliwh8m8tP2ZEbx0wW1FUV3fdT6XHdT1Gyilx

# 76GCDUUwgg1BBgorBgEEAYI3AwMBMYINMTCCDS0GCSqGSIb3DQEHAqCCDR4wgg0a

# AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG

# SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCDdgyec4VQcqksq864CEacd1Pzk2ezd

# PeoK96mDmT76XwIRAL9hcGldS2kQgrHvO23S96IYDzIwMjEwNTA3MjEzNzI2WqCC

# CjcwggT+MIID5qADAgECAhANQkrgvjqI/2BAIc4UAPDdMA0GCSqGSIb3DQEBCwUA

# MHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsT

# EHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJl

# ZCBJRCBUaW1lc3RhbXBpbmcgQ0EwHhcNMjEwMTAxMDAwMDAwWhcNMzEwMTA2MDAw

# MDAwWjBIMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xIDAe

# BgNVBAMTF0RpZ2lDZXJ0IFRpbWVzdGFtcCAyMDIxMIIBIjANBgkqhkiG9w0BAQEF

# AAOCAQ8AMIIBCgKCAQEAwuZhhGfFivUNCKRFymNrUdc6EUK9CnV1TZS0DFC1JhD+

# HchvkWsMlucaXEjvROW/m2HNFZFiWrj/ZwucY/02aoH6KfjdK3CF3gIY83htvH35

# x20JPb5qdofpir34hF0edsnkxnZ2OlPR0dNaNo/Go+EvGzq3YdZz7E5tM4p8XUUt

# S7FQ5kE6N1aG3JMjjfdQJehk5t3Tjy9XtYcg6w6OLNUj2vRNeEbjA4MxKUpcDDGK

# SoyIxfcwWvkUrxVfbENJCf0mI1P2jWPoGqtbsR0wwptpgrTb/FZUvB+hh6u+elsK

# IC9LCcmVp42y+tZji06lchzun3oBc/gZ1v4NSYS9AQIDAQABo4IBuDCCAbQwDgYD

# VR0PAQH/BAQDAgeAMAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUH

# AwgwQQYDVR0gBDowODA2BglghkgBhv1sBwEwKTAnBggrBgEFBQcCARYbaHR0cDov

# L3d3dy5kaWdpY2VydC5jb20vQ1BTMB8GA1UdIwQYMBaAFPS24SAd/imu0uRhpbKi

# JbLIFzVuMB0GA1UdDgQWBBQ2RIaOpLqwZr68KC0dRDbd42p6vDBxBgNVHR8EajBo

# MDKgMKAuhixodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVkLXRz

# LmNybDAyoDCgLoYsaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl

# ZC10cy5jcmwwgYUGCCsGAQUFBwEBBHkwdzAkBggrBgEFBQcwAYYYaHR0cDovL29j

# c3AuZGlnaWNlcnQuY29tME8GCCsGAQUFBzAChkNodHRwOi8vY2FjZXJ0cy5kaWdp

# Y2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEVGltZXN0YW1waW5nQ0EuY3J0

# MA0GCSqGSIb3DQEBCwUAA4IBAQBIHNy16ZojvOca5yAOjmdG/UJyUXQKI0ejq5LS

# JcRwWb4UoOUngaVNFBUZB3nw0QTDhtk7vf5EAmZN7WmkD/a4cM9i6PVRSnh5Nnon

# t/PnUp+Tp+1DnnvntN1BIon7h6JGA0789P63ZHdjXyNSaYOC+hpT7ZDMjaEXcw30

# 82U5cEvznNZ6e9oMvD0y0BvL9WH8dQgAdryBDvjA4VzPxBFy5xtkSdgimnUVQvUt

# MjiB2vRgorq0Uvtc4GEkJU+y38kpqHNDUdq9Y9YfW5v3LhtPEx33Sg1xfpe39D+E

# 68Hjo0mh+s6nv1bPull2YYlffqe0jmd4+TaY4cso2luHpoovMIIFMTCCBBmgAwIB

# 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

# c3RhbXBpbmcgQ0ECEA1CSuC+Ooj/YEAhzhQA8N0wDQYJYIZIAWUDBAIBBQCggZgw

# GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0yMTA1

# MDcyMTM3MjZaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFOHXgqjhkb7va8oWkbWq

# tJSmJJvzMC8GCSqGSIb3DQEJBDEiBCCUekYsSUeMhmUs1AxgFgvfV5x+lL0mXzQ7

# nIqZMQQd4zANBgkqhkiG9w0BAQEFAASCAQCo5MRnaije39dC6vjIg/Yvh++6ohSo

# YX4fW+4zscAQ1zZGbxaOYQCCxThZ6aMtFNCWeX/RAg+c5eX6K2johJlCHeWC68oS

# Db8Q2G3uIGWPEMQ/XXk4hAneuIJTniQvbOCAUJ6N7sogXlynH62Bnk9uD4H39VKm

# uBabf8cJGq28rUIPp4lN+xKpUFspsQbOhFNSOH0Oc8ZYBUQAt0M6Rii8UoMQJYv2

# Xh2q47Xj4oX4DF9mUdKUhiFRNvhMb+2Oe4kFdD7tAfjOViWyuu9+5yXZJK2Ms6FV

# OpJFbqh08IvCxVW5GrpxmjEybWMt/7vzqNKMd8DFPQv5Z19GUbfhb0wE

# SIG # End signature block