# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# Filename: Import_DistroGroup.ps1
# Version:     2016.03.15
# Purpose: Imports the managers, allowed senders, allowed sender 
# groups, member-of groups, group members, and group email addresses
# from a collection of csv files at the path specified by the InPath 
# variable. The files were created by the Export_DistroGroup script.
#
# Note: This script uses the Quest ActiveRoles PowerShell snapin for
# retrieving the groups that this group is a member of.
# 
# Usage:
# Import_DistroGroup "Group Name"
# "Group Name" must be the exact name of the group in the on-premises
# Exchange organization.
# 

Param(
    [string]$Group
)

# Specify the path of your input files. This should be the same as
# the OutPath from Export_DistroGroup.
$InPath = "C:\Temp\Groups\"

# If the Completed folder doesn't exist, create it.
$CompletePath = $InPath + "Completed\"
if (-not (Test-Path $CompletePath)) {
    New-Item $CompletePath -Type Directory
}

# These variables tell the script where to find the individual csv
# files.
$AcceptFromFile = $InPath + $Group + "-AcceptFrom.csv"
$AcceptFromDLFile = $InPath + $Group + "-AcceptFromDL.csv"
$ManagersFile = $InPath + $Group + "-Managers.csv"
$MembersFile = $InPath + $Group + "-Members.csv"
$MemberOfFile = $InPath + $Group + "-MemberOf.csv"
$SettingsFile = $InPath + $Group + "-Settings.csv"

# This variable holds the name of the group as it will be created
# in Exchange Online.
$OLGroup = $Group + " OL"

# Load the Quest AD snapin.
if ((get-pssnapin -name quest.activeroles.admanagement -EA 0) `
  -eq $null) {
    Write-Host "Loading Quest..."
    Add-PsSnapin quest.activeroles.admanagement
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a an AcceptFrom file, add the list of allowed senders to
# the online group and move the file to the Completed folder.
if (Test-Path $AcceptFromFile) {
    Write-Host "Adding acceptable senders..."
    $AcceptFrom = Import-CSV $AcceptFromFile
    $AcceptFrom | Foreach {Set-DistributionGroup $OLGroup `
        -AcceptMessagesOnlyFrom @{add=$_.UserPrincipalName}}
    Move-Item $AcceptFromFile -Destination $CompletePath
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a an AcceptFromDL file, add the list of allowed senders
# to the online group and move the file to the Completed folder.
if (Test-Path $AcceptFromDLFile) {
    Write-Host "Adding acceptable Group senders..."
    $AcceptFromDL = Import-CSV $AcceptFromDLFile
    $AcceptFromDL | Foreach {Set-DistributionGroup $OLGroup `
        -AcceptMessagesOnlyFromDLMembers @{add=$_.Name}}
    Move-Item $AcceptFromDLFile -Destination $CompletePath
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a Managers file, add the managers to the ManagedBy
# attribute and move the file to the Completed folder.
if (Test-Path $ManagersFile) {
    Write-Host "Adding group managers..."
    $Managers = Import-CSV $ManagersFile
    $Managers | Foreach {
        Set-DistributionGroup $OLGroup `
            -ManagedBy @{add=$_.UserPrincipalName}
    }
    Move-Item $ManagersFile -Destination $CompletePath
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a Members file, add the members to the online group and
# move the file to the Completed folder. If there is no Members file,
# consider whether you need to migrate this group at all.
if (Test-Path $MembersFile) {
    Write-Host "Adding group members..."
    $Members = Import-CSV $MembersFile
    $Members | Foreach {Add-DistributionGroupMember $OLGroup `
        -Member $_.UserPrincipalName}
    Move-Item $MembersFile -Destination $CompletePath
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a MembersOf file, add this online group to the listed 
# groups. Skip any groups that the online group is already a member of.
# Move the file to the Completed folder.
if (Test-Path $MemberOfFile) {
    Write-Host "Adding group to other groups..."
    $MemberOf = Import-CSV $MemberOfFile
    $CurrentMemberOf = (Get-QADMemberOf $OLGroup | Select GroupName)
    $MemberOf | Foreach {
        if ($CurrentMemberOf.GroupName -NotContains $_.GroupName) {
            $GroupName = $_.GroupName + " OL"
            Add-DistributionGroupMember $GroupName -Member $OLGroup
        }
    }
    Move-Item $MemberOfFile -Destination $CompletePath
}

# xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
# If there is a Settings file, apply the contents to the online group
# and move the file to the Completed folder. If you modified this
# section in Export_DistroGroup, be sure to mirror those modifications
# here.
if (Test-Path $SettingsFile) {
    Write-Host "Writing miscellaneous group settings..."
    $Settings = Import-CSV $SettingsFile
    $Settings | Foreach {
        if ($_.HiddenFromAddressListsEnabled -eq "true") {
            $Hide = $True
        }
        else {$Hide = $False}
        if ($_.RequireSenderAuthenticationEnabled -eq "true") {
            $ReqAuth = $True
        }
        else {$ReqAuth = $False}
        Set-DistributionGroup $OLGroup `
            -HiddenFromAddressListsEnabled $Hide `
            -RequireSenderAuthenticationEnabled $ReqAuth
    }
    Move-Item $SettingsFile -Destination $CompletePath
}