Book a Demo

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

Pages: [1] 2
1
General Board / Re: Edit with Profile Helper - not an option?!
« on: September 26, 2013, 11:02:44 pm »
Very strange then, glad it's not me being a numpty! I've lodged a ticket with Sparx. Will see what they say.

Thanks for the assistance, Q.

2
General Board / Re: Edit with Profile Helper - not an option?!
« on: September 26, 2013, 10:23:06 pm »
If you mean have I created a Model from a Pattern 'MDG technology Builder - Basic Template', then yes, I have. I've tried it with the Simple Template too.

Once I have a stereotype or two (created using the 'Add Stereotype' or 'Add Diagram Extension' tools), I'd expect to right click on the created stereotype and select an option 'Edit in Profile Helper'. The profile helper appears when i'm creating new items, but won't then let me go back and edit them in the helper, as there is no option to do so.

3
General Board / Edit with Profile Helper - not an option?!
« on: September 26, 2013, 07:01:18 pm »
Hi all,

I've been playing around with creating an MDG Technology to provide a framework for a particular type of analysis we do at my work. Looking at the online help (including the webinar video provided by Sparx) and they refer to an option on the 'right click' menu called 'Edit with Profile Helper'. This option doesn't exist in my version of EA and I'm not sure why.

Is it linked to the version or release? I have 1009 Corporate edition.

Any help appreciated, as the helper seems a much easier way to get an MDG going, saving reference to all the attributes I need!

Rgds
Chris

4
General Board / Re: Paste as Link on Sequence Diagrams
« on: September 18, 2013, 10:13:13 pm »
New version sorts the problem! Thanks Geert.

5
General Board / Re: Paste as Link on Sequence Diagrams
« on: September 18, 2013, 07:12:19 pm »
Thanks Geert, I've tried Ctrl dragging and it still doesn't give me a dialogue box. I also ntice that the 'Paste as Link' options are greyed out in the Edit menu. If they've changed things in the last few builds, I'll try updating. i notice I'm a few builds behind the current (1004, whereas latest is 1010, I think).

6
General Board / Paste as Link on Sequence Diagrams
« on: September 18, 2013, 06:57:27 pm »
I have an issue when building a sequence diagram, which doesn't seem to occur in other diagrams. When dragging an element from another package, Enterprise Architect doesn't give me the option of choosing whether I paste as a link, it just automatically creates a new instance within the sequence diagram package.

I can't find any settings which are preventing this happening, and the option seems to appear on other users' systems. Has anyone else had this problem (and solved it)? I've searched the help and googled all sorts to try and solve it, but with no luck.

If anyone can help, I've greatly appreciate it.
Many thanks
Chris

7
General Board / Re: Extracting Conveyed Items using SQL query
« on: May 15, 2013, 06:46:56 pm »
Finally found the time to try this! Thanks for the suggestion. My issue is that EA won't let me conduct a JOIN on a memo field, which t_xref.Description is. Hence I moved to using 'Where' statements instead of joining the tables.

You are correct that I'm just creating my searches within EA, using a .eap file (MS Access).

The wildcard within the final 'LIKE' statement doesn't seem to work whether I use '*' or '%' if there is more than one info item conveyed on a connector. The results for that connector just don't appear in the search results in this case. It works fine if only one info item is conveyed on the connector.

8
General Board / Re: Extracting Conveyed Items using SQL query
« on: February 08, 2013, 02:45:52 am »
It's amazing how writing something down can help you think better, plus a bit of searching on general SQL fora. I didn't really need to join all the tables, as I was just extracting data from them, so I reduced by LEFT JOINs to 'Where' statements. You can use memo fields in 'Where' statements. The downside of this is that it won't work if there is more than one information item conveyed (when EA puts both guids in the same Description field, separated by commas).


SELECT t_connector.ea_guid AS CLASSGUID, t_connector.Connector_Type AS CLASSTYPE, t_connector.Connector_ID AS [IER ID], t_connector.Name,  TO1.Name AS Source, TO2.Name AS Destination, TO3.Name AS [Info Item Conveyed], t1.VALUE AS [Data Size], t2.VALUE AS Unit, t3.VALUE AS Frequency, t4.VALUE AS [Protective Marking], t5.VALUE AS Timeliness, t6.VALUE AS [Applicable Standards], t7.VALUE AS Provenance, t8.VALUE AS Validation

FROM t_connector, t_object AS TO2, t_object AS TO1,  t_connectortag AS t1, t_connectortag AS t2,  t_connectortag AS t3, t_connectortag AS t4,  t_connectortag AS t5,  t_connectortag AS t6,  t_connectortag AS t7, t_connectortag AS t8, t_xref AS XCON, t_object AS TO3

WHERE t_connector.Stereotype='IER'  
AND t1.Property='Data Size'
AND t2.Property='Unit'
AND t3.Property='Frequency'
AND t4.Property='Protective Marking'
AND t5.Property='Timeliness'
AND t6.Property='Applicable Standards'
AND t7.Property='Provenance'
AND t8.Property='Validation'
AND t_connector.End_Object_ID=TO2.Object_ID
AND t_connector.Start_Object_ID=TO1.Object_ID
AND t_connector.Connector_ID=t1.ElementID
AND t_connector.Connector_ID=t2.ElementID
AND t_connector.Connector_ID=t3.ElementID
AND t_connector.Connector_ID=t4.ElementID
AND t_connector.Connector_ID=t5.ElementID
AND t_connector.Connector_ID=t6.ElementID
AND t_connector.Connector_ID=t7.ElementID
AND t_connector.Connector_ID=t8.ElementID
AND XCON.Behavior='conveyed'
AND XCON.Description=TO3.ea_guid
AND t_connector.ea_guid=XCON.Client

