Exporting relationships among entities as csv

Exporting relationships among entities as csv

Z

Zack

started a topic
about 1 year ago

Is it possible to export not only the names of individual entities, but relationships among them too? I have essentially made a network, with each entity connected by arrows, and would like to examine the structure of this network using an external application.

Pauline

said
about 1 year ago

Hi Zack,

Thanks for getting in touch and asking a good question!

As much as we'd love to help, it's not possible to export the relationships among the entities to csv. Won't you mind sharing a couple of screenshots showing the network and the expected csv outcome? We'll be happy to suggest you a workaround and see if we can add this export option to our backlog.

Looking forward to your response. Thanks!

Kind regards,

Pauline

RealtimeBoard

Z

Zack

said
about 1 year ago

Thanks for the prompt reply! I'm attaching several screenshots of what I get from an export, as well as quick thoughts concerning what a potential solution might look like!

Untitled2.png - A screenshot of the network I'm working with, which sort of emerged out of an on-the-fly brainstorming session. I'm disappointed that I can't leverage this or make it more productive.

Untitled3.png - A screenshot of the csv export I currently get, as viewed in excel.

Untitled4.png - proposed fields for sheet 1 of 2. Each entity is given an ID, and the text and associated visual properties, which it seems most shapes have options for, are included as fields. I can draw my own conclusions regarding 'type' of entity (are they ideas or people who think about them?) based on the visual properties that I assigned to them in a somewhat consistent manner as I drew them. I.e., all ideas have a certain hex code fill (a certain shade of blue) with a certain opacity, and all people are grey text with transparent border and fill.

Untitled5.png - Proposed fields for sheet 2 of 2. Each line is given an ID, and its visual properties are represented in a similar way as the first sheet. Various fields would be filled with NULL, since a non-directional line does not have arrow markers (or maybe they are just transparent?). Source and Target refer to the IDs of entities being connected by a line. Lines with no source or target are still represented by their ID, along with their visual properties.

As you could probably surmise from above, an export would generate 2 sheets, which are essentially lists of nodes and lists of edges. These could then be easily imported to network visualization software such as gephi for more extensive visualization and analysis.