Powershell add attribute to xml node

# Import active directory module
import-module activedirectory

# create template

$template =@'
<employees version='1.0'>
	<employee>
	<name></name>
	<samaccountname></samaccountname>
	<telephonenumber></telephonenumber>
	<title></title>
	<l></l>
	<department></department>
	<buildingName></buildingName>
	<extensionattribute10></extensionattribute10>
	<roomnumber></roomnumber>
	</employee>
</employees>
'@
$template | Out-File c:\inetpub\wwwroot\VingeOfficexml\users.xml -encoding UTF8

# load template into XML object
$xml = New-Object xml

$xml.Load("c:\inetpub\wwwroot\VingeOfficexml\users.xml")
if ($success -ne $true) {
    $($xml.LastErrorText)
    exit
}


# grab template user
$newuser = (@($xml.employees.employee)[0]).Clone()

# Grab the users from active directory
get-aduser user -properties Name,samaccountName,telephonenumber,title,l,department,buildingName,ExtensionAttribute10,roomNumber|

ForEach-Object {
	$newuser = $newuser.clone()
    $newuser.Name = $_.Name
	$newuser.samaccountname = $_.samaccountname
	$newuser.telephonenumber = $_.telephonenumber
	$newuser.title = $_.title
	$newuser.l = $_.l
	$newuser.department = $_.department
	$newuser.buildingName = $_.buildingName[0].toString()
    $newuser.extensionattribute10 = $_.extensionattribute10.toString()
    $newuser.roomnumber = $_.roomnumber[0].tostring()
    
	$xml.employees.AppendChild($newuser) > $null
}

#clean the xml from template
$xml.employees.employee | 
Where-Object { $_.name -eq "" } | ForEach-Object  { [void]$xml.employees.RemoveChild($_) }
# save xml to file
$xml.Save("c:\inetpub\wwwroot\VingeOfficexml\employees.xml")

Select allOpen in new window