Public/Migration/CloudData/Sync-CloudData.ps1
|
using namespace System.Management.Automation.Host function Sync-CloudData { [CmdletBinding()] param ( [Parameter()] $ResultSize = 'Unlimited' ) #Region Paths $PoshPath = (Join-Path -Path ([Environment]::GetFolderPath('Desktop')) -ChildPath Posh365 ) $SourcePath = Join-Path -Path $PoshPath -ChildPath $InitialDomain if (-not ($null = Test-Path $SourcePath)) { $null = New-Item $PoshPath -Type Directory -Force -ErrorAction SilentlyContinue $null = New-Item $SourcePath -Type Directory -Force -ErrorAction SilentlyContinue } #EndRegion Paths #Region Choose Recipient $TypeGrid = foreach ($Item in 'Mailboxes', 'MailUsers', 'AzureADUsers') { [PSCustomObject]@{ RecipientType = $Item } } $TypeObject = $TypeGrid | Out-GridView -OutputMode Single -Title "Choose Recipient Type" $Type = $TypeObject.RecipientType if (-not $Type) { Write-Host 'Please run script again and select a recipient type. Halting script' -ForegroundColor Red continue } #EndRegion Choose Recipient #Region SOURCE Connect to Service ($InitialDomain) returned while (-not $InitialDomain) { $InitialDomain = Select-CloudDataConnection -Type $Type -TenantLocation Source } #EndRegion SOURCE Connect to Service #Region Invoke-GetCloudData ($SourceData) returned $SourceCsvFile = Join-Path -Path $SourcePath -ChildPath ('SyncCloudData_Source_{0}_{1}_{2}.csv' -f $Type, $InitialDomain, [DateTime]::Now.ToString('yyyy-MM-dd-hhmm')) $SourceData = Invoke-GetCloudData -ResultSize $ResultSize -InitialDomain $InitialDomain -Type $Type $SourceDataChoice = $SourceData | Out-GridView -Title "Choose objects to convert - no changes are made to any tenant on this step" -OutputMode Multiple $SourceDataChoice | Export-Csv -Path $SourceCsvFile -NoTypeInformation Write-Host "Source $Type objects chosen written to file: $SourceCsvFile`r`n" -ForegroundColor Green #EndRegion Invoke-GetCloudData #Region Ask if ready to convert $Yes = [ChoiceDescription]::new('&Yes', 'Convert Cloud Data: Yes') $No = [ChoiceDescription]::new('&No', 'Convert Cloud Data: No') $Title = 'Please make a selection' $Question = 'Convert data? (We only create a CSV in this step)' $Options = [ChoiceDescription[]]($Yes, $No) $Menu = $host.ui.PromptForChoice($Title, $Question, $Options, 0) #EndRegion Ask if ready to convert switch ($Menu) { 0 { #Region TARGET Connect to Service ($InitialDomain) returned $SourceInitialDomain = $InitialDomain ; $InitialDomain = $null $InitialDomain = Select-CloudDataConnection -Type $Type -TenantLocation Target while ($SourceInitialDomain -eq $InitialDomain -or -not $InitialDomain) { Write-Host "`r`nSource Tenant cannot be the same as the Target Tenant. Please connect to Target Tenant now.`r`n" -ForegroundColor White -BackgroundColor DarkMagenta $InitialDomain = Select-CloudDataConnection -Type $Type -TenantLocation Target } #EndRegion TARGET Connect to Service #Region TARGET Convert Source Data ($ConvertedData) returned $TargetCsvFile = Join-Path -Path $SourcePath -ChildPath ('SyncCloudData_Converted_{0}_{1}_{2}.csv' -f $Type, $InitialDomain, [DateTime]::Now.ToString('yyyy-MM-dd-hhmm')) $ConvertedData = Convert-CloudData -SourceData $SourceDataChoice -Type $Type $ConvertedData | Out-GridView -Title "Data converted for import into Target: $InitialDomain" $ConvertedData | Export-Csv -Path $TargetCsvFile -NoTypeInformation #EndRegion TARGET Convert Source Data ($ConvertedData) returned } 1 { Write-Host 'Halting Script' -ForegroundColor Red return } } #Region Y/N Write Converted Data to Target Tenant $Yes = [ChoiceDescription]::new('&Yes', 'Import: Yes') $No = [ChoiceDescription]::new('&No', 'Import: No') $Question = 'Write converted data to Target Tenant (if you opened it, verify SyncCloudData_Results.csv is closed)?' $Options = [ChoiceDescription[]]($Yes, $No) $Menu = $host.ui.PromptForChoice($Title, $Question, $Options, 1) #EndRegion Y/N Write Converted Data to Target Tenant switch ($Menu) { 0 { if ($Type -eq 'AzureADUsers') { $ResultFile = Join-Path -Path $SourcePath -ChildPath 'SyncCloudData_Results_AzureADUsers.csv' } else { $ResultFile = Join-Path -Path $SourcePath -ChildPath 'SyncCloudData_Results.csv' } New-CloudData -SourceData $ConvertedData -Type $Type | Export-Csv $ResultFile -NoTypeInformation -Append $ResultObject = Import-Csv $ResultFile $ResultObject | Out-GridView -Title $ResultFile $ResultObject | Export-PoshExcel (Join-Path -Path $SourcePath -ChildPath ('SyncCloudData_Results_EXCEL_{0}.xlsx' -f [DateTime]::Now.ToString('yyyy-MM-dd-hhmm') )) } 1 { Write-Host 'Halting Script' -ForegroundColor Red return } } } |