How can i update a current value in a XML file using powershell?

Question

Hello everyone i dont know if this question is asked before but i need to update couple of values in a xml file using powershell i have the following code it works local but on tfs it doesn't work i get the following error System.Management.Automation.MethodInvocationException: Exception calling "ReadAllText" with "1" argument(s): "Value cannot be null.

And i have the following code

$EmployeeData= "C:\files\Employees.xml"
$oldEmployeeID= "23"
$NewEmployeeID= "25"

$content = [System.IO.File]::ReadAllText($EmployeeData).Replace($oldEmployeeID, $NewEmployeeID)
[System.IO.File]::WriteAllText($EmployeeData, $content)

localy it works but on tfs its crashes does anybody know why with the following error code

System.Management.Automation.MethodInvocationException: Exception calling "ReadAllText" with "1" argument(s): "Value cannot be null.

Could you elaborate "on tfs it doesn't work"? Did you include the script in TFS build? How's your build definition like? Which version of TFS are you using? — Cece Dong - MSFT
– Cece Dong - MSFT, Commented Apr 19, 2018 at 8:35

Ranadip Dutta · Accepted Answer · 2018-04-18 13:19:27Z

1

You do not need to use this. You can directly parse XML in powershell by type casting:

$EmployeeData= "C:\files\Employees.xml"
$oldEmployeeID= "23"
$NewEmployeeID= "25"

[XML]$content = Get-Content $EmployeeData

Then you can access $content.elementId or $content.nodename.

Follow THIS for your reference.

Hope it helps.

answered Apr 18, 2018 at 13:19

Ranadip Dutta

9,5493 gold badges33 silver badges48 bronze badges

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

Comments

Cece Dong - MSFT · Accepted Answer · 2018-04-19 09:34:35Z

0

If you want to update values/tokens in a XML file during TFS build, a simple way is to use Replace Tokens task or Tokenization Task in your build definition.

answered Apr 19, 2018 at 9:34

Cece Dong - MSFT

31.3k1 gold badge35 silver badges46 bronze badges

Collectives™ on Stack Overflow

How can i update a current value in a XML file using powershell?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related