search

archimatetool / archi

Archi: ArchiMate Modelling Tool
https://www.archimatetool.com
MIT License
946 stars 269 forks source link

[Feature Request] Folder Tree Structure Preservation on CSV exports/Imports #280

Open JamesUsmar opened 6 years ago

JamesUsmar commented 6 years ago

Hi,

I was wondering if would be possible to preserve folder structures within the CSV exports and imports?

I create csv files from multiple sources to augment a model, and it would be very handy to be able to automate a folder tree for different "things" (eg locations, devices, nodes etc.) under there respective parent tree entry point.

This is just a management / beautification convenience feature request for elements.csv and relationships.csv files.

As a suggestion you could include a new delimiter field which probably is best to support backward compatibility and any automations out there. Alternatively you could add it to the Type field as a pre-pended piece of text eg "/Machines/Computers/Device" ?

... , Type, .... ... , Device, ....

becomes

.... ,Type , FolderTree , .... ... , Device , /Machines/Computers , ...

Or similar. Thoughts?

Thanks. James.

Phillipus commented 6 years ago

TBH, I'm more interested in why users are exporting their models into Excel, via CSV, and re-importing them. Would it not be better to have a direct export to Excel?

See http://forum.archimatetool.com/index.php?topic=419.0

JamesUsmar commented 6 years ago

... ahh not if the data is being "munged" through awk, sed, PowerShell etc... then parsing CSV is easier. (Appreciate XML is well supported with PowerShell)

My ask was just in managing the tree viewer and 1000's of objects in long lists is a little painful. Being able to automate the objects in to convenient containers would be really helpful.

Just a thought.