functions/Invoke-Installer.ps1
function Invoke-Installer { [CmdletBinding()] param ( [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [string]$File, [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)] [string]$OutDir ) begin { $versionMinimum = [Version]'5.0' if ($versionMinimum -gt $PSVersionTable.PSVersion) { throw "This script requires PowerShell $versionMinimum" } # Get function definition files. $Functions = @( Get-ChildItem -Path "$PSScriptRoot\installer" -Filter *.ps1 -ErrorAction SilentlyContinue ) # Dot source the files foreach ($Import in @($Functions)) { try { . $Import.fullname } catch { Write-Error -Message "Failed to import function $($Import.fullname): $_" } } function True {return "1"} function False {return "0"} function NullableString { param([string] $Text) if ([string]::IsNullOrEmpty($Text)) { return [nullstring]::value } else { return $Text -replace "‘‘", """" -replace "’’", """" -replace "’", "'" } } } 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' $jsonSettings.MaxDepth = $null $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 # MIIpNAYJKoZIhvcNAQcCoIIpJTCCKSECAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCDuWEQDtu9vin+R # aHP9doTW3gfRmc6DONRe2XQOb2ESnaCCDiMwggawMIIEmKADAgECAhAIrUCyYNKc # TJ9ezam9k67ZMA0GCSqGSIb3DQEBDAUAMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK # EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNV # BAMTGERpZ2lDZXJ0IFRydXN0ZWQgUm9vdCBHNDAeFw0yMTA0MjkwMDAwMDBaFw0z # NjA0MjgyMzU5NTlaMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwg # SW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcg # UlNBNDA5NiBTSEEzODQgMjAyMSBDQTEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw # ggIKAoICAQDVtC9C0CiteLdd1TlZG7GIQvUzjOs9gZdwxbvEhSYwn6SOaNhc9es0 # JAfhS0/TeEP0F9ce2vnS1WcaUk8OoVf8iJnBkcyBAz5NcCRks43iCH00fUyAVxJr # Q5qZ8sU7H/Lvy0daE6ZMswEgJfMQ04uy+wjwiuCdCcBlp/qYgEk1hz1RGeiQIXhF # LqGfLOEYwhrMxe6TSXBCMo/7xuoc82VokaJNTIIRSFJo3hC9FFdd6BgTZcV/sk+F # LEikVoQ11vkunKoAFdE3/hoGlMJ8yOobMubKwvSnowMOdKWvObarYBLj6Na59zHh # 3K3kGKDYwSNHR7OhD26jq22YBoMbt2pnLdK9RBqSEIGPsDsJ18ebMlrC/2pgVItJ # wZPt4bRc4G/rJvmM1bL5OBDm6s6R9b7T+2+TYTRcvJNFKIM2KmYoX7BzzosmJQay # g9Rc9hUZTO1i4F4z8ujo7AqnsAMrkbI2eb73rQgedaZlzLvjSFDzd5Ea/ttQokbI # YViY9XwCFjyDKK05huzUtw1T0PhH5nUwjewwk3YUpltLXXRhTT8SkXbev1jLchAp # QfDVxW0mdmgRQRNYmtwmKwH0iU1Z23jPgUo+QEdfyYFQc4UQIyFZYIpkVMHMIRro # OBl8ZhzNeDhFMJlP/2NPTLuqDQhTQXxYPUez+rbsjDIJAsxsPAxWEQIDAQABo4IB # WTCCAVUwEgYDVR0TAQH/BAgwBgEB/wIBADAdBgNVHQ4EFgQUaDfg67Y7+F8Rhvv+ # YXsIiGX0TkIwHwYDVR0jBBgwFoAU7NfjgtJxXWRM3y5nP+e6mK4cD08wDgYDVR0P # AQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMDMHcGCCsGAQUFBwEBBGswaTAk # BggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEEGCCsGAQUFBzAC # hjVodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkUm9v # dEc0LmNydDBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsMy5kaWdpY2VydC5j # b20vRGlnaUNlcnRUcnVzdGVkUm9vdEc0LmNybDAcBgNVHSAEFTATMAcGBWeBDAED # MAgGBmeBDAEEATANBgkqhkiG9w0BAQwFAAOCAgEAOiNEPY0Idu6PvDqZ01bgAhql # +Eg08yy25nRm95RysQDKr2wwJxMSnpBEn0v9nqN8JtU3vDpdSG2V1T9J9Ce7FoFF # UP2cvbaF4HZ+N3HLIvdaqpDP9ZNq4+sg0dVQeYiaiorBtr2hSBh+3NiAGhEZGM1h # mYFW9snjdufE5BtfQ/g+lP92OT2e1JnPSt0o618moZVYSNUa/tcnP/2Q0XaG3Ryw # YFzzDaju4ImhvTnhOE7abrs2nfvlIVNaw8rpavGiPttDuDPITzgUkpn13c5Ubdld # AhQfQDN8A+KVssIhdXNSy0bYxDQcoqVLjc1vdjcshT8azibpGL6QB7BDf5WIIIJw # 8MzK7/0pNVwfiThV9zeKiwmhywvpMRr/LhlcOXHhvpynCgbWJme3kuZOX956rEnP # LqR0kq3bPKSchh/jwVYbKyP/j7XqiHtwa+aguv06P0WmxOgWkVKLQcBIhEuWTatE # QOON8BUozu3xGFYHKi8QxAwIZDwzj64ojDzLj4gLDb879M4ee47vtevLt/B3E+bn # KD+sEq6lLyJsQfmCXBVmzGwOysWGw/YmMwwHS6DTBwJqakAwSEs0qFEgu60bhQji # WQ1tygVQK+pKHJ6l/aCnHwZ05/LWUpD9r4VIIflXO7ScA+2GRfS0YW6/aOImYIbq # yK+p/pQd52MbOoZWeE4wggdrMIIFU6ADAgECAhADsuWQRbq1qj3ect5VAxkgMA0G # CSqGSIb3DQEBCwUAMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwg # SW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcg # UlNBNDA5NiBTSEEzODQgMjAyMSBDQTEwHhcNMjMwNTE2MDAwMDAwWhcNMjYwNTIw # MjM1OTU5WjBzMQswCQYDVQQGEwJVUzENMAsGA1UECBMEVXRhaDEVMBMGA1UEBxMM # U291dGggSm9yZGFuMR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5c3QsIEluYy4xHjAc # BgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjCCAiIwDQYJKoZIhvcNAQEBBQAD # ggIPADCCAgoCggIBAObA/ZMm0ngFmqmUW8QpvB5R2WwUIbCHZkoYN3LLelwf6FCX # NNCZOxBz6CppjoQ4kL1HtQNpENDPMTMxG5/lMTlZvf1mu/mYEYXOddPsgv+QP4bd # P+9w+NVE4vguFffuBSzQi8KmnrgGgDVLuhTjvN5WlP/AhzHldDNhKtkQh/bzIgrL # sivSLRo3ow2kVCzJTZYwXudZ/cI2vrNf0jKRQgcC/ao1emvt68RNQJPxDpmd4Eb5 # DOF+jd9w0Sb77/m/ir2rTbVjoLOlPxD9FlGsdB+kyMV45D9hYuD4D1s998j/wDeL # ezs/sXgrJToXS0Yjpxaul++7GVuLYgBQvB1UAVejXjDuJO2FF7gUeJihWk/OKmaW # kQTGavOt8/RcOrru1LdJ733fJnMZsmonQPokOdlUADNKBSAEskgRbD3SQ/Y9LKcm # 8w/hj9L6PSXBF/E/Kaq92SArEjkvYDlsXp7xslKgAxP26pzq7/hn2gro6/jjLUyh # xt60j8Pm0tjhOdQhCcioRO2zouopusZmPMO6H95T1PEkhd/cEmkywmMqOMVMpAUg # O796xTvZ4kjOsaQTOKvAEJDjc42EHZd2RWcVUMI41iHpNILkYHSPHe4mVQC8BdZx # qzGI6ay7U1mEvCYlMYQZwDZ/xYxI7q0YBjQOm5jVuPvAHmlE6pUiWuGz3JKXAgMB # AAGjggIDMIIB/zAfBgNVHSMEGDAWgBRoN+Drtjv4XxGG+/5hewiIZfROQjAdBgNV # HQ4EFgQUaRlF8Nw4+YnDPBwkIaUEjV2a1MowDgYDVR0PAQH/BAQDAgeAMBMGA1Ud # JQQMMAoGCCsGAQUFBwMDMIG1BgNVHR8Ega0wgaowU6BRoE+GTWh0dHA6Ly9jcmwz # LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNENvZGVTaWduaW5nUlNBNDA5 # NlNIQTM4NDIwMjFDQTEuY3JsMFOgUaBPhk1odHRwOi8vY3JsNC5kaWdpY2VydC5j # b20vRGlnaUNlcnRUcnVzdGVkRzRDb2RlU2lnbmluZ1JTQTQwOTZTSEEzODQyMDIx # Q0ExLmNybDA+BgNVHSAENzA1MDMGBmeBDAEEATApMCcGCCsGAQUFBwIBFhtodHRw # Oi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwgZQGCCsGAQUFBwEBBIGHMIGEMCQGCCsG # AQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20wXAYIKwYBBQUHMAKGUGh0 # dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNENvZGVT # aWduaW5nUlNBNDA5NlNIQTM4NDIwMjFDQTEuY3J0MAkGA1UdEwQCMAAwDQYJKoZI # hvcNAQELBQADggIBABpsvUpsQVtdpqQNUxSC3Ix3qXeJ81vNGS7sXYxlYhvEChJF # gixfjebMfHZu0YLJ3xIeX7VwW8wyF+9RkI4RnPtkJD2JSmDd2mH4y/gy138EZMHa # n+XbMeMXcsOTL9cI5zUBw86EGj/xcL5NIj9DDym8DPh9/OZY5L5sGXrO1VjA/mUM # lnpqpoNZaNsjQ7Gla6K5BC0xIoHxNYTX1uRSjmYkKdnNMTcHqOLcgxwaXzix26Bs # n1pKO+NMe3DqthjFX0Pe6Z47b3GrjEYT4IoJP0N3H1crDfpm2vlBMwdSrNvr+epH # VfZqOx8/VwS7VKygkP5Dp4zXyOa3W+11sMQIQ4AS4lER4g1GS/DmrlP2FWYGaaVJ # YB01y1tWA23V3VM/Z/aeOR3uUE8p6tc5AFu2jNa16l9f5XNp9p5Fx2QzFh6pGqBu # d0ict3T/vGWZWxzOhWqqp/Xd1oV5lMwW50t9CEKWpHidZXZZUkw2vwLnkZZzpFzs # +b1HFxPKAvBXcwWO9ZV+FGeDk09ZBy3E4hY9JaF2Z9KiYa8EMzEOtHaHAkynD6Za # TFhRSAnO3OMixVE/ro6dW7drPYKxKKYf1Y5QXaPU9ijer9ub0gnYDjPqsh3gWolp # 7vjAE7t5JDE1PQDqCuuUn8FQakB/NJVs3Nt/Xz5ADD7e6h6JADmUr1l2e4agMYIa # ZzCCGmMCAQEwfTBpMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIElu # Yy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRydXN0ZWQgRzQgQ29kZSBTaWduaW5nIFJT # QTQwOTYgU0hBMzg0IDIwMjEgQ0ExAhADsuWQRbq1qj3ect5VAxkgMA0GCWCGSAFl # AwQCAQUAoHwwEAYKKwYBBAGCNwIBDDECMAAwGQYJKoZIhvcNAQkDMQwGCisGAQQB # gjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkE # MSIEIFoU6W5840rUvBSY/SdAMxcVt3DNYP01Y7PRkyJ/tKdjMA0GCSqGSIb3DQEB # AQUABIICAIl/xjmQCoyaoPgUwgkp/ns63c/mL3Rl0+w7qYGN3EKh/fiUGub+hET5 # 6oK6U+cIUdxr8ZBUpjAUI9phZT3o65aUi/GGhR4XAcsrGtbjD5pz8+RuuMJhPX9g # 2fNbFbM5ea+4ADoBMkyRdWACGQRFRV7oJY1/6OZ4dCUcm/5K0mNpvmKsqKknTA19 # itdKqYFhoIqTfoH6GLwlO5J/89SEPIkKmw0kdLDP47DxKiukb9XNDJnx1WW+C+5l # RVpNwMMnJ2gnx2gyIPN+mTN9rfcthL4lWIpQ0BJWYoAYrgPkpBmSoVoEyo+qOhdI # 22NcFEt+WDIW2w5olzKK6uLhQJTlqp2ne4KoajNWdmQzQkyZjtieUC8/INz8v+0W # 9vyZyCrSnzomW5hfLCA58WfvKxvxWBoYliiIxO7fnFBrD1DEHbEJ2JjNcASw4za8 # 7x4d+gNYJX7BEjrJZcdGa8vD/pzWne6qeGUJIhwcPPQD5BylMOkPcb0pErYBZ0KA # wbkBQC9VhzQh/16S7Zefo88+WTJzJzQHD7b889g9FezNN1eE343jAHSvhUoIR89Z # N/mSZHHUa0dIwhsmPl3/IMcvwo6TO2r/FjJ3Oh5etfc8PUSpg6Fn10mqoq43VbrV # EdMGjBKp+g0fGNh+QiLTJ98jQaogPqs7IbDgBMMHsn6aGlVdDKapoYIXPTCCFzkG # CisGAQQBgjcDAwExghcpMIIXJQYJKoZIhvcNAQcCoIIXFjCCFxICAQMxDzANBglg # hkgBZQMEAgEFADB3BgsqhkiG9w0BCRABBKBoBGYwZAIBAQYJYIZIAYb9bAcBMDEw # DQYJYIZIAWUDBAIBBQAEIAOk0KDRyN9negLpH23db4TIVqGxIXUv00c6iPKtRrfb # AhB0DPGsnze0jdaATF6bnpNFGA8yMDIzMDUxNzE3MDkyN1qgghMHMIIGwDCCBKig # AwIBAgIQDE1pckuU+jwqSj0pB4A9WjANBgkqhkiG9w0BAQsFADBjMQswCQYDVQQG # EwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xOzA5BgNVBAMTMkRpZ2lDZXJ0 # IFRydXN0ZWQgRzQgUlNBNDA5NiBTSEEyNTYgVGltZVN0YW1waW5nIENBMB4XDTIy # MDkyMTAwMDAwMFoXDTMzMTEyMTIzNTk1OVowRjELMAkGA1UEBhMCVVMxETAPBgNV # BAoTCERpZ2lDZXJ0MSQwIgYDVQQDExtEaWdpQ2VydCBUaW1lc3RhbXAgMjAyMiAt # IDIwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQDP7KUmOsap8mu7jcEN # mtuh6BSFdDMaJqzQHFUeHjZtvJJVDGH0nQl3PRWWCC9rZKT9BoMW15GSOBwxApb7 # crGXOlWvM+xhiummKNuQY1y9iVPgOi2Mh0KuJqTku3h4uXoW4VbGwLpkU7sqFudQ # SLuIaQyIxvG+4C99O7HKU41Agx7ny3JJKB5MgB6FVueF7fJhvKo6B332q27lZt3i # XPUv7Y3UTZWEaOOAy2p50dIQkUYp6z4m8rSMzUy5Zsi7qlA4DeWMlF0ZWr/1e0Bu # bxaompyVR4aFeT4MXmaMGgokvpyq0py2909ueMQoP6McD1AGN7oI2TWmtR7aeFgd # Oej4TJEQln5N4d3CraV++C0bH+wrRhijGfY59/XBT3EuiQMRoku7mL/6T+R7Nu8G # RORV/zbq5Xwx5/PCUsTmFntafqUlc9vAapkhLWPlWfVNL5AfJ7fSqxTlOGaHUQhr # +1NDOdBk+lbP4PQK5hRtZHi7mP2Uw3Mh8y/CLiDXgazT8QfU4b3ZXUtuMZQpi+ZB # pGWUwFjl5S4pkKa3YWT62SBsGFFguqaBDwklU/G/O+mrBw5qBzliGcnWhX8T2Y15 # z2LF7OF7ucxnEweawXjtxojIsG4yeccLWYONxu71LHx7jstkifGxxLjnU15fVdJ9 # GSlZA076XepFcxyEftfO4tQ6dwIDAQABo4IBizCCAYcwDgYDVR0PAQH/BAQDAgeA # MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgwIAYDVR0gBBkw # FzAIBgZngQwBBAIwCwYJYIZIAYb9bAcBMB8GA1UdIwQYMBaAFLoW2W1NhS9zKXaa # L3WMaiCPnshvMB0GA1UdDgQWBBRiit7QYfyPMRTtlwvNPSqUFN9SnDBaBgNVHR8E # UzBRME+gTaBLhklodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVz # dGVkRzRSU0E0MDk2U0hBMjU2VGltZVN0YW1waW5nQ0EuY3JsMIGQBggrBgEFBQcB # AQSBgzCBgDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMFgG # CCsGAQUFBzAChkxodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRU # cnVzdGVkRzRSU0E0MDk2U0hBMjU2VGltZVN0YW1waW5nQ0EuY3J0MA0GCSqGSIb3 # DQEBCwUAA4ICAQBVqioa80bzeFc3MPx140/WhSPx/PmVOZsl5vdyipjDd9Rk/BX7 # NsJJUSx4iGNVCUY5APxp1MqbKfujP8DJAJsTHbCYidx48s18hc1Tna9i4mFmoxQq # RYdKmEIrUPwbtZ4IMAn65C3XCYl5+QnmiM59G7hqopvBU2AJ6KO4ndetHxy47JhB # 8PYOgPvk/9+dEKfrALpfSo8aOlK06r8JSRU1NlmaD1TSsht/fl4JrXZUinRtytIF # Zyt26/+YsiaVOBmIRBTlClmia+ciPkQh0j8cwJvtfEiy2JIMkU88ZpSvXQJT657i # nuTTH4YBZJwAwuladHUNPeF5iL8cAZfJGSOA1zZaX5YWsWMMxkZAO85dNdRZPkOa # GK7DycvD+5sTX2q1x+DzBcNZ3ydiK95ByVO5/zQQZ/YmMph7/lxClIGUgp2sCovG # SxVK05iQRWAzgOAj3vgDpPZFR+XOuANCR+hBNnF3rf2i6Jd0Ti7aHh2MWsgemtXC # 8MYiqE+bvdgcmlHEL5r2X6cnl7qWLoVXwGDneFZ/au/ClZpLEQLIgpzJGgV8unG1 # TnqZbPTontRamMifv427GFxD9dAq6OJi7ngE273R+1sKqHB+8JeEeOMIA11HLGOo # JTiXAdI/Otrl5fbmm9x+LMz/F0xNAKLY1gEOuIvu5uByVYksJxlh9ncBjDCCBq4w # ggSWoAMCAQICEAc2N7ckVHzYR6z9KGYqXlswDQYJKoZIhvcNAQELBQAwYjELMAkG # A1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRp # Z2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGlnaUNlcnQgVHJ1c3RlZCBSb290IEc0MB4X # DTIyMDMyMzAwMDAwMFoXDTM3MDMyMjIzNTk1OVowYzELMAkGA1UEBhMCVVMxFzAV # BgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVzdGVk # IEc0IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQTCCAiIwDQYJKoZIhvcN # AQEBBQADggIPADCCAgoCggIBAMaGNQZJs8E9cklRVcclA8TykTepl1Gh1tKD0Z5M # om2gsMyD+Vr2EaFEFUJfpIjzaPp985yJC3+dH54PMx9QEwsmc5Zt+FeoAn39Q7SE # 2hHxc7Gz7iuAhIoiGN/r2j3EF3+rGSs+QtxnjupRPfDWVtTnKC3r07G1decfBmWN # lCnT2exp39mQh0YAe9tEQYncfGpXevA3eZ9drMvohGS0UvJ2R/dhgxndX7RUCyFo # bjchu0CsX7LeSn3O9TkSZ+8OpWNs5KbFHc02DVzV5huowWR0QKfAcsW6Th+xtVhN # ef7Xj3OTrCw54qVI1vCwMROpVymWJy71h6aPTnYVVSZwmCZ/oBpHIEPjQ2OAe3Vu # JyWQmDo4EbP29p7mO1vsgd4iFNmCKseSv6De4z6ic/rnH1pslPJSlRErWHRAKKtz # Q87fSqEcazjFKfPKqpZzQmiftkaznTqj1QPgv/CiPMpC3BhIfxQ0z9JMq++bPf4O # uGQq+nUoJEHtQr8FnGZJUlD0UfM2SU2LINIsVzV5K6jzRWC8I41Y99xh3pP+OcD5 # sjClTNfpmEpYPtMDiP6zj9NeS3YSUZPJjAw7W4oiqMEmCPkUEBIDfV8ju2TjY+Cm # 4T72wnSyPx4JduyrXUZ14mCjWAkBKAAOhFTuzuldyF4wEr1GnrXTdrnSDmuZDNIz # tM2xAgMBAAGjggFdMIIBWTASBgNVHRMBAf8ECDAGAQH/AgEAMB0GA1UdDgQWBBS6 # FtltTYUvcyl2mi91jGogj57IbzAfBgNVHSMEGDAWgBTs1+OC0nFdZEzfLmc/57qY # rhwPTzAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAwwCgYIKwYBBQUHAwgwdwYIKwYB # BQUHAQEEazBpMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20w # QQYIKwYBBQUHMAKGNWh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2Vy # dFRydXN0ZWRSb290RzQuY3J0MEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwz # LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRSb290RzQuY3JsMCAGA1UdIAQZ # MBcwCAYGZ4EMAQQCMAsGCWCGSAGG/WwHATANBgkqhkiG9w0BAQsFAAOCAgEAfVmO # wJO2b5ipRCIBfmbW2CFC4bAYLhBNE88wU86/GPvHUF3iSyn7cIoNqilp/GnBzx0H # 6T5gyNgL5Vxb122H+oQgJTQxZ822EpZvxFBMYh0MCIKoFr2pVs8Vc40BIiXOlWk/ # R3f7cnQU1/+rT4osequFzUNf7WC2qk+RZp4snuCKrOX9jLxkJodskr2dfNBwCnzv # qLx1T7pa96kQsl3p/yhUifDVinF2ZdrM8HKjI/rAJ4JErpknG6skHibBt94q6/ae # sXmZgaNWhqsKRcnfxI2g55j7+6adcq/Ex8HBanHZxhOACcS2n82HhyS7T6NJuXdm # kfFynOlLAlKnN36TU6w7HQhJD5TNOXrd/yVjmScsPT9rp/Fmw0HNT7ZAmyEhQNC3 # EyTN3B14OuSereU0cZLXJmvkOHOrpgFPvT87eK1MrfvElXvtCl8zOYdBeHo46Zzh # 3SP9HSjTx/no8Zhf+yvYfvJGnXUsHicsJttvFXseGYs2uJPU5vIXmVnKcPA3v5gA # 3yAWTyf7YGcWoWa63VXAOimGsJigK+2VQbc61RWYMbRiCQ8KvYHZE/6/pNHzV9m8 # BPqC3jLfBInwAM1dwvnQI38AC+R2AibZ8GV2QqYphwlHK+Z/GqSFD/yYlvZVVCsf # gPrA8g4r5db7qS9EFUrnEw4d2zc4GqEr9u3WfPwwggWNMIIEdaADAgECAhAOmxiO # +dAt5+/bUOIIQBhaMA0GCSqGSIb3DQEBDAUAMGUxCzAJBgNVBAYTAlVTMRUwEwYD # VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAi # BgNVBAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0yMjA4MDEwMDAw # MDBaFw0zMTExMDkyMzU5NTlaMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdp # Q2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERp # Z2lDZXJ0IFRydXN0ZWQgUm9vdCBHNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCC # AgoCggIBAL/mkHNo3rvkXUo8MCIwaTPswqclLskhPfKK2FnC4SmnPVirdprNrnsb # hA3EMB/zG6Q4FutWxpdtHauyefLKEdLkX9YFPFIPUh/GnhWlfr6fqVcWWVVyr2iT # cMKyunWZanMylNEQRBAu34LzB4TmdDttceItDBvuINXJIB1jKS3O7F5OyJP4IWGb # NOsFxl7sWxq868nPzaw0QF+xembud8hIqGZXV59UWI4MK7dPpzDZVu7Ke13jrclP # XuU15zHL2pNe3I6PgNq2kZhAkHnDeMe2scS1ahg4AxCN2NQ3pC4FfYj1gj4QkXCr # VYJBMtfbBHMqbpEBfCFM1LyuGwN1XXhm2ToxRJozQL8I11pJpMLmqaBn3aQnvKFP # ObURWBf3JFxGj2T3wWmIdph2PVldQnaHiZdpekjw4KISG2aadMreSx7nDmOu5tTv # kpI6nj3cAORFJYm2mkQZK37AlLTSYW3rM9nF30sEAMx9HJXDj/chsrIRt7t/8tWM # cCxBYKqxYxhElRp2Yn72gLD76GSmM9GJB+G9t+ZDpBi4pncB4Q+UDCEdslQpJYls # 5Q5SUUd0viastkF13nqsX40/ybzTQRESW+UQUOsxxcpyFiIJ33xMdT9j7CFfxCBR # a2+xq4aLT8LWRV+dIPyhHsXAj6KxfgommfXkaS+YHS312amyHeUbAgMBAAGjggE6 # MIIBNjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTs1+OC0nFdZEzfLmc/57qY # rhwPTzAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzAOBgNVHQ8BAf8E # BAMCAYYweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5k # aWdpY2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0 # LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcnQwRQYDVR0fBD4wPDA6oDig # NoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9v # dENBLmNybDARBgNVHSAECjAIMAYGBFUdIAAwDQYJKoZIhvcNAQEMBQADggEBAHCg # v0NcVec4X6CjdBs9thbX979XB72arKGHLOyFXqkauyL4hxppVCLtpIh3bb0aFPQT # SnovLbc47/T/gLn4offyct4kvFIDyE7QKt76LVbP+fT3rDB6mouyXtTP0UNEm0Mh # 65ZyoUi0mcudT6cGAxN3J0TU53/oWajwvy8LpunyNDzs9wPHh6jSTEAZNUZqaVSw # uKFWjuyk1T3osdz9HNj0d1pcVIxv76FQPfx2CWiEn2/K2yCNNWAcAgPLILCsWKAO # QGPFmCLBsln1VWvPJ6tsds5vIy30fnFqI2si/xK4VC0nftg62fC2h5b9W9FcrBjD # TZ9ztwGpn1eqXijiuZQxggN2MIIDcgIBATB3MGMxCzAJBgNVBAYTAlVTMRcwFQYD # VQQKEw5EaWdpQ2VydCwgSW5jLjE7MDkGA1UEAxMyRGlnaUNlcnQgVHJ1c3RlZCBH # NCBSU0E0MDk2IFNIQTI1NiBUaW1lU3RhbXBpbmcgQ0ECEAxNaXJLlPo8Kko9KQeA # PVowDQYJYIZIAWUDBAIBBQCggdEwGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEE # MBwGCSqGSIb3DQEJBTEPFw0yMzA1MTcxNzA5MjdaMCsGCyqGSIb3DQEJEAIMMRww # GjAYMBYEFPOHIk2GM4KSNamUvL2Plun+HHxzMC8GCSqGSIb3DQEJBDEiBCAbfL1u # ZkFHXOXiSxL5NeN11JWJVOIP7QcquQy8MdUIsTA3BgsqhkiG9w0BCRACLzEoMCYw # JDAiBCDH9OG+MiiJIKviJjq+GsT8T+Z4HC1k0EyAdVegI7W2+jANBgkqhkiG9w0B # AQEFAASCAgATX7Tlk/52mNFZc3NRJodIx4m/6CcrcoWD8DN0QwMcuOx4IQQipKqL # LEUV83UGiVmwzAFw2KRqOVzg89kQIYp6WIZuIfTkUOCwoDmSwdycAFY2UJE187x2 # Lmi7tNo0tIBTBbsj4EYyeQnceaZTIWoi1UCLdWvLoxMiKXCwcSoFovGRpd84zCy9 # CfAgkrP50tqTcGznS8dM2ysyfdjgaBzMYWDvx4fxdYRqyHYGYkHqyoMB4uEcOfxc # +kjVZDBOFvS6jHeIW8wEsLGQp0T7g9hqvtyGbkrF2wMDkG03hdCJiYvUIDEHQ1Zz # kR/ikouPFRQdBndt2seVGnXItz0XatkHvvTw883qzNx5OSnr+npQLvjajYDjKWwh # TSTd4xIMS4xMyn4Vac3qBYYna7tOETTXB6a1ew7MzDlcbc1+yXGd9oVqSvNjAVEm # 6QvfW1fWZsUQUtNI5xPcfrCUV3Dt+z3F788kdzjHpFhuxVN5uYWv6CW6Z8eEqftV # hQMyBzmpVVBE8/pMJ8QLeFWCjCUV9vUBFW6VXOTHRQpdqsmY9py6Zi+M3AwM/ApS # kRWPGprVhwRrHw161eXgI4fsCvNHHdD95HPhoqGRNZXjMFQC1ve8gSJsWCBk0Ta8 # 7dNHRdrDaMlMk7O2QDFoR0A71o7hydnIETfBO63JXXJf1qtYYo8Ckg== # SIG # End signature block |