Guys !!! Request your assistance: ======================== Im parsing an XML file; creating 2 PSCustomObjects; adding child objects to it; for some reason Im not able to merge these to 2 PSCustomObjects; once its merged, Ive to export to a CSV file; Plz review the below and assist asap. ======================== # Import XML file and cast it to a Variable $XML = [xml] (Get-Content D:\Temp\HardDiskSt\survey2014-03-11-20-05-43.xml) $LDArray = $xml.selectnodes(//device) | Where {$_.class -eq logicalDrive} $SDCntrlArray = $xml.selectnodes(//device) | Where {$_.class -eq storageController} $export = @() # # PSCustomObject 1 If ($LDArray.count -gt 0) {$i = 0 While ($i -lt $LDArray.count) { $LDInfo1 = New-Object -TypeName PSObject $LDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value $LDArray[$i].class $LDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value $LDArray[$i].class $export += $LDInfo1 $i= $i+1 } } Else { $LDInfo1 = New-Object -TypeName PSObject $LDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value Value1 $LDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value Value1 $export += $LDInfo1 } $LDInfo1 # PSCustomObject 2 If ($SDCntrlArray.count -gt 0) {$i = 0 While ($i -lt $SDCntrlArray.count) { $SDInfo1 = New-Object -TypeName PSObject $SDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value $SDCntrlArray[$i].class $SDInfo1 | Add-Member -MemberType NoteProperty -Name Property2 -value $SDCntrlArray[$i].class $export += $HDInfo1 $i= $i+1 } $HDInfo1 } Else { $SDInfo1 = New-Object -TypeName PSObject $SDInfo1 | Add-Member -MemberType NoteProperty -Name Property1 -value Value1 $SDInfo1 | Add-Member -MemberType NoteProperty -Name Property2 -value Value2 $export += $HDInfo1 } $Export | select * | export-csv renais.csv -notype -Append -Force ========================
Posted on: Sat, 15 Mar 2014 10:48:38 +0000
Trending Topics
Recently Viewed Topics
© 2015