# encoding: ascii
# api: powershell
# title: CreateMasterLists
# description: PowerShell form that can create master lists for later use in Quests Notes Migration Tool…
# version: 3.1.19
# type: function
# author: DollarUnderscore
# license: CC0
# function: Call-CreateMasterLists_pff
# x-poshcode-id: 4508
# x-archived: 2013-10-11T21:06:19
# x-published: 2013-10-07T21:02:00
#
#
#========================================================================
# Code Generated By: SAPIEN Technologies, Inc., PowerShell Studio 2012 v3.1.19
# Generated On: 2013-10-07 22:58
# Generated By: Anders Wahlqvist
# Organization: DollarUnderscore (http://dollarunderscore.azurewebsites.net)
#========================================================================
#----------------------------------------------
#region Application Functions
#----------------------------------------------
function OnApplicationLoad {
#Note: This function is not called in Projects
#Note: This function runs before the form is created
#Note: To get the script directory in the Packager use: Split-Path $hostinvocation.MyCommand.path
#Note: To get the console output in the Packager (Windows Mode) use: $ConsoleOutput (Type: System.Collections.ArrayList)
#Important: Form controls cannot be accessed in this function
#TODO: Add snapins and custom code to validate the application load
return $true #return true for success or false for failure
}
function OnApplicationExit {
#Note: This function is not called in Projects
#Note: This function runs after the form is closed
#TODO: Add custom code to clean up and unload snapins when the application exits
$script:ExitCode = 0 #Set the exit code for the Packager
}
#endregion Application Functions
#----------------------------------------------
# Generated Form Function
#----------------------------------------------
function Call-CreateMasterLists_pff {
#----------------------------------------------
#region Import the Assemblies
#----------------------------------------------
[void][reflection.assembly]::Load("mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
[void][reflection.assembly]::Load("System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
[void][reflection.assembly]::Load("System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089")
[void][reflection.assembly]::Load("System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
#endregion Import Assemblies
#----------------------------------------------
#region Generated Form Objects
#----------------------------------------------
[System.Windows.Forms.Application]::EnableVisualStyles()
$formCreateNMEMasterList = New-Object 'System.Windows.Forms.Form'
$checkboxUseWildcardSearchkey = New-Object 'System.Windows.Forms.CheckBox'
$labelNumberOfFilesToSplit = New-Object 'System.Windows.Forms.Label'
$ColumnsForKey = New-Object 'System.Windows.Forms.ComboBox'
$labelColumnToUseAsKeyforV = New-Object 'System.Windows.Forms.Label'
$FileBuildingProgress = New-Object 'System.Windows.Forms.ProgressBar'
$statusbar = New-Object 'System.Windows.Forms.StatusBar'
$buttonBuildFiles = New-Object 'System.Windows.Forms.Button'
$buttonBrowseFolder = New-Object 'System.Windows.Forms.Button'
$textboxFolder = New-Object 'System.Windows.Forms.TextBox'
$NumberOfFiles = New-Object 'System.Windows.Forms.ComboBox'
$checkboxSplitTheFilesForMe = New-Object 'System.Windows.Forms.CheckBox'
$labelSaveFilesTo = New-Object 'System.Windows.Forms.Label'
$checkboxMigrateAllUsersusedT = New-Object 'System.Windows.Forms.CheckBox'
$buttonUserMigrateBrowse = New-Object 'System.Windows.Forms.Button'
$textboxUserToMigrate = New-Object 'System.Windows.Forms.TextBox'
$labelUsersToMigratevalues = New-Object 'System.Windows.Forms.Label'
$buttonMasterListBrowse = New-Object 'System.Windows.Forms.Button'
$textboxMasterTSV = New-Object 'System.Windows.Forms.TextBox'
$labelSourceMasterTsv = New-Object 'System.Windows.Forms.Label'
$openfiledialog1 = New-Object 'System.Windows.Forms.OpenFileDialog'
$openfiledialog2 = New-Object 'System.Windows.Forms.OpenFileDialog'
$folderbrowserdialog1 = New-Object 'System.Windows.Forms.FolderBrowserDialog'
$folderbrowserdialog2 = New-Object 'System.Windows.Forms.FolderBrowserDialog'
$InitialFormWindowState = New-Object 'System.Windows.Forms.FormWindowState'
#endregion Generated Form Objects
#----------------------------------------------
# User Generated Script
#----------------------------------------------
$formCreateNMEMasterList_Load={
#TODO: Initialize Form Controls here
}
$buttonMasterListBrowse_Click={
if($openfiledialog1.ShowDialog() -eq 'OK')
{
$textboxMasterTSV.Text = $openfiledialog1.FileName
}
}
$buttonUserMigrateBrowse_Click={
if($openfiledialog2.ShowDialog() -eq 'OK')
{
$textboxUserToMigrate.Text = $openfiledialog2.FileName
}
}
$buttonBrowseFolder_Click={
if($folderbrowserdialog1.ShowDialog() -eq 'OK')
{
$textboxFolder.Text = $folderbrowserdialog1.SelectedPath
}
}
#region Control Helper Functions
function Load-ComboBox
{
<#
.SYNOPSIS
This functions helps you load items into a ComboBox.
.DESCRIPTION
Use this function to dynamically load items into the ComboBox control.
.PARAMETER ComboBox
The ComboBox control you want to add items to.
.PARAMETER Items
The object or objects you wish to load into the ComboBox's Items collection.
.PARAMETER DisplayMember
Indicates the property to display for the items in this control.
.PARAMETER Append
Adds the item(s) to the ComboBox without clearing the Items collection.
.EXAMPLE
Load-ComboBox $combobox1 "Red", "White", "Blue"
.EXAMPLE
Load-ComboBox $combobox1 "Red" -Append
Load-ComboBox $combobox1 "White" -Append
Load-ComboBox $combobox1 "Blue" -Append
.EXAMPLE
Load-ComboBox $combobox1 (Get-Process) "ProcessName"
#>
Param (
[ValidateNotNull()]
[Parameter(Mandatory=$true)]
[System.Windows.Forms.ComboBox]$ComboBox,
[ValidateNotNull()]
[Parameter(Mandatory=$true)]
$Items,
[Parameter(Mandatory=$false)]
[string]$DisplayMember,
[switch]$Append
)
if(-not $Append)
{
$ComboBox.Items.Clear()
}
if($Items -is [Object[]])
{
$ComboBox.Items.AddRange($Items)
}
elseif ($Items -is [Array])
{
$ComboBox.BeginUpdate()
foreach($obj in $Items)
{
$ComboBox.Items.Add($obj)
}
$ComboBox.EndUpdate()
}
else
{
$ComboBox.Items.Add($Items)
}
$ComboBox.DisplayMember = $DisplayMember
}
function Load-ListBox
{
<#
.SYNOPSIS
This functions helps you load items into a ListBox or CheckedListBox.
.DESCRIPTION
Use this function to dynamically load items into the ListBox control.
.PARAMETER ListBox
The ListBox control you want to add items to.
.PARAMETER Items
The object or objects you wish to load into the ListBox's Items collection.
.PARAMETER DisplayMember
Indicates the property to display for the items in this control.
.PARAMETER Append
Adds the item(s) to the ListBox without clearing the Items collection.
.EXAMPLE
Load-ListBox $ListBox1 "Red", "White", "Blue"
.EXAMPLE
Load-ListBox $listBox1 "Red" -Append
Load-ListBox $listBox1 "White" -Append
Load-ListBox $listBox1 "Blue" -Append
.EXAMPLE
Load-ListBox $listBox1 (Get-Process) "ProcessName"
#>
Param (
[ValidateNotNull()]
[Parameter(Mandatory=$true)]
[System.Windows.Forms.ListBox]$ListBox,
[ValidateNotNull()]
[Parameter(Mandatory=$true)]
$Items,
[Parameter(Mandatory=$false)]
[string]$DisplayMember,
[switch]$Append
)
if(-not $Append)
{
$listBox.Items.Clear()
}
if($Items -is [System.Windows.Forms.ListBox+ObjectCollection])
{
$listBox.Items.AddRange($Items)
}
elseif ($Items -is [Array])
{
$listBox.BeginUpdate()
foreach($obj in $Items)
{
$listBox.Items.Add($obj)
}
$listBox.EndUpdate()
}
else
{
$listBox.Items.Add($Items)
}
$listBox.DisplayMember = $DisplayMember
}
#endregion
$buttonBrowseFolder_Click2={
if($folderbrowserdialog2.ShowDialog() -eq 'OK')
{
$textboxFolder.Text = $folderbrowserdialog2.SelectedPath
}
}
$checkboxMigrateAllUsersusedT_CheckedChanged={
#TODO: Place custom script here
if ($checkboxMigrateAllUsersusedT.Checked) {
$PathToMasterFile = $textboxMasterTSV.Text
if ($(Test-Path $PathToMasterFile)) {
$checkboxSplitTheFilesForMe.Enabled = $true
$checkboxSplitTheFilesForMe.Checked = $true
$UsersToMigrate = Get-Content $PathToMasterFile
if ($UsersToMigrate.count -gt 1000 -and $checkboxMigrateAllUsersusedT.Checked -eq $true) {
Load-ComboBox $NumberOfFiles "2"
3..500 | % { Load-ComboBox $NumberOfFiles "$_" -Append }
}
else {
Load-ComboBox $NumberOfFiles "2"
3..$($UsersToMigrate.count/2) | % { Load-ComboBox $NumberOfFiles "$_" -Append }
}
$NumberOfFiles.Enabled = $true
$NumberOfFiles.Focus
}
$textboxUserToMigrate.Enabled = $false
$buttonUserMigrateBrowse.Enabled = $false
$ColumnsForKey.Enabled = $false
$checkboxUseWildcardSearchkey.Enabled = $false
}
else {
$textboxUserToMigrate.Enabled = $true
$buttonUserMigrateBrowse.Enabled = $true
$ColumnsForKey.Enabled = $true
$checkboxUseWildcardSearchkey.Enabled = $true
}
}
function DisableFormInput
{
$textboxMasterTSV.Enabled = $false
$buttonMasterListBrowse.Enabled = $false
$textboxUserToMigrate.Enabled = $false
$buttonUserMigrateBrowse.Enabled = $false
$buttonBrowseFolder.Enabled = $false
$textboxFolder.Enabled = $false
$ColumnsForKey.Enabled = $false
$NumberOfFiles.Enabled = $false
$checkboxSplitTheFilesForMe.Enabled = $false
$textboxUserToMigrate.Enabled = $false
$buttonUserMigrateBrowse.Enabled = $false
$ColumnsForKey.Enabled = $false
$buttonBuildFiles.Enabled = $false
$checkboxMigrateAllUsersusedT.Enabled = $false
$checkboxUseWildcardSearchkey.Enabled = $false
}
function EnableFormInput
{
$textboxMasterTSV.Enabled = $true
$buttonMasterListBrowse.Enabled = $true
$buttonBrowseFolder.Enabled = $true
$textboxFolder.Enabled = $true
$checkboxSplitTheFilesForMe.Enabled = $true
$buttonBuildFiles.Enabled = $true
$checkboxMigrateAllUsersusedT.Enabled = $true
if ($checkboxSplitTheFilesForMe.Checked) {
$NumberOfFiles.Enabled = $true
}
else {
$NumberOfFiles.Enabled = $false
}
if ($checkboxMigrateAllUsersusedT.Checked) {
$textboxUserToMigrate.Enabled = $false
$buttonUserMigrateBrowse.Enabled = $false
$ColumnsForKey.Enabled = $false
$checkboxUseWildcardSearchkey.Enabled = $false
}
else {
$textboxUserToMigrate.Enabled = $true
$buttonUserMigrateBrowse.Enabled = $true
$ColumnsForKey.Enabled = $true
$checkboxUseWildcardSearchkey.Enabled = $true
}
}
$buttonBuildFiles_Click={
#TODO: Place custom script here
DisableFormInput
$FileBuildingProgress.Value = 0
$statusbar.Text = "Starting..."
$PathToMasterFile = $textboxMasterTSV.Text
$PathToUserToMigrateFile = $textboxUserToMigrate.Text
$PathForNewFiles = $textboxFolder.Text
$MasterFileOK = Test-Path $PathToMasterFile
if ($checkboxMigrateAllUsersusedT.Checked -eq $true) {
$UsersToMigrateFileOK = $true
}
else {
$UsersToMigrateFileOK = Test-Path $PathToUserToMigrateFile
}
$SaveFolderOK = Test-Path $PathForNewFiles
$ColumnKey = $ColumnsForKey.Text
$MasterFileBN = Get-ChildItem $PathToMasterFile | Select-Object -ExpandProperty BaseName
$TmpCsvFile = "$PathForNewFiles\$MasterFileBN-TEMP.tmp"
$ErrorFile = "$PathForNewFiles\NotFound.txt"
$NumberFilesWanted=$NumberOfFiles.Text
Remove-Item $ErrorFile -Force -ErrorAction 'SilentlyContinue'
if ($ColumnKey -ne "" -and $ColumnKey -ne $null) {
$ColumnKeyOK = $true
}
elseif ($checkboxMigrateAllUsersusedT.Checked -eq $true) {
$ColumnKeyOK = $true
}
else {
$ColumnKeyOK = $false
}
if ($MasterFileOK -eq $true -and $UsersToMigrateFileOK -eq $true -and $SaveFolderOK -eq $true -and $ColumnKeyOK -eq $true) {
if ($checkboxMigrateAllUsersusedT.Checked -eq $true) {
$UsersToSplit = Get-Content $PathToMasterFile -Encoding 'Unicode'
$NumberOfUsersToMigrate=$UsersToSplit.count
}
else {
$statusbar.Text = "Loading files..."
$MasterList = Import-csv $PathToMasterFile -Delimiter "`t" -Encoding 'Unicode'
$UsersToMigrate = Get-Content $PathToUserToMigrateFile
$NumberOfUsersToMigrate=$UsersToMigrate.count
$FindingUserNr=0
foreach ($UserToMigrate in $UsersToMigrate) {
$FindingUserNr++
$FileBuildingProgress.Value = $FindingUserNr/$NumberOfUsersToMigrate*100
$statusbar.Text = "Finding $UserToMigrate in master file..."
[System.Windows.Forms.Application]::DoEvents()
if ($checkboxUseWildcardSearchkey.Checked -eq $true) {
$Match = $null
$Match = $MasterList | Where-Object { $_.$($ColumnKey) -like "*$UserToMigrate*" }
if ($Match -ne $null) {
$Match | Export-Csv $TmpCsvFile -Delimiter "`t" -Encoding 'Unicode' -Append -NoTypeInformation
}
else {
Write-Output "No match for $UserToMigrate (wildcard)" | Out-File $ErrorFile -Append
}
}
else {
$Match = $null
$Match = $MasterList | Where-Object { $_.$($ColumnKey) -eq $UserToMigrate }
if ($Match -ne $null) {
$Match | Export-Csv $TmpCsvFile -Delimiter "`t" -Encoding 'Unicode' -Append -NoTypeInformation
}
else {
Write-Output "No match for $UserToMigrate (no wildcard)" | Out-File $ErrorFile -Append
}
}
}
$statusbar.Text = "Reading temp file..."
$UsersToSplit = Get-Content $TmpCsvFile -Encoding 'Unicode' | % { $_ -replace "`"" }
Remove-Item $TmpCsvFile -Force -ErrorAction 'SilentlyContinue'
}
$statusbar.Text = "Preparing to create final file(s)... Wait..."
$FileBuildingProgress.Value = 0
[int] $NumberOfUsersPerFile=$NumberOfUsersToMigrate/$NumberFilesWanted
[int] $CurrentFileNumber = 1
[int] $CurrentUser = 0
[int] $CurrentUserNoReset = 0
$FirstRun = $true
$Headers = Get-Content $PathToMasterFile -Encoding 'Unicode' | select -First 1
Remove-Item $("$PathForNewFiles\$MasterFileBN-ChosenUsers.tsv") -Force -ErrorAction 'SilentlyContinue'
Remove-Item $("$PathForNewFiles\$MasterFileBN-1.tsv") -Force -ErrorAction 'SilentlyContinue'
if ($checkboxSplitTheFilesForMe.Checked) {
$UsersToSplit | % {
$CurrentUserNoReset++
$statusbar.Text = "Splitting into files..."
$FileBuildingProgress.Value = $CurrentUserNoReset/$NumberOfUsersToMigrate*100
[System.Windows.Forms.Application]::DoEvents()
$CurrentUser++
if ($CurrentUser -ge $NumberOfUsersPerFile -and $CurrentFileNumber -lt $NumberFilesWanted -and $FirstRun -eq $false) {
$CurrentFileNumber++
[int] $CurrentUser = 0
$Headers | Out-File $("$PathForNewFiles\$MasterFileBN-$CurrentFileNumber.tsv") -Encoding 'Unicode'
}
$_ | Out-File $("$PathForNewFiles\$MasterFileBN-$CurrentFileNumber.tsv") -Encoding 'Unicode' -Append
if ($FirstRun -eq $true -and $CurrentUser -ge 3) {
$FirstRun = $false
}
}
}
else {
$statusbar.Text = "Creating file..."
$UsersToSplit | Out-File $("$PathForNewFiles\$MasterFileBN-ChosenUsers.tsv") -Encoding 'Unicode' -Append
}
$statusbar.Text = "Ready."
}
else {
$statusbar.Text = "Check all the paths/settings."
}
EnableFormInput
$FileBuildingProgress.Value = 0
}
$textboxMasterTSV_TextChanged={
#TODO: Place custom script here
$PathToMasterFile = $textboxMasterTSV.Text
if ($(Test-Path $PathToMasterFile)) {
$MasterList = Import-csv $PathToMasterFile -Delimiter "`t" -Encoding Unicode | select -First 1
$Columns=$MasterList | Get-Member | Where-Object { $_.MemberType -eq 'NoteProperty' } | select -ExpandProperty Name
$Columns | Sort-Object | % { Load-ComboBox $ColumnsForKey "$_" -Append }
}
}
$textboxFolder_TextChanged={
#TODO: Place custom script here
}
$textboxUserToMigrate_TextChanged={
#TODO: Place custom script here
$PathToUserToMigrateFile = $textboxUserToMigrate.Text
if ($(Test-Path $PathToUserToMigrateFile)) {
$checkboxSplitTheFilesForMe.Enabled = $true
$UsersToMigrate = Get-Content $PathToUserToMigrateFile
Load-ComboBox $NumberOfFiles "2"
3..$($UsersToMigrate.count/2) | % { Load-ComboBox $NumberOfFiles "$_" -Append }
}
else {
$NumberOfFiles.Enabled = $false
$checkboxSplitTheFilesForMe.Enabled = $false
}
}
$checkboxSplitTheFilesForMe_CheckedChanged={
#TODO: Place custom script here
if ($checkboxSplitTheFilesForMe.Checked) {
$NumberOfFiles.Enabled = $true
}
else {
$NumberOfFiles.Enabled = $false
}
}
# --End User Generated Script--
#----------------------------------------------
#region Generated Events
#----------------------------------------------
$Form_StateCorrection_Load=
{
#Correct the initial state of the form to prevent the .Net maximized form issue
$formCreateNMEMasterList.WindowState = $InitialFormWindowState
}
$Form_Cleanup_FormClosed=
{
#Remove all event handlers from the controls
try
{
$buttonBuildFiles.remove_Click($buttonBuildFiles_Click)
$buttonBrowseFolder.remove_Click($buttonBrowseFolder_Click2)
$textboxFolder.remove_TextChanged($textboxFolder_TextChanged)
$checkboxSplitTheFilesForMe.remove_CheckedChanged($checkboxSplitTheFilesForMe_CheckedChanged)
$checkboxMigrateAllUsersusedT.remove_CheckedChanged($checkboxMigrateAllUsersusedT_CheckedChanged)
$buttonUserMigrateBrowse.remove_Click($buttonUserMigrateBrowse_Click)
$textboxUserToMigrate.remove_TextChanged($textboxUserToMigrate_TextChanged)
$buttonMasterListBrowse.remove_Click($buttonMasterListBrowse_Click)
$textboxMasterTSV.remove_TextChanged($textboxMasterTSV_TextChanged)
$formCreateNMEMasterList.remove_Load($formCreateNMEMasterList_Load)
$formCreateNMEMasterList.remove_Load($Form_StateCorrection_Load)
$formCreateNMEMasterList.remove_FormClosed($Form_Cleanup_FormClosed)
}
catch [Exception]
{ }
}
#endregion Generated Events
#----------------------------------------------
#region Generated Form Code
#----------------------------------------------
#
# formCreateNMEMasterList
#
$formCreateNMEMasterList.Controls.Add($checkboxUseWildcardSearchkey)
$formCreateNMEMasterList.Controls.Add($labelNumberOfFilesToSplit)
$formCreateNMEMasterList.Controls.Add($ColumnsForKey)
$formCreateNMEMasterList.Controls.Add($labelColumnToUseAsKeyforV)
$formCreateNMEMasterList.Controls.Add($FileBuildingProgress)
$formCreateNMEMasterList.Controls.Add($statusbar)
$formCreateNMEMasterList.Controls.Add($buttonBuildFiles)
$formCreateNMEMasterList.Controls.Add($buttonBrowseFolder)
$formCreateNMEMasterList.Controls.Add($textboxFolder)
$formCreateNMEMasterList.Controls.Add($NumberOfFiles)
$formCreateNMEMasterList.Controls.Add($checkboxSplitTheFilesForMe)
$formCreateNMEMasterList.Controls.Add($labelSaveFilesTo)
$formCreateNMEMasterList.Controls.Add($checkboxMigrateAllUsersusedT)
$formCreateNMEMasterList.Controls.Add($buttonUserMigrateBrowse)
$formCreateNMEMasterList.Controls.Add($textboxUserToMigrate)
$formCreateNMEMasterList.Controls.Add($labelUsersToMigratevalues)
$formCreateNMEMasterList.Controls.Add($buttonMasterListBrowse)
$formCreateNMEMasterList.Controls.Add($textboxMasterTSV)
$formCreateNMEMasterList.Controls.Add($labelSourceMasterTsv)
$formCreateNMEMasterList.ClientSize = '289, 473'
$formCreateNMEMasterList.FormBorderStyle = 'FixedToolWindow'
#region Binary Data
$formCreateNMEMasterList.Icon = [System.Convert]::FromBase64String('
AAABAAEAMDAAAAAAAACoJQAAFgAAACgAAAAwAAAAYAAAAAEAIAAAAAAAACQAAAAAAAAAAAAAAAAA
AAAAAAD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
LDA1ASwwNQIsMDUFLDA1CCwwNQksMDUILDA1BiwwNQQsMDUCLDA1Af///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AAAAAAEAAAABAAAABAAAAAYHCAkKDg8RDxUXGRUaGx8aGx4hHR0gIx4fISUbICMmFiEkKBEiJCkJ
IyYqAwAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEA
AAABAAAAAQAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///8A////AP//
/wD///8A////AP///wD///8AAAAAAQAAAAYAAAAOAAAAGgICAikDAwQ4BgcHSAgJClMKCwxaCwwN
WAwND1EPERJIEhUXPRYZGzAYGh4eFxgbEg4PEgoDBAQHAAAABgAAAAYAAAAGAAAABgAAAAcAAAAH
AAAACQAAAAsAAAANAAAADgAAAA4AAAAOAAAADgAAAAwAAAAKAAAABwAAAAQAAAACAAAAAQAAAAEA
AAAAAAAAAAAAAAD///8A////AP///wD///8A////AP///wAAAAABAAAAAwAAAA0BAQEbGxQIOjon
C6RKLwf1WzgE/3BFBP96Twj/c04K5kQwDKYICQplDA0PWRETFE4TFRdBEhQVMAwNDiIEBQUbAAAA
GQAAABkAAAAZAAAAGgAAAB0AAAAkAAAALgAAADkAAABDAAAASwAAAFAAAABQAAAASwAAAEMAAAA3
AAAAKQAAABsAAAAQAAAACAAAAAQAAAABAAAAAQAAAAD///8A////AP///wD///8AAAAAAQAAAAEA
AAAEAAAACAAAABIaFQsuMiMN2SgXAP9UNQH/d0sB/4xZAv+cYAH/sXAB/690Bv91UAvQFxIKbwwN
D2cOEBFmDg4QXgkKC1IDAwRHAQEBRAAAAEMAAABDAAAAQwAAAEgAAABQAAAAWgAAAGkPCgJ/MCIH
ni4gCKUvIAilMCIInwAAAHIAAABgAAAATQAAADgAAAAnAAAAGAAAAA4AAAAHAAAABAAAAAH///8A
////AP///wD///8AAAAAAQAAAAQAAAAJAAAAEgAAAB4lHBDYIRUA/2lFAf+QXwL/lWIB/55oAf+r
cAL/uXcB/8mGAv/NiwT/dVIN5wYHB4YICQmPCAkJkgUGB4kCAwOBAQEBewAAAHoAAAB6AAAAegAA
AHsAAAB9AAAAglE5DcuOYAz/snYG/7p7Bv+scAP/iVoD/1c7CPdONgq6AAAAZQAAAFMAAABAAAAA
LQAAAB4AAAASAAAACQAAAAT///8A////AP///wAAAAABAAAAAgAAAAgAAAAQAAAAHB0cG5cmGAP/
dEwC/4ZYAf+AVQH/hVkE/3JLBf+YZQX/tncD/8qHAv/YlgP/m2sE/0c4IP9fWEz/W1VJ/19YTP9m
X1H/amJU/2tjVP9qYlP/aWFS/2hgUf9eVEH/Kx0H/2ZCAv+1dgL/wn8C/8iCAv/QiAL/248C/8iC
Av9FLQH/IxYE9h0WCasAAABYAAAARAAAAC4AAAAeAAAAEwAAAAr///8A////AP///wAAAAABAAAA
AQAAAAcAAAAPAAAAHB0ZFPJhPwH/fFIB/3NMAf9xWi3/sa2m/9zd3v/h3tX/rZZo/8SBA//ZmAP/
4aIE/3RUGv/Z19T/09TV/9nZ2v/p6er/9/j4//z8/P/7+/v/+vr5//j4+P+TgmT/VjkB/6NqAv+1
dgL/vXoC/61xAf+rbwL/0IcC/+mYAv+iagL/QiwD/ywfCv8AAABXAAAAQwAAAC4AAAAcAAAAEAAA
AAn///8A////AP///wD///8AAAAAAQAAAAQAAAAJHx8eTS4hCv9rRgH/d00B/2ZGCv+ysq//w8XG
/9fX2f/s7e3/8u/r/6xzCP/YlAP/46YE/4JYBv/Fvq//09TV/9XW1//m5uf/9vb1//z7+//6+vr/
+fn4/9LLvf9aPAL/h1gB/6VsAv+lbAL/dEwB/3NVG/+FdFH/WEQe/8uFAv/vnAL/WzwB/yobAv8A
AAA5AAAAKwAAAB0AAAARAAAACAAAAAT///8A////AP///wD///8AAAAAAQAAAAEAAAAEJCQjdEQw
Cv9mQwH/cksB/2tZOP/HyMr/wsPF/87P0P/j5OT/9PX1/6h7KP/YkwP/5KgF/35YBP+pmHr/09TV
/9PU1f/k5OX/8/T0//v6+v/5+fn/+Pf3/5R3Qf9ySwH/jl0C/5plAv+RXwL/sJt1/9HR0f/b2tn/
xbys/8F+BP/7owL/jl0B/z8oAf8AAAAZAAAAEwAAAA0AAAAHAAAABAAAAAH///8A////AP///wD/
//8A////AP///wAAAAABJSUkcUUxCv9iQAH/bUgB/2xbO//S09T/xcbH/8fIyv/Y2dr/7O3t/6yJ
R//WkQP/5asF/4VcA/+pmXr/0tPU/9LT1P/i4+P/8/Pz//r5+f/4+Pj/08u9/4laAf91TQH/kF4C
/4BUAf+3o3z/09LT/9jX1//f39//k3tR/+GSBP/5ogL/mmQB/0wwAv8LDA0JBAUFBQAAAAMAAAAB
AAAAAQAAAAD///8A////AP///wD///8A////AP///wD///8AJSUkQEAuCv9dPgH/aEUB/2FDC//O
zMr/0NLT/8rLzf/T1NX/5ufn/6qHRv/XkQP/5q0F/55tA/+qmnv/09TV/9LT0//i4uP/8fHx//f3
9//39/b/oIBG/4ZYAv94TgH/fVEB/4dtPP/d3Nz/2dnY/9zb2/+0ppD/oWsJ/+qZAv/olwL/mmUC
/1Y2Av8pLTEIIyYqAwAAAAEAAAAAAAAAAAAAAAD///8A////AP///wD///8A////AP///wD///8A
JSUkIDInEP9VOAH/ZEIB/3BJAf99ZTv/2dfW/9fY2f/Z2dr/5ufn/6mHRv/YlQP/57AG/59vA/+r
mnv/1tbX/9PV1v/i4uP/8fDw//b29v+spJX/oWsG/3FKAf9/UwH/VjgB/7mwn//d3Nz/19fX/6WX
fv96Uwz/0IgD/96QAv+/fQL/omoC/z8qCv8sMDUMLDA1BAAAAAAAAAAAAAAAAAAAAAD///8A////
AP///wD///8A////AP///wD///8A////ACkmHr88KAH/WjsB/2tGAf93TgH/eFwq/8a/tf/m5+f/
7e3u/6mHR//amgT/6LIG/59wA/+smn3/2NnZ/9bX2P/j5OT/8PDw/9TSzf+LZB3/wH0C/149Af+B
VQH/Qy0B/9PRzv/Hw7z/hXFK/4FXCv/BfgL/zYUB/8yFAf+vcwH/jV0D/zktGf8sMDUOLDA1BP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////ACUlJDAzJxL/OyYB
/2E/Af91TQH/glYC/4ZaB/+Oayr/vKJy/6pxCP/cmwT/6bQG/4hhA/+unX7/3t7e/9zc3f/n5+b/
5eXj/5l4O//PhwL/yYQC/3FKAf+CVQH/cUoC/2ZGC/92UAr/o2wF/8OAAf/OhgH/248C/9GIAv+0
dgL/YEsm/1JLPv8sMDUKLDA1A////wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wAlJSRgSzQN/1o5AP91TAD/kF8B/6RsAv+0dwL/wX4C/8+MA//fowX/6rUG
/4lgA/+wn4D/5OPk/+Hh4f/c3Nv/c2FA/8+IBP/WjAL/0ogC/6dtAv+DVQL/oGgB/7Z2Av/EgAH/
0YgC/9+RA//hlAP/3pEC/759Bf+PeVL/npyY/1dQQ/8sMDUELDA1Af///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8AT0o/gIdzUP+QXwf/rnIC/7Z5
A/+9gQP/y5AE/9ylBf/lsAb/6rYG/5tqA/+yoID/5+fn/9TV1P9nWT//zYcE/9yPAv/bjwL/2IwC
/82FAv+9ewL/yIwe/9ubJ//loif/6qQk/9GRG/+2eg7/qYdK/7iwof/T0dD/qqqp/1xVR/8sMDUB
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8AeHFggP/////a2NX/sKmb/6mZfP+MZR//t30G/92mBf/msgb/5qgF/7R1A/+xoID/4eLi/25l
Vf++fQP/0YgC/9qOAv/ekQL/3ZAC/+CaGf/quV//uJhb/6aUcv+ejnL/sqWO/8G4qP/c2tn/2tnY
/9jX1f/W1NP/rayr/2BZS/////8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8AfXVlgP///////////////3laIf+/hQP/1J4F/9+rBv/e
pwz/n41n/7uGJv/LxLT/cWxk/6BrB/+7egH/xYAB/9OJAv/fkQL/6qUo/+6/av++r5L/1dXU/9nY
1//d3Nz/3t3c/93c2//b2tj/2dfW/9bV0//U0tH/rKuq/2NcT/////8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8AgXpqgP//////////
/////7qoiP/BhwT/1qEF/9qnDv+qlmj/m5J8/5SJcP+0raD/TkIp/7F0Av+zdgH/uXkB/8iDAf/q
qC7/37Rm/7ywnP/f39//3Nvb/93c3P/e3dz/3t3b/9za2f/Z2Nb/19XU/9XT0f/S0c//q6qp/2Zg
Uv////8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8Ahn9vgP////////////////Ty8P+lein/0Z0O/7Cec/+lnYn/opmE/5+WgP+ZkHn/
cGZQ/0c3Gf+1dwH/tXYB/8OGFf/ku23/w7ei/+Xk4//j4uH/4eDf/9/e3f/d3Nv/3Nva/9rY1//X
1tX/1dTS/9PR0P/Qz83/qqmo/2ljVv////8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8AioN0gP////////////////7+/v/a0sL/tXoQ
/7Kig/+qo5D/p5+M/6Obh/+hmIT/lYx3/1VNOv9oSQ//t34T/8CaVv+UhGj/2tra/+Lh4P/i4eD/
4eDf/9/e3P/d29r/2tnY/9jX1f/W1NP/09LQ/9HPzv/Ozcv/qain/21mWf////8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8Aj4h5gP//
/////////v7+//39/f/8/Pz/0MWx/6KQav+tppb/pp6N/6egjv+8t6r/qKCN/2FZSP87NSj/alYx
/3hnSP/CwsL/1NPT/9/e3f/g397/397d/93c2//b2dj/2dfW/9bV0//U0tH/0dDO/8/NzP/Ny8n/
qKem/3BqXP////8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8Ak41+gP/////+/v7//f39//z8/P/7+/v/4d/a/3NpUv+jnY3/kYl3/66m
lv/Hxb3/trCg/4V9bf9ZVUz/mZiV/7Gxsv+8vLz/z87O/9va2v/f3t3/3tzb/9va2f/Z2Nb/19XU
/9TT0f/S0M//z87M/83Lyv/Lycf/p6al/3NtYP////8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8AmJGDgP/////+/v7//Pz8//v7+//w
7+3/gXhi/2pgSP98dWP/l5KH/5aThv+vqJr/saqa/6yllP94dGv/u7u8/7Ozs/+6urr/y8rK/9jY
1//d3Nv/3NvZ/9rY1//X1tT/1dPS/9PRz//Qzs3/zszK/8vJx//IxsT/pKOi/3ZwZP////8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
nJaIgP7+/v/9/f3/+/v7//f29v+Xj33/bmRL/3JnT/9uZE7/jIh+/4yJgP+qpZj/ta6g/7Wunv+B
e23/tLSy/7a2tv+5ubn/yMjH/9bU0//b2tn/2tnX/9jW1f/V1NP/09HQ/9HPzf/Ozcv/zMrI/8nH
xf/Dwb//n52c/3l0Z/////8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8AoZuNgP7+/v/8/Pz/+vr6/7eypv9zaFD/d21V/3txWv98cl3/
d3Fi/46NhP+dmpD/vLep/7y2qP+tp5n/gn95/7u7u/+3t7f/wsLC/9HQzv/Y1tX/2NfW/9bV0//U
0tH/0dDO/8/Ny//Mysn/ysjG/8bEwv+5t7X/mZeW/313a/////8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8ApqCSgP7+/v/7+/v/0M3G
/3huV/98clv/fXNe/4N6Zf+GfWr/Z2FS/3x5cv+joJf/vLes/8K9sf++uav/cm1i/7m4uP+3t7f/
u7u7/8nIyP/U0tH/1tTT/9TT0f/S0M//z87M/83Lyf/Kycf/yMbE/768uv+tq6j/kpGP/4B6bv//
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8AqqWYgP39/f/m5eH/iH9s/4F3Y/+FfGj/i4Ju/4+Gc/+NhnP/UExB/42Lhf+0sqr/vruy
/8jDuf/GwbX/op2R/4WDff+4uLf/trW1/8HAwP/Ozcv/09HQ/9LRz//Qzs3/zczK/8vJx//IxsT/
wsC+/7Oxrv+hnpv/jIqJ/4N+cv////8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8Ar6qdgPX19P+dlob/hn1q/4qCb/+RiXb/lo17/5OM
ev9eWUz/o6Kd/8nJyP+7t7D/zcnC/8/Lwf/MyL7/x8O4/25pYP+2tbT/srKy/7m4uP/GxcT/z83M
/8/OzP/OzMv/zMrI/8nHxf/Fw8H/uLa0/6ekov+UkY7/hoSC/4eBdv////8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8Aq6aZgLOtof+N
hXL/kop4/5iQf/+clYT/mZKB/1BKPf+hoJr/2drZ/9/f3/+8urb/19TN/9XSyv/Tz8f/0MzD/42I
gP+Rj4z/sbGw/7Kxsf+9vbv/ycfG/87Myv/Mysn/ysjG/8bEwv+9u7j/raqo/5uYlP+IhIH/f317
/4qFev////8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8AoJuNr5aOfP+YkYD/n5iH/6GbjP+gmov/YFtP/5iWkf/e3d7/5OTj/+bl5P/f
3t3/xcK8/9za1P/Z19D/1tPL/8/Mw/9iXVX/s7Oy/66trf+1tLP/wcC//8nIxv/Jx8X/x8XD/8C+
vP+zsK3/oZ6b/46LiP9ua2b/ZmRh/42Iff////8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wC6t65goJmJ/6Gaiv+lno//qaKU/6Sfkv9eWU//
joyG/9/g3//m5uX/5+fm/+Xk5P/k4+L/v725/+Ph3f/g3tj/3drU/9nWz/+FgXn/lpSR/6ysq/+u
raz/ubm3/8TCwf/GxMP/w8C+/7e1s/+Wk47/cm5o/1JNRv8+OjL/c3Fr/5SOgN////8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////ALy5sjCrpZfvp6GT
/6ummP+wq57/rKeb/1xXTf+JhoD/3Nva/+bl5P/o5+b/5+bl/+Xk4//j4uH/2tnY/8XDv//m5eH/
4+Hd/+De2f/Ewbv/aWZf/66trf+pp6f/r6+u/6+sqv+gnZj/hIB4/2hiWf9cV07/UUxE/356df+y
sK7/o5+U/5mThUD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8AuLauELSvpM+wqp7/ta+i/7WwpP+2sqf/eHRp/3d1bv/c29r/5ubl/+fn5v/m5eX/5eTj
/+Pi4f/h4N//397d/7e1sf/t7Or/6unm/+bl4f/i4dz/d3Rs/6Wkov+mpaT/qKin/3FrY/96dm7/
ko6H/7Kvq//W1NL//v7+/+7u7v+5t7P/oJqMr////wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8AtrOqj7m0qP+9uK3/wLuw/8C9s/+Hgnn/d3Rt/9jX
1//m5eT/6Ofm/+fm5f/m5eT/5OPi/+Lg3//f3t3/3dzb/9TT0f+8urb/8PDu/+3s6v/q6eb/q6ij
/3p4c/+npaT/oqGh/315dP/g4eH//Pz8////////////+Pj4/9DQ0P+nopbvpJ6QIP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8AvLiu/8XAtv/J
xbz/y8e//5eSiv9va2P/09PR/+Li4f/n5+b/5+bm/+bl5P/k4+L/4uHg/+Df3v/e3Nv/29rZ/9nY
1v+0sq//6+vq//Pz8v/w8O//6+rp/2ZiXf+rqqn/oJ+e/4iGg//U1NX/+/v7///////9/f3/5eXk
/7KvqP+qpZdw////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8AxcG5/9HNxf/W08v/wb64/3FtZP/W1dT/5eTj/+fm5f/o5+b/5+bl/+Xk4//j
4uD/4N/e/97d3P/c29n/2tjX/9fW1P/V09L/trWy//X19f/19fX/8vLy/5KPiv+amZb/o6Gf/3l2
cP/S09P/+/v7///////y8vL/wsG//66pnb////8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8AxcO7/97b1f/Pzcj/fHhw/+Tj4f/t7ez/
6Ojo/+jn5//m5eT/5eTj/+Pi4f/h4N//397c/9zb2v/a2dj/2NbV/9bU0//T0tD/rKqm/+vq6v/1
9fX/9fX1/8rJxv+Bfnv/paSh/4OAev/S09P//Pz8//r6+v/Y2Nf/r6ui/7CrnjD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8ApqOb
j9vZ1f+XlY//p6OYv/f39//v7+7/6uno/+jn5v/m5eT/5OPi/+Hg3//f3t3/3dzb/9vZ2P/Y19b/
1tXT/9TS0f/R0M7/z83L/66sqP/19fX/9fX1/9bV0/+Fgn3/paOg/4N/ev/S0tL//fz8/+rq6v+2
tbD/sKuegP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AJeVjXCVkopgsKuegPf39v/u7e3/6Ofm/+bl5P/k4+L/4uHg
/+Df3f/d3Nv/29rZ/9nY1v/X1dT/1NPR/9LQz//Pzsz/zcvJ/6mno//e3t3/9fX1/7Syrv+DgHv/
n5uZ/4SAfP/Pz8//9PT0/8rJyP+vq5/P////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8AsKuegPb2
9f/t7Ov/5+bl/+Tk4//i4eD/4N/e/97d3P/c2tn/2djX/9fW1P/V09L/0tHP/9DOzf/OzMr/y8nH
/8jHxf+jop7/4eDf/3l2b/+dmpf/lJGN/3p2cv/IyMj/39/e/7Kvpu+wq54w////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8AsKuegPX19f/r6+r/5eTj/+Pi4f/h4N//3t3c/9zb2v/a2df/2NbV/9XU
0v/T0dD/0c/N/87My//Mysj/ycfF/8XDwf+joZ7/amdh/5GOiv+alpP/jImF/397d/+5uLj/vry2
/7CrnnD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8AsKuegPX19P/4+Pj/+Pj3//f39//3
9/b/9vb2//b19f/19fX/9fT0//T08//z8/P/8/Ly//Ly8f/y8fH/8fDw/+/u7v/t7Oz/6uno/9/e
3f/Qz83/t7Wy/42MiP+4t7T/sKuen////wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
sKueQMC8td+9urP/vLmy/7q4sf+5trD/uLWu/7e0rf+2s6z/tLGr/7Owqf+yr6j/sK2n/6+spf+u
q6T/rKmi/52alP+bmZL/mZeQ/5aUjf+Sj4n/jImC/5ORjL+0r6SP////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD/
//8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP//
/wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////
AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///8A
////AP///wD///8A////AP///wD///8A////AP///wD///8A////AP///wD///////8AAP//////
/wAA////////AAD/4D////8AAP/AH//D/wAA/4AAfgD/AAD/AAAAAD8AAP8AAAAAPwAA/wAAAAA/
AAD/AAAAAD8AAP8AAAAAPwAA/wAAAAA/AAD/AAAAAD8AAP8AAAAAPwAA/4AAAAA/AAD/wAAAAD8A
AP/AAAAAPwAA/8AAAAA/AAD/wAAAAD8AAP/AAAAAPwAA/8AAAAA/AAD/wAAAAD8AAP/AAAAAPwAA
/8AAAAA/AAD/wAAAAD8AAP/AAAAAPwAA/8AAAAA/AAD/wAAAAD8AAP/AAAAAPwAA/8AAAAA/AAD/
wAAAAD8AAP/AAAAAPwAA/8AAAAA/AAD/gAAAAH8AAP8AAAAAfwAA/gAAAAD/AAD+AAAAAf8AAP4A
AAAB/wAA/gAAAAP/AAD+AAAAA/8AAP/AAAAH/wAA/8AAAA//AAD/wAAAH/8AAP/AAAAf/wAA/+AA
AD//AAD///////8AAP///////wAA////////AAA=')
#endregion
$formCreateNMEMasterList.Name = "formCreateNMEMasterList"
$formCreateNMEMasterList.Text = "Create NME Master List"
$formCreateNMEMasterList.add_Load($formCreateNMEMasterList_Load)
#
# checkboxUseWildcardSearchkey
#
$checkboxUseWildcardSearchkey.Location = '13, 176'
$checkboxUseWildcardSearchkey.Name = "checkboxUseWildcardSearchkey"
$checkboxUseWildcardSearchkey.Size = '264, 24'
$checkboxUseWildcardSearchkey.TabIndex = 15
$checkboxUseWildcardSearchkey.Text = "Use wildcard search (*keyword*)"
$checkboxUseWildcardSearchkey.UseVisualStyleBackColor = $True
#
# labelNumberOfFilesToSplit
#
$labelNumberOfFilesToSplit.Location = '12, 322'
$labelNumberOfFilesToSplit.Name = "labelNumberOfFilesToSplit"
$labelNumberOfFilesToSplit.Size = '263, 23'
$labelNumberOfFilesToSplit.TabIndex = 14
$labelNumberOfFilesToSplit.Text = "Number of files to split into:"
#
# ColumnsForKey
#
$ColumnsForKey.DropDownStyle = 'DropDownList'
$ColumnsForKey.FormattingEnabled = $True
$ColumnsForKey.Location = '12, 92'
$ColumnsForKey.Name = "ColumnsForKey"
$ColumnsForKey.Size = '228, 21'
$ColumnsForKey.TabIndex = 13
#
# labelColumnToUseAsKeyforV
#
$labelColumnToUseAsKeyforV.Location = '13, 66'
$labelColumnToUseAsKeyforV.Name = "labelColumnToUseAsKeyforV"
$labelColumnToUseAsKeyforV.Size = '264, 23'
$labelColumnToUseAsKeyforV.TabIndex = 12
$labelColumnToUseAsKeyforV.Text = "Column to use as key: (for values in the file below)"
#
# FileBuildingProgress
#
$FileBuildingProgress.Location = '0, 428'
$FileBuildingProgress.Name = "FileBuildingProgress"
$FileBuildingProgress.Size = '289, 23'
$FileBuildingProgress.TabIndex = 11
#
# statusbar
#
$statusbar.Location = '0, 451'
$statusbar.Name = "statusbar"
$statusbar.Size = '289, 22'
$statusbar.TabIndex = 10
$statusbar.Text = "Ready"
#
# buttonBuildFiles
#
$buttonBuildFiles.Location = '13, 379'
$buttonBuildFiles.Name = "buttonBuildFiles"
$buttonBuildFiles.Size = '264, 43'
$buttonBuildFiles.TabIndex = 9
$buttonBuildFiles.Text = "Build file(s)"
$buttonBuildFiles.UseVisualStyleBackColor = $True
$buttonBuildFiles.add_Click($buttonBuildFiles_Click)
#
# buttonBrowseFolder
#
$buttonBrowseFolder.Location = '246, 249'
$buttonBrowseFolder.Name = "buttonBrowseFolder"
$buttonBrowseFolder.Size = '30, 23'
$buttonBrowseFolder.TabIndex = 4
$buttonBrowseFolder.Text = "..."
$buttonBrowseFolder.UseVisualStyleBackColor = $True
$buttonBrowseFolder.add_Click($buttonBrowseFolder_Click2)
#
# textboxFolder
#
$textboxFolder.AutoCompleteMode = 'SuggestAppend'
$textboxFolder.AutoCompleteSource = 'FileSystemDirectories'
$textboxFolder.Location = '12, 251'
$textboxFolder.Name = "textboxFolder"
$textboxFolder.Size = '228, 20'
$textboxFolder.TabIndex = 3
$textboxFolder.add_TextChanged($textboxFolder_TextChanged)
#
# NumberOfFiles
#
$NumberOfFiles.DropDownStyle = 'DropDownList'
$NumberOfFiles.Enabled = $False
$NumberOfFiles.FormattingEnabled = $True
$NumberOfFiles.Location = '12, 348'
$NumberOfFiles.Name = "NumberOfFiles"
$NumberOfFiles.Size = '129, 21'
$NumberOfFiles.TabIndex = 7
#
# checkboxSplitTheFilesForMe
#
$checkboxSplitTheFilesForMe.Enabled = $False
$checkboxSplitTheFilesForMe.Location = '13, 295'
$checkboxSplitTheFilesForMe.Name = "checkboxSplitTheFilesForMe"
$checkboxSplitTheFilesForMe.Size = '264, 24'
$checkboxSplitTheFilesForMe.TabIndex = 6
$checkboxSplitTheFilesForMe.Text = "Split the files for me!"
$checkboxSplitTheFilesForMe.UseVisualStyleBackColor = $True
$checkboxSplitTheFilesForMe.add_CheckedChanged($checkboxSplitTheFilesForMe_CheckedChanged)
#
# labelSaveFilesTo
#
$labelSaveFilesTo.Location = '12, 225'
$labelSaveFilesTo.Name = "labelSaveFilesTo"
$labelSaveFilesTo.Size = '100, 23'
$labelSaveFilesTo.TabIndex = 5
$labelSaveFilesTo.Text = "Save file(s) to:"
#
# checkboxMigrateAllUsersusedT
#
$checkboxMigrateAllUsersusedT.Location = '13, 198'
$checkboxMigrateAllUsersusedT.Name = "checkboxMigrateAllUsersusedT"
$checkboxMigrateAllUsersusedT.Size = '264, 24'
$checkboxMigrateAllUsersusedT.TabIndex = 3
$checkboxMigrateAllUsersusedT.Text = "Migrate all users (used to only split the master file)"
$checkboxMigrateAllUsersusedT.UseVisualStyleBackColor = $True
$checkboxMigrateAllUsersusedT.add_CheckedChanged($checkboxMigrateAllUsersusedT_CheckedChanged)
#
# buttonUserMigrateBrowse
#
$buttonUserMigrateBrowse.Location = '247, 147'
$buttonUserMigrateBrowse.Name = "buttonUserMigrateBrowse"
$buttonUserMigrateBrowse.Size = '30, 23'
$buttonUserMigrateBrowse.TabIndex = 1
$buttonUserMigrateBrowse.Text = "..."
$buttonUserMigrateBrowse.UseVisualStyleBackColor = $True
$buttonUserMigrateBrowse.add_Click($buttonUserMigrateBrowse_Click)
#
# textboxUserToMigrate
#
$textboxUserToMigrate.AutoCompleteMode = 'SuggestAppend'
$textboxUserToMigrate.AutoCompleteSource = 'FileSystem'
$textboxUserToMigrate.Location = '13, 149'
$textboxUserToMigrate.Name = "textboxUserToMigrate"
$textboxUserToMigrate.Size = '228, 20'
$textboxUserToMigrate.TabIndex = 0
$textboxUserToMigrate.add_TextChanged($textboxUserToMigrate_TextChanged)
#
# labelUsersToMigratevalues
#
$labelUsersToMigratevalues.Location = '13, 123'
$labelUsersToMigratevalues.Name = "labelUsersToMigratevalues"
$labelUsersToMigratevalues.Size = '264, 23'
$labelUsersToMigratevalues.TabIndex = 2
$labelUsersToMigratevalues.Text = "Users to migrate: (values matching the above key)"
#
# buttonMasterListBrowse
#
$buttonMasterListBrowse.Location = '247, 37'
$buttonMasterListBrowse.Name = "buttonMasterListBrowse"
$buttonMasterListBrowse.Size = '30, 23'
$buttonMasterListBrowse.TabIndex = 1
$buttonMasterListBrowse.Text = "..."
$buttonMasterListBrowse.UseVisualStyleBackColor = $True
$buttonMasterListBrowse.add_Click($buttonMasterListBrowse_Click)
#
# textboxMasterTSV
#
$textboxMasterTSV.AutoCompleteMode = 'SuggestAppend'
$textboxMasterTSV.AutoCompleteSource = 'FileSystem'
$textboxMasterTSV.Location = '13, 39'
$textboxMasterTSV.Name = "textboxMasterTSV"
$textboxMasterTSV.Size = '228, 20'
$textboxMasterTSV.TabIndex = 0
$textboxMasterTSV.add_TextChanged($textboxMasterTSV_TextChanged)
#
# labelSourceMasterTsv
#
$labelSourceMasterTsv.Location = '13, 13'
$labelSourceMasterTsv.Name = "labelSourceMasterTsv"
$labelSourceMasterTsv.Size = '262, 23'
$labelSourceMasterTsv.TabIndex = 0
$labelSourceMasterTsv.Text = "Source master tsv:"
#
# openfiledialog1
#
$openfiledialog1.DefaultExt = "txt"
$openfiledialog1.Filter = "Text File (.tsv)|*.tsv|All Files|*.*"
$openfiledialog1.ShowHelp = $True
#
# openfiledialog2
#
$openfiledialog2.DefaultExt = "txt"
$openfiledialog2.Filter = "Text File (.txt)|*.txt|All Files|*.*"
$openfiledialog2.ShowHelp = $True
#
# folderbrowserdialog1
#
#
# folderbrowserdialog2
#
#endregion Generated Form Code
#----------------------------------------------
#Save the initial state of the form
$InitialFormWindowState = $formCreateNMEMasterList.WindowState
#Init the OnLoad event to correct the initial state of the form
$formCreateNMEMasterList.add_Load($Form_StateCorrection_Load)
#Clean up the control events
$formCreateNMEMasterList.add_FormClosed($Form_Cleanup_FormClosed)
#Show the Form
return $formCreateNMEMasterList.ShowDialog()
} #End Function
#Call OnApplicationLoad to initialize
if((OnApplicationLoad) -eq $true)
{
#Call the form
Call-CreateMasterLists_pff | Out-Null
#Perform cleanup
OnApplicationExit
}