How to extract element properties into excel

[Alex Yakovlev]

I need to extract all elements & their properties in a data model into excel table in format:

[table]
[tr]
[td] Element Name[/td]
[td] Property name[/td]
[/tr]
[tr]
[td]Element 1[/td]
[td]Property 1[/td]
[/tr]
[tr]
[td]Element 1[/td]
[td]Property 2[/td]
[/tr]
[tr]
[td]Element 2[/td]
[td]Property 1[/td]
[/tr]
[tr]
[td]Element 2[/td]
[td]Property 2[/td]
[/tr]
[tr]
[td]Element 2[/td]
[td]Property 3[/td]
[/tr]
[/table]

How can I do this?

Thanks, Alex.

[Adrian Support]

Hi

eaDocX can output a summary of the attributes / methods for a class so for a data model which will provide the information of the properties for each element – see the attached screenshots.
To perform this:

1. create a new workbook
2. select the package containing the tables[/
3. In the columns tab – check “Display Compound Attributes” – it is near the bottom of the columns tab
4. Select desired columns for output include “Attribute summary” to output table properties
5. Select EA output button to initiate export

This output will just list the element properties. If you want to get more detail for each property then you can select a single table element and initiate the export of the attributes (properties) for the single table (see screenshot for menu selection).

This operation will output the properties, 1 per row, for the single table. This output will allow you to select more detail; with the advantage that you can edit the detail and update.

I hope that provides what you need.

BR

eaDocX support

[Alex Yakovlev]

Many thanks for prompt response at the weekend..

The attribute summary feature however is not what I hoped for. It outputs all attributes/operations of an element into a single excel row.. There is no way to edit the attributes/operations and there is not way to extract properties of the attributes/operations.

The 2nd option allows to output attributes/operations for a single element only – if a data model consists from a few dozens of files, exporting their attributes/operations becomes too time consuming to be useful.

Any chance to implement exporting/importing attributes/operations for all elements in a package in the next version of the EADocX?

[Adrian Support]

Thought that may be the case – a few others have asked and we have considered including but our delay in doing has been the decision on UI.

Would you be be happy with something like a menu option on the context menu so that when a package is selected the extensions menu would provide “eaDocX | Open in Excel | Class properties (there may be a better name)” it would output class (table) properities.

This output columns could be:

ElementType (Attribute or Method) | Class Name (as a mandatory column to ensure that you know the parent) | Name | plus any other columns you select.

There would be one per row so would provide the ability to compare/import as any other element.

Does this cover your requirement?

Regards

eaDocX support

I’ll discuss

[Alex Yakovlev]

Yes, this would cover my current requirement exactly.

The feature should allow to include class attributes specified as target roles in a associate relationship with other classes.

As a further direction to evolve this i would also suggest to consider following in the design:
* to include as columns: other elements, and their features connected with “link to element feature” connector, and such connector itself with its properties. In my projects this would allow to output data mapping specifications defined with connectors linked to element features on both ends.

Thanks, Alex.

• This reply was modified 11 years, 8 months ago by Alex Yakovlev.

[Author]

Posts