How may I automate diagrams importing from Excell?

Question

Hello, I've discovered yesterdat yEd watching youtoube, because I am looking for a software that allow me to automate diagrams. What I want to do is the following.

Let's imagine I have an Excell file in which I have introduced in cells several names

John is connected to Frank and Frank is connected Mary

(John, Frank, Mary)

Joe is connected to David

(Joe, David)

Mary is connected to Joe

(Mary, Joe)

You can see the Excell here...

 

Okay, when importing the file to yEd the result I want to get is this...

 

 

My question is, how may I get a result like this one?

I'm new with yEd and I am trying to import from Excell but I am not able to connect things like I've shown in Excell and yEd, perhaps is because I am not introduing well the data in Excell or because I am not importing it well

However, here you can see the general idea of what I want to do and the results I want to get, so... how may I do this?

Liebe Grüße (Cheers)

Answer 1

Hi!

yEd expects the data in a more regular format, that is, every row must contain the information about one single connection. The ordering of the rows has no specific meaning.

The Excel table for your example should be simialr to this:

John, Frank
Frank, Mary
Joe, David
Mary, Joe

Comments

Hi Michael thanks for your reply. I am using this for more complicated things than the example I've posted, I am using this to connect physics theories.
I think I've understood you well, so I am posting 2 excell captures, and please, tell me what do you think...

THE INCORRECT WAY TO HANDLE DATA IN EXCELL FOR YED IS THIS:
http://i1374.photobucket.com/albums/ag418/jg115/yed-003_zps5342e11b.jpg

THE CORRECT WAY TO ALLOW YED TO SEE AND FLOWCHART THE SAME DATA, IS THIS:
http://i1374.photobucket.com/albums/ag418/jg115/yed-005_zpsc70dc510.jpg

Is this correct?
I plan to create very huge and complex flowcharts automating the processes, for physics and maths this is very important.

Another question I wanted to do is if, finally, I can export data to scientific visualization software like Gephi... ?

https://www.youtube.com/watch?v=bXCBh6QH5W0

*LG*

---

Yes, the second table is correct.

For yEd, it doesn't matter what your data represents as long as it can be modeled is a graph. There is no explicit limit for the graph size, but with several thousands of elements in your graph, yEd might react slower than usually. Especially some of the automatic layout algorithms do complicated calculations and are not very suitable for graphs of that size.

If your graph is dense, that is, the ratio of connection count to node count is high, any automatic layout algorithm will have a hard time to determine a nice layout.

yEd can export to a number of graph formats
  http://yed.yworks.com/support/manual/fileformat.html
and Gephi's file formats are described here
  https://gephi.org/users/supported-graph-formats/

Likely, transferring the basic graph structure to Gephi will be possible out of the box,
but for additional information like locations or graphical properties you'll need a custom converter from yEd's basic graph format GraphML to one of the advanced formats of Gephi.

Please note that the GraphML standard specifies only how to store the basic graph structure and therefore, advanced data is stored very differently in yEd GraphML and Gephi GraphML.

---

Hi back Michael
I'm trying to import from Excell and get the expected results, but I am not getting the same results, I'll be showing you several screenshots, so you can see what is wrong?

I have organized the Excell as you told me... see it here please:

http://i1374.photobucket.com/albums/ag418/jg115/yed-006_zps3d5c3b2b.jpg

Then, the result I should get is this...
http://i1374.photobucket.com/albums/ag418/jg115/yed-002_zpsdb8a27d6.jpg

But I am not getting that result...
THE RESULT I GET IS THIS???
http://i1374.photobucket.com/albums/ag418/jg115/yed-008_zps209886cb.jpg

The settings I am using are the following...

http://i1374.photobucket.com/albums/ag418/jg115/yed-009_zps7e294e33.jpg

http://i1374.photobucket.com/albums/ag418/jg115/yed-010_zpsba0cf0c0.jpg

Can you tell me please, what am I doing wrong?
I should get the results shown in the first flowchart... and not the results I am getting as you can see in the second flowchart...

What should I change in yEd to get the results as in the first flowchart?

*LG*

---

You have "Property Names in First Row" selected. With that option activated, the data in the first row is not used to create graph elements, but interpreted as names for custom properties. Either disable that option (since you do not have data for custom properties) or prepend a new row with meta data (e.g. "Source", "Target").

---

Hello there, now I think it is working, I am posting the pictures because I think can help people. Exactly, the first row is lost, because I have selected Property Names in First Row.
I'm testing this, and seriously, this is a JEWELL. Amazing software, incredible how develop complex diagrams importing from Excell in seconds!
Data entry must be like this (colum A connected with column B)
http://i1374.photobucket.com/albums/ag418/jg115/yed-011_zpsd99bd5f2.jpg

The result is this wonderful diagram
http://i1374.photobucket.com/albums/ag418/jg115/yed-013_zps4327536e.jpg

And the settings are like this:
http://i1374.photobucket.com/albums/ag418/jg115/yed-009_zps7e294e33.jpg

http://i1374.photobucket.com/albums/ag418/jg115/yed-010_zpsba0cf0c0.jpg

The only thing that worry me... is that I see when importing data, that I observe only 40 rows in the preview... but, do you accept larger Excells right?
I am planning to flowchart very large excells of perhaps... 2000 rows... yEd accept that right?

---

Thanks for sharing your settings for other users.

40 is just the minimum number of rows and columns of the preview window. When you open a file with a table larger than that, it shows all of your data.

---

I am amazed with this jewell, seriously, I was searching this a lot of time, I was tired of VISIO, Draw, SmartDraw and many other. I needed automation, and this is science fiction, true automation. Thanks for this seriously.
I have seen the software is only in Deutch and English.
If you want the program be also in Spanish (I am from Spain), please, let me know, and I'll be happy to translate everything for you. Of course free. I want this software be known, it saved my life, so it's the less I can do. THANKS !!!!
*LG*

---

Thank you very much for your king offer to translate yEd to Spanish. Unfortunately, it is currently not possible to add additional language support to yEd.