functions/Invoke-Installer.ps1
|
class Id { [int] $Id = 0 [int] GetNewId() { $this.Id-- return $this.Id } } class DataMart { #[int] $Id #[guid] $ContentId [string] $Name [string] $DataMartType [string] $Description [string] $SqlAgentProxyName [string] $SqlCredentialName [decimal] $DefaultEngineVersion [string] $SystemName [string] $DataStewardFullName [string] $DataStewardEmail [string] $Version [string] $IsHidden [Connection[]] $Connections [Entity[]] $Entities [Binding[]] $Bindings [ObjectAttributeValue[]] $AttributeValues } class Connection { [int] $Id #[guid] $ContentId [string] $SystemName [string] $Description [string] $DataSystemTypeCode [string] $DataSystemVersion [string] $SystemVendorName [string] $SystemVersion [ObjectAttributeValue[]] $AttributeValues } class Entity { [int] $Id #[guid] $ContentId [int] $ConnectionId [string] $BusinessDescription [string] $EntityName [string] $TechnicalDescription [string] $PersistenceType [bool] $IsPublic [bool] $AllowsDataEntry [int] $RecordCountMismatchThreshold [nullable[int]] $RecordCount [nullable[system.datetimeoffset]] $LastSuccessfulLoadTimestamp [nullable[system.datetimeoffset]] $LastModifiedTimestamp [nullable[system.datetimeoffset]] $LastDeployedTimestamp [Field[]] $Fields [Index[]] $Indexes [ObjectAttributeValue[]] $AttributeValues } class Binding { #[int] $Id #[guid] $ContentId [string] $Name [int] $DestinationEntityId [int] $SourceConnectionId [string] $BindingType [string] $Classification [string] $Description [string] $LoadTypeCode [string] $Status [string] $GroupingColumn [string] $GroupingFormat [string] $GrainName [ObjectAttributeValue[]] $AttributeValues } class Field { [int] $Id #[guid] $ContentId [string] $FieldName [string] $BusinessDescription [string] $TechnicalDescription [string] $DataType [string] $DefaultValue [string] $DataSensitivity [nullable[int]] $Ordinal [string] $Status [string] $ExampleData # [nullable[system.datetimeoffset]] $ExampleDataUpdatetimestamp [bool] $IsPrimaryKey [bool] $IsNullable [bool] $IsAutoIncrement [bool] $ExcludeFromBaseView [bool] $IsSystemField [ObjectAttributeValue[]] $AttributeValues } class Index { [int] $Id #[guid] $ContentId [string] $IndexName [bool] $IsUnique [bool] $IsActive [string] $IndexTypeCode [bool] $IsColumnStore [bool] $IsCapSystem [nullable[system.datetimeoffset]] $LastModifiedTimestamp [nullable[system.datetimeoffset]] $LastDeployedTimestamp [IndexField[]] $IndexFields } class IndexField { [int] $Id [int] $IndexId [nullable[int]] $FieldId [int] $Ordinal [bool] $IsDescending [bool] $IsCovering } class ObjectAttributeValue { [string] $AttributeName [string] $AttributeValue } function NullableString { param([string] $Text) if ([string]::IsNullOrEmpty($Text)) { return [nullstring]::value } else { return $Text -replace "‘‘", """" -replace "’’", """" -replace "’", "'" } } function True {return "1"} function False {return "0"} function Invoke-Installer { [CmdletBinding()] param ( [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [string]$File, [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [string]$OutDir ) process { try { Test-Path $File | Out-Null; $InputFile = Get-Item $File $FileDirectory = Split-Path $File -Parent $Msg = "INSTALLER - $(Split-Path $File -Leaf)"; Write-Host $Msg -ForegroundColor Magenta; Write-Verbose $Msg; Write-Log $Msg; } catch { $Msg = "$(" " * 8)Unable to find any hcx files."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error'; } if ($InputFile.Extension -eq '.hcx') { try { $Msg = "$(" " * 4)Unzipping hcx file..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; Copy-Item -Path $File -Destination $File.Replace('.hcx', '.zip') -Force | Out-Null $ZipFile = $File.Replace('.hcx', '.zip') $OutBin = "$($FileDirectory)\$((Split-Path $File -Leaf).Replace('.hcx', '_bin'))" $Zipoutdir = "$($OutBin)\$((Split-Path $File -Leaf).Replace('.hcx', '_zip'))" if (Test-Path $OutBin) { Remove-Item $OutBin -Force -Recurse | Out-Null } If (!(Test-Path $Zipoutdir)) { New-Item -ItemType Directory -Force -Path $Zipoutdir -ErrorAction Stop | Out-Null } Unzip -file $ZipFile -destination $Zipoutdir Remove-Item $ZipFile -Force | Out-Null } catch { $Msg = "$(" " * 8)Unable to unzip file."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error'; } $Msg = "$(" " * 4)Getting sam json object..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; $DataFile = Get-ChildItem $Zipoutdir -Recurse | Where-Object { $_.Extension -eq ".sam" } } elseif ($InputFile.Extension -eq '.sm') { $Msg = "$(" " * 4)Getting sm json object..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; $DataFile = $InputFile } $RawContent = (Get-Content $DataFile.FullName | Select-Object -Skip 1); try { $jsonSettings = New-Object Newtonsoft.Json.JsonSerializerSettings $jsonSettings.TypeNameHandling = 'Objects' $jsonSettings.PreserveReferencesHandling = 'Objects' $RawData = [Newtonsoft.Json.JsonConvert]::DeserializeObject($RawContent, $jsonSettings) if (Test-Path $OutBin) { Remove-Item $OutBin -Recurse -Force } } catch { $ErrorMessage = $_.Exception.Message $Msg = "$(" " * 8)Unable to deserialize json object :( --> $ErrorMessage"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error'; Exit } $Msg = "$(" " * 4)Formatting raw data to MDS format..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg; $id = [Id]::new() $ids = @{} function GetId($contentId) { if (!$ids.ContainsKey($contentId)) { $ids.Add($contentId, $id.GetNewId()) } return $ids.Item($contentId) } $DataMart = [DataMart]::new() #$DataMart.Id = GetId($RawData.ContentId) #$DataMart.ContentId = $RawData.ContentId $DataMart.Name = NullableString($RawData.DataMartNM) $DataMart.DataMartType = ($RawData.DataMartTypeDSC) $DataMart.Description = NullableString($RawData.DescriptionTXT) $DataMart.SqlAgentProxyName = NullableString($RawData.SqlAgentProxyName) $DataMart.SqlCredentialName = NullableString($RawData.SqlCredentialName) $DataMart.DefaultEngineVersion = $RawData.DefaultEngineVersionNumber $DataMart.SystemName = NullableString($RawData.SystemNM) $DataMart.DataStewardFullName = NullableString($RawData.DataStewardFullNM) $DataMart.DataStewardEmail = NullableString($RawData.DataStewardEmailTXT) $DataMart.Version = NullableString($RawData.VersionText) $DataMart.IsHidden = NullableString($RawData.IsHidden) foreach ($RawConnection in $RawData.Connections) { $Connection = [Connection]::new() $Connection.Id = GetId($RawConnection.ContentId) #$Connection.ContentId = $RawConnection.ContentId $Connection.SystemName = NullableString($RawConnection.SystemName) $Connection.Description = NullableString($RawConnection.Description) $Connection.DataSystemTypeCode = NullableString($RawConnection.DataSystemTypeCode) $Connection.DataSystemVersion = NullableString($RawConnection.DataSystemTypeVersion) $Connection.SystemVendorName = NullableString($RawConnection.SystemVendorName) $Connection.SystemVersion = NullableString($RawConnection.SystemVersion) foreach ($RawAttributeValue in $RawConnection.AttributeValues) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = $RawAttributeValue.AttributeName $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue $Connection.AttributeValues += $AttributeValue } if (!$Connection.AttributeValues) {$Connection.AttributeValues = @()} $DataMart.Connections += $Connection } if (!$DataMart.Connections) {$DataMart.Connections = @()} foreach ($RawAttributeValue in $RawData.AttributeValues) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = $RawAttributeValue.AttributeName $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue $DataMart.AttributeValues += $AttributeValue } if (!$DataMart.AttributeValues) {$DataMart.AttributeValues = @()} foreach ($RawEntity in $RawData.Tables) { $Entity = [Entity]::new() $Entity.Id = GetId($RawEntity.ContentId) #$Entity.ContentId = $RawEntity.ContentId $Entity.ConnectionId = GetId($RawEntity.DestinationConnection.ContentId) $Entity.BusinessDescription = NullableString($RawEntity.DescriptionTXT) $Entity.EntityName = NullableString($RawEntity.ViewName) $Entity.PersistenceType = "Database" $Entity.IsPublic = $RawEntity.IsPublic $Entity.AllowsDataEntry = $RawEntity.AllowsDataEntry $Entity.RecordCountMismatchThreshold = $RawEntity.RowCountMismatchThreshold $Entity.LastSuccessfulLoadTimestamp = $RawEntity.SuccessfulLastRunDate $Entity.LastModifiedTimestamp = $null $Entity.LastDeployedTimestamp = $null if ($RawEntity.DatabaseNM) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "DatabaseName" $AttributeValue.AttributeValue = $RawEntity.DatabaseNM $Entity.AttributeValues += $AttributeValue } if ($RawEntity.SchemaNM) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "SchemaName" $AttributeValue.AttributeValue = $RawEntity.SchemaNM $Entity.AttributeValues += $AttributeValue } if ($RawEntity.TableNM) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "TableName" $AttributeValue.AttributeValue = $RawEntity.TableNM $Entity.AttributeValues += $AttributeValue } if ($RawEntity.ViewName) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "ViewName" $AttributeValue.AttributeValue = $RawEntity.ViewName $Entity.AttributeValues += $AttributeValue } if ($RawEntity.FileGroup) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "FileGroupNumber" $AttributeValue.AttributeValue = $RawEntity.FileGroup $Entity.AttributeValues += $AttributeValue } if (($RawEntity.IsPersisted | Measure-Object).Count) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = "PersistedFlag" $AttributeValue.AttributeValue = (. $RawEntity.IsPersisted) <# takes value True/False and runs the True/False function; which converts to 1/0 #> $Entity.AttributeValues += $AttributeValue } foreach ($RawAttributeValue in $RawEntity.AttributeValues) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = $RawAttributeValue.AttributeName $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue $Entity.AttributeValues += $AttributeValue } if (!$Entity.AttributeValues) {$Entity.AttributeValues = @()} foreach ($RawBinding in $RawEntity.FedByBindings) { $Binding = [Binding]::new() #$Binding.Id = GetId($RawBinding.ContentId) #$Binding.ContentId = $RawBinding.ContentId $Binding.Name = NullableString($RawBinding.BindingName) $Binding.DestinationEntityId = $Entity.Id $Binding.SourceConnectionId = GetId($RawBinding.SourceConnection.ContentId) $Binding.BindingType = ($RawBinding.GetType().Name -replace "Binding", "") $Binding.Classification = NullableString($RawBinding.ClassificationCode) $Binding.Description = NullableString($RawBinding.BindingDescription) $Binding.LoadTypeCode = NullableString($RawBinding.LoadType) $Binding.Status = NullableString($RawBinding.BindingStatus) $Binding.GroupingColumn = NullableString($RawBinding.GroupingColumn) $Binding.GroupingFormat = NullableString($RawBinding.GroupingFormat) $Binding.GrainName = NullableString($RawBinding.GrainName) foreach ($RawAttributeValue in $RawBinding.AttributeValues) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = $RawAttributeValue.AttributeName $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue $Binding.AttributeValues += $AttributeValue } if (!$Binding.AttributeValues) {$Binding.AttributeValues = @()} $DataMart.Bindings += $Binding } if (!$DataMart.Bindings) {$DataMart.Bindings = @()} foreach ($RawField in $RawEntity.Columns) { $Field = [Field]::new() $Field.Id = GetId($RawField.ContentId) #$Field.ContentId = $RawField.ContentId $Field.FieldName = NullableString($RawField.ColumnNM) $Field.BusinessDescription = NullableString($RawField.DescriptionTXT) $Field.DataType = NullableString($RawField.DataTypeDSC) $Field.DefaultValue = NullableString($RawField.DefaultValueTXT) $Field.DataSensitivity = NullableString($RawField.DataSensitivityCD) $Field.Ordinal = $RawField.Ordinal $Field.Status = NullableString($RawField.Status) $Field.ExampleData = NullableString($RawField.ExampleDataTXT) # $Field.ExampleDataUpdatetimestamp = $RawField.ExampleDataUpdateDate $Field.IsPrimaryKey = $RawField.IsPrimaryKeyValue $Field.IsNullable = $RawField.IsNullableValue $Field.IsAutoIncrement = $RawField.AutoIncrement $Field.ExcludeFromBaseView = $RawField.ExcludeFromBaseViewValue $Field.IsSystemField = $RawField.IsSystemColumnValue foreach ($RawAttributeValue in $RawField.AttributeValues) { $AttributeValue = [ObjectAttributeValue]::new() $AttributeValue.AttributeName = $RawAttributeValue.AttributeName $AttributeValue.AttributeValue = $RawAttributeValue.LongTextValue + $RawAttributeValue.TextValue + $RawAttributeValue.NumberValue $Field.AttributeValues += $AttributeValue } if (!$Field.AttributeValues) {$Field.AttributeValues = @()} $Entity.Fields += $Field } if (!$Entity.Fields) {$Entity.Fields = @()} foreach ($RawIndex in $RawEntity.Indexes) { $Index = [Index]::new() $Index.Id = GetId($RawIndex.ContentId) #$Index.ContentId = $RawIndex.ContentId $Index.IndexName = NullableString($RawIndex.IndexName) $Index.IsUnique = $RawIndex.IsUnique $Index.IsActive = $RawIndex.IsActive $Index.IndexTypeCode = NullableString($RawIndex.IndexTypeCode) $Index.IsColumnStore = $RawIndex.IsColumnStore $Index.IsCapSystem = $RawIndex.IsCapSystem $Index.LastModifiedTimestamp = $RawIndex.LastModifiedTimestamp $Index.LastDeployedTimestamp = $RawIndex.LastDeployedTimestamp foreach ($RawIndexField in $RawIndex.IndexColumns) { $IndexField = [IndexField]::new() $IndexField.Id = GetId("$($RawIndexField.Index.ContentId)_$($RawIndexField.Column.ContentId)") $IndexField.IndexId = GetId($RawIndexField.Index.ContentId) $IndexField.FieldId = GetId($RawIndexField.Column.ContentId) $IndexField.Ordinal = $RawIndexField.Ordinal $IndexField.IsDescending = $RawIndexField.IsDescending $IndexField.IsCovering = $RawIndexField.IsCovering $Index.IndexFields += $IndexField } if (!$Index.IndexFields) {$Index.IndexFields = @()} $Entity.Indexes += $Index } if (!$Entity.Indexes) {$Entity.Indexes = @()} $DataMart.Entities += $Entity } if (!$DataMart.Entities) {$DataMart.Entities = @()} if (!$OutVar) { New-Directory -Dir (Split-Path $OutDir -Parent); [Newtonsoft.Json.JsonConvert]::SerializeObject($DataMart, [Newtonsoft.Json.Formatting]::Indented) | Out-File "$($OutDir).json" -Force -Encoding default $Msg = "$(" " * 4)Output to file $("$($OutDir).json")"; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg; } else { $Msg = "$(" " * 4)Output to variable"; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg; } $Msg = "Success!`r`n"; Write-Host $Msg -ForegroundColor Green; Write-Verbose $Msg; Write-Log $Msg; $Output = New-Object PSObject $Output | Add-Member -Type NoteProperty -Name RawData -Value $DataMart $Output | Add-Member -Type NoteProperty -Name Outdir -Value $OutDir return $Output } } # SIG # Begin signature block # MIIcRgYJKoZIhvcNAQcCoIIcNzCCHDMCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCBV/3CMtvCEHYSn # Pw7eslscuZjFGsOv3d9iOLJGE5W/bqCCCqAwggUwMIIEGKADAgECAhAECRgbX9W7 # 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 # KwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgXLmwmyxQtHuSxAV33yNkGn/J+mRi # M/DWxGhdrd0OLp4wDQYJKoZIhvcNAQEBBQAEggEAXJp1YnocUwXMk8JUm9lvxd7P # /4jMrrPoLR1hwOb/WQAD3Ic/YkmrM3SC0vGdgdbv+XDciXtN+++Bo3ESOQEMZJwr # lLWIuii+MEKuFLvmzZUremOiyk+qq3azrxrkkEBFUnqmpjzy+HQdEdOgSk2dVXMS # tpQhx9rECLYUGAubYVihCbj7GjRVR7R+HQIudh3sYHn6eLjSMCEegkYxfOlXcRD/ # deo/Cr87irPtRiDEj+BEUKAB0po+twSFiaZ91irGCIIBsXaxk01WOeHrelClDJcs # r2R29sFI5dWhhCpEd3s3aN0kpv23mkYvXl2L6g6xUMSdaTa/HXWzx2Why4baQqGC # Dsgwgg7EBgorBgEEAYI3AwMBMYIOtDCCDrAGCSqGSIb3DQEHAqCCDqEwgg6dAgED # MQ8wDQYJYIZIAWUDBAIBBQAwdwYLKoZIhvcNAQkQAQSgaARmMGQCAQEGCWCGSAGG # /WwHATAxMA0GCWCGSAFlAwQCAQUABCB5jADyj/jeOEnEkHpbRn5WeUndgazRTY5w # 6FXjBob9CAIQAjbhNSTZUQycCKxHWwwV4hgPMjAxOTAxMTYyMzExNTNaoIILuzCC # 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 # MTYyMzExNTNaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFEABkUdcmIkd66EEr0cJ # G1621MvLMC8GCSqGSIb3DQEJBDEiBCCAFCMhpWThSebIaGZp+cFSLulHQ6Fp/JUp # 0UPPDUOVUTANBgkqhkiG9w0BAQEFAASCAQARM8xtVZSHJMDuqjwKiVIG8+LK77B0 # i6ZSDwjBDQgDEHUeCOhtBA+B0DeCDJE5l2rXe1oWO2zUJ56ae4O7XSpdrpn7A7qd # 52SopdkWwnSqdP12T5zPzRLaCrT6eORk8QxEYZzjlfydWh1UcR69D4w+9w8waKgB # nqzBmXJSdvC7XeopC9lDg8NvhPygBo7u7aqQSq+1aYuTwJDC9aqMmOVIoSweDWLP # IZ5+w6+7JDk98jpVJxJBar6AqsedhVNCFSDQ1KiA6K6Vo9Na+K4JCRuR/mkxTc1W # Eoljg3N/jd02dslpLp8SizMX3Alhk4D+IBRQjOQvflNQZjWcsZP4l1A3 # SIG # End signature block |