Archi Forum

Archi Plug-ins => jArchi => Topic started by: dave_gordon on March 20, 2023, 19:07:27 PM

Title: Export contents of Visualier Elements to CSV
Post by: dave_gordon on March 20, 2023, 19:07:27 PM
Hi there,
I am using Archi to log the elements connected by relationships linked to an Application Component, which are nested three levels above (Grouped Object [top level], Value Stream & Capability) and three levels below (Application Function, Data Object & Artifact [bottom level])

The visualiser shows the above perfectly (Depth Level 3), but given the sheer volume of data, I need a way to export just the linked data to a CSV file.

I'm not a developer and have searched tirelessly but cannot find what to me seems to be an obvious need. 


I can export two linked relationships but what I need are all six as described above.  I did find an article that describes exporting to MySQL and running a query but this seems a rather long-winded approach - see https://gevaertw.wordpress.com/2018/12/10/querying-the-archi-db-to-get-relations/

Any advice or help would be much appreciated.

Regards

 
Title: Re: Export contents of Visualier Elements to CSV
Post by: Phil Beauvoir on March 20, 2023, 20:07:24 PM
Hi,

What you're trying to do is not necessarily tied to the Visualiser. The Visualiser is only displaying a concept and its relations and connected concepts recursively.

In jArchi, this translates to starting from a concept, getting its incoming and outgoing relations and recursing on the endpoints. Once you have these then you can export to CSV or any other data format. That's the theory...

Phil
Title: Re: Export contents of Visualier Elements to CSV
Post by: dave_gordon on March 20, 2023, 20:56:12 PM
Hi Phil,
Many thanks for the prompt reply.

I can relay exactly what the relations are between the incoming and outgoing elements but I need the (presumably repeatable) code that I can translate this into that will list and export.   I hope this makes sense.

Regards