Messages

1

General Board / Re: How to change Phase of a selected list of elem

« on: August 31, 2012, 10:10:33 pm »

thx.
thats a clunky solution to what i would think is something users would like to do quite often.

2

General Board / How to change Phase of a selected list of elements

« on: August 31, 2012, 09:02:45 pm »

Hi,
I have a package that has 50 elements in it (UseCases).
Currently they are all marked as Phase 1.0.

I want to be able to change some to 2.1 and some to 2.2.
Is there an easy way to do this in EA?


I know how to do this.
1. i can use the Package COntrol - Update Package Status
this will update ALL of them with a new Phase.

2. i can use Model Search to find the items i want to update to 2.1 and the ones i want to update to 2.2.
Is there a way from Model Search to update the items returned?


Thx
Derek

3

General Board / Re: Model Search : How display Package / Model Nam

« on: August 28, 2012, 05:59:25 pm »

Thx Geert.
It looks like ill have to create a number of SQL searches to allow other team members do simple searches.

4

General Board / Model Search : How display Package / Model Name

« on: August 28, 2012, 05:04:26 pm »

Hi,
When using Model Search i think it would be useful if the table of matches returned
1. the package name that the item was found it.
2. the root node package (model) that the item was found in.

This means i can search the entire EA project and then sort the returned information by one of the many root node models or by the package its contained in.


Is the above possible or planned?

Thx
Derek

5

General Board / Re: Search Model: How search specific model

« on: August 28, 2012, 04:57:11 pm »

