Any idea of how I could transform the XML doc into the following layout
below in the csv file ??
With the SchemeName at the start of the .csv file then the column titles
followed by the relevant rows of information from the xml doc.
Ie.
SchemeName - DATA
UniqueRecordID RegistrationNumber RegisteredName Address1, Address2,
Address3, Address4,PostCode,DateComplete,DescriptionOfWorkItems...
2,02,Name,StreetName, , ,Town,SA128JW,20/01/2005,Shower,New Unit
3,03,Name,StreetName,Road , ,Town,SA128JW,20/01/2005,Shower,New Unit
2,02,NameStreet Name Town SA128JW ,20/01/2005,Shower,New Unit
-----------
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:apd="http://www.govtalk.gov.uk/people/AddressAndPersonalDetails";>
<xsl:template match="/">
<xsl:apply-templates select="//BuildingRecord"/> </xsl:template>
<xsl:template match="BuildingRecord">
<xsl:apply-templates select=".//text()"/>
<xsl:text>
</xsl:text>
</xsl:template>
<xsl:template match="text()">
<xsl:if test="position() > 1
"><xsl:text>,</xsl:text></xsl:if>
<xsl:value-of select="normalize-space(.)"/> </xsl:template>
<xsl:template match="apd:*//text()">
<xsl:value-of select="normalize-space(.)"/><xsl:text>
</xsl:text> </xsl:template>
</xsl:stylesheet>
------------------------------
-----Original Message-----
From: Joris Gillis [mailto:roac(_at_)pandora(_dot_)be]
Sent: 09 February 2005 11:29
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Generating a CSV file using XSLT
Tempore 12:10:20, die 02/09/2005 AD, hinc in
xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com scripsit Ian Vaughan
<i(_dot_)vaughan(_at_)neath-porttalbot(_dot_)gov(_dot_)uk>:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">
<xsl:output method="text"/>
<xsl:template match="BuildingRecord">
<xsl:value-of
select="normalize-space(SchemeUniqueRecordIdentifier)"/>,
<xsl:value-of
select="normalize-space(CompetentPerson/PersonRegistrationNumber)"/>,
<xsl:value-of
select="normalize-space(CompetentPerson/InstallerRegisteredName)"/>,
<xsl:value-of
select="normalize-space(WorkPerformed/PropertyInformation/PropertyLoca
ti
on/PropertyAddress/)"/>,
<xsl:value-of
select="normalize-space(WorkPerformed/DateWorkCompleted)"/>,
<xsl:value-of
select="normalize-space(WorkPerformed/DescriptionOfWorkItem)"/>,
</xsl:template>
</xsl:stylesheet>
Hi,
Maybe you could make more use of templates to get the same result:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:apd="http://www.govtalk.gov.uk/people/AddressAndPersonalDetails";>
<xsl:template match="/">
<xsl:apply-templates select="//BuildingRecord"/> </xsl:template>
<xsl:template match="BuildingRecord">
<xsl:apply-templates select=".//text()"/>
<xsl:text>
</xsl:text>
</xsl:template>
<xsl:template match="text()">
<xsl:if test="position() > 1
"><xsl:text>,</xsl:text></xsl:if>
<xsl:value-of select="normalize-space(.)"/> </xsl:template>
<xsl:template match="apd:*//text()">
<xsl:value-of select="normalize-space(.)"/><xsl:text>
</xsl:text> </xsl:template>
</xsl:stylesheet>
output:
2,02,NameStreet Name Town SA128JW ,20/01/2005,Shower,New Unit
regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-view.cgi?userid=38041)
"Et ipsa scientia potestas est" - Francis Bacon , Meditationes sacrae
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--