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 - philchudley

Pages: [1] 2 3 ... 49
1
Thanks

I have solved my own problem  :)

The ID of the navigation cell linked diagram ID is in PDATA1, but this must be stored as an Int32 and then everything works just fine!

Phil

2
Thanks

I have solved my own problem  :)

The ID of the navigation cell linked diagram ID is in PDATA1, but this must be stored as an Int32 and then everything works just fine!

Phil

3
This is a long shot, but does anyone out there know where in the repository database are the details of the Navigation Cell Hyperlink property is stored?

I cannot find it anywhere ... its not t_xref

I would like to know for an add-in I am creating which needs to manipulate Navigation Cells.

I have found that the ID of the diagram the Navigation Cell links to is held in the PDATA1 field of the t_object table for the Navigation Cell entry. But this is not the complete picture.

Phil

4
I have just noticed this as well

On a related topic, where in the repository database are the details of the Hyperlink property stored?

I cannot find it anywhere ...

I would like to know for an add-in I am creating which needs to manipulate Navigation Cells.

I have found that the ID of the diagram the Navigation Cell links to is held in the PDATA1 field of the t_object table for the Navigation Cell entry. But this is not the complete picture.

Phil

5
General Board / Re: Toolbox is not working
« on: January 05, 2024, 01:14:15 am »
Have you tried clicking the >> icon (just above the Sparx Logo Start Page)

This hides / shows the toolbox

In my EA install toolbox is hidden by default, maybe this is your issue?

Phil

6
Automation Interface, Add-Ins and Tools / Close the Search Window
« on: December 05, 2023, 11:42:28 pm »
Hi All

It is possible to display results from a SQL Search within a Script to the Search Window.

BUT it appears there is no way to close the Search Window within the Script.

On the first execution the results display correctly, but on all subsequent executions, blank rows appear s the last rows in the Search Window.

Does anyone know how to close the search window within a script? I am using EA  16.1 latest build 64 bit and my script is written in JavaScript.

Many thanks
Phil

7
Automation Interface, Add-Ins and Tools / Session.Prompt Dialog
« on: November 08, 2023, 11:34:08 pm »
I am playing around with Model based add-ins using EA version 16.11.1627 64bit

Just, for the moment a simple menu to display an About box. The About box is displayed using Session.Prompt

This works fine, except that EA appears to hang with OK is clicked with the "blue circle of death" and will eventually (after about 45 secs to 1 minute) close the dialog.

Anyone else experienced this? If so, did you find a solution?

I suppose the delay does give the user time to read the dialog.  ;)

Phil

8
General Board / Re: HTML report of diagrams only
« on: October 04, 2023, 08:36:21 pm »
With EA open and a repository open:

1) Click the Resources tab in the Browser
2) Right-click HTML Publishing and select Create HTML Template
3) Provide a name for your template, for example Diagram Only
4) Click on the section named Body - Diagram and you will see the following in the editor

<div class="PageBody">
   <div class="diagram_image"> #IMAGE# </div>
   <div class="ObjectTitle">#NAME# : #TYPE# diagram</div>
   <table border="0" cellpadding="0" cellspacing="0" class="ObjectDetails">
      <tr>
         <td width="15%" class="ObjectDetailsTopic">Created:</td>
         <td width="85%" class="ObjectDetailsValue">#CREATEDATE#</td>
      </tr>
      <tr>
         <td width="15%" class="ObjectDetailsTopic">Modified:</td>
         <td width="85%" class="ObjectDetailsValue">#MODDATE#</td>
      </tr>
      <tr style="padding-top: 10px;">
         <td width="15%" class="ObjectDetailsTopic"><button onclick="switchProjectProperties()"><img src="#IMAGES#/plus03.gif" align="absmiddle" id="proj" /></button>Project:</td>
         <td width="85%" class="ObjectDetailsValue"></td>         
      </tr>
      <tr id="proj00" style="display: none;">
         <td width="15%" class="ObjectDetailsTopic" style="padding-left: 18px;">Author:</td>
         <td width="85%" class="ObjectDetailsValue">#AUTHOR#</td>
      </tr>
      <tr id="proj01" style="display: none;">
         <td width="15%" class="ObjectDetailsTopic" style="padding-left: 18px;">Version:</td>
         <td width="85%" class="ObjectDetailsValue">#VERSION#</td>
      </tr>
      <tr>
         <td width="15%" class="ObjectDetailsTopic"><button onclick="switchAdvancedProperties()"><img src="#IMAGES#/plus03.gif" align="absmiddle" id="adv" /></button>Advanced:</td>
         <td width="85%" class="ObjectDetailsValue"></td>         
      </tr>
      <tr id="adv00" style="display: none;">
         <td width="15%" class="ObjectDetailsTopic" style="padding-left: 18px;">ID:</td>
         <td width="85%" class="ObjectDetailsValue">#GUID#</td>
      </tr>
   </table>
   #NOTE#
</div>

5) Delete everything except line 2 <div class="diagram_image"> #IMAGE# </div>

This should leave:

<div class="PageBody">
   <div class="diagram_image"> #IMAGE# </div>
</div>

6) Click Save then Close

When you generate the HTML change the Style from <default> to your template name and all should be fine

Hope this helps

Phil

9
You can extract the fully qualified stereotype including the MDG name from the dreaded t_xref table

XrefID,Name,Type,Visibility,Namespace,Requirement,Constraint,Behavior,Partition,Description,Client,Supplier,Link,

{B8B468ED-8D4F-415c-8130-9108013D6A2C},Stereotypes,element property,Public, , , , ,0,@STEREO;Name=FunctionalRequirement;FQName=EAREQ::FunctionalRequirement;@ENDSTEREO;,{00196C9C-8221-4405-A5C3-616FC03FAA52},<none>, ,

The t_xref column is Description and the FQ stereotype is held in a; delimited string, for example FQName=EAREQ::FunctionalRequirement;

So, to discover the MDG for a particular element (or connector)

1) Create a SELECT query that extracts t_xref.Description from the join of t_object and t_xref, using t_object.ea_guid and t_xref.Client
2) Extract you MDG by extracting the necessary substring.

An example of a SQL query to perform the above (without the substring extraction) is:

SELECT t_xref.Description
FROM t_object, t_xref
WHERE t_object.ea_guid = t_xref.Client
AND t_object.ea_guid = 'GUID of your element /connector here'


Other methods of joining tables are available  ;)

Phil

10
I agree do not create elements directly in the database without using the EA API.

I also believe creating elements directly in the database without using the EA API, contravenes the EA licence agreement, so maybe worth check that out.

Phil

11
Geert is correct, the text property for a SysML requirement is indeed stored as a tagged value.

Phil

12
The method to display the menu for a tagged value as per BPMN (assuming the ID if the MDG is MYMDG)

1) Define an enumeration containing the literals for the tagged value
2) Add an enumeration tagged value to the stereotype (lets say MyStereotype), for example MyTaggedValue
3) In the metaclass for the stereotype add an attribute named _subTypeProperty of type String
4) Set the initial value of this attribute to the fully qualified MDG name of the tagged value (as defined in 2) above. In this example this would be

MYMDG::MyStereotype::MyTaggedValue

Hope this helps

Phil


13
A trick I use to let an element "link" to multiple diagrams is:

1) Create a EA Custom (or other diagram type) diagram. I usually place this diagram in its own package.
2) Drag onto this diagram the diagrams you want the element to link to as Navigation Cells, and choose an image of your choice.
3) Set the element to be a composite linked to the diagram created in 1)

Phil

14
General Board / Re: Repository Schema ER diagram
« on: January 26, 2023, 02:05:33 am »
I suspect that Trigger objects are located within the t_object table with t_object.Name matching the value PDATA1 in the t_connector. table

So a join using t_object and t_connector on t_object.Name and t_connector.PDATA1 restricting t_object to t_object.Object_Type to 'Trigger' and t_connector.Connector_Type to 'StateFlow'

Should do the trick.

Phil

15
Bugs and Issues / Re: Latest Release of EA v16.1 Template Fragments
« on: January 24, 2023, 08:15:00 pm »
Fair comment Geert, I was clarifying my interpretation.

I understand the Child elements when left blank, indeed does repeat what is in the element section, for all child levels. However, I have observed that if you place something inside the child elements section it overrides the element section, but only executes for one level of child level, well at least it did last time I tried.

I was just wondering whether fragment could be used in the child element section to provide a different appearance to that of the element. An unusual situation, but I have been asked by clients whether this is possible. Hence my post.

Phil

Pages: [1] 2 3 ... 49