hi there,
i am a beginner in XSLT. i tried for two days to convert a graph made in visio to graphml. i managed with the nodes, but have problems with the links can anyone help please. here are the source and the target XML

<?xml version='1.0' encoding='utf-8' ?>
<Connects>
<Connect FromSheet='4' FromCell='BeginX' FromPart='9' ToSheet='1' ToCell='Connections.X2' ToPart='101'/>
<Connect FromSheet='4' FromCell='EndX' FromPart='12' ToSheet='2' ToCell='Connections.X4' ToPart='103'/>
<Connect FromSheet='5' FromCell='BeginX' FromPart='9' ToSheet='1' ToCell='Connections.X1' ToPart='100'/>
<Connect FromSheet='5' FromCell='EndX' FromPart='12' ToSheet='3' ToCell='Connections.X3' ToPart='102'/>
<Connect FromSheet='7' FromCell='BeginX' FromPart='9' ToSheet='6' ToCell='Connections.X4' ToPart='103'/>
<Connect FromSheet='7' FromCell='EndX' FromPart='12' ToSheet='3' ToCell='Connections.X2' ToPart='101'/>
</Connects>


<?xml version="1.0" encoding="UTF-8"?>
  <graph>
    <edge id="4" source="1" target="2"/>
    <edge id="5" source="1" target="3"/>
    <edge id="7" source="6" target="9"/>
  </graph>


thanks in advance.

krasimir

Its me again.
I tried something like... for each Connects/Connect I do If [@FromCell='BeginX'] to capture the source id. then i tried to open element "edge" and to add the source id attribute. Also i did If [@FromCell='EndX'] to capture the target id. My idea was to add the target attribute and close the element "edge" in the second if, but was unable to compile this solution. can anyone help please...

krasimir

Hi !

Got your solution:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
        <xsl:apply-templates select="Connects"/>
    </xsl:template>
    <xsl:template match="Connects">
        <graph>
            <xsl:apply-templates select="Connect[@FromCell = 'BeginX']"/>
        </graph>
    </xsl:template>
    <xsl:template match="Connect">
        <xsl:element name="edge">
            <xsl:attribute name="id">
                <xsl:value-of select="@FromSheet"/>
            </xsl:attribute>
            <xsl:attribute name="source">
                <xsl:value-of select="@ToSheet"/>
            </xsl:attribute>
            <xsl:attribute name="target">
                <xsl:value-of select="following-sibling::Connect[@FromCell = 'EndX' and @FromSheet = ./@FromSheet]/@ToSheet"/>
            </xsl:attribute>
        </xsl:element>
    </xsl:template>
</xsl:stylesheet>

Keep reading the forum, you'll learn fast over time.

Rushman

Dijkstra's law on Programming and Inertia:

If you don't know what your program is supposed to do, don't try to write it.

Thanks alot, rushman! I knew you can do it. Just saw one of your other replies and knew you have the skills! Hope i will be able to do tasks like this myself soon. Thanks again!!!

How do I apply the style sheet?