How to update a string in the [xml] attribute using powershell?

Question

I am having numerous web.config files. In which URL contains machine name.

This is my sample web.config file

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.Model>
<client>
      <endpoint address="http://MyMachineName:80/MyProj/Core/NewService/SecurityObject.0/Secretservice.svc" binding="basicHttpBinding" bindingConfiguration="MyProj_Internal_Routing" behaviorConfiguration="UserSIDBehavior" contract="SecurityMgmt.SecurityMgmtContract" name="HttpEndpointSecMgt" />
      <endpoint address="http://MyMachineName:80/MyProj/Core/DataObject/SystemCatalogs1.0/DataObjectservice/DataObjectservice.svc" binding="basicHttpBinding" bindingConfiguration="MyProj_Internal_Routing" behaviorConfiguration="UserSIDBehavior" contract="DataObjectservice.SystemCatalogsDataObjectservice" name="BasicHttpBinding_SystemCatalogsDataObjectservice" />
      <endpoint address="http://MyMachineName:80/MyProj/Core/NewService/Movement.0/Movement.svc" binding="basicHttpBinding" bindingConfiguration="MyProj_Internal_Routing" behaviorConfiguration="UserSIDBehavior" contract="NavigationClientLib.NavigationNewService" name="BasicHttpBinding_NavigationNewService" />
 </client>

 <system.Model>

 </configuration>

When user changes machine name this has to be updated in all the xml files.

I decided to write a function like this.

    Function Update-MachineName ([string] $FilePath,[string] $xpath, [string] $NewMachineName="NewComputer") {


    # Get the config file contents
    $WebConfig = [XML] (Get-content $Filepath)

    #Find the url using xpath which has old Machine name 
    $hostnameString= Select-XML -XML $WebConfig -XPath $Xpath

    Foreach ( $hostname in $hostnameString) { 

           if ( ($hostname.Node.value -match 'http') -eq $true ) {

               $hostname.Node.value
               $MachineOldName = $($($hostname.Node.value.split("/"))[2].split(":"))[0]
               $MachineOldName

               $hostname.Node.value.replace( $MachineOldName,$NewMachineName)

           }
    }

 $WebConfig.Save($FilePath)
}

Update-MachineName "C:\web.config" "//@address"

Though i replace with new machine name, still the web.config content doesn't updated. How to make it updated with the new Machine name

Shay Levy · Accepted Answer · 2012-05-14 12:44:19Z

3

Your replacement value is not saved back on the node. Change this line:

$hostname.Node.value.replace( $MachineOldName,$NewMachineName)

To

$hostname.Node.value=$hostname.Node.value.replace( $MachineOldName,$NewMachineName)

answered May 14, 2012 at 12:44

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Brabant · Accepted Answer · 2012-05-14 12:42:30Z

3

If it's only for replacing machine names in the XML structure you mentioned above, you don't really need to parse XML and use XPath...

$oldMachineName = "MyMachineName"
$newMachineName = "MyBrandNewMachineNAme"

$content = Get-Content -path $filePath
$content | foreach { $_.Replace($oldMachineName, $newMachineName) } | Set-Content $filePath

answered May 14, 2012 at 12:42

David Brabant

43.9k16 gold badges93 silver badges119 bronze badges

Comments

jumbo · Accepted Answer · 2012-05-14 12:03:02Z

1

In your function, you must save the file back to the disk. You are manipulating with xml in memory, so changes will be visible only in the console, not in the actual file.

answered May 14, 2012 at 12:03

jumbo

4,8986 gold badges41 silver badges44 bronze badges

1 Comment

Samselvaprabu Over a year ago

:I have added save function also but still no use ($WebConfig.Save($FilePath))

Kiquenet · Accepted Answer · 2014-11-17 08:42:37Z

0

You can use like this:

$nodoEndpointSvcAddress = $($configXml.configuration.'system.serviceModel'.client.endpoint |  where { $_.name -eq "MyEndPoint1" })
[string]$endpointSvcAddress = $nodoEndpointSvcAddress.address
Write-Host $endpointSvcAddress

# Replace
$server = "test"
iif ($endpointSvcAddress.Contains($server))
{
    Write-Host "`r`nReplace $endpointSvcAddress"
    $nodoEndpointSvcAddress.address=$nodoEndpointSvcAddress.address.replace( $server,"PROSERVER")
    Write-Host ("Replaced " + $nodoEndpointSvcAddress.address)

}

$configXml.Save($pathCDR)

answered Nov 17, 2014 at 8:42

Kiquenet

15.2k36 gold badges152 silver badges250 bronze badges

Collectives™ on Stack Overflow

How to update a string in the [xml] attribute using powershell?

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related