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.


Topics - OpenIT Solutions

Pages: 1 2 [3] 4 5 ... 7
31
General Board / EAP to DBMS (SQL server) transfer
« on: January 06, 2012, 11:10:54 pm »
Hi All,

I'm getting an error whan transfering a blank EAP to DBMS - t_category does'nt exist. Well it does in the DBMS...anyone come across similar issue ? Same with 9.2 and 8.0 - so i've probably got something mis-configured - but can't see it

Any help, pointers appreciated...

ps Sparxs crashes after reporting the error....

32
General Board / Changing types...
« on: January 06, 2012, 04:04:17 am »
I need to change the object type of all text annotations in my model that have a name that starts with 'BR-' from a TextAnnotation to a Requirement.

I've written and run the update sql:

update t_object set object_type = 'Requirement', stereotype = 'Functional' where stereotype = 'TextAnnotation' and name like 'BR-%'

Runs fine...however in sparx the objects are still shown as TextAnnotations - until i open and clos their property sheet - they then magically become Requirments...clearly i need to update something else...but i can't figure out what it is - which table ??

Any help much appreciated.

Thanks,

Jon.

ps...can't use advanced->change object type as need to set the stereotype as well to 'Functional'

33
General Board / HTML output via model documents
« on: December 23, 2011, 03:02:07 am »
Hi All,

Has anyone else observed this behaviour....any diagrams or elements (other than packages) in the package that i add as an attribute to my "model document" class are not included in the html output..?

Is this by design? Or have i done something wrong ? Or is this a bug ?

Regards,


Jon.

34
General Board / Upgrading...
« on: December 23, 2011, 10:13:03 pm »
Just wanted to check....we will be upgrading from 8 to 9.2 and moving from bpmn 1.1 to v2. I'm assuming i just need to run the bpmn migration script...correct ?

We host on MS SQL Server...have there been any changes to the MS SQL Server setup script between v8 and v9.2 ? Do i need to do anything with the underlying database for optimal performance ?

Regards,

Jon

35
General Board / Class Attributes
« on: November 11, 2011, 10:57:34 pm »
Hi All,

Is there a way in EA to show a relationship between an object (in our case a Requirment/BusinessRule) and specific attributes of a class?

I'm after something that is pretty straight forward as it will be business analysts forming the relationship/dependancy.

Regards,

Jon.

36
General Board / Styles & Section Numbering in RTF
« on: November 22, 2011, 10:29:10 pm »
Hi All,

I've read (and probably not understood - note i think help docs need updating here) the User-Defined Section Nunbering section, but i can't get the effect i require.

I'm generating a document (a table of requirments) which is being automatically inserted into a Word document as a linked document. This works fine.

However the word document uses different "heading styles", "Numbered Heading 2" and "Numbered Heading 3". I can create the same styles in the RTF template editor and apply "Heading Style 2" to my "Package name", however i can't get the RTF generatror to automatcially use "Heading Style 3" for child packages. Any suggestions ?

I appreciate this ones a bit difficult to explain, so please ask for clarification if you think you may be able to help.

Regards,


Jon.

37
General Board / MS SQL Server CHARINDEX, SUBSTRING functions
« on: November 19, 2011, 02:08:23 am »
Any idea why i get an error when trying to use these functions in a model search against my MS SQL Server OLE DB connection within EA ?

Thanks,

Jon.

38
General Board / Rules Composer
« on: November 11, 2011, 12:47:43 am »
Hi,

Does anyone know which database tables the rules composer stores its data in ?

Regards,

Jon.

39
General Board / CSV import
« on: November 10, 2011, 01:50:35 am »
We have a list of requirments that we will need to import, on a regular basis. The CSV import capability works fine. However when i re-import the list (to pick up additions and changes) any existing entry in EA is created again. I'd like EA to either skip or overwrite duplicate entries - is there any way to when using CSV import to do this (when we don't have GUIDS) on the import CSV file?

40
General Board / RTF report containing details of rules composer ?
« on: November 01, 2011, 09:29:10 pm »
Hi All,

Is there a way to output via the RTF Document Generator the details contained within a "rule task" when viewed via the "rules composer" ?

I know i can output to csv file, but i need the details in my requirments document that is being auto generated via the RTF Document Generator.

Regards,

Jon.

41
General Board / Notes type....
« on: September 13, 2011, 01:20:12 am »
Hi,

Anyone know which table stores the actual notes (text) associated with t_object of object_type Note ?

Thanks,

Jon.

42
General Board / ole db connection string for auto failover?
« on: September 12, 2011, 09:58:38 pm »
Hi,

Does anyone know if the 'FailoverProvider=xxx' connection option can be made for an sql server (ole db connection) in EA ?

Thanks,

Jon.

43
General Board / 8.0 - diagrams blacked out ??
« on: September 08, 2011, 01:06:45 am »
HI All,

Has anyone seen this - i have a user that intermitently will open a diagram and find it blacked out in ea v8. This is a multi user env using sql server db ? Still happens if i get her to refresh/load the project...

Thoughts ?

Regards,

Jon.

44
General Board / Tagged Values
« on: September 07, 2011, 03:05:42 am »
Hi All,

Anyone know which table holds tagged value data...doesn't look like t_taggedvalue...?

Thanks,

Jon.

45
General Board / How does EA model BPMN under the hoods?
« on: August 24, 2011, 09:49:54 pm »
Hi,

I have a question about how EA models BPMN under the hoods. Specifically i need to understand how EA associates a BPMN Pool/Lane with a contained Activity/Process on a diagram? Does anyone know which tables/column in the EA database tell EA that the activity is contained within the pool on the diagram?

I ask a i need to write a report that lists all activities used by a role (ie a Lane in BPMN). The problem is that we have a libary (ie seperate directory in EA of all roles - a bunch of BPMN Lane elements/objects in a directory) of roles/Lanes that is reused across diagrams. Each diagram is in its own package (representing the process being modeled), which also contains the activities associated with the package.

The only relationship (used loosly here) that i can see is at the diagram level - as the Activity just sits in the Lane - its not a child or embeded element. There is also no formal relationship (connectors) between the two elements - so how does EA know that the Lane contains the activity on the diagram? I can see a ObjectType column in the DiagramObjects table and see the the Lane is dockable, so my assumption is that when a move a Lane (dockable element) on a diagram EA looks at the coordinates of all elements on the diagram and moves any that are within the dockable element - problem is that i can't search for this in SQL etc....so can't report upon it...any clues or suggestions?

Appreciate any help,

Jon.

Pages: 1 2 [3] 4 5 ... 7