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.

Categories

Importing data from excel

0 votes

Hello,

 

I am new to the yEd and so far I really like the program. But I have one issue. 

I have a very large tree structure in excel in the form of text which per 'tree level' is shifted one colomn to the right.  The issue is that this is a very large data set (1250 items devided over about 21 levels of dept) Now I already found that this cannot be imported to yEd directly. My quenstion is: is there some way to import this data, maybe using a transformation step in between?

as an example a structure from excel could look like this:

 

top level        
  some level below top level  
    sub level1  
    sub level2  
      subsublevel1
  some other level below the top
    sub level 0  
  some level below top level3  
    sub level3  
    sub level4  
      subsublevel2
        subsubsublevel
  some other level below the top
    sub level 0  

 

 

Kind regards,

 

Quinten 

in Feature Requests by (120 points)

1 Answer

0 votes

Well, yes - if the "transformation step" is reorganizing your data.

With unique names (which are necessary), your example structure corresponds to
n0
      n1.1
            n2.1
            n2.2
                  n3.1
      n1.2
            n2.3
      n1.3
            n2.4
            n2.5
                  n3.2
                        n4
      n1.4
            n2.6

This data has to be reorganized into two columns as follows:

The first row is optional (depending on whether or not you have "Property Names in First Row" enabled). The order of the remaining rows does not matter. With "Layout" set to "Hierarchical", this data will result in the following diagram:

 

Edit: Removed duplicate row.

by [yWorks] (151k points)
edited by
Thomas thank you. I am going to try this. I will have to write a script to transform my data into such a table but I think I'll be able to do this.
Legal Disclosure | Privacy Policy
...