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 ... 8
31
General Board / Tagged Values - t_objectproperties
« on: January 19, 2012, 01:47:49 am »
Hi All,

Can someone (from Sparx?) explain how the ea_guid is populated in the t_objectproperties table?

The reason i ask is that we created a BPMN profile, based upon the standard BPMN1.1 profile (minus some elements we didn't want our users to use). We now want to upgrade to BPMN v2.

The Sparx migration script doesn't work. Not suprised as i've change the profile name from BPMN1.1 to DBBPMN1.1. So i've run the following sql:

update t_xref set description = REPLACE (cast(description as nvarchar (max)), 'DBBPMN', 'BPMN')where description like '%DBBPMN%';
update t_diagram set StyleEx = REPLACE (cast(StyleEx as nvarchar (max)), 'DBBPMN', 'BPMN')where StyleEx like '%DBBPMN%';

The migration script now starts but crashes Sparx when it hits the migration of tagged values. If i delete all tagged values from t_objectproperties and re-run the migration script is fine.

Some digging suggests that the ea_guid in t_objectproperties is a combination of the type of tagged values internal ID and something else...i understand that the internal id would relate to our version of the BPMN profile (DBBPMN profile) so i need to update the ea_guid before the migration script will run...just need to understand how to update...

Any hints / pointers much appreciated.

Regards,

Jon.

32
General Board / Help with version control (with svn)
« on: January 13, 2012, 08:48:56 pm »
Hi All,

I've been asked to put a PoC together to show how version control works with Sparx. Pretty straight forward, all setup and working - but...i need to check with you gurus how branching works with Sparx.

Am i correct in thinking that Sparx itself cannot be used to create a branch. You need to create it in svn, then use Sparx to export from your trunk. Reconfigure your Sparx svn connection to point to the branch and import - work on your branch then at a later date export from Sparx - re-configure your svn in Sparx (or use the original eap) to point to the trunk (get all latest) and use baseline compare to your branch export to merge branch back into trunk as required ?

Unless i'm missing something - it doesn't look to me that i can do branching / merging seamlessly within a single Sparx project ?

Any help / pointers etc much appreciated,

Regards,


Jon.

33
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....

34
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'

35
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.

36
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

37
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.

38
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.

39
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.

40
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.

41
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?

42
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.

43
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.

44
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.

45
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.

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