Generating a hierarchical map of nodes in a flat XML file

Hi folks,

Using XSL, I'm trying to take an XML file containing a flat list of "topics" and generate a hierarchical topic map. The topic nodes include a role attribute that indicates their position in the hierarchy (role="1" being the top node).

Here is the original XML file structure:

Expand|Select|Wrap|Line Numbers

 <NoName>

    <topic id="id1" role="1">

        <title>Heading 1 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

    <topic id="id2" role="2">

        <title>Heading 2 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

    <topic id="id3" role="2">

        <title>Heading 2 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

    <topic id="id4" role="3">

        <title>Heading 2 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

    <topic id="id1" role="1">

        <title>Heading 1 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

    <topic id="id2" role="2">

        <title>Heading 2 Title</title>

        <body>

            <p>Some text.</p>

        </body>

    </topic>

</NoName>

My goal is to generate a hierarchical map of the topics, include the topic "id" attribute and title value within the topic node, and discard the other subnodes (body, p).

Expand|Select|Wrap|Line Numbers

 <map>

    <topic  href="id1.xml" navtitle="Heading 1" type="topic">

          <topic  href="id2.xml"  navtitle="Heading 2" type="topic"></topic>

          <topic  href="id3.xml"  navtitle="Heading 2" type="topic">

                 <topic  href="id4.xml" navtitle="Heading 3"  type="topic"></topic>

      </topic>

    <topic  href="id1.xml" navtitle="Heading 1" type="topic">

          <topic  href="id2.xml"  navtitle="Heading 2" type="topic"></topic>

      </topic>

</map>

After mapping the various topics in my XML file, I'll then be able to chunk the topics into individual XML files and reference them using the map. The map architecture is based on an existing DTD.

I thought I could get by using variables and for-each statements, but my code (below) generates nothing (no errors). I've also played around with keys, but have produced nothing but errors in Xalan so far.

Expand|Select|Wrap|Line Numbers

 <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="NoName">

 <main>

 <xsl:apply-templates select="topic[@role='1']" />

 </main>

 </xsl:template>
 
    <xsl:template name="hierarchy" match="/NoName">

    <xsl:variable name="id" select="@Id"/>

    <xsl:variable name="title" select="title"/>

        <xsl:for-each select="topic[@role='1']">

            <xsl:sort select="."/>

            <map title="{$title}" id="{$id}.xml">

                <xsl:for-each select="topic[@role='2']">

                    <xsl:sort select="."/>

                    <topicref href="{$id}.xml" navtitle="{$title}" type="topic">

                        <xsl:for-each select="topic[@role='3']">

                            <xsl:sort select="."/>

                            <topicref href="{$id}.xml" navtitle="{$title}" type="topic">

                                <xsl:for-each select="topic[@role='4']">

                                    <xsl:sort select="."/>

                                    <topicref href="{$id}.xml" navtitle="{$title}" type="topic"/>

                                </xsl:for-each>

                            </topicref>

                        </xsl:for-each>

                    </topicref>

                </xsl:for-each>

            </map>

        </xsl:for-each>

    </xsl:template>

</xsl:stylesheet>

If anyone could point me in the right direction, I'd sure appreciate it!

Thanks!

Mark Peters

Jun 16 '06 #1

Subscribe Post Reply

1795

by: Ksenia Marasanova | last post by:

I get this kind of list from a database. (The tuple structure is: id, name, parent_id) I would like to transfer it (in Python) into a tree structure. I don't care much about format, as long...

Python

Flat to hierarchical using attributes

by: Steve Mac | last post by:

I am very new to XML / XSL and am having trouble with transforming a flat xml file into a hierarchical format using an id / parentid attribute relationship. Any help on this would be greatly...

.NET Framework

Custom class exists to add, update, delete and select nodes in record style XML file???

by: Earl Teigrob | last post by:

I am considering writing a Class that Selects, Adds, Updates and Deletes Nodes in an XML File but do not what to reinvent the wheel. (See XML file below) That data format would emulate records...

.NET Framework

Can XML describe different hierarchical data?

by: Bruce W.1 | last post by:

I want an XML file to describe hierarchical data where each node is different. Each node will contain different and varied other nodes. Describing this in an XML file would be easy but I'm having...

.NET Framework

hierarchical implementation question

by: jayson_13 | last post by:

Hi, I want to retrieve the hierarchical structure which is store inside the database and then display it using treeview control. But now I got a design issue which I hope that you guys can help...

C# / C Sharp

Best way or returning hierarchical data

by: Daisy | last post by:

Let's say I've got a forum, where users can be moderators of each forum. Tables look like this: USER -------- user_key name FORUM

C# / C Sharp

Binding to Hierarchical Data Source (FAQs)

by: Kent Boogaart | last post by:

Hi, I have some hierarchical data (FAQs) that I would like to bind to. The basic structure is: FAQ Category + Categories + FAQs So an FAQ category has any number of sub-categories and any...

ASP.NET

How to load hierarchical Db data in treeview??

by: Don | last post by:

In a previous version of vb I used to save and load hierarchical data from an Access db into a treeview. But, I never found a very satisfying or elegant way to do it. I used a flat file approach...

Visual Basic .NET

Flat Employee XML into hierarchical XML

by: doozer1979 | last post by:

Hello, I Have a flat XML file that i have exported from MS access. When i export it from access i want to run it through an xslt to turn it into a hierachical structure Each person has a...

XML

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Generating a hierarchical map of nodes in a flat XML file

Similar topics