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.


Messages - Mats Gejnevall

Pages: [1] 2 3
1
Bugs and Issues / Avoiding deleting elements in use
« on: December 14, 2017, 03:25:00 am »
Hi all
I want to clean up my database of elements not in use. I use the Find orphan function and it lists a lot of elements not in use. But many of them are used in my information flows. Is there a way of detecting which orphaned elements are used in information flows? Or is there a configuration where they would not show up in that list?

Thanks Mats

2
Bugs and Issues / Compartments and instances
« on: December 14, 2017, 03:13:52 am »
Hi all
I am using compartments a lot to show relationships. But when I have relations between an element and an instance of an element I have a problem. But just in one direction. Element to instance works fine with some shape scripting, but when I want to see the relations of the element that has relations to the instances of it in the compartment of that element, it does not work.

Example: I have more than one firewall in my diagram. I create instances of that firewall and connect these instances to networks. When I use compartments to show which firewalls these networks are using it works fine, but when I want to see what networks the firewall element is connected to I get no information. I assume it is because the instance and element are different database entries.

Any solutions?

Thanks
Mats

3
So I can do an XMI export and import it later and the external references will be set up correctly?

4
Hi all
Is it possible to export everything in a package including related elements in other packages and move them to another EA respository? I have created a more detailed set of models in this repository but I do not want them there long term. Would the packages of the related elements also be included in such an export?

Thanks
Mats

5
Bugs and Issues / Changing property on multiple elements
« on: September 06, 2017, 05:37:30 pm »
Is there any way to change a property on a set of selected elements? I know it can be done by CSV export and import, but any other way?

6
But I think there should be some way of turning off the relatedElements temporarily. I can do it by turning off the metamodel, but that can corrupt my models. It might be possible to create some shape script inside each relatedElement script to do that, but again to complicated.

7
Hi
We are using Decorations and relatedElements for all the elements in our MDG. But when the size of some the diagrams increased, the time to save a diagram went up to 30 seconds for .EAP and 90 seconds for a database save.

Has anyone else encountered this and were you able to solve it, instead of creating smaller diagrams? About 60 elements in these diagrams!

Thanks
Mats

8
This helped with another issues as well! Now we can find all our stereotyped elements in the Relationship matrix as well. And when using _metatype on our relations/connections they also show up in the Relationship matrix!!!  :D :D :D :D :D

9
Bugs and Issues / Re: Using instances in compartments
« on: April 05, 2017, 05:16:30 pm »
Interesting, I had a name on ONE of the linked instances and it showed just the object id of that instance, nothing at all for the second one.
When a added a name to the second one, both instances showed up with names in the compartment!!!

That is a strange feature ::)

Mats

10
Bugs and Issues / Using instances in compartments
« on: April 05, 2017, 12:05:53 am »
I create instances with the same stereotype as the original element. And I use compartments to show relations between elements. When I create a relation between an element and an instance (where I have defined that the sterotypes have a relation) and display this relation in a compartment (using a RelatedElement shape script)  the object number of the instance is displayed instead of the name of the instance!

Is this a bug or a feature?

Thanks
Mats

11
Suggestions and Requests / Use sterotype name when creating element
« on: March 30, 2017, 12:26:33 am »
I have created a MDG with a number of stereotyped elements, most of them are based on Class. When I drag and drop them from the toolbox, they are are given the name Class + a number. I assume there is a way of configuring the sterotype to use the name of it instead of the UML metaclass. But I have not been able to find it.

Can someone give me a hit (or a link to where this is described)?

Thanks
Mats

12
Suggestions and Requests / Conveyed items & SQL
« on: March 17, 2017, 08:35:49 pm »
Hi
This code works to get a list source and target applications and the information that flows between them (from the InformationFlow relation) and the mechanism used to communicate (integrate) the appplications (tag on InformationFlow). I have used it from excel and it works fine. But when I use it from SPARX it does not find the dbo.split function.
I do have the code for the dbo.split (from internet), but I do not know to include it in the SPARX SQL window. Anyone knows???

Code: [Select]
SELECT  source.name AS Source ,
        source.stereotype AS Source_Stereotype ,
        target.name AS Target ,
        target.stereotype AS Target_Stereotype ,
        ISNULL(ct.Value, '') AS IntegrationDescription
, o.name Information
FROM    ( SELECT    Behavior ,
                    Client ,
                    d.s Description
          FROM      t_xref x1
                    CROSS APPLY dbo.split(',', x1.description) d
          WHERE     x1.Behavior = 'Conveyed'
        ) x
JOIN t_object o ON x.Description=o.ea_guid
        JOIN dbo.t_connector c ON c.ea_guid=x.Client
JOIN dbo.t_object source  ON c.Start_Object_ID=source.Object_ID
JOIN dbo.t_object target ON c.End_Object_ID=target.Object_ID
        LEFT OUTER JOIN dbo.t_connectortag ct ON c.Connector_ID=ct.ElementID
WHERE   x.Behavior = 'conveyed'
        AND c.end_object_id = target.object_id
        AND source.stereotype != 'Process'
        AND target.stereotype != 'Process';

dbo.split from https://ole.michelsen.dk/blog/split-string-to-table-using-transact-sql.html
Code: [Select]
[/
CREATE FUNCTION [dbo].[Split]
(
    @String NVARCHAR(4000),
    @Delimiter NCHAR(1)
)
RETURNS TABLE
AS
RETURN
(
    WITH Split(stpos,endpos)
    AS(
        SELECT 0 AS stpos, CHARINDEX(@Delimiter,@String) AS endpos
        UNION ALL
        SELECT endpos+1, CHARINDEX(@Delimiter,@String,endpos+1)
            FROM Split
            WHERE endpos > 0
    )
    SELECT 'Id' = ROW_NUMBER() OVER (ORDER BY (SELECT 1)),
        'Data' = SUBSTRING(@String,stpos,COALESCE(NULLIF(endpos,0),LEN(@String)+1)-stpos)
    FROM Split
)
GO
code]

13
Hi
I have added a TAG to my InformationFlow sterotype and added the InformationFlow to my toolbox. When I use it from the toolbox the TAG is created, but not when I use it directly (QL) in the diagram. It picks up InformationFlow from my QL file correctly, but not the TAG.

Do I need to do something in my QuickLink file to make it work?

Thanks
Mats

14
Suggestions and Requests / Re: Label position in shape
« on: February 09, 2017, 02:20:08 am »
I will try making the decorations so small that the label text will not overwrite them.

15
Suggestions and Requests / Re: Dual decorations when switching MDG
« on: February 04, 2017, 02:05:37 am »
Hi Paolo
I tried doing that but the UML element decoration comes on top of my decoration. I have not found any setting that puts my decoration on top.

But the gradient setting removed the the other problem!!

Thanks
Mats

Pages: [1] 2 3