Sorting Xml only first level

Amichai

Hi All.

I have an xml something like this:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<root>

   <person>

         <name>John</name>

         <family name>Smith</family name>

   </person>

   <address>

          <street>123</street>

          <city>New York</city>

   </address>

</root>

I want to sort only the first level. i.e.
have result like this:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="UTF-8"?>

<root>

   <address>

          <street>123</street>

          <city>New York</city>

   </address>

   <person>

         <name>John</name>

         <family name>Smith</family name>

   </person>

</root>

address now comes before person, but the internal nodes, keep their order.

I want to sort it alphabetically using xslt file.

Any idea?

I appreciate your help.

Amichai

Dormilich

what does the <xsl:sort> give you?

Amichai

Hi Dormilich,

I'm pretty novice with xslt, and the examples i've seen over the web, shows how to sort the entire xml, but no one (i've find) show how to sort only first level.

The xslt file i'm using looks like this:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="utf-8" ?>

<!-- ex: set sw=2 ts=2 expandtab: -->

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
 
  <xsl:output method="xml" indent="yes" encoding="utf-8"/>
 
  <xsl:template match="/">

    <xsl:apply-templates />

  </xsl:template>

  <xsl:template match="@*|node()">

    <xsl:copy>

      <xsl:copy-of select="@*"/>

      <!-- copy all attributes before  applying templates to children only -->

      <xsl:apply-templates >

        <!-- First sort key: node name -->

        <xsl:sort data-type="text" select="name()" order="ascending" case-order="upper-first" />

        <!-- Second sort key: 'Name' property -->

        <xsl:sort data-type="text" select="@Name" order="ascending" case-order="upper-first" />

      </xsl:apply-templates>
 
    </xsl:copy>

  </xsl:template>

</xsl:stylesheet>

Amichai

actually, i'm trying to sort with node Name and 'Name' attribute, but for simplifying the question (as the sort according to one key or more is not relevant) i'm asking only about 'sort first level' issue.

Thanks for your help.

Amichai.

Dormilich

looking at the provided xsl... why do you want to sort the XML? XML is used for data transfer, so a sort without intention behind does not make sense to me.

Amichai

I need to sort a very large xml file (sized 60MB).

Currently i'm sorting it using the xslt file above. however this consumes a lot of memory (~700MB), and i'm afraid that when i get larger xml files (let's say 200MB sized), the sorting will fail the application with out of memory exception.

So the solution i thought about was to sort only one level at time, and to travel over the xml and sort each time the node and the children without descended.

What i'm asking is: is there a simple way doing this with xslt?

Dormilich

from what I know it is not specifically the sorting that requires that much memory, it is parsing and building the document tree itself that requires the memory. to work with very large XML files, you probably need a different parser model.

Amichai

Hi,

I discussed this issue with a friend of mine, and he suggested me not do this sorting with xslt, and do it using C# sorting function instead.

Dormilich, thanks for the help, and for the good willing.

Sorting first level using xslt is no more needed for my task.

Have you all nice week.

Amichai.

Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

re: Sorting Xml only first level

Similar XML bytes

/bytes/development

/bytes/it

/bytes/about