Update XML value with PowerShell

Question

I have some XML that is driving me crazy. I'm trying to simply update the XML file located in $env:USERNAME\Appdata\Local\file.xml. I cannot for the life of me work out how to find the value for SoftPhoneHotDeskExtension & SoftPhoneHotDeskCode and update them.

<NavigatePro>
  <UserPref>
    <Attribute Name="NavigateProInstalling">
      <Value>0</Value>
      <Type Value="4">DWord</Type>
    </Attribute>
    <Attribute Name="PlantronicsHeadsetSupportEnable">
      <Value>0</Value>
      <Type Value="1">String</Type>
    </Attribute>
    <Attribute Name="SoftPhoneHotDeskExtension">
      <Value>999</Value>
      <Type Value="1">String</Type>
    </Attribute>
    <Attribute Name="SoftPhoneHotDeskCode">
      <Value>888</Value>
      <Type Value="1">String</Type>
    </Attribute>
  </UserPref>
</NavigatePro>

I can list them out by name by using:

[xml]$XMLfile = Get-Content c:\users\$env:USERNAME\Appdata\Local\file.xml
$XMLFile.NavigatePro.UserPref.Attribute

This will show me the list of attributes by name and value but I cannot fathom how to update them and save them back. I have looked at XPath and using SingleNode but to no avail. Most of the errors come back stating they cannot find the node I'm looking for.

Jack Fleeting · Accepted Answer · 2022-04-25 13:20:03Z

2

If I understand you correctly, xpath is the solution here:

$extension = $xml.SelectSingleNode("//Attribute[@Name='SoftPhoneHotDeskExtension']/Value")
$extension.innerText="xxx"
$hdcode = $xml.SelectSingleNode("//Attribute[@Name='SoftPhoneHotDeskCode']/Value")
$hdcode.innerText="yyy"

and that should do it.

answered Apr 25, 2022 at 13:20

Jack Fleeting

25k6 gold badges27 silver badges49 bronze badges

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

1 Comment

Jack Fleeting Over a year ago

@g33kphr33k Glad it worked for you!

Theo · Accepted Answer · 2022-04-25 14:29:56Z

2

Another way would be to use the case-insensitive 'dot-notation':

$file = "$env:USERNAME\Appdata\Local\file.xml"
$xml  = [System.Xml.XmlDocument]::new()
$xml.Load($file)

($xml.navigatepro.userpref.attribute | Where-Object {$_.Name -eq 'softphonehotdeskextension'}).Value = '1234'
($xml.navigatepro.userpref.attribute | Where-Object {$_.Name -eq 'softphonehotdeskcode'}).Value = '5678'
$xml.Save($file)

^{To make sure your xml gets the encoding of the file correct, I suggest you use the .Load() method of the
XmlDocument Class instead of casting the result of Get-Content to [xml]}

answered Apr 25, 2022 at 14:29

Theo

61.9k8 gold badges28 silver badges48 bronze badges

Collectives™ on Stack Overflow

Update XML value with PowerShell

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related