I am trying to convert a CSV document into an XML document for import into a directory. The CSV is formatted as follows:
Firstname,Lastname,Email,Phone,Room,ID
Bob,Smith,[email protected],1111,Suite 101,1
John,Doe,[email protected],2222,Suite 102,2
The desired XML output needs to be as follows:
<?xml version="1.0" encoding="UTF-8"?>
<TSP version="1.1">
<contact firstname="Bob" lastname="Smith" email="[email protected]" Phone="1111" room="Suite 101" id="1"/>
<contact firstname="John" lastname="Doe" email="[email protected]" phone="2222" room="Suite 102" id="2"/>
</TSP>
Using information from this post Powershell CSV to XML I was able to get the following output which is close but missing some bindings:
<contact Firstname ="Bob" Lastname= "Smith Email= "[email protected] Phone= "1111" Room= "Suite 101" Phone= "1111" />
<contact Firstname ="John" Lastname= "Doe Email= "[email protected] Phone= "2222" Room= "Suite 102" Phone= "2222" />
Any help is very much appreciated!
Script Used:
$docTemplate = @'
<contact $($contacts -join "`n") />
'@
$entryTemplate = @'
Firstname ="$($Phone.Firstname)" Lastname= "$($Phone.Lastname) Email= "$($Phone.Email) Phone= "$($Phone.Phone)" Room= "$($Phone.Room)" Phone= "$($Phone.Phone)"
'@
Import-Csv Test.csv -Delimiter ',' | Group-Object Id -ov grp | ForEach-Object {
$contacts = foreach ($Phone in $_.Group) {
$ExecutionContext.InvokeCommand.ExpandString($entryTemplate)
}
$ExecutionContext.InvokeCommand.ExpandString($docTemplate) } |
Set-Content -LiteralPath file.xml
=and the start of the attribute value (e.g.,Phone= "$($Phone.Phone)"should bePhone="$($Phone.Phone)", and b) add a binding forID, which you left off from your template, just like the others demonstrate.ID, as I mentioned before. If you're having some problem other than that, it's not clear from your post.