Converting XML to CSV (using XSLT)

Question

I have the following XML code, and need to convert this to a .csv file. I don't need the whole xml file, but i have to select some xml tags.

<contract_Set>
<contract_period>
    <reference>111111</reference>
    <startperiod>2017-09-01</startperiod>
    <endperiod>2017-09-06</endperiod>
    <vehicle_Set>
      <vehicle>
        <vehicle_id>4444</vehicle_id>
        <make>Mercedes-Benz</make>
      </vehicle>
    </vehicle_Set>
    <invoice_Set>
      <invoice>
        <id>12345</id>
        <description>Some text</description>
      </invoice>
    </invoice_Set>
    <invoice_Set>
      <invoice>
        <id>12222</id>
        <description>More text</description>
      </invoice>
    </invoice_Set>
</contract_period>
<contract_period>
    <reference>222222</reference>
    <startperiod>2017-09-01</startperiod>
    <endperiod>2017-09-30</endperiod>
    <vehicle_Set>
      <vehicle>
        <vehicle_id>55555</vehicle_id>
        <make>Audi</make>
      </vehicle>
    </vehicle_Set>
    <invoice_Set>
      <invoice>
        <id>45678</id>
        <description>Audi text</description>
      </invoice>
    </invoice_Set>
</contract_period></contract_Set>

I need my output to be like:

Reference;Make;Invoice_Id;Invoice_Description
111111;Mercedes-Benz;12345;Some text
111111;Mercedes-Benz;12222;More text
222222;Audi;45678;Audi text

How can i do this with XSLT 1.0? I have searched for solutions in similar questions, but no success. I'm looking to select values of some tags, not all tags.

You can literally search for your question title and find two dozen working solutions. Pick one of them. — Tomalak
– Tomalak, Commented Sep 11, 2017 at 9:32
this i s aduplicate of stackoverflow.com/questions/365312/xml-to-csv-using-xslt — MartinByers
– MartinByers, Commented Sep 11, 2017 at 9:47
I have been searching for an answer in existing questions..ofcourse. I did not find any solutions where it is possible to select the values of some xml tags, while ignoring others. — Stuart
– Stuart, Commented Sep 11, 2017 at 10:49

Aniket V · Accepted Answer · 2017-09-12 12:42:25Z

The following XSL will provide the desired output.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="text" />
    <xsl:variable name="separator" select="'&#59;'" />
    <xsl:variable name="newline" select="'&#10;'" />

    <xsl:template match="/">
        <xsl:text>Reference;Make;Invoice_Id;Invoice_Description</xsl:text>
        <xsl:value-of select="$newline" />
        <xsl:for-each select="//invoice_Set">
            <xsl:value-of select="../reference" />
            <xsl:value-of select="$separator" />
            <xsl:value-of select="../vehicle_Set/vehicle/make" />
            <xsl:value-of select="$separator" />
            <xsl:value-of select="invoice/id" />
            <xsl:value-of select="$separator" />
            <xsl:value-of select="invoice/description" />
            <xsl:value-of select="$separator" />
            <xsl:value-of select="$newline" />
        </xsl:for-each>
    </xsl:template>
</xsl:stylesheet>

Output

Reference;Make;Invoice_Id;Invoice_Description
111111;Mercedes-Benz;12345;Some text;
111111;Mercedes-Benz;12222;More text;
222222;Audi;45678;Audi text;

User515 · Accepted Answer · 2017-09-11 12:55:30Z

0

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
  <xsl:output method="text" encoding="iso-8859-1"/>

  <xsl:strip-space elements="*" />

  <xsl:template match="/">
    <xsl:text>Reference;Make;Invoice_Id;Invoice_Description</xsl:text>
    <xsl:text>&#xa;</xsl:text>
    <xsl:apply-templates select="contract_Set"/>     
</xsl:template>

  <xsl:template match="contract_period">
      <xsl:value-of select="reference"/>;<xsl:value-of select="vehicle_Set/vehicle/make"/>;<xsl:value-of select="invoice_Set/invoice/id"/>;<xsl:value-of select="invoice_Set/invoice/description"/>;
  </xsl:template>
</xsl:transform>

answered Sep 11, 2017 at 12:55

User515

18613 bronze badges

1 Comment

Stuart Over a year ago

Thank you for your answer. Unfortunately, I'm only getting two records in my output. 111111;Mercedes-Benz;12222;More text is missing

Collectives™ on Stack Overflow

Converting XML to CSV (using XSLT)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related