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

[JamesUsmar]

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]

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]

... 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.