Author Topic: unnerving data entry (Read 4310 times)

Olaf.Scheunemann · « **on:** July 11, 2005, 12:40:30 pm »

Hi,
I have a whole lot of tables and attributes that need to be entered into EA.
Also I need to specifiy direct access to EA which I found I could enter through Interfaces. But data entry is a pain as I have to go to element features and enter the attributes 1 by 1.
I have all info in a spreadsheet.
Is there a chance for cut & paste somewhere?
Also if I do all that work will I be able to see the attribute usage in the relationship matrix at all?
Thanks for your time and resources ;-)

Cheers
Olaf

thomaskilian · « **Reply #1 on:** July 12, 2005, 02:50:57 am »

There is probably no easy way to do that. You could try the following:
- creating the tables with a DDL and then importing to EA
- transforming the tables to XMI and importing them into EA
- writing a script to import the data using automation

You can't use the relationship matrix to cross reference attribute use. The RM can only show how elements (e.g. different classes, aka tables) are related to each other. So each attribute belongs to only one table. And there is probably no point in doing any cross reference. Or maybe I didn't get your point?

Olaf.Scheunemann · « **Reply #2 on:** July 12, 2005, 03:00:48 am »

Thanks Thomas,

What I was trying to do is to get a cross reference what actor/module/activity/ report/etc... is using what info on field level.

I am doing current state analysis and among other things there are reports being used by users but they only need some of the info of an old report.

When I am done I need to create a table showing all attributes and their consumers...

thomaskilian · « **Reply #3 on:** July 12, 2005, 03:39:00 am »

That's clearer now. But the answer is (unfortunately): not possible

As mentioned above you only can see relations between elements. An attribute is not an element. You could use an association and assign the source/target role with the respective attribute. But you won't see that in the RM.

Olaf.Scheunemann · « **Reply #4 on:** July 12, 2005, 05:00:16 am »

now there is room for improvement

Thanks a lot - I will go for a Report....

final question:
Is there a complete doc fo the datamodel of the EA file somewhere around here?

thomaskilian · « **Reply #5 on:** July 12, 2005, 05:23:10 am »

For good reasons: no. However you will find some tips here in the board that directly lead you to EA's tables. An easy way to start: import an EA repository into EA

Olaf.Scheunemann · « **Reply #6 on:** July 12, 2005, 05:41:39 am »

Many thanks again :-))

Sparx Systems Forum

News: