Using PowerShell to download XML, and save as CSV file?

Question

I'm fairly new to PowerShell, but have a strong C# background.

The task I'm trying to accomplish is to download some XML, and then save some of the elements from the XML file in a .csv file. I don't need all the elements from the XML, just a few items.

The XML looks something like this:

<result>
  <case>
    <InputData>
      <Id>1</Id>
      <Firstname>John</Firstname>
      <Lastname>Smith</Lastname>
      <....lots more properties and subnodes I don't need>
    </InputData>
  </case>
</result>

I've managed to download the XML using something like this:

$downloaded = ([Xml](New-Object Net.WebClient).DownloadString("http://url.to.server/file.xml"))

Now I need to extract just a few of the properties from the XML, and export it to CSV file.

I understand that I can reach the data with $downloaded.result.case[0].InputData.Firstname, but need some advice on how to extract a few of the properties and save as CSV.

Scott Weinstein · Accepted Answer · 2009-06-30 19:17:39Z

4

you could do something like:

$downloaded.result.case | %{ $_.InputData }`
| select Firstname,Lastname `
| Export-Csv -path foo.csv -NoTypeInformation

edited Jun 30, 2009 at 19:17

answered Jun 30, 2009 at 16:46

Scott Weinstein

19.1k15 gold badges83 silver badges117 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Frode Lillerud Over a year ago

Very good, but how can I loop over every Case, not hardcode to case[0]? Also, the columns in the .csv file become separated by comma. How can I choose the delimiter?

Scott Weinstein Over a year ago

edited answer to address your first comment Q. As for the second, in PowerShell v2, there is a -delimiter option, but in v1 it requires a hand coded solution

Tomalak · Accepted Answer · 2009-06-30 13:33:56Z

0

XSLT is a (the?) standard way when it comes to transforming XML to something else.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" />

  <xsl:template match="InputData">
    <xsl:value-of select="concat('"', Id, '"')" />
    <xsl:value-of select="','" />
    <xsl:value-of select="concat('"', Firstname, '"')" />
    <xsl:value-of select="','" />
    <xsl:value-of select="concat('"', Lastname, '"')" />
    <xsl:value-of select="&#10;" />
  </xsl:template>

</xsl:stylesheet>

Some Powershell context: www.hanselman.com: XSLT with Powershell

answered Jun 30, 2009 at 13:33

Tomalak

340k68 gold badges547 silver badges635 bronze badges

Collectives™ on Stack Overflow

Using PowerShell to download XML, and save as CSV file?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related