printing XML file with XSLT code

Assume the following XML file:
>
<?xml version="1.0" encoding="UTF-8"?>
<abc>
<def>
<mno>2008-06-11-13:15:59</mno>
<pqr stu="World">Hello</pqr>
</def>
<ghi>
<jkl vwx="12345678" </jkl>
</ghi>
</abc>
>
Below is my desired out. As you can see for each element I print
"element=value" and for each attribute within an element I print
"element_attribute=value"
>
mno=2008-06-11-13:15:59
pqr=Hello
pqr_stu=World
jkl_vwx=12345678

Can somebody point me in the right direction or provide me with some
sample XSLT transformation code that can do this.
>
Keep in mind, I would like to keep this as generic as possible. That
is I don't want to reference element or attributes by names.

Being a newbie with XSLT transformation code please excuse my neivte.
In addition, I am not sure what I want to do can be done with xslt so
I apologize up front for asking anything stupid
>
I have a shell script that needs to get values from an XML file. What
I want to do is transform the XML into something more KSH friendly so
it can be easy to parsed in my KSH script.
>
I would like to go through an entire XML document and for every
"element" and "element/attribute" print the associated value in NVP
(name value pair).
>
Assume the following XML file:
>
<?xml version="1.0" encoding="UTF-8"?>
<abc>
<def>
<mno>2008-06-11-13:15:59</mno>
<pqr stu="World">Hello</pqr>
</def>
<ghi>
<jkl vwx="12345678" </jkl>
</ghi>
</abc>
>
Below is my desired out. As you can see for each element I print
"element=value" and for each attribute within an element I print
"element_attribute=value"
>
mno=2008-06-11-13:15:59
pqr=Hello
pqr_stu=World
jkl_vwx=12345678
>
Can somebody point me in the right direction or provide me with some
sample XSLT transformation code that can do this.
>
Keep in mind, I would like to keep this as generic as possible. That
is I don't want to reference element or attributes by names. I would
like something like this
>
for each element
do
if attribute
print element_attribute=value
else
print element=value
done
>
As oppose to say search element "pqr" and print value
>
Thanks to all who answer

Stu wrote:
>

Quote: >Assume the following XML file: >> ><?xml version="1.0" encoding="UTF-8"?> ><abc> > <def> > <mno>2008-06-11-13:15:59</mno> > <pqr stu="World">Hello</pqr> > </def> > <ghi> > <jkl vwx="12345678" </jkl> > </ghi> ></abc> >> >Below is my desired out. As you can see for each element I print >"element=value" and for each attribute within an element I print >"element_attribute=value" >> >mno=2008-06-11-13:15:59 >pqr=Hello >pqr_stu=World >jkl_vwx=12345678

>
The following script in XMLgawk does it:
>
@load xml
XMLCHARDATA { data = $0 }
XMLSTARTELEM { for (i in XMLATTR) print XMLSTARTELEM "_" i "=" XMLATTR[i] }
XMLENDELEM && data ~ /[:alnum:]/ { print XMLENDELEM "=" data }
>
It produces the output you wanted (except for a change in sequence).

Quote: >The following script in XMLgawk does it: >> >@load xml >XMLCHARDATA { data = $0 } >XMLSTARTELEM { for (i in XMLATTR) print XMLSTARTELEM "_" i "=" >XMLATTR[i] } >XMLENDELEM && data ~ /[:alnum:]/ { print XMLENDELEM "=" data } >> >It produces the output you wanted (except for a change in sequence).

>
[:alnum:] delivers correct results with the given test data, but I guess
you meant:
XMLENDELEM && data ~ /[[:alnum:]]/ ...

Hermann Peifer schrieb:
>

