|
| | | Altova Mailing List Archives>Archive Index >microsoft.public.xsl Archive Home >Recent entries >Thread Prev - RE: Re-organize and sort source tree >Thread Next - RE: Re-organize and sort source tree RE: Re-organize and sort source treeTo: NULL Date: 10/4/2004 6:55:00 AM Mukul,
I had managed to get that working myself (!). Thanks very much for your
help; your solution works perfectly and is quite efficient. I appreciate
your assistance.
"Mukul Gandhi" wrote:
> Please apply this correction -
>
> <xsl:for-each
> select="msxsl:node-set($rtf)/temp/office/cities/city[generate-id(.) =
> generate-id(key('by-city', .)[1])]">
> <xsl:sort select="." />
> <cities>
> <city>
> <name><xsl:value-of select="." /></name>
>
> <offices>
> <xsl:for-each select="key('by-city', .)">
> <xsl:sort select="../../name" />
> <office id="{../../@id}">
> <xsl:copy-of select="../preceding-sibling::name" />
> <xsl:copy-of
> select="../preceding-sibling::address" />
> <xsl:copy-of select="../following-sibling::phone"
> />
> </office>
> </xsl:for-each>
> </offices>
> </city>
> </cities>
> </xsl:for-each>
>
> I am applying Muenchian grouping to every offices node. For this reason, I
> had to convert this variable <xsl:variable name="rtf"> (short for Result Tree
> Fragment) into a node-set.
>
> To learn Muenchian grouping, please read here
> http://www.jenitennison.com/xslt/grouping/index.html .
>
> Regards,
> Mukul
>
> "anyware" wrote:
>
> > Hi Mukul:
> >
> > First, thanks very much for the reply and solution.
> >
> > It is almost perfect, just one flaw that I see. The <city> element is
> > meant to encapsulate the <offices> element, but is instead appearing as its
> > sibling. So, the xslt produces this fragment:
> >
> > <country name="Canada">
> > <cities>
> > <city>
> > <name>Calgary</name>
> > </city>
> > <offices>
> > <office id="Branch 2">
> > <name>Canadian Branch</name>
> > <address>
> > <line>1 Prince Edward Boulevard</line>
> > <line>5th Floor</line>
> > <line>Room 10</line>
> > <line>Calgary, Alberta</line>
> > </address>
> > <phone>(888) 888-8888</phone>
> > </office>
> > </offices>
> > </cities>
> >
> > But what it should produce is:
> >
> > <country name="Canada">
> > <cities>
> > <city>
> > <name>Calgary</name>
> > <offices>
> > <office id="Branch 2">
> > <name>Canadian Branch</name>
> > <address>
> > <line>1 Prince Edward Boulevard</line>
> > <line>5th Floor</line>
> > <line>Room 10</line>
> > <line>Calgary, Alberta</line>
> > </address>
> > <phone>(888) 888-8888</phone>
> > </office>
> > </offices>
> > </city>
> > </cities>
> > </country>
> >
> > Also, I have seen similar usage of the Muenchian method that you are
> > employing, but am having trouble understanding how it works. I can't figure
> > out how the unique list of city keys is generated (i.e. how does
> > generate-id() work?) and how the equality check
> > (genrate-id(.)=generate-id(key)'by-city',.)) work? Would you mind explaining
> > the following statement:
> >
> > <xsl:for-each
> > select="msxsl:node-set($rtf)/temp/office/cities/city[generate-id(.) =
> > generate-id(key('by-city', .)[1])]">
> >
> > Thanks again for all of your help!
> >
> >
> >
> > "Mukul Gandhi" wrote:
> >
> > > Please try this XSL -
> > >
> > > <?xml version="1.0" encoding="UTF-8"?>
> > > <xsl:stylesheet version="1.0"
> > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> > > xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
> > >
> > > <xsl:output method="xml" encoding="UTF-8" indent="yes"/>
> > >
> > > <xsl:key name="by-city" match="temp/office/cities/city" use="."/>
> > >
> > > <xsl:template match="/">
> > > <locations>
> > > <divisions>
> > > <xsl:for-each select="locations/divisions/division">
> > > <xsl:sort select="@id"/>
> > > <division id="{@id}">
> > > <regions>
> > > <xsl:for-each select="regions/region">
> > > <xsl:sort select="@name"/>
> > > <region name="{@name}">
> > > <countries>
> > > <xsl:for-each select="countries/country">
> > > <xsl:sort select="@name"/>
> > > <country name="{@name}">
> > > <xsl:variable name="rtf">
> > > <temp>
> > > <xsl:copy-of select="offices/office"/>
> > > </temp>
> > > </xsl:variable>
> > > <xsl:for-each
> > > select="msxsl:node-set($rtf)/temp/office/cities/city[generate-id(.) =
> > > generate-id(key('by-city', .)[1])]">
> > > <xsl:sort select="." />
> > > <cities>
> > > <city>
> > > <name><xsl:value-of
> > > select="." /></name>
> > > </city>
> > > <offices>
> > > <xsl:for-each select="key('by-city', .)">
> > > <xsl:sort select="../../name" />
> > > <office id="{../../@id}">
> > > <xsl:copy-of
> > > select="../preceding-sibling::name" />
> > > <xsl:copy-of
> > > select="../preceding-sibling::address" />
> > > <xsl:copy-of
> > > select="../following-sibling::phone" />
> > > </office>
> > > </xsl:for-each> </offices>
> > > </cities>
> > > </xsl:for-each>
> > > </country>
> > > </xsl:for-each>
> > > </countries>
> > > </region>
> > > </xsl:for-each>
> > > </regions>
> > > </division>
> > > </xsl:for-each>
> > > </divisions>
> > > </locations>
> > > </xsl:template>
> > >
> > > </xsl:stylesheet>
> > >
> > > Regards,
> > > Mukul
> > >
> > > "anyware" wrote:
> > >
> > > > I'm struggling with using the Muenchian method to produce a result tree
> > > > that re-organizes and sorts the
> > > > source tree's nodes.
> > > >
> > > > The goal is to take the source tree and produce a result set that makes
> > > > the
> > > > child <cities> element (including its child <city> element) a parent of the
> > > > <offices> element. The result tree would also be sorted by the following
> > > > ascending order:
> > > > division/@id, region/@name, country/@name, new cities/city/name location
> > > > path, and office/name.
> > > >
> > > > I appreciate any assistance with the XSLT. Also, if possible, please
> > > > include comments describing how the
> > > > XSLT works. Thanks very much!
> > > >
> > > > Given the following source tree...
> > > >
> > > > <?xml version="1.0" encoding="UTF-8"?>
> > > > <locations>
> > > > <divisions>
> > > > <division id="B">
> > > > <regions>
> > > > <region name="pacific">
> > > > <countries>
> > > > <country name="China">
> > > > <offices>
> > > > <office id="BR5">
> > > > <name>Branch 5</name>
> > > > <address>
> > > > <line>China World Tower 1</line>
> > > > <line>1 Jian Guo Men Wai Avenue</line>
> > > > <line>Beijing</line>
> > > > </address>
> > > > <cities>
> > > > <city>Beijing</city>
> > > > </cities>
> > > > <phone></phone>
> > > > </office>
> > > > </offices>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > </regions>
> > > > </division>
> > > > <division id="A">
> > > > <regions>
> > > > <region name="europe">
> > > > <countries>
> > > > <country name="Germany">
> > > > <offices>
> > > > <office id="BR3">
> > > > <name>Branch 3</name>
> > > > <address>
> > > > <line>P.O. Box 1210</line>
> > > > <line>Frankfurt, Germany</line>
> > > > </address>
> > > > <cities>
> > > > <city>Frankfurt</city>
> > > > </cities>
> > > > <phone>+49-55-5555 5555</phone>
> > > > </office>
> > > > </offices>
> > > > </country>
> > > > <country name="England">
> > > > <offices>
> > > > <office id="BR4">
> > > > <name>Branch 4</name>
> > > > <address>
> > > > <line>26 Abbey Lane</line>
> > > > <line>London</line>
> > > > </address>
> > > > <cities>
> > > > <city>London</city>
> > > > </cities>
> > > > <phone>+44-22-2222 2222</phone>
> > > > </office>
> > > > <office id="BR5">
> > > > <name>AAAAA Branch 4</name>
> > > > <address>
> > > > <line>7 Kings Highway</line>
> > > > <line>London</line>
> > > > </address>
> > > > <cities>
> > > > <city>London</city>
> > > > </cities>
> > > > <phone>+44-99-9999 9999</phone>
> > > > </office>
> > > > </offices>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > <region name="americas">
> > > > <countries>
> > > > <country name="United States">
> > > > <offices>
> > > > <office id="HO">
> > > > <name>Home Office</name>
> > > > <address>
> > > > <line>P.O. Box 1234</line>
> > > > <line>New York, NY 11111</line>
> > > > </address>
> > > > <cities>
> > > > <city>New York</city>
> > > > </cities>
> > > > <phone>(212) 123-4567</phone>
> > > > </office>
> > > > <office id="BR1">
> > > > <name>Branch 1</name>
> > > > <address>
> > > > <line>999 Main Street</line>
> > > > <line>Suite 1200</line>
> > > > <line>Miami, FL 22222</line>
> > > > </address>
> > > > <cities>
> > > > <city>Miami</city>
> > > > </cities>
> > > > <phone>777-7777</phone>
> > > > </office>
> > > > </offices>
> > > > </country>
> > > > <country name="Canada">
> > > > <offices>
> > > > <office id="Branch 2">
> > > > <name>Canadian Branch</name>
> > > > <address>
> > > > <line>1 Prince Edward Boulevard</line>
> > > > <line>5th Floor</line>
> > > > <line>Room 10</line>
> > > > <line>Calgary, Alberta</line>
> > > > </address>
> > > > <cities>
> > > > <city>Calgary</city>
> > > > </cities>
> > > > <phone>(888) 888-8888</phone>
> > > > </office>
> > > > </offices>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > </regions>
> > > > </division>
> > > > </divisions>
> > > > </locations>
> > > >
> > > >
> > > > ...the XSLT would generate the following result tree:
> > > >
> > > > <?xml version="1.0" encoding="UTF-8"?>
> > > > <locations>
> > > > <divisions>
> > > > <division id="A">
> > > > <regions>
> > > > <region name="americas">
> > > > <countries>
> > > > <country name="Canada">
> > > > <cities>
> > > > <city>
> > > > <name>Calgary</name>
> > > > <offices>
> > > > <office id="Branch 2">
> > > > <name>Canadian Branch</name>
> > > > <address>
> > > > <line>1 Prince Edward Boulevard</line>
> > > > <line>5th Floor</line>
> > > > <line>Room 10</line>
> > > > <line>Calgary, Alberta</line>
> > > > </address>
> > > > <phone>(888) 888-8888</phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > </cities>
> > > > </country>
> > > > <country name="United States">
> > > > <cities>
> > > > <city>
> > > > <name>Miami</name>
> > > > <offices>
> > > > <office id="BR1">
> > > > <name>Branch 1</name>
> > > > <address>
> > > > <line>999 Main Street</line>
> > > > <line>Suite 1200</line>
> > > > <line>Miami, FL 22222</line>
> > > > </address>
> > > > <phone>777-7777</phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > <city>
> > > > <name>New York</name>
> > > > <offices>
> > > > <office id="HO">
> > > > <name>Home Office</name>
> > > > <address>
> > > > <line>P.O. Box 1234</line>
> > > > <line>New York, NY 11111</line>
> > > > </address>
> > > > <phone>(212) 123-4567</phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > </cities>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > <region name="europe">
> > > > <countries>
> > > > <country name="England">
> > > > <cities>
> > > > <city>
> > > > <name>London</name>
> > > > <offices>
> > > > <office id="BR5">
> > > > <name>AAAAA Branch 5</name>
> > > > <address>
> > > > <line>7 Kings Highway</line>
> > > > <line>London</line>
> > > > </address>
> > > > <phone>+44-99-9999 9999</phone>
> > > > </office>
> > > > <office id="BR4">
> > > > <name>Branch 4</name>
> > > > <address>
> > > > <line>26 Abbey Lane</line>
> > > > <line>London</line>
> > > > </address>
> > > > <phone>+44-22-2222 2222</phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > </cities>
> > > > </country>
> > > > <country name="Germany">
> > > > <cities>
> > > > <city>
> > > > <name>Frankfurt</name>
> > > > <offices>
> > > > <office id="BR3">
> > > > <name>Branch 3</name>
> > > > <address>
> > > > <line>P.O. Box 1210</line>
> > > > <line>Frankfurt, Germany</line>
> > > > </address>
> > > > <phone>+49-55-5555 5555</phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > </cities>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > </regions>
> > > > </division>
> > > > <division id="B">
> > > > <regions>
> > > > <region name="pacific">
> > > > <countries>
> > > > <country name="China">
> > > > <cities>
> > > > <city>
> > > > <name>Beijing</name>
> > > > <offices>
> > > > <office id="BR5">
> > > > <name>Branch 5</name>
> > > > <address>
> > > > <line>China World Tower 1</line>
> > > > <line>1 Jian Guo Men Wai Avenue</line>
> > > > <line></line>
> > > > </address>
> > > > <phone></phone>
> > > > </office>
> > > > </offices>
> > > > </city>
> > > > </cities>
> > > > </country>
> > > > </countries>
> > > > </region>
> > > > </regions>
> > > > </division>
> > > > </divisions>
> > > > </locations>
> > > >
| |
| | ||||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