found answer.
In the Model Search you have to.
1. Options - Manage Searches
2. Search Options  and set the scope to "Return matching items for selected package.
(the Search Options is a button on the toolbar when Manage Searches open.


NOTE: the default search scope seems to be "return matching items for the entire model"

This is ambiguous. What is the entire model?
A project can contain multiple models. There is not a concept of the entire model. There is a concept of an entire project.
So this search options should be
- entire project
- current model
- current package.

Project
   Model0
     Package00
     Package01
   Model1
      Package10
      etc.

Thx
Derek

6

General Board / Search Model: How search specific model

« on: August 28, 2012, 04:45:15 pm »

Hi,
My EA project contains multiple root node models.
I want to perform a search (Model Search) to just find items that are in one of the root node models.

How can this be acheived? I cant see any obvious way that the model Search is sensitive to the model selected in project browser.
I cant see any option to allow me put a search string against the root node model.

Thx
Derek

7

General Board / Re: HTML Report compatibility

« on: August 17, 2012, 10:20:14 pm »

Excellent. Thats exactly what i need.
Confirmed it works.
Thx
Derek

8

General Board / Re: HTML Report compatibility

« on: August 17, 2012, 07:55:42 pm »

Hi,
Ive just exported from EA a html report.

It works fine in IE 9.
Partially works in Firefox 14
Doesnt work at all in Chrome 21


In Firefox you get Errors in the console.
When you browse to an element (e.g. requirement) you generally have 2 buttons
+ Project
+ Advanced

if you click on these you get error.
Timestamp: 17/08/2012 10:49:23
Error: TypeError: cont.document.getElementById(src) is null
Source File: file:///C:/ea/html/js/displayToc.js
Line: 954

Clicking on "Associations to" also produces errors.
Timestamp: 17/08/2012 10:51:36
Error: TypeError: tableSelTitle is null
Source File: file:///C:/ea/html/js/displayToc.js
Line: 1002



Chrome just doesnt seem to like the "Frame" design.



I also have another issue. The structure of the output html files bares no resemblance to the model in EA. This means you cannot link to the HTML report.

e.g. id like to send an email to colleagues and put a link to a particualr feature.
In EA i know its path.
/System Features/Feature Descriptions/SI System Installation Features/FEA.SYS_SI.1 - Product
This gets tranlated to this
EARoot/EA1/EA1/EA1/EA35.htm

(all the numbers will change depending on the strucutre within EA.

Thx
Derek

9

Automation Interface, Add-Ins and Tools / Re: DB with multiple Models: SqlQuery just 1 model

« on: August 28, 2012, 04:40:11 pm »

Thx Geert. I used the SQL query with JOIN and it worked perfectly.

For others .
I used the GetModelId method to get the ID of the varous root node models. The returned integer is what i used as the startingPackageId

Thx
Derek

10

Automation Interface, Add-Ins and Tools / DB with multiple Models: SqlQuery just 1 model?

« on: August 23, 2012, 08:09:04 pm »

Hi,
On our MySQL DB we have multiple Models (root node packages).

I want to do a query and am only intereseted in data from a specific model.

Currently when it runs it returns informaotin from all Models.
org.sparx.Repository oRepos = new org.sparx.Repository()
oRepos.OpenFile(sReposName);

// simple Query
String sSqlQuery  = "SELECT t_object.ea_guid AS GUID  FROM t_object";
String sTmp = oRepos.SQLQuery(sSqlQuery);
System.out.println(sTmp);


The t_object table has objects that are in ALL models. Is there a way to filter the query so it only returns items that are in one of the root node models?

Thx
Derek

11

Automation Interface, Add-Ins and Tools / Re: SqlQuery: Different behaviour when access DB V

« on: August 24, 2012, 04:24:42 pm »

thx.
Confirmed this works for MS and MySQL
SELECT t_object.ea_guid AS [GUID]  FROM t_object

12

Automation Interface, Add-Ins and Tools / SqlQuery: Different behaviour when access DB Vs a

« on: August 23, 2012, 08:04:12 pm »

Hi,
We host our EA models in a MySQL DB.
I have created a shortcut .eap file to the DB.

When i run a Java program to perform a SqlQuery of the DB (via the shortcut .eap) file it works correctly.

org.sparx.Repository oRepos = new org.sparx.Repository()
oRepos.OpenFile(sReposName);

String sSqlQuery  = "SELECT t_object.ea_guid AS GUID  FROM t_object";
String sTmp = oRepos.SQLQuery(sSqlQuery);
System.out.println(sTmp);




If i "transfer" the DB to a .eap project (to create a local copy) with the
Tools - Data Management - Project Transfer
and re-run the same JAVA program to do a SqlQuery it returns the following with no data.
<?xml version="1.0"?>
<EADATA version="1.0" exporter="Enterprise Architect">
</EADATA>



Does the SQL query need to change depending on the database behind the scenes?

Thx
Derek

13

Automation Interface, Add-Ins and Tools / Re: SqlQuery from JAVA API returning nothing

« on: August 23, 2012, 06:33:22 pm »

found issue in my code. It works fine.
My error was that i was constructing the SQL Search on multi lines.

             sSqlQuery  = "SELECT";
             sSqlQuery += "   t_object.ea_guid AS GUID,";
             sSqlQuery += "   t_object.name AS Name,";
             sSqlQuery += "   t_object.Object_Type AS Type,";
             sSqlQuery += "   t_object.Author AS Author";
             sSqlQuery += "FROM ";                                 <----- this line was issue.
             sSqlQuery += "   t_object";


I had to put a space in front of the FROM.

             sSqlQuery  = "SELECT";
             sSqlQuery += "   t_object.ea_guid AS GUID,";
             sSqlQuery += "   t_object.name AS Name,";
             sSqlQuery += "   t_object.Object_Type AS Type,";
             sSqlQuery += "   t_object.Author AS Author";
             sSqlQuery += " FROM ";
             sSqlQuery += "   t_object";

14

Automation Interface, Add-Ins and Tools / SqlQuery from JAVA API returning nothing

« on: August 23, 2012, 06:23:16 pm »

Hi,
Im using the JAVA api to export information from EA.
Im now extending it and want to use the Repository command SqlQuery.

Using the EA GUI i can construct the SQL query in the Model Search window and it runs correctly.
Trivial example here.
SELECT t_object.ea_guid AS GUID FROM t_object


When i try to use the JAVA API i get nothing back. here is my script.

org.sparx.Repository oRepos = new org.sparx.Repository()
oRepos.OpenFile(sReposName);

String sSqlQuery  = "SELECT t_object.ea_guid AS GUID  FROM t_object";
String sTmp = oRepos.SQLQuery(sSqlQuery);
System.out.println(sTmp);


What i get back in sTmp is this. (empty xml)
<?xml version="1.0"?>
<EADATA version="1.0" exporter="Enterprise Architect">
</EADATA>

Ive tried putting a broken SQL command in and i still get same back the same.
String sSqlQuery  = "SELECT t_object.XXXXXea_guid AS GUID  FROM t_object";


Any suggestions?

Thx
Derek