Revision history [back]

There are different ways to convert XML data to standard property output when displaying PowerShell properties. One approach is to use the Select-Object cmdlet to select the desired properties from the XML data and convert them to a PowerShell object. For example:

$xml = [xml] "<Root><Item><Name>John</Name><Age>30</Age></Item><Item><Name>Jane</Name><Age>25</Age></Item></Root>"
$items = $xml.SelectNodes("//Item")
$props = $items | Select-Object @{n="Name";e={$_.Name}}, @{n="Age";e={$_.Age}}
$props

In this example, we first define an XML string and convert it to an XML object using the [xml] type accelerator. We then select the Item nodes from the XML using an XPath query, and pipe them to Select-Object with calculated properties that convert the Name and Age XML elements to PowerShell properties. The resulting output is a PowerShell object with the Name and Age properties:

Name Age
---- ---
John  30
Jane  25

Another approach is to use a module such as ConvertTo-Property that can convert XML data to PowerShell objects with defined properties. This can be useful for more complex XML structures or for cases where the properties need to be transformed or renamed. For example:

Install-Module ConvertTo-Property -Scope CurrentUser -Force

$xml = [xml] "<Settings><Database><Server>localhost</Server><DatabaseName>Northwind</DatabaseName></Database></Settings>"
$props = $xml | ConvertTo-Property -PropertyMap @{Server="SqlServer";DatabaseName="Database"}
$props

In this example, we define an XML string with nested elements and use ConvertTo-Property with a property map that renames the Server and DatabaseName elements to SqlServer and Database, respectively. The resulting object has the renamed properties:

SqlServer  Database
---------  --------
localhost  Northwind