[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Tempore 14:45:37, die 02/09/2005 AD, hinc in xsl-list@xxxxxxxxxxxxxxxxxxxxxx scripsit Ian Vaughan <i.vaughan@xxxxxxxxxxxxxxxxxxxxxxx>:
The way to the best solution depends on the XML. When no information is provided, are the elements then missing or do they have no text node children?
If I may assume the latter, you might try this:
<xsl:template match="/">
<xsl:text>UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems
</xsl:text>
<xsl:apply-templates select="//BuildingRecord"/>
</xsl:template>
</xsl:stylesheet>
produces:
UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems
2,02,Name,Street Name,,,Town,SA128JW,20/01/2005,Shower,New Unit
the field names are generated automatically here, if you prefer hard coding them, just omit all templates with mode set to 'label'.
Re: [xsl] Generating a CSV file using XSLT
Subject: Re: [xsl] Generating a CSV file using XSLT From: "Joris Gillis" <roac@xxxxxxxxxx> Date: Wed, 09 Feb 2005 19:17:44 +0100 |
Tempore 14:45:37, die 02/09/2005 AD, hinc in xsl-list@xxxxxxxxxxxxxxxxxxxxxx scripsit Ian Vaughan <i.vaughan@xxxxxxxxxxxxxxxxxxxxxxx>:
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
The way to the best solution depends on the XML. When no information is provided, are the elements then missing or do they have no text node children?
If I may assume the latter, you might try this:
<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:text>UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems
</xsl:text>
<xsl:apply-templates select="//BuildingRecord"/>
</xsl:template>
<xsl:template match="BuildingRecord"> <xsl:apply-templates select=".//*[not(*)] | .//apd:*/*"/> <xsl:text> </xsl:text> </xsl:template>
<xsl:template match="BuildingRecord//* | apd:*/* "> <xsl:if test="position() > 1 ">,</xsl:if> <xsl:value-of select="normalize-space(.)"/> </xsl:template>
</xsl:stylesheet>
produces:
UniqueRecordID, RegistrationNumber, RegisteredName, Address1, Address2, Address3, Address4,PostCode, DateComplete, DescriptionOfWorkItems, DescriptionOfWorkItems
2,02,Name,Street Name,,,Town,SA128JW,20/01/2005,Shower,New Unit
the field names are generated automatically here, if you prefer hard coding them, just omit all templates with mode set to 'label'.
regards, -- Joris Gillis (http://www.ticalc.org/cgi-bin/acct-view.cgi?userid=38041) "Et ipsa scientia potestas est" - Francis Bacon , Meditationes sacrae
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Generating a CSV file usi, Ian Vaughan | Thread | RE: [xsl] Generating a CSV file usi, Ian Vaughan |
RE: [xsl] Using XML/XSLT for forms , Pieter Reint Siegers | Date | [xsl] Combining call-template with , Frans Englich |
Month |
Keywords