Hi
I've started to look at Essential project and Excel import with LauchPad as an accelarator. As EA has lots of usefull views that can be used is there an easy way to populate the repository directly uisng Protege interface (eg: defining EA Principles) and then export both data and metadada to Excel for later integration?
Best Regards
Sync between EA Tool and Excel files
Hi,
To do this you'd need to write a view that creates the spreadsheet structure you need. The All Instance by Class view is a good starting point as it has the ID (Important for importing back in with the Import Utility), name and description plus the ability to export to Excel. see: https://essentialviewer.com/demo/report ... l&cl=en-gb
You'd need to extend the view to include the slots you need and add them to the table.
Once you have your spreadsheet you would need to use the Import Utility to create an import spec against the spreadsheet, have a look at the tutorial https://www.enterprise-architecture.org ... g_imports/ to get an idea how to do that
Hope that helps
John
To do this you'd need to write a view that creates the spreadsheet structure you need. The All Instance by Class view is a good starting point as it has the ID (Important for importing back in with the Import Utility), name and description plus the ability to export to Excel. see: https://essentialviewer.com/demo/report ... l&cl=en-gb
You'd need to extend the view to include the slots you need and add them to the table.
Once you have your spreadsheet you would need to use the Import Utility to create an import spec against the spreadsheet, have a look at the tutorial https://www.enterprise-architecture.org ... g_imports/ to get an idea how to do that
Hope that helps
John
-
FogoVonSlack
- Posts: 2
- Joined: 20 Nov 2018, 16:44
Hi,
I'm not sure if this helps but I have recently used the Essential Import Utility to load our Architecture Principles into Protege - as an alternative to typing them in. To be fair the load is pretty basic and there are no lookups or cross references needed (as in some of the Essential Launchpad worksheets). I have not yet tried doing the reverse - downloading from Protege into spreadsheets.
I'm not sure if this helps but I have recently used the Essential Import Utility to load our Architecture Principles into Protege - as an alternative to typing them in. To be fair the load is pretty basic and there are no lookups or cross references needed (as in some of the Essential Launchpad worksheets). I have not yet tried doing the reverse - downloading from Protege into spreadsheets.
