Dylan posted from a non-sub'd addr. -bill!
----- Forwarded message from [email protected] ----- Date: Wed, 14 Jul 2010 14:15:52 -0700 From: [email protected] Subject: Auto-discard notification To: [email protected] The attached message has been automatically discarded. Date: Wed, 14 Jul 2010 14:10:54 -0700 From: Dylan Beaudette <[email protected]> Subject: Re: [vox-tech] complex XML to CSV via XSLT To: Harold Lee <[email protected]> Cc: "lugod's technical discussion forum" <[email protected]> Reply-To: [email protected] Thanks! That seemed to do the trick. However, I have a new problem. The following works when I have a simple XML document with only 1 'pedon' per 'pedon_collection' <xsl:template match="pedon_collection/pedon/vegetation"> <xsl:result-document href="vegetation.csv" format="csv"> <xsl:apply-templates select="*" /> </xsl:result-document> </xsl:template> <xsl:template match="vegetation_record"> <xsl:apply-templates /> <xsl:if test="following-sibling::*"> <xsl:value-of select="$break" /> </xsl:if> </xsl:template> <xsl:template match="vegetation_record/*"> <!-- remove normalize-space() if you want keep white-space at it is --> <xsl:value-of select="concat($quote, normalize-space(.), $quote)" /> <xsl:if test="following-sibling::*"> <xsl:value-of select="$delim" /> </xsl:if> </xsl:template> How can I apply these rules to _each_ 'pedon' in a 'pedon_collection', such the results are appended to the same file? Thanks! Dylan On Wednesday 14 July 2010, Harold Lee wrote: > If you want one XSLT program to output multiple files, then use the > result-document instruction/element: > > http://www.w3.org/TR/xslt20/#element-result-document > > It allows you to specify all of the formatting options available via > xsl:output, so you can output text - i.e. CSV - this way. > > Harold > > On Wed, Jul 14, 2010 at 11:40 AM, Dylan Beaudette > > <[email protected]> wrote: > > Hi, > > > > I have an XML file generated via PHP, and containing the contents of > > several linked tables from a relational database. I would like to > > generalize some sample XSLT documents to convert the entire file into a > > sequence of CSV files. The XML file will essentially be exploded back > > into a set of CSV files, one for each of the original tables. The idea > > would be to create a couple XSLT files for converting the XML format into > > several possible output formats. > > > > Attached is the XML file, as well as two XSLT files. I suppose that I > > could loop over the tables of interest, and apply separate XSLT files to > > the original XML-- saving to different output files each time. It would > > be more convenient to have all of that logic embedded in the XSLT file-- > > if possible. > > > > Any ideas? > > > > Cheers, > > Dylan > > > > > > -- > > Dylan Beaudette > > Soil Resource Laboratory > > http://casoilresource.lawr.ucdavis.edu/ > > University of California at Davis > > 530.754.7341 > > > > _______________________________________________ > > vox-tech mailing list > > [email protected] > > http://lists.lugod.org/mailman/listinfo/vox-tech -- Dylan Beaudette Soil Resource Laboratory http://casoilresource.lawr.ucdavis.edu/ University of California at Davis 530.754.7341 ----- End forwarded message ----- -- -bill! Sent from my computer _______________________________________________ vox-tech mailing list [email protected] http://lists.lugod.org/mailman/listinfo/vox-tech
