[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Variations in XML to CSV

Subject: Re: Variations in XML to CSV
From: Michel Hendriksen <michel.hendriksen@xxxxxxxxx>
Date: Thu, 21 Apr 2011 16:40:44 +0200
Re:  Variations in XML to CSV

Its hard to say when you don't provide an output sample. I guess order
is important etc.

Maybe you need to take several steps. Like determine how mayn subject
elements you have max etc. Then maybe sort your input so all same
named elements are consecutive. And then generate as many as you have
for each element padding with empty items when you have run through.


On Thu, Apr 21, 2011 at 4:30 PM, Bridger Dyson-Smith
<bdysonsmith@xxxxxxxxx> wrote:
> Hi all,
> thanks for taking a moment to read.
> I'm trying to generate a CSV file from XML that looks something like this:
> <root>
>  <metadata>
>    <title>Alpha</title>
>    <subject>Sinister</subject>
>    <creator>Beta</creator>
>    <subject>Gamma</subject>
>    <subject>Delta</subject>
>    <subject>Epsilon</subject>
>    <date>2011-04-19</date>
>  </metadata>
>  <metadata>
>    <title>Zeta</title>
>    <creator>Eta</creator>
>    <creator>Theta</creator>
>    <contributor>Dexter</contributor>
>    <contributor>Iota</contributor>
>    <subject>Kappa</subject>
>    <subject>Lambda</subject>
>    <date>2011-04-19</date>
>  </metadata>
> </root>
> I'm at a complete loss. I've been reading (and rereading) examples
> from the XSLT Cookbook, but I haven't been able to make the examples
> jive with what I'm looking at on my screen. Is this even possible? If
> so, would someone mind giving me a push in the right direction?
> I've been able to generate a dummy XML file that has a complete set of
> all the elements:
> <root>
>  <metadata>
>    <title>Value</title>
>    <subject>Value</subject>
>   <creator>Value</creator>
>   <creator>Value</creator>
>   <contributor>Value</contributor>
>   <subject>Value</subject>
>   <subject>Value</subject>
>   <subject>Value</subject>
>   <date>Value</date>
>  </metadata>
> </root>
> If I use this to generate a row of column names, I think I can map the
> variable elements to their respective columns provided I can get that
> aforementioned push. Maybe it needs to be a kick...
> Thanks again for reading.
> Cheers,
> Bridger

Current Thread


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.