Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - michielper

Pages: [1] 2 3
General Board / Import of large model from an external source
« on: April 11, 2019, 09:12:26 pm »
I want to import a very large class model, consisting of 100.000+ elements and relationships from a non-EA SQL database into Sparx EA. What is the best way to do this?
I know there is a VBA importer to import from an Excel spreadsheet (written by Geert Bellekens) but that is probably not scalable enough. My idea is that it should be possible to create an XML file that can be imported as XMI. Is this possible? And what exactly is the format I must use?
And what about the relationships? All elements have of course already a unique ID, how can I use that to create the right relationships in EA? EA will want to assign its own GUID of course and the relationships must contain the EA GIUD, not the original ID.

Any help or suggestions are highly appreciated!

Bugs and Issues / Problems with Archimate in version 14
« on: April 10, 2019, 05:48:27 pm »
It seems that there are problems with the implementation of Archimate in EA version 14.
Several things do not seem to work as required, especially the connections when drawn from the "quick link" arrow next to an element:
- The access relation is not in the pulldown (e.g. when connecting a Component to a Data object)
- The Composition relationship is drawn as an Association
- and many more relationships from quick-link are missing or wrong

This all worked well in version 13

General Board / spam filtering in forum
« on: January 22, 2019, 01:50:28 am »
The forum moderator should set the spam filters to be more strict! There seems to be a lot of garbage now!

General Board / Archimate elements not visually correct
« on: January 21, 2019, 10:26:35 pm »
I have a situation where an ArchiMate_BusinessProcess is shown as a yellow rounded rectangle but without the small arrow in the top right corner! Another element in the same diagram does also have ArchiMate_BusinessProcess as stereotype but does, correctly, show the small arrow.
How can this be, what determines the visual appearance of an element?

General Board / Automatically create aggregation relationships?
« on: October 08, 2018, 09:15:51 pm »
I have a situation here where there are many diagrams with nested elements without explicit relationships. The language used is Archimate and nesting has no meaning in Archimate. The meaning that is implicitly assumed by visual nesting comes closest to Aggregation. So in order to make the diagrams into meaningful Archimate diagrams, explicit aggregation relationships must be created wherever a hierarchy (nesting) exists. I suppose it should be possible to to this automatically, via a script. Has anyone attempted this?


General Board / Example of Custom SQL template fragment
« on: August 31, 2018, 09:16:04 pm »
I am trying to create a custom SQL template fragment to be included in a report template. The purpose of the fragment is to show dependency sequences of a certain length starting from the current element. The query works fine as a custom search but I get stuck in trying to get any result at all from the fragment when I make a template fragment out of it. So I would like to see an example of a working custom SQL fragment and the report template that includes it.

Thanks for any help!

General Board / show connectivity/dependency chain
« on: August 30, 2018, 06:39:33 pm »
An interesting piece of information that is hidden in an architecture repository are the connectivity and dependency chains between components. These are the answers to questions like: "via which other components and connectors is application A connected to application B". Perhaps narrowed down to certain connector types or component types.

As far as I can see, this type of query/report is not supported out of the box in EA but it should be possible to create it, perhaps by using SQL and/or template fragments.... My question is, has anyone thought about this and created a solution?

Thanks in advance!

General Board / Time traveling in EA
« on: August 06, 2018, 06:00:07 pm »
Time traveling is showing a series of views each representing a different lifecycle stage of a system (part of an application landscape).
This can be clearly very useful but is not explicitly supported by EA.

So how can we do this?
One obvious way would be to create new instances for every element for each of the lifecycle stages to show. That has the obvious disadvantage of ending up with many instances of essentially the same element that must be kept in sync. Making all instances inherit from a base instance looks like a possible approach. However, inheritance cannot (i think) be so fine tuned as to exactly specify which aspects of an element are inherited and which are not. Specifically, you want the connectors between elements be different in the different stages. Connectors are not first-class citizens in EA but are part of the Elements so different connectivity requires different elements :-(.

Has anyone else thought about this and created a feasible solution?

I am generating documents with diagrams in EA version 13. Package names are the paragraph headings in my document.
When a package contains a diagram that is not too large, I want the package name (paragraph header) to be on the same page as the diagram and not have a paragraph name followed by a large empty space.
So, I tried the "keep with next" option in my template. When opening the generated document in Word, however, the paragraph heading is NOT marked as "keep with next" and the paragraph heading is attached to the preceding text, is followed by a large empty space and the diagram is on the next page. Not what I want...
I also tried "keep together" but this neither works.

Has anyone else experienced the same problem and perhaps found a solution?

General Board / EA data model
« on: July 31, 2018, 08:04:46 pm »
Where do I find the complete EA data model? All tables and attributes that one can use in SQL queries.

Bugs and Issues / Font size of Swim Lanes not persistent
« on: July 20, 2018, 06:42:28 pm »
The font size of the names of my swim lanes (in UML Activity Charts) changes back to 8 points after I have set it to 12 points in the swim lane dialog!  >:(
This happens every time. I change the font in the swim lane dialog, save and close the diagram, reopen it and the font is set back to 8 points. Extremely annoying!

General Board / Swim lane header font changing
« on: July 18, 2018, 07:38:46 pm »
The font size of the names of my swim lanes (in UML Activity Charts) changes back to 8 points after I have set it to 12 points in the swim lane dialog!  >:(
This happens every time. I change the font in the swim lane dialog, save and close the diagram, reopen it and the font is set back to 8 points. Extremely annoying!

So is there a way to prevent this or perhaps to change the default font for swim lane headings? The swim lane headings do NOT change when I change the default font in Preferences!

I am using EA version 13 on Windows 10.

General Board / Ways to show changes in Reports
« on: June 07, 2018, 01:19:23 am »
What options do I have to show what has changed in a Report since the previous version (or since a specific time)?
One way is to use Search * and sort on Date which gives the most recently changed elements on top. You can also generate a report that lists this information.

So, what other options do I have?
Is there some way to indicate changes in the text or diagrams themselves?
Is a baseline comparison of models useful?

Thanks for any tips!

General Board / Versioning of connectors
« on: May 16, 2018, 04:48:35 pm »
I would like to model a situation where I have a number of elements who's connections change over the system lifecycle. So, the components remain the same but the connections between them are different between versions.
Of course, one way to do this is by simply making different views (diagrams) in which different connectors are shown. This may be a useful approach if it's only the pictures that matter but not if the model itself is important, e.g. when generating reports or when simulating the model.
Another approach is to create copies of the elements but this creates a maintenance problem and is very inelegant.

So what other options do I have?

Thanks for any help!

Suggestions and Requests / Multiple Project Browser Windows
« on: May 14, 2018, 09:08:10 pm »
(Re)organizing the Project Browser is not easy when there is only one Project Browser window and you have to drag elements and packages long distances up and down, holding down the mouse button. This would be a lot easier if it were possible to open a second window on the Project Browser so that you can drag from one window to the other. Similar to what you do in a file browser.

Pages: [1] 2 3