'im getting problems while converting xml to csv using powershell

My xml looks like:

<Line>
  <Item>3820-2013-00</Item> 
  <Type>SpecTdp Revision</Type> 
  <Rev>B</Rev> 
  <Name>BLACK KAL-GARD SCREW</Name> 
  <owning_site /> 
  <Commodity>HO Hardware</Commodity> 
  <Family>HW-MEC Mech Part</Family> 
  <Security>Un Classified</Security> 
  <Status>Released</Status> 
  <ActionCode /> 
  <LogisticAlert /> 
  <MediaType>DI-MEDIA</MediaType> 
  <CompanyData>DD</CompanyData> 
  <EdnEng_Dwg /> 
  <Eco>D35882/00</Eco> 
  <Project /> 
  <plmpdf>un3820-2013-00#RevB#A0#S2.pdf</plmpdf> 
  <plmpdf_Link>un3820-2013-00#RevB#A0#S2.pdf</plmpdf_Link> 
  <change_plmpdf>unD35882#Rev00#A0#S1.pdf</change_plmpdf> 
  <change_plmpdf_Link>unD35882#Rev00#A0#S1.pdf</change_plmpdf_Link> 
  <ProdFiles>
    <prod>un3820-2013-00RevB.x_t</prod> 
    <prod>un3820-2013-00RevB.zip</prod> 
  </ProdFiles>
</Line>

I would like to get 2 rows in the CSV file for each <prodfiles> value.
When I'm doing:

$inputFile.Line.ChildNodes  | Export-Csv "$b" -NoTypeInformation -Delimiter:";" -Encoding:UTF8

I get xml.object for the value of prodfiles.

xmlpowershellcsv


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions