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

Pages: 1 2 3 [4] 5 6 ... 8
46
We get around this by publishing the models to our corporate intranet site, and then manually trigger the indexing of the static files using the intranet site's indexing/search solution.

47
Suggestions and Requests / Re: Setting the "status" for diagrams
« on: March 17, 2012, 02:43:28 am »
@Doug Blake

Good idea for a workaround, i guess that's what I'll have to do for now.

48
Suggestions and Requests / Re: Setting the "status" for diagrams
« on: March 17, 2012, 12:52:54 am »
I should have mentioned, I know you can view the profiles in the Resource browser, I just find the implementation awkward when it comes to using them as part of a project review.

49
Suggestions and Requests / Re: Setting the "status" for diagrams
« on: March 17, 2012, 12:28:54 am »
I wasn't thinking in terms of UML, I was thinking in terms of an architecture repository made up of catalogs, matrices and diagrams.

I use diagrams to capture view points for my clients, and I want to use the status attribute to support the approval workflow we use for these diagrams.   Currently I have to track the approval using a separate spreadsheet.  

Similarly I'd like to be able to store an object or bookmark visible in the project browser that represents a specific instance of a matrix (matrix profile + target + source), and be able to have notes, status etc. attributes associated with the specific instance.  (if you can already do this let me know)

Same reason, I want to be able to review the matrix with clients to verify the connections, and then flagged the relationship was approved.    

Without these capabilities, we may have to start looking for another solution as the size of our Architecture catalog grows.   Either moving from EA, or investing in a custom extension.

For the other tech heads.

As long as the "last modified date" is set in response to any changes to the diagram/matrices attributes, we can work the SQL to identify when the matrices and diagrams would need to be reviewed, due to changes in underlying elements and connectors.  e.g. last modified date of diagram is older than last modified date of a connector/element represented in the diagram.

50
Suggestions and Requests / Setting the "status" for diagrams
« on: March 16, 2012, 01:41:55 am »
I'd like to be able to set a status attribute for diagrams, the same way I can for elements in the repository.

Currently there is no way to indicate that a diagram has been reviewed and approved etc.

51
General Board / Simplifying tracing from a Source Document
« on: February 09, 2015, 06:24:08 am »
As a Business Analyst I often reference existing documentation as a source of statements that describe people, processes, requirements, rules etc, included in my analysis.   Early on I discovered that Sparx EA allows me to import and store RTF documents, and then directly generate elements in the repository by selecting statements from these documents.   Unfortunately the interface for this feature is NOT very user friendly, requiring you to navigate several nested menus each time you want to create a new element.   To address this issue (and later to simplify some other tasks), I decided to use an application called AutoHotKey to reduces these steps down to a single Keyboard Shortcut.

To get a copy of my AutoHotKey script and a description of how to use it, check out my new blog.

http://stevenksavage.com/?p=22

52
General Board / Neaten report output by adding bookmarks
« on: December 05, 2014, 05:08:21 am »
On: http://www.sparxsystems.com/products/ea/11/beta/index.html#reporting

There is:
  • Define a Template Fragment that calls a different fragment based on element type
  • Neaten report output by adding bookmarks to support conditional output
  • Define a header to be generated for the first item only
  • Define a list separator to be generated for items other than the first
  • Conditionally write text around any field only if it is non-empty
  • See system reports for examples

For the last line "See system reports for examples" could you be a bit more specific?  The only way for me to see bookmarks in these examples is to copy the template documents  one at at a time to see if it "might" be the one you are talking about (can't view bookmarks on the originals)

I have this working for:

  • {Element.Notes.Start} {Element.Notes} {Element.Notes.End}, and
  • {Element.valueOf(aTaggedValue).Start} {Element.valueOf(aTaggedValue)} {Element.valueOf(aTaggedValue).End}

I haven't figured out how to do this for custom fields yet.  
I did find the info on:

custom>{CustomSQL_TITLE_Begin}Label: {CustomSQL_TITLE_End}{CustomSQL_LIST_Begin}, {CustomSQL_LIST_End}{FieldName}<custom

I'd like to change my output depending on {FieldName} being null or providing a value.  

{CustomSQL.FieldName.Start} {FieldName} {CustomSQL.FieldName.End} does not seem to work.

53
General Board / Re: Can fields be conditionally included in templa
« on: July 07, 2014, 07:25:31 am »
Can you use this within a "custom" tag?
e.g. I have a custom query result with the field TEST1

Custom.TEST1.Start
and
CustomSQL.TEST1.Start

neither worked.

54
General Board / Re: Can fields be conditionally included in templa
« on: June 23, 2014, 06:21:45 am »
Has the ability to work with conditional text (in the GUI) been added yet?

55
General Board / Re: Search for diagram with name
« on: September 17, 2013, 01:39:29 am »
Hi RoyC, I understand that.
Unfortunately "Diagram" does not show up in the "Search On" list (the initial filter), Element, Attribute etc. do, but not Diagram.

In the manual it shows Diagram in the "Search On" list:
http://www.sparxsystems.com/enterprise_architect_user_guide/10/navigate_search_and_trace/adding_filters.html

Am I looking in the wrong spot?

56
General Board / Re: Search for diagram with name
« on: September 15, 2013, 01:01:00 am »
I've been looking at this, more to filter out certain diagrams types from specific reports (that's why I don't want to use the feature to exclude a diagram from ALL reports)

What I find odd: the help section on Filters in EA 10 specifically shows and mentions filtering by Diagram properties:

"If you are adding filters to an existing search, the list contains only items appropriate to the initial filter. For example, if the initial filter is on diagram properties, the list for any subsequent filters for the search only contains the Diagram option"

http://www.sparxsystems.com/enterprise_architect_user_guide/10/navigate_search_and_trace/adding_filters.html

But like everyone else, I can't find this option, did it exist and was removed????

57
General Board / Re: SQL "with clause" for reusing subqueries
« on: September 15, 2013, 01:18:16 am »
Quote
They need to parse it as some passages are being replaced (like e.g. <Serach Term>, #Branch#, etc.)

q.

I thought something like that too, but I was surprised that using the API (Repository.SQLQuery) wasn't just a pass through.   If it was I could use a script and a template fragment to do some of what I want.

58
General Board / Re: SQL "with clause" for reusing subqueries
« on: August 26, 2013, 11:41:10 pm »
Yes, I'll submit a feature request.
I thought the query would be a simple pass through, I guess EA does some type of syntax checking on the SQL?


59
General Board / Re: SQL "with clause" for reusing subqueries
« on: August 23, 2013, 06:26:18 am »
Hi Helmut, I tested it already with Query builder and it works fine

There was a typo in my last post though:
WITH q04 AS (Select q03.PName, q03.EName, q03.EID, q03.AName, q03.AType From
(Select q02.PName, q02.EName, q02.EID, t_attribute.Name AS AName, t_attribute.Type AS AType From t_attribute JOIN  /* q03: get the attrbutes for the XSD objects */
(Select q01.Name AS PName, t_object.Name AS EName, t_object.Note AS ENote, Object_ID AS EID from t_object JOIN /* q02: get the objects within the XSD packages */
(Select Package_ID, Name From t_package where Parent_ID IN /* q01: get the packages within the XSD Schema */
(Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}') /* the package containing the XSD Schemas */
) q01 ON t_object.Package_ID = q01.Package_ID /* end: q01 */
) q02 ON t_attribute.Object_ID = q02.EID /* end: q02 */
) q03 /* end: q03 */
)
Select * From q04

For now I guess I'll just use SQL Developer to pull the data I need.

60
General Board / SQL "with clause" for reusing subqueries
« on: August 23, 2013, 02:08:00 am »
I'm doing a rather complex query to generate a data dicitonary.
To simplify the query, I'd like to make use of Oracles WITH clause.  Unfortunately this doesnt seem to be supported in the SQL search feature (or the repository.SQLQuery) command.  

I don't know if it's something with my local setup, or somehting with EA.  Any ideas?  

Simple Example:
WITH q01 AS (Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}')
SELECT Package_ID From q01

Info from oracle:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm#i2129904

What I'm trying to do:

WITH q04 AS (Select q03.PName, q03.EName, q03.EID, q03.AName, q03.AType From
(Select q02.PName, q02.EName, q02.EID, t_attribute.Name AS AName, t_attribute.Type AS AType From t_attribute JOIN  /* q03: get the attrbutes for the XSD objects */
(Select q01.Name AS PName, t_object.Name AS EName, t_object.Note AS ENote, Object_ID AS EID from t_object JOIN /* q02: get the objects within the XSD packages */
(Select Package_ID, Name From t_package where Parent_ID IN /* q01: get the packages within the XSD Schema */
(Select Package_ID From t_package where ea_guid = '{A5B35797-AA94-4641-ACC7-AB1A2819DD66}') /* the package containing the XSD Schemas */
) q01 ON t_object.Package_ID = q01.Package_ID /* end: q01 */
) q02 ON t_attribute.Object_ID = q02.EID /* end: q02 */
) q03 /* end: q03 */
)

Pages: 1 2 3 [4] 5 6 ... 8