PowerShell script to generate Rewrite Maps config files based on as CSV file

GenerateRewriteMap.ps1

param([string] $csvPath, [string] $configOutputPath, [string] $rewriteMapName)

$csv = Import-Csv -Delimiter ";" -Path $csvPath

$xml = New-Object -TypeName XML
$xml.Load($configOutputPath)

$rewriteMap = Select-XML -Xml $xml -XPath "//rewriteMap[@name='$rewriteMapName']"
$rewriteMap.Node.SelectNodes('//add') | ForEach { $_.ParentNode.RemoveChild($_) } | Out-Null

foreach($redirectLine in $csv){
    $newRedirect = $xml.CreateElement("add")
    $newRedirect.SetAttribute("key", $redirectLine.from)
    $newRedirect.SetAttribute("value", $redirectLine.to)

    $rewriteMap.Node.AppendChild($newRedirect) | Out-Null
}

$xml.Save($configOutputPath)