Extensions/ConvertFrom-ExistingIapSubmission.ps1
|
# Copyright (C) Microsoft Corporation. All rights reserved. <# .SYNOPSIS Script for converting an existing In-AppProduct (IAP) submission in the Store to the January 2017 PDP schema. .DESCRIPTION Script for converting an existing In-AppProduct (IAP) submission in the Store to the January 2017 PDP schema. The Git-repo for the StoreBroker module can be found here: http://aka.ms/StoreBroker .PARAMETER IapId The ID of the IAP that the PDP's will be getting created for. The most recent submission for this IAP will be used unless a SubmissionId is explicitly specified. .PARAMETER SubmissionId The ID of the application submission that the PDP's will be getting created for. The most recent submission for IapId will be used unless a value for this parameter is provided. .PARAMETER SubmissionId The submission object that you want to convert, which was previously retrieved. .PARAMETER Release The release to use. This value will be placed in each new PDP and used in conjunction with '-OutPath'. Some examples could be "1601" for a January 2016 release, "March 2016", or even just "1". .PARAMETER PdpFileName The name of the PDP file that will be generated for each region. .PARAMETER OutPath The output directory. This script will create two subfolders of OutPath: <OutPath>\PDPs\<Release>\ <OutPath>\Images\<Release>\ Each of these sub-folders will have region-specific subfolders for their file content. .EXAMPLE .\ConvertFrom-ExistingIapSubmission -IapId 0ABCDEF12345 -Release "March Release" -OutPath "C:\NewPDPs" Converts the data from the last published submission for IapId 0ABCDEF12345. The generated files will use the default name of "PDP.xml" and be located in lang-code specific sub-directories within c:\NewPDPs. .EXAMPLE .\ConvertFrom-ExistingIapSubmission -IapId 0ABCDEF12345 -SubmissionId 1234567890123456789 -Release "March Release" -PdpFileName "InAppProductDescription.xml" -OutPath "C:\NewPDPs" Converts the data from submission 1234567890123456789 for IapId 0ABCDEF12345 (which might be a published or pending submission). The generated files will be named "InAppProductDescription.xml" and will be located in lang-code specific sub-directories within c:\NewPDPs. .EXAMPLE .\ConvertFrom-ExistingIapSubmission -Submission $sub -Release "March Release" -OutPath "C:\NewPDPs" Converts the data from a submission object that was captured earlier in your PowerShell session. It might have come from Get-InAppProductSubmission, or it might have been generated some other way. This method of running the script was created more for debugging purposes, but others may find it useful. The generated files will use the default name of "PDP.xml" and be located in lang-code specific sub-directories within c:\NewPDPs. #> [CmdletBinding( SupportsShouldProcess, DefaultParametersetName = "UseApi")] param( [Parameter( Mandatory, ParameterSetName = "UseApi", Position = 0)] [string] $IapId, [Parameter( ParameterSetName = "UseApi", Position = 1)] [string] $SubmissionId = $null, [Parameter( Mandatory, ParameterSetName = "ProvideSubmission", Position = 0)] [PSCustomObject] $Submission = $null, [Parameter(Mandatory)] [string] $Release, [string] $PdpFileName = "PDP.xml", [Parameter(Mandatory)] [string] $OutPath ) # Import Write-Log $rootDir = Split-Path -Path $PSScriptRoot -Parent $helpers = "$rootDir\StoreBroker\Helpers.ps1" if (-not (Test-Path -Path $helpers -PathType Leaf)) { throw "Script execution requires Helpers.ps1 which is part of the git repo. Please execute this script from within your cloned repo." } . $helpers #region Comment Constants $script:LocIdAttribute = "_locID" $script:LocIdFormat = "Iap_{0}" $script:CommentFormat = " _locComment_text=`"{{MaxLength={0}}} {1}`" " #endregion Comment Constants function Add-ToElement { <# .SYNOPSIS Adds an arbitrary number of comments and attributes to an XmlElement. .PARAMETER Element The XmlElement to be modified. .PARAMETER Comment An array of comments to add to the element. .PARAMETER Attribute A hashtable where the keys are the attribute names and the values are the attribute values. .NOTES If a provided attribute already exists on the Element, the Element will NOT be modified. It will ONLY be modified if the Element does not have that attribute. .EXAMPLE PS C:\>$xml = [xml] (Get-Content $filePath) PS C:\>$root = $xml.DocumentElement PS C:\>Add-ToElement -Element $root -Comment "Comment1", "Comment2" -Attribute @{ "Attrib1"="Val1"; "Attrib2"="Val2" } Adds two comments and two attributes to the root element of the XML document. #> param( [Parameter(Mandatory)] [System.Xml.XmlElement] $Element, [string[]] $Comment, [hashtable] $Attribute ) if ($Comment.Count -gt 1) { # Reverse 'Comment' array in order to preserve order because of nature of 'Prepend' # Input array is modified in place, no need to capture result [Array]::Reverse($Comment) } foreach ($text in $Comment) { if (-not [String]::IsNullOrWhiteSpace($text)) { $elem = $Element.OwnerDocument.CreateComment($text) $Element.PrependChild($elem) | Out-Null } } foreach ($key in $Attribute.Keys) { if ($null -eq $Element.$key) { $Element.SetAttribute($key, $Attribute[$key]) } else { $out = "For element $($Element.LocalName), did not create attribute '$key' with value '$($Attribute[$key])' because the attribute already exists." Write-Log -Message $out -Level Warning } } } function Ensure-RootChild { <# .SYNOPSIS Creates the specified element as a child of the XML root node, only if that element does not exist already. .PARAMETER Xml The XmlDocument to (potentially) modify. .PARAMETER Element The name of the element to existence check. .OUTPUTS XmlElement. Returns a reference to the (possibly newly created) element requested. .EXAMPLE PS C:\>$xml = [xml] (Get-Content $filePath) PS C:\>Ensure-RootChild -Xml $xml -Element "SomeElement" $xml.DocumentElement.SomeElement now exists and is an XmlElement object. #> [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseApprovedVerbs", "", Justification="Best description for purpose")] param( [Parameter(Mandatory)] [System.Xml.XmlDocument] $Xml, [Parameter(Mandatory)] [string] $Element ) # ProductDescription node $root = $Xml.DocumentElement if ($root.GetElementsByTagName($Element).Count -eq 0) { $elem = $Xml.CreateElement($Element, $Xml.DocumentElement.NamespaceURI) $root.AppendChild($elem) | Out-Null } return $root.GetElementsByTagName($Element)[0] } function Add-Title { <# .SYNOPSIS Creates the Title node. .PARAMETER Xml The XmlDocument to modify. .PARAMETER Listing The base listing from the submission for a specific Lang. #> param( [Parameter(Mandatory)] [System.Xml.XmlDocument] $Xml, [Parameter(Mandatory)] [PSCustomObject] $Listing ) $elementName = "Title" $elementNode = Ensure-RootChild -Xml $Xml -Element $elementName $elementNode.InnerText = $Listing.title # Add comment to parent $maxChars = 100 $paramSet = @{ "Element" = $elementNode; "Attribute" = @{ $script:LocIdAttribute = ($script:LocIdFormat -f $elementName) }; "Comment" = @( " [required] ", ($script:CommentFormat -f $maxChars, "IAP $elementName")) } Add-ToElement @paramSet } function Add-Description { <# .SYNOPSIS Creates the description node .PARAMETER Xml The XmlDocument to modify. .PARAMETER Listing The base listing from the submission for a specific Lang. #> param( [Parameter(Mandatory)] [System.Xml.XmlDocument] $Xml, [Parameter(Mandatory)] [PSCustomObject] $Listing ) $elementName = "Description" $elementNode = Ensure-RootChild -Xml $Xml -Element $elementName $elementNode.InnerText = $Listing.description # Add comment to parent $maxChars = 200 $paramSet = @{ "Element" = $elementNode; "Attribute" = @{ $script:LocIdAttribute = ($script:LocIdFormat -f $elementName) }; "Comment" = @( " [optional] ", ($script:CommentFormat -f $maxChars, "IAP $elementName")) } Add-ToElement @paramSet } function Add-Icon { <# .SYNOPSIS Creates the icon node. .PARAMETER Xml The XmlDocument to modify. .PARAMETER Listing The base listing from the submission for a specific Lang. .OUTPUTS [String] The path specified for the icon (if available) .NOTES This function is implemented a bit differently than the others. Icon is an optional element, but if it's specified, the Filename attribute must be included with a non-empty value. This is fine if the Listing has an icon defined, but if it doesn't, then we want to include the element, but commented out so that users know later what they need to add if they wish to include an icon at some future time. We will create/add the icon node the way we do in all other cases so that we have its XML, but if we then determine that there is no icon for that listing, we'll convert the element to its XML string representation that we can add as a comment, and then remove the actual node. #> param( [Parameter(Mandatory)] [System.Xml.XmlDocument] $Xml, [Parameter(Mandatory)] [PSCustomObject] $Listing ) # For this element, we want the comment above, rather than inside, the element. $comment = $Xml.CreateComment(' [optional] Specifying an icon is optional. If provided, the icon must be a 300 x 300 png file. ') $Xml.DocumentElement.AppendChild($comment ) | Out-Null $iconFilename = $Listing.icon.fileName $elementName = "Icon" [System.Xml.XmlElement] $elementNode = Ensure-RootChild -Xml $Xml -Element $elementName $paramSet = @{ "Element" = $elementNode; "Attribute" = @{ 'Filename' = $iconFilename }; } Add-ToElement @paramSet if ($null -eq $iconFilename) { # We'll just comment this out for now since it's not being used. # We do a tiny bit of extra processing to remove the unnecessary xmlns attribute that # is added to the node when we get the OuterXml. $iconElementXml = $elementNode.OuterXml -replace 'xmlns="[^"]+"', "" $comment = $Xml.CreateComment(" $iconElementXml ") $Xml.DocumentElement.RemoveChild($elementNode) | Out-Null $Xml.DocumentElement.AppendChild($comment ) | Out-Null } return $iconFilename } function ConvertFrom-Listing { <# .SYNOPSIS Converts a base listing for an existing submission into a PDP file that conforms with the January 2017 PDP schema. .PARAMETER Listing The base listing from the submission for the indicated Lang. .PARAMETER Lang The language / region code for the PDP (e.g. "en-us") .PARAMETER Release The release to use. This value will be placed in each new PDP. Some examples could be "1601" for a January 2016 release, "March 2016", or even just "1". .PARAMETER PdpRootPath The root / base path that all of the language sub-folders will go for the PDP files. .PARAMETER FileName The name of the PDP file that will be generated. .OUTPUTS [String[]] Array of image names that the PDP references .EXAMPLE ConvertFrom-Listing -Listing ($sub.listings."en-us".baseListing) -Lang "en-us" -Release "1701" -PdpRootPath "C:\PDPs\" -FileName "PDP.xml" Converts the given "en-us" base listing to the current PDP schema, and saves it to "c:\PDPs\en-us\PDP.xml" #> [CmdletBinding()] param( [Parameter(Mandatory)] [PSCustomObject] $Listing, [Parameter(Mandatory)] [string] $Lang, [Parameter(Mandatory)] [string] $Release, [Parameter(Mandatory)] [string] $PdpRootPath, [Parameter(Mandatory)] [string] $FileName ) $xml = [xml]([String]::Format('<?xml version="1.0" encoding="utf-8"?> <InAppProductDescription language="en-us" xmlns="http://schemas.microsoft.com/appx/2012/InAppProductDescription" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xml:lang="{0}" Release="{1}"/>', $Lang, $Release)) Add-Title -Xml $Xml -Listing $Listing Add-Description -Xml $Xml -Listing $Listing $icon = Add-Icon -Xml $Xml -Listing $Listing $imageNames = @() $imageNames += $icon # Save XML object to file $filePath = Ensure-PdpFilePath -PdpRootPath $PdpRootPath -Lang $Lang -FileName $FileName $xml.Save($filePath) # Post-process the file to ensure CRLF (sometimes is only LF). $content = Get-Content -Encoding UTF8 -Path $filePath $content -join [Environment]::NewLine | Out-File -Force -Encoding utf8 -FilePath $filePath return $imageNames } function Ensure-PdpFilePath { <# .SYNOPSIS Ensures that the containing folder for a PDP file that will be generated exists so that it can successfully be written. .DESCRIPTION Ensures that the containing folder for a PDP file that will be generated exists so that it can successfully be written. .PARAMETER PdpRootPath The root / base path that all of the language sub-folders will go for the PDP files. .PARAMETER Lang The language / region code for the PDP (e.g. "en-us") .PARAMETER FileName The name of the PDP file that will be generated. .EXAMPLE Ensure-PdpFilePath -PdpRootPath "C:\PDPs\" -Lang "en-us" -FileName "PDP.xml" Ensures that the path c:\PDPs\en-us\ exists, creating any sub-folder along the way as necessary, and then returns the path "c:\PDPs\en-us\PDP.xml" .OUTPUTS [String] containing the full path to the PDP file. #> [CmdletBinding()] [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseApprovedVerbs", "", Justification="Best description for purpose")] param( [Parameter(Mandatory)] [string] $PdpRootPath, [string] $Lang, [string] $FileName ) $dropFolder = Join-Path -Path $PdpRootPath -ChildPath $Lang if (-not (Test-Path -PathType Container -Path $dropFolder)) { New-Item -Force -ItemType Directory -Path $dropFolder | Out-Null } return (Join-Path -Path $dropFolder -ChildPath $FileName) } function Show-ImageFileNames { <# .SYNOPSIS Informs the user what the image filenames are that they need to make available to StoreBroker. .DESCRIPTION Informs the user what the image filenames are that they need to make available to StoreBroker. .PARAMETER LangImageNames A hashtable, indexed by langcode, containing an array of image names that the listing for that langcode references. .PARAMETER Release The release name that was added to the PDP files. .EXAMPLE Show-ImageFileNames -LangImageNames $langImageNames -Release "1701" #> [CmdletBinding()] [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseSingularNouns", "", Justification="The most common scenario is that there will be multiple images, not a singular image.")] param( [Parameter(Mandatory)] [hashtable] $LangImageNames, [Parameter(Mandatory)] [string] $Release ) # If there are no screenshots, nothing to do here if ($LangImageNames.Count -eq 0) { return } # If there are no images being used at all, then we can also early return $imageCount = 0 foreach ($lang in $LangImageNames.GetEnumerator()) { $imageCount += $lang.Value.Count } if ($imageCount.Count -eq 0) { return } Write-Log -Message @( "You now need to find all of your images and place them here: <ImagesRootPath>\$Release\<langcode>\...", " where <ImagesRootPath> is the path defined in your config file,", " and <langcode> is the same langcode for the directory of the PDP file referencing those images.") # Quick analysis to help teams out if they need to do anything special with their PDP's $langs = $LangImageNames.Keys | ConvertTo-Array $seenImages = $LangImageNames[$langs[0]] $imagesDiffer = $false for ($i = 1; ($i -lt $langs.Count) -and (-not $imagesDiffer); $i++) { if (($LangImageNames[$langs[$i]].Count -ne $seenImages.Count)) { $imagesDiffer = $true break } foreach ($image in $LangImageNames[$langs[$i]]) { if ($seenImages -notcontains $image) { $imagesDiffer = $true break } } } # Now show the user the image filenames if ($imagesDiffer) { Write-Log -Level Warning -Message @( "It appears that you don't have consistent images across all languages.", "While StoreBroker supports this scenario, some localization systems may", "not support this without additional work. Please refer to the FAQ in", "the documentation for more info on how to best handle this scenario.") $output = @() $output += "The currently referenced image filenames, per langcode, are as follows:" foreach ($langCode in ($LangImageNames.Keys.GetEnumerator() | Sort-Object)) { $output += " * [$langCode]: " + ($LangImageNames.$langCode -join ", ") } Write-Log -Message $output } else { Write-Log -Message @( "Every language that has a PDP references the following images:", "`t$($seenImages -join `"`n`t`")") } } # function Main is invoked at the bottom of the file function Main { [CmdletBinding()] param() if ($null -eq (Get-Module StoreBroker)) { $message = "The StoreBroker module is not available in this PowerShell session. Please import the module, authenticate correctly using Set-StoreBrokerAuthentication, and try again." throw $message } $sub = $Submission if ($null -eq $sub) { if ([String]::IsNullOrEmpty($SubmissionId)) { $iap = Get-InAppProduct -IapId $IapId $SubmissionId = $iap.lastPublishedInAppProductSubmission.id if ([String]::IsNullOrEmpty($SubmissionId)) { $SubmissionId = $iap.pendingInAppProductSubmission.id Write-Log -Message "No published submission exists for this In-App Product. Using the current pending submission." -Level Warning } } $sub = Get-InAppProductSubmission -IapId $IapId -SubmissionId $SubmissionId } $langImageNames = @{} $langs = ($sub.listings | Get-Member -type NoteProperty) $pdpsGenerated = 0 $langs | ForEach-Object { $lang = $_.Name Write-Log -Message "Creating PDP for $lang" -Level Verbose Write-Progress -Activity "Generating PDP" -Status $lang -PercentComplete $(($pdpsGenerated / $langs.Count) * 100) try { $imageNames = ConvertFrom-Listing -Listing ($sub.listings.$lang) -Lang $lang -Release $Release -PdpRootPath $OutPath -FileName $PdpFileName $langImageNames[$lang] = $imageNames $pdpsGenerated++ } catch { Write-Log -Message "Error creating [$lang] PDP:" -Exception $_ -Level Error throw } } if ($pdpsGenerated -gt 0) { Write-Log -Message "PDP's have been created here: $OutPath" Show-ImageFileNames -LangImageNames $langImageNames -Release $Release } else { Write-Log -Level Warning -Message @( "No PDPs were generated.", "Please verify that this existing In-App Product has one or more language listings that this extension can convert,", "otherwise you can start fresh using the sample PDP\InAppProductDescription.xml as a starting point.") } } # Script body $OutPath = Resolve-UnverifiedPath -Path $OutPath # function Main invocation Main # SIG # Begin signature block # MIIjkgYJKoZIhvcNAQcCoIIjgzCCI38CAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAtI5TcIBHw+nLL # WNpATg52J997V3lvaftMjktlvbgvAaCCDYEwggX/MIID56ADAgECAhMzAAABh3IX # chVZQMcJAAAAAAGHMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD # VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p # bmcgUENBIDIwMTEwHhcNMjAwMzA0MTgzOTQ3WhcNMjEwMzAzMTgzOTQ3WjB0MQsw # CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u # ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB # AQDOt8kLc7P3T7MKIhouYHewMFmnq8Ayu7FOhZCQabVwBp2VS4WyB2Qe4TQBT8aB # znANDEPjHKNdPT8Xz5cNali6XHefS8i/WXtF0vSsP8NEv6mBHuA2p1fw2wB/F0dH # sJ3GfZ5c0sPJjklsiYqPw59xJ54kM91IOgiO2OUzjNAljPibjCWfH7UzQ1TPHc4d # weils8GEIrbBRb7IWwiObL12jWT4Yh71NQgvJ9Fn6+UhD9x2uk3dLj84vwt1NuFQ # itKJxIV0fVsRNR3abQVOLqpDugbr0SzNL6o8xzOHL5OXiGGwg6ekiXA1/2XXY7yV # Fc39tledDtZjSjNbex1zzwSXAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE # AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUhov4ZyO96axkJdMjpzu2zVXOJcsw # UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1 # ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDU4Mzg1MB8GA1UdIwQYMBaAFEhu # ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu # bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w # Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3 # Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx # MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAixmy # S6E6vprWD9KFNIB9G5zyMuIjZAOuUJ1EK/Vlg6Fb3ZHXjjUwATKIcXbFuFC6Wr4K # NrU4DY/sBVqmab5AC/je3bpUpjtxpEyqUqtPc30wEg/rO9vmKmqKoLPT37svc2NV # BmGNl+85qO4fV/w7Cx7J0Bbqk19KcRNdjt6eKoTnTPHBHlVHQIHZpMxacbFOAkJr # qAVkYZdz7ikNXTxV+GRb36tC4ByMNxE2DF7vFdvaiZP0CVZ5ByJ2gAhXMdK9+usx # zVk913qKde1OAuWdv+rndqkAIm8fUlRnr4saSCg7cIbUwCCf116wUJ7EuJDg0vHe # yhnCeHnBbyH3RZkHEi2ofmfgnFISJZDdMAeVZGVOh20Jp50XBzqokpPzeZ6zc1/g # yILNyiVgE+RPkjnUQshd1f1PMgn3tns2Cz7bJiVUaqEO3n9qRFgy5JuLae6UweGf # AeOo3dgLZxikKzYs3hDMaEtJq8IP71cX7QXe6lnMmXU/Hdfz2p897Zd+kU+vZvKI # 3cwLfuVQgK2RZ2z+Kc3K3dRPz2rXycK5XCuRZmvGab/WbrZiC7wJQapgBodltMI5 # GMdFrBg9IeF7/rP4EqVQXeKtevTlZXjpuNhhjuR+2DMt/dWufjXpiW91bo3aH6Ea # jOALXmoxgltCp1K7hrS6gmsvj94cLRf50QQ4U8Qwggd6MIIFYqADAgECAgphDpDS # AAAAAAADMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMK # V2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0 # IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0 # ZSBBdXRob3JpdHkgMjAxMTAeFw0xMTA3MDgyMDU5MDlaFw0yNjA3MDgyMTA5MDla # MH4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS # ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMT # H01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTEwggIiMA0GCSqGSIb3DQEB # AQUAA4ICDwAwggIKAoICAQCr8PpyEBwurdhuqoIQTTS68rZYIZ9CGypr6VpQqrgG # OBoESbp/wwwe3TdrxhLYC/A4wpkGsMg51QEUMULTiQ15ZId+lGAkbK+eSZzpaF7S # 35tTsgosw6/ZqSuuegmv15ZZymAaBelmdugyUiYSL+erCFDPs0S3XdjELgN1q2jz # y23zOlyhFvRGuuA4ZKxuZDV4pqBjDy3TQJP4494HDdVceaVJKecNvqATd76UPe/7 # 4ytaEB9NViiienLgEjq3SV7Y7e1DkYPZe7J7hhvZPrGMXeiJT4Qa8qEvWeSQOy2u # M1jFtz7+MtOzAz2xsq+SOH7SnYAs9U5WkSE1JcM5bmR/U7qcD60ZI4TL9LoDho33 # X/DQUr+MlIe8wCF0JV8YKLbMJyg4JZg5SjbPfLGSrhwjp6lm7GEfauEoSZ1fiOIl # XdMhSz5SxLVXPyQD8NF6Wy/VI+NwXQ9RRnez+ADhvKwCgl/bwBWzvRvUVUvnOaEP # 6SNJvBi4RHxF5MHDcnrgcuck379GmcXvwhxX24ON7E1JMKerjt/sW5+v/N2wZuLB # l4F77dbtS+dJKacTKKanfWeA5opieF+yL4TXV5xcv3coKPHtbcMojyyPQDdPweGF # RInECUzF1KVDL3SV9274eCBYLBNdYJWaPk8zhNqwiBfenk70lrC8RqBsmNLg1oiM # CwIDAQABo4IB7TCCAekwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFEhuZOVQ # BdOCqhc3NyK1bajKdQKVMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsGA1Ud # DwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFHItOgIxkEO5FAVO # 4eqnxzHRI4k0MFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwubWljcm9zb2Z0 # LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y # Mi5jcmwwXgYIKwYBBQUHAQEEUjBQME4GCCsGAQUFBzAChkJodHRwOi8vd3d3Lm1p # Y3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y # Mi5jcnQwgZ8GA1UdIASBlzCBlDCBkQYJKwYBBAGCNy4DMIGDMD8GCCsGAQUFBwIB # FjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2RvY3MvcHJpbWFyeWNw # cy5odG0wQAYIKwYBBQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AcABvAGwAaQBjAHkA # XwBzAHQAYQB0AGUAbQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAGfyhqWY # 4FR5Gi7T2HRnIpsLlhHhY5KZQpZ90nkMkMFlXy4sPvjDctFtg/6+P+gKyju/R6mj # 82nbY78iNaWXXWWEkH2LRlBV2AySfNIaSxzzPEKLUtCw/WvjPgcuKZvmPRul1LUd # d5Q54ulkyUQ9eHoj8xN9ppB0g430yyYCRirCihC7pKkFDJvtaPpoLpWgKj8qa1hJ # Yx8JaW5amJbkg/TAj/NGK978O9C9Ne9uJa7lryft0N3zDq+ZKJeYTQ49C/IIidYf # wzIY4vDFLc5bnrRJOQrGCsLGra7lstnbFYhRRVg4MnEnGn+x9Cf43iw6IGmYslmJ # aG5vp7d0w0AFBqYBKig+gj8TTWYLwLNN9eGPfxxvFX1Fp3blQCplo8NdUmKGwx1j # NpeG39rz+PIWoZon4c2ll9DuXWNB41sHnIc+BncG0QaxdR8UvmFhtfDcxhsEvt9B # xw4o7t5lL+yX9qFcltgA1qFGvVnzl6UJS0gQmYAf0AApxbGbpT9Fdx41xtKiop96 # eiL6SJUfq/tHI4D1nvi/a7dLl+LrdXga7Oo3mXkYS//WsyNodeav+vyL6wuA6mk7 # r/ww7QRMjt/fdW1jkT3RnVZOT7+AVyKheBEyIXrvQQqxP/uozKRdwaGIm1dxVk5I # RcBCyZt2WwqASGv9eZ/BvW1taslScxMNelDNMYIVZzCCFWMCAQEwgZUwfjELMAkG # A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx # HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z # b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAYdyF3IVWUDHCQAAAAABhzAN # BglghkgBZQMEAgEFAKCBrjAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor # BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgDSLETUWb # zqvB/Wx9AC6yhYMr1kUO/5QHa+j6haAXZF8wQgYKKwYBBAGCNwIBDDE0MDKgFIAS # AE0AaQBjAHIAbwBzAG8AZgB0oRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTAN # BgkqhkiG9w0BAQEFAASCAQAB92CmaPfoZAZwQfjFsziHqJdPVSfpmSFwWrKk+lLQ # dl2Tbo1NMQMdbnKodwmJlkanQXZSMzZRQ7MOafAQnRgfdhQ2+bTBjEkvXY8y7bfp # EGvLX43WYwbqxT1WV919nolFOWZ5XB4Y00vjWFoygzMf/4VIi/W2POleP0p9nAqr # wjh3ubQruXdqLZpij9VmwNfK6NM8f7Q+Lcrd9KnSNwP1cR3zUkpuIkTDd6vrYErF # M8TXDDK8Vjd1VZHkFM5PTsAMuNRojPpijh8m/3iMUcXL+s6P0wR6wIOAtT77OLmp # YvC2t2VbLHd/Bb/ziNTPhWbW9RpTjHiagO+ortFYamgqoYIS8TCCEu0GCisGAQQB # gjcDAwExghLdMIIS2QYJKoZIhvcNAQcCoIISyjCCEsYCAQMxDzANBglghkgBZQME # AgEFADCCAVUGCyqGSIb3DQEJEAEEoIIBRASCAUAwggE8AgEBBgorBgEEAYRZCgMB # MDEwDQYJYIZIAWUDBAIBBQAEIOm+3hSYM9WzNfPEZSCZ6mukzSTiRFsp0PFZrDVg # HRtjAgZfu+aDJG8YEzIwMjAxMjAxMjAwNzEyLjAxOFowBIACAfSggdSkgdEwgc4x # CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt # b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1p # Y3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMg # VFNTIEVTTjo0RDJGLUUzREQtQkVFRjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt # U3RhbXAgU2VydmljZaCCDkQwggT1MIID3aADAgECAhMzAAABK5PQ7Y4K9/BHAAAA # AAErMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo # aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y # cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw # MB4XDTE5MTIxOTAxMTUwMloXDTIxMDMxNzAxMTUwMlowgc4xCzAJBgNVBAYTAlVT # MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK # ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVy # YXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjo0RDJG # LUUzREQtQkVFRjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vydmlj # ZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAJb6i4/AWVpXjQAludgA # NHARSFyzEjltq7Udsw5sSZo68N8oWkL+QKz842RqIiggTltm6dHYFcmB1YRRqMdX # 6Y7gJT9Sp8FVI10FxGF5I6d6BtQCjDBc2/s1ih0E111SANl995D8FgY8ea5u1nqE # omlCBbjdoqYy3APET2hABpIM6hcwIaxCvd+ugmJnHSP+PxI/8RxJh8jT/GFRzkL1 # wy/kD2iMl711Czg3DL/yAHXusqSw95hZmW2mtL7HNvSz04rifjZw3QnYPwIi46CS # i34Kr9p9dB1VV7++Zo9SmgdjmvGeFjH2Jth3xExPkoULaWrvIbqcpOs9E7sAUJTB # sB0CAwEAAaOCARswggEXMB0GA1UdDgQWBBQi72h0uFIDuXSWYWPz0HeSiMCTBTAf # BgNVHSMEGDAWgBTVYzpcijGQ80N7fEYbxTNoWoVtVTBWBgNVHR8ETzBNMEugSaBH # hkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNU # aW1TdGFQQ0FfMjAxMC0wNy0wMS5jcmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUF # BzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1RpbVN0 # YVBDQV8yMDEwLTA3LTAxLmNydDAMBgNVHRMBAf8EAjAAMBMGA1UdJQQMMAoGCCsG # AQUFBwMIMA0GCSqGSIb3DQEBCwUAA4IBAQBnP/nYpaY+bpVs4jJlH7SsElV4cOvd # pnCng+XoxtZnNhVboQQlpLr7OQ/m4Oc78707RF8onyXTSWJMvHDVhBD74qGuY3KF # mqWGw4MGqGLqECUnUH//xtfhZPMdixuMDBmY7StqkUUuX5TRRVh7zNdVqS7mE+Gz # EUedzI2ndTVGJtBUI73cU7wUe8lefIEnXzKfxsycTxUos0nUI2YoKGn89ZWPKS/Y # 4m35WE3YirmTMjK57B5A6KEGSBk9vqyrGNivEGoqJN+mMN8ZULJJKOtFLzgxVg7m # z5c/JgsMRPvFwZU96hWcLgrNV5D3fNAnWmiCLCMjiI8N8IQszZvAEpzIMIIGcTCC # BFmgAwIBAgIKYQmBKgAAAAAAAjANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMC # VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV # BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJv # b3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IDIwMTAwHhcNMTAwNzAxMjEzNjU1WhcN # MjUwNzAxMjE0NjU1WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv # bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0 # aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCASIw # DQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKkdDbx3EYo6IOz8E5f1+n9plGt0 # VBDVpQoAgoX77XxoSyxfxcPlYcJ2tz5mK1vwFVMnBDEfQRsalR3OCROOfGEwWbEw # RA/xYIiEVEMM1024OAizQt2TrNZzMFcmgqNFDdDq9UeBzb8kYDJYYEbyWEeGMoQe # dGFnkV+BVLHPk0ySwcSmXdFhE24oxhr5hoC732H8RsEnHSRnEnIaIYqvS2SJUGKx # Xf13Hz3wV3WsvYpCTUBR0Q+cBj5nf/VmwAOWRH7v0Ev9buWayrGo8noqCjHw2k4G # kbaICDXoeByw6ZnNPOcvRLqn9NxkvaQBwSAJk3jN/LzAyURdXhacAQVPIk0CAwEA # AaOCAeYwggHiMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBTVYzpcijGQ80N7 # fEYbxTNoWoVtVTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMC # AYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTV9lbLj+iiXGJo0T2UkFvX # zpoYxDBWBgNVHR8ETzBNMEugSaBHhkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20v # cGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcmwwWgYI # KwYBBQUHAQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5j # b20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIzLmNydDCBoAYDVR0g # AQH/BIGVMIGSMIGPBgkrBgEEAYI3LgMwgYEwPQYIKwYBBQUHAgEWMWh0dHA6Ly93 # d3cubWljcm9zb2Z0LmNvbS9QS0kvZG9jcy9DUFMvZGVmYXVsdC5odG0wQAYIKwYB # BQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AUABvAGwAaQBjAHkAXwBTAHQAYQB0AGUA # bQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAAfmiFEN4sbgmD+BcQM9naOh # IW+z66bM9TG+zwXiqf76V20ZMLPCxWbJat/15/B4vceoniXj+bzta1RXCCtRgkQS # +7lTjMz0YBKKdsxAQEGb3FwX/1z5Xhc1mCRWS3TvQhDIr79/xn/yN31aPxzymXlK # kVIArzgPF/UveYFl2am1a+THzvbKegBvSzBEJCI8z+0DpZaPWSm8tv0E4XCfMkon # /VWvL/625Y4zu2JfmttXQOnxzplmkIz/amJ/3cVKC5Em4jnsGUpxY517IW3DnKOi # PPp/fZZqkHimbdLhnPkd/DjYlPTGpQqWhqS9nhquBEKDuLWAmyI4ILUl5WTs9/S/ # fmNZJQ96LjlXdqJxqgaKD4kWumGnEcua2A5HmoDF0M2n0O99g/DhO3EJ3110mCII # YdqwUB5vvfHhAN/nMQekkzr3ZUd46PioSKv33nJ+YWtvd6mBy6cJrDm77MbL2IK0 # cs0d9LiFAR6A+xuJKlQ5slvayA1VmXqHczsI5pgt6o3gMy4SKfXAL1QnIffIrE7a # KLixqduWsqdCosnPGUFN4Ib5KpqjEWYw07t0MkvfY3v1mYovG8chr1m1rtxEPJdQ # cdeh0sVV42neV8HR3jDA/czmTfsNv11P6Z0eGTgvvM9YBS7vDaBQNdrvCScc1bN+ # NR4Iuto229Nfj950iEkSoYIC0jCCAjsCAQEwgfyhgdSkgdEwgc4xCzAJBgNVBAYT # AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD # VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBP # cGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjo0 # RDJGLUUzREQtQkVFRjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy # dmljZaIjCgEBMAcGBSsOAwIaAxUARAw2kg/n/0n60D7eGy96WYdDT6aggYMwgYCk # fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH # UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD # Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF # AONw8NMwIhgPMjAyMDEyMDEyMDQxNTVaGA8yMDIwMTIwMjIwNDE1NVowdzA9Bgor # BgEEAYRZCgQBMS8wLTAKAgUA43Dw0wIBADAKAgEAAgIU0QIB/zAHAgEAAgIR8jAK # AgUA43JCUwIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB # AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAILDDSf2eyhpkCAp # lyOkv23fGjd8s6KTmh3jxraG6I0e/2UfEOnVpv7Vk0Y+YV2pLjTaeLsZ/uamPbe9 # 3veo4afbS+vIgY4McXdBRUaWmFt/1z0A02XxfldsryO5T5YxlORPAiTkmQGTVY0x # uEBhQ+4IY2uRqY+criRsmleCB9BwMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMC # VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV # BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp # bWUtU3RhbXAgUENBIDIwMTACEzMAAAErk9Dtjgr38EcAAAAAASswDQYJYIZIAWUD # BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B # CQQxIgQgYKmRmO1TGD/ykSBja/jtA2CrQO65dmr7UiNlpa0C0/MwgfoGCyqGSIb3 # DQEJEAIvMYHqMIHnMIHkMIG9BCBkJznmSoXCUyxc3HvYjOIqWMdG6L6tTAg3KsLa # XRvPXzCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u # MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp # b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB # K5PQ7Y4K9/BHAAAAAAErMCIEIEG4IeFASuJX8iHPVvGS7+QodAMc4Ko3aEwBNftq # 7K3+MA0GCSqGSIb3DQEBCwUABIIBAFGVQYaECMaBK3SnXSbJWJMH20apPFBRgqqb # ldkSfPbwc5Tw2Gew/4ShjozYNCKFltqvPYi9R2gcso/1E8Skk8WLm6dNeGvn5RWy # bKR36F01eDRcYYomAz6qRBGl1KRZCWUdF++3HBoa1vM3agLMa3n9M7wC8YgYEhGt # cwok+X8bQamKkfQdgXVo0kwC4uOQozUOxvSeZ0z+oPVSVCh/fOSRwermCdgFX7aD # ZNg+6yPMb97HbwTdZ1WmklV0M129PiHAeC/mvk5zCABA8EERJ+a03qXPIn1BXIoA # uq+A+YQgwQhwgmTkYCPyxv5HHus/voVWvFSIftJyxAINqsZwOLI= # SIG # End signature block |