Restructure XML

[Matt]

I would like to restructure my xml with a generic style sheet to perform the following. I want to be able to inspect a group of nodes then place them into a collection node if there are more than one at the same level with the same name. This should occur as well if sub-levels have consecutive node names. Is this possible? I have worked on it for a while and have not come up with a method to generically do this. If anyone has any thoughts or ideas I'm listening.

SOURCE
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
<shift>day</shift>
<shift>night</shift>
</root>

Now I run through the generic stylesheet and what I want to now have is:

DESTINATION
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<collection>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
</collection>
<collection>
<shift>day</shift>
<shift>night</shift>
</collection>
</root>

Thanks,

Matt

[Robbe Morris [C# MVP]]

I'm not sure why you would bother. You could easily get a list of all the
people nodes or all the shift nodes by using the .SelectNodes method and
work with them as needed. What would putting them under a parent node
call collection do for you?

I'm guessing you don't have a lot of familiarity with XPath queries.
Perhaps you should take a look at this set of basic syntax samples.
It is a COM sample, not .NET, but the XPath queries are still applicable.

http://www.eggheadcafe.com/articles/20030627d.asp

But, to answer your question specifically, yes you can certainly do
what you are asking.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Matt" <md*****@sorvive.DONT-SEND-SPAM.com> wrote in message news:Om**************@tk2msftngp13.phx.gbl...
I would like to restructure my xml with a generic style sheet to perform the following. I want to be able to inspect a group of nodes then place them into a collection node if there are more than one at the same level with the same name. This should occur as well if sub-levels have consecutive node names. Is this possible? I have worked on it for a while and have not come up with a method to generically do this. If anyone has any thoughts or ideas I'm listening.

SOURCE
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
<shift>day</shift>
<shift>night</shift>
</root>

Now I run through the generic stylesheet and what I want to now have is:

DESTINATION
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<collection>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
</collection>
<collection>
<shift>day</shift>
<shift>night</shift>
</collection>
</root>

Thanks,

Matt

[Matt]

Robbe,

I am working with documents that have over 425 nodes in them and I do this
with more than 3000 customers. I am trying to find a way to work with their
XML documents more generically in our processes.

I have actually been working with XML for about 7 years now and that is why
I was probably making the sample XML too generic and simple. I understand
XPath quite well and know XQuery as well. I am trying to figure out how to
reformat our customers XML into a generic form to simply our processes. I
could easily do this if I received the same data from all 3000 customers but
I do not.

If you would like to work with one of my 100mb XML documents I would gladly
send it to you if you would like to see something much more complex. Let me
know if you would like to help out.

Matt
"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> wrote in message
news:eb*************@TK2MSFTNGP15.phx.gbl...
I'm not sure why you would bother. You could easily get a list of all the
people nodes or all the shift nodes by using the .SelectNodes method and
work with them as needed. What would putting them under a parent node
call collection do for you?

I'm guessing you don't have a lot of familiarity with XPath queries.
Perhaps you should take a look at this set of basic syntax samples.
It is a COM sample, not .NET, but the XPath queries are still applicable.

http://www.eggheadcafe.com/articles/20030627d.asp

But, to answer your question specifically, yes you can certainly do
what you are asking.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"Matt" <md*****@sorvive.DONT-SEND-SPAM.com> wrote in message
news:Om**************@tk2msftngp13.phx.gbl...
I would like to restructure my xml with a generic style sheet to perform
the following. I want to be able to inspect a group of nodes then place
them into a collection node if there are more than one at the same level
with the same name. This should occur as well if sub-levels have
consecutive node names. Is this possible? I have worked on it for a while
and have not come up with a method to generically do this. If anyone has
any thoughts or ideas I'm listening.

SOURCE
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
<shift>day</shift>
<shift>night</shift>
</root>

Now I run through the generic stylesheet and what I want to now have is:

DESTINATION
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<collection>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
</collection>
<collection>
<shift>day</shift>
<shift>night</shift>
</collection>
</root>

Thanks,

Matt

[Oleg Tkachenko [MVP]]

Matt wrote:

I would like to restructure my xml with a generic style sheet to perform
the following. I want to be able to inspect a group of nodes then place
them into a collection node if there are more than one at the same level
with the same name. This should occur as well if sub-levels have
consecutive node names. Is this possible? I have worked on it for a
while and have not come up with a method to generically do this. If
anyone has any thoughts or ideas I'm listening.

_*SOURCE*_
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
<shift>day</shift>
<shift>night</shift>
</root>

Now I run through the generic stylesheet and what I want to now have is:

*_DESTINATION_*
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<collection>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/>
</collection>
<collection>
<shift>day</shift>
<shift>night</shift>
</collection>
</root>

You could try something like this:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output indent="yes"/>
<xsl:key name="nameKey" match="*" use="concat(name(), '||',
generate-id(..))"/>
<xsl:template match="/|*" priority="1">
<xsl:for-each select="*[generate-id() =
generate-id(key('nameKey', concat(name(), '||', generate-id(..))))]">
<xsl:variable name="namesake" select="key('nameKey',
concat(name(), '||', generate-id(..)))"/>
<xsl:choose>
<xsl:when test="count($namesake) = 1">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="."/>
</xsl:copy>
</xsl:when>
<xsl:otherwise>
<collection>
<xsl:for-each select="$namesake">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="."/>
</xsl:copy>
</xsl:for-each>
</collection>
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:template>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>

