Welcome to yEd Q&A!
Here you can ask questions and receive answers from other members of the community and yEd developers. And you can tell us your most wanted feature requests.


Excel-Import: Node list makes single nodes

0 votes


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 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"/>


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:template match="map">
    <xsl:apply-templates select="descendant::node"/>

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



The result is this CSV:


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..)?




in Help by (700 points)

1 Answer

0 votes
Best answer

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.
by [yWorks] (26.8k points)
Legal Disclosure | Privacy Policy