Re: Generating a CSV file using XSLT

Tempore 14:45:37, 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>:
> 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() &gt; 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

--~------------------------------------------------------------------
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>
--~--