PS. NOt optimized - just an idea.

--
Oleg Tkachenko [XML MVP, MCP]
http://blog.tkachenko.com

[Matt]

Oleg,

You kill me with how quickly you can create a solution! I don't know what I
would do without your suggestions. Now to only figure out how it works and
why.

Thanks again, this is exactly the type of thing I was looking for.

Matt
"Oleg Tkachenko [MVP]" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in message
news:ue**************@TK2MSFTNGP10.phx.gbl...

Matt wrote:

I would like to restructure my xml with a generic style sheet to perform
the following. I want to be able to inspect a group of nodes then place
them into a collection node if there are more than one at the same level
with the same name. This should occur as well if sub-levels have
consecutive node names. Is this possible? I have worked on it for a
while and have not come up with a method to generically do this. If
anyone has any thoughts or ideas I'm listening. _*SOURCE*_
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/> <shift>day</shift>
<shift>night</shift> </root>
Now I run through the generic stylesheet and what I want to now have is:
*_DESTINATION_*
<root>
<job>
<janitor/>
<programmer/>
<administrator/>
</job>
<collection>
<person name="Matt"/>
<person name="Bob"/>
<person name="Larry"/> </collection>
<collection>
<shift>day</shift>
<shift>night</shift> </collection>
</root>

You could try something like this:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output indent="yes"/>
<xsl:key name="nameKey" match="*" use="concat(name(), '||',
generate-id(..))"/>
<xsl:template match="/|*" priority="1">
<xsl:for-each select="*[generate-id() = generate-id(key('nameKey',
concat(name(), '||', generate-id(..))))]">
<xsl:variable name="namesake" select="key('nameKey',
concat(name(), '||', generate-id(..)))"/>
<xsl:choose>
<xsl:when test="count($namesake) = 1">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="."/>
</xsl:copy>
</xsl:when>
<xsl:otherwise>
<collection>
<xsl:for-each select="$namesake">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="."/>
</xsl:copy>
</xsl:for-each>
</collection>
</xsl:otherwise>
</xsl:choose>
</xsl:for-each>
</xsl:template>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>

PS. NOt optimized - just an idea.

--
Oleg Tkachenko [XML MVP, MCP]
http://blog.tkachenko.com

[Oleg Tkachenko [MVP]]

Matt wrote:

Now to only figure out how it works and why.

It's basically classical Muenchian grouping. For each element
recursively I group children by name and if there is more than one child
with the same name, I wrap them in <collection>. The identity transform
template at the end is for other content such as text, comments and PIs
to be copied as is.

--
Oleg Tkachenko [XML MVP, MCP]
http://blog.tkachenko.com