Quote: Quote: >>The following script in XMLgawk does it: >>> >>@load xml >>XMLCHARDATA { data = $0 } >>XMLSTARTELEM { for (i in XMLATTR) print XMLSTARTELEM "_" i "=" >>XMLATTR[i] } >>XMLENDELEM && data ~ /[:alnum:]/ { print XMLENDELEM "=" data } >>> >>It produces the output you wanted (except for a change in sequence). >> >[:alnum:] delivers correct results with the given test data, but I >guess you meant: >XMLENDELEM && data ~ /[[:alnum:]]/ ...

>
No, I thought [:alnum:] was sufficient.
Does it really make a difference in this example ?

Jürgen Kahrs wrote:

Quote: >Hermann Peifer schrieb: >> Quote: >>>The following script in XMLgawk does it: >>>> >>>@load xml >>>XMLCHARDATA { data = $0 } >>>XMLSTARTELEM { for (i in XMLATTR) print XMLSTARTELEM "_" i "=" >>>XMLATTR[i] } >>>XMLENDELEM && data ~ /[:alnum:]/ { print XMLENDELEM "=" data } >>>> >>>It produces the output you wanted (except for a change in sequence). >>> >>[:alnum:] delivers correct results with the given test data, but I >>guess you meant: >>XMLENDELEM && data ~ /[[:alnum:]]/ ... >> >No, I thought [:alnum:] was sufficient. >Does it really make a difference in this example ?

>
[:alnum:] is treated as list of characters: 'a', 'l', 'm', 'n', 'u', and
':', whereas [[:alnum:]] is treated as a character class. The former
will match 'Hello', but not 'HELLO', whereas the latter will match both.

You know both languages equally well (XSL and XMLgawk).
Would you prefer the XSL solution that was posted here ?

Big files (say: 100+ MB), with a flat, regular structure -XMLgawk
Small files with many optional and/or empty elements -XSL

Hermann Peifer wrote:

Quote: Big files (say: 100+ MB), with a flat, regular structure -XMLgawk Small files with many optional and/or empty elements -XSL

>
Depends in part the XSLT processor, of course. Some handle large
documents better than others.

Of course. Reality is not as black and white as my rule of thumb
suggests. Would you have any pointer to some helpful XSLT processor
comparison/benchmarking?

Hermann Peifer wrote:

Quote: >Of course. Reality is not as black and white as my rule of thumb >suggests. Would you have any pointer to some helpful XSLT processor >comparison/benchmarking?

>
Most of what I've been doing has been using the W3C/NIST XPath and XSLT
conformance suites (pointed to from http://www.w3.org/QA/TheMatrix),
test sets such as the DataPower (now IBM) XSLTMark kernels (described at
http://www.xml.com/pub/a/2001/03/28/xsltmark/), or customer datasets
(which for obvious reasons I can't share).
>
I do know that the XSLT processor in the DataPower product can recognize
at least some cases where a document can be processed in a streaming
manner rather than reading it all into memory at once. That depends on
the nature of the stylesheet, of course; I'm not sure exactly where the
current limits are. But when this optimization works, it permits
handling huge documents and reduces latency, both of which are good
things. Websearch on "DataPower streaming" finds some discussion of this.
>
I don't think Apache Xalan has any true streaming capability yet, though
we've wanted it for many years. However, Xalan's internal data model
(DTM) is considerably more space-efficient than a standard Java DOM,
which improves its ability to handle large documents. (We had a version
of DTM which reduced overhead to only 16 bytes per XML node -- but
compressing things that far cost us some performance and imposed some
limitations we didn't like, so we had to let it grow a bit.)
>
I haven't used XMLgawk. But part of the point of XML is precisely that
adopting a shared (and relatively simple) syntax eases the task of
writing useful and reusable tools, and there's certainly a large amount
of "let a thousand flowers bloom" built into that assumption. I prefer
to stick to the W3C's standardized tools as much as possible, both to
push those to improve and for best portability of my work, but if
another tool does something XSLT really can't, or does it far better
than the copy of XSLT you have available to you, I'm not going to tell
you not to use it.