Does anyone know a cute way of searching within a memo field for a string? The 'LIKE' operator doesn't seem to work in this way, even when using wildcards infront and/or behind it. The section in question is:

AND XCON.Description LIKE TO3.ea_guid

I've tried '%'+FIELDNAME+'%', but it doesn't seem to work (except for those with only one item conveyed, just like the original statement.

Rgds
Chris

9
General Board / Extracting Conveyed Items using SQL query
« on: February 08, 2013, 02:15:03 am »
Hi all,

I'm trying to create a list of connectors (Information Flows of stereotype 'IER'), with their start and finish element names, and their conveyed Information Item element names. I've almost got it, by Left Joining t_object and t_connector multiple times, and using t_xref as the link table between the connector and the info item element. However, it stores the ea_guid of the info item element within a 'memo' field type, so it won't let me do my final Left Join. I'm banging my head against a wall trying to think of a work-around. Has anyone got any ideas? Code below:

SELECT t_connector.ea_guid AS CLASSGUID, t_connector.Connector_Type AS CLASSTYPE, t_connector.Connector_ID AS ID, t_connector.Name,  TO1.Name AS Source, TO2.Name AS Destination, XCON.Description AS [xref conveyed item guid], TO3.Name AS [Conveyed Item]
      FROM ((((t_connector
            LEFT JOIN t_object AS TO1
                  ON t_connector.Start_Object_ID=TO1.Object_ID)
            LEFT JOIN t_object AS TO2
                  ON t_connector.End_Object_ID=TO2.Object_ID)
            LEFT JOIN t_xref AS XCON
                  ON t_connector.ea_guid=XCON.Client)
            LEFT JOIN t_object AS TO3
                  ON XCON.Description=TO3.ea_guid)

WHERE t_connector.Stereotype='IER'  
AND XCON.Behavior='conveyed'


Any help gratefully appreciated.
Chris

10
General Board / Re: Please help - Complex SQL failing!
« on: January 15, 2013, 03:19:43 am »
Brilliant, thanks to all who have contributed. I've now got it working exactly as I wanted. Plus I've learned a bit more SQL into the bargain! A very productive first foray into the forum!  

11
General Board / Re: Please help - Complex SQL failing!
« on: January 13, 2013, 09:39:03 pm »
Great, that seems to be working a treat. Thanks very much. Especially once I'd woken up this morning and realised I should be replacing the T1, T2 etc with my actual tag names! Talk about a 'dim moment'!  Just shows how time away and a fresh look can help.

For presentational purposes, some of my column headings have two words, separated by a space, rather than an underscore. To get the statement to read it as a title, I put apostrophes before and after the two words, but they then show up in the column heading. The single-worded headings don't have this problem. Is there a notation/syntax that allows me to identify two words as a column heading but not then transfer the identification characters to the heading?

Last problem to solve, then I promise I'll leave you all alone!

Chris

12
General Board / Re: Please help - Complex SQL failing!
« on: January 13, 2013, 09:50:37 am »
Aha, that makes sense. Yes, I'm using a normal EAP file, created within EA. What should the syntax change be to allow geert's suggestion to work?

Thanks for taking the time to input to this.

13
General Board / Re: Please help - Complex SQL failing!
« on: January 13, 2013, 03:29:05 am »
qwerty, what's a RDBMS? I'm just using the SQL editor in the 'project find' window within EA10.

14
General Board / Re: Please help - Complex SQL failing!
« on: January 13, 2013, 02:33:48 am »
Just tried it again, I just keep getting the error: DAO. QueryDef [3296]  Join expression not supported.

Should there be an'AS' between to connector tag and t2? Not that it seems to make a difference.

Rgds
Chris

15
General Board / Re: Please help - Complex SQL failing!
« on: January 11, 2013, 09:21:22 am »
Thanks for the help everyone, it's working almost as I want it now. I still haven't solved my 2nd problem though. A better description below (apols if names are slightly wrong, I'm doing it from memory):

My Leftjoin statements get me to this (abridged!):

Name   Start_Object    End_Object  
IER1        S1                  Si1
IER2        S2                  Si2
IER3        S3                  Si3

t_connectortag colums of interest:

Name    TagName    TagValue
IER1        Tag1             xxx
IER1        Tag2             yyy
IER1        Tag3             zzz
IER2        Tag1             aaa
IER2        Tag2             bbb
IER2        Tag3             ccc
IER3        Tag1             ppp
IER3        Tag2             qqq
IER3        Tag3              rrr


The following is fairly simple to achieve, but not quite what I want, because of all the repetition:

Name    TagName    TagValue    Start_Object    End_Object
IER1        Tag1             xxx          S1                  Si1
IER1        Tag2             yyy          S1                  Si1
IER1        Tag3             zzz           S1                  Si1
IER2        Tag1             aaa          S2                  Si2
IER2        Tag2             bbb          S2                  Si2
IER2        Tag3             ccc           S2                  Si2
IER3        Tag1             ppp          S3                  Si3
IER3        Tag2             qqq          S3                  Si3
IER3        Tag3              rrr           S3                  Si3


What I really want is to extract the discrete values of TagName and create columns, then put the corresponding TagValue values in the appropriate column against the appropriate Name:

Name    Source       Sink    Tag1    Tag2    Tag3
IER1        S1            Si1     xxx      yyy      zzz
IER2        S2            Si2     aaa      bbb      ccc
IER3        S3            Si3     ppp      qqq       rrr


Any ideas?

Pages: [1] 2