Joris
Using your suggested code the output generated in the CSV file is as
follows, as you can see all the row headers and data are being displayed
on the same line, shown below
LA Code
NICEIC
UniqueRecordID RegistrationNumber RegisteredName Address1 Address2
Address3 Address4 PostCode DateComplete DescriptionOfWorkItems
DescriptionOfWorkItems 24 2031 Name Street ..............etc
When it should look like what is shown below
LA Code DATA
<SPACE>
UniqueRecordID RegistrationNumber RegisteredName Address1 Address2
Address3 Address4 PostCode DateComplete DescriptionOfWorkItems
24 2031 Name Street etc.
I have tried changing the XSLT but with no success..
Another problem I am finding is that in the XML if some of the fields
hold data such as " House, House Name " then instead of that piece of
data being entered under Address 2, House goes under Address2 and House
Name goes into Address 3. As it is finding the comma seperating House,
House Name and splitting up the data.
Any ideas on a solution would be most helpful
ian
-----Original Message-----
From: Joris Gillis [mailto:roac(_at_)pandora(_dot_)be]
Joris
I have added the following lines to the template to get the display to
look like what is shown below with the LA Code hightlighting the data
in SchemeName, however in the results it is not returning the
SchemeName or the text LA Code ?? But it is returning the rest of the
information ??
Can you see why this is the case from the code I have added ?
Yes you have to make sure the template is applied:
<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="BuildingRecordSet"> <xsl:apply-templates
select="SchemeName"/> <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="SchemeName">
<xsl:text>LA Code
</xsl:text>
<xsl:apply-templates/>
<xsl:text>
</xsl:text>
</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>
regards,
--
Joris Gillis (http://www.ticalc.org/cgi-bin/acct-view.cgi?userid=38041)
Veni, vidi, wiki (http://www.wikipedia.org)
--~------------------------------------------------------------------
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>
--~--