Rename and Edit xml files using powershell

pushd " C:\sites\ASDF"
dir -Directory | % {rename-item "C:\sites\ASDF\$($_.Name)\Default.xml" "$($_.Name).xml"}
popd

Select allOpen in new window

Not checked here, test carefully

For question 2: do you want to modify data in the XML or change the structure?

Its like , I have One XML file in  d:/Site/Template/default.xml and parallel to the default.xml file and have two folders - CrsRep and my default.xml file contains the two nodes CrsRep and DOC. I need to automatically edit the nodes with the updated path of the folder.

I am using the below script to copy and rename all the folders.

$source = 'd:\Site\Template'
$target = 'd:\Site\'
$xmlPath = 'D:\Tenant.xml'

$xml = [xml](Get-Content -Path $xmlPath)
$envCode = $xml.SelectSingleNode('Tenants/ENVcode').InnerText.Trim()
$xml.SelectNodes('Tenants/Schools/School') | ForEach-Object {
      $name = "$($envCode)-$($_.InnerText.Trim())"
      $destination = Join-Path -Path $target -ChildPath $name
      Copy-Item -Path $source -Destination $destination -Recurse -Force -Verbose
      Get-ChildItem -Path $destination -Filter default.xml -Recurse | Rename-Item -NewName "$($name).xml"
}

After running this I will get all the folders with names listed in my Tenant file. Also inside all the folders, my default.xml file is renamed to name same as the folder name.xml. I just need to update the paths also inside all these new folder.xml with the corresponding new path in CrsRep and Doc Node.

Not sure if I get what you're trying to do
Have a look at Jeff Hicks excellent explanation of how to handle XML files in PowerShell:
https://www.petri.com/creating-custom-xml-net-powershell


HTH

Hi Michael,

I have folders and files in the below order.

Site -> SIT-1234 -> SIT-1234.xml, CrsRep, DocMan folders.
Site -> SIT-1245 -> SIT-1245.xml, CrsRep, DocMan folders.

 SIT-1234, SIT-2345 and such 100 more folders and inside all these there is one xml named as SIT-1234.xml, SIT-2345.xml and so on.
Below is my XML.

<?xml version="1.0" encoding="UTF-8"?>
<breakfast_menu>
  <food>
    <name>Belgian Waffles</name>
    <price>$5.95</price>
    <description>
   Two of our famous Belgian Waffles with plenty of real maple syrup
   </description>
    <calories>650</calories>
      <DocMan>a123.xml</DocMan>
      <Crystal reports>a124.xml</Crystal reports>
  </food>
</breakfast_menu>

I just need to update the DocMan and CrsRep node same as the path of these folders in all XMLs.