Excel-Import: Node list makes single nodes

Question

Hello

I have a XML-file like this:

<map version="0.9.0">
<!-- To view this file, download free mind mapping software FreeMind from http://freemind.sourceforge.net -->
<node CREATED="1327478699125" ID="ID_1202573115" MODIFIED="1327478699125" TEXT="Start">
<node CREATED="1327478715593" ID="ID_1274856431" MODIFIED="1327478717437" POSITION="right" TEXT="a">
<node CREATED="1327478748546" ID="ID_1587295463" MODIFIED="1327478749515" TEXT="4"/>
</node>
<node CREATED="1327478718296" ID="ID_325575686" MODIFIED="1327478718906" POSITION="right" TEXT="b"/>
<node CREATED="1327478719687" ID="ID_1032928779" MODIFIED="1327478720500" POSITION="right" TEXT="c">
<node CREATED="1327478734953" ID="ID_349051169" MODIFIED="1327478736734" TEXT="1"/>
<node CREATED="1327478737500" ID="ID_1200348443" MODIFIED="1327478739046" TEXT="2"/>
<node CREATED="1327478742234" ID="ID_1104719965" MODIFIED="1327478743765" TEXT="3"/>
</node>
</node>
</map>
 

I use to create a CSAV with this XSLT:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text" encoding="UTF-8"/>

<xsl:template match="/">
    <xsl:apply-templates/>
</xsl:template>

<xsl:template match="map">
    <xsl:text>Vater;Kind
    </xsl:text>
    <xsl:apply-templates select="descendant::node"/>
</xsl:template>

<xsl:template match="node">
    <xsl:value-of select="../@TEXT"/>
    <xsl:text>;</xsl:text>
    <xsl:value-of select="@TEXT"/>
    <xsl:text>
    </xsl:text>
</xsl:template>

</xsl:stylesheet>
 

The result is this CSV:

Vater;Kind
    ;Start
    Start;a
    a;4
    Start;b
    Start;c
    c;1
    c;2
    c;3
  

I open CSV with Exce, remove the second and the last line and save it to XLS. When I open it with yEd I do not get a single structure, but I get three structures:

Node "Start" with children a, b, c
Node "c" with children 1, 2, 3
Node "a" with child 4

How to get a single structure with "Start - c - 1" (and so one..)?

Regards

Peter

 

Answer 1

This may be a problem with supernumerary space characters in your Excel cells. If cells contain exactly the same characters, yEd should create only a single node.

If you use LibreOffice/OpenOffice to convert the CSV to Excel, it may help to select Space as one of the charaters to Separate by and enable the option Merge delimiters.