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 - OpenIT Solutions

Pages: 1 ... 3 4 [5] 6 7 ... 31
61
General Board / Re: BPMN2 Off Page Connector
« on: July 13, 2015, 08:04:13 pm »
Yes - set the eventDefinition tagged value to Link.

62
General Board / Re: BPMN2 Off Page Connector
« on: July 10, 2015, 09:08:21 pm »
Add an intermediate event and set its event definition tagged value to Link.

If you were to add an explicit icon in the toolbox for every combination of event type (start, end and intermediate) you would end up with about 30 icons (to cover throwing/catching etc) ... hence the three icons (start, end, intermediated) and the use of tagged values to set the explicit type/definition...

63
General Board / Re: User Security - hiding items?
« on: July 03, 2015, 06:17:41 pm »
Hi,

In the real world this is necessary if you want to put all your architectural assets in one repository - which eases traceability, analytics etc.

Consider the example where your modeling a TOM. An element of which could be a new org design. Not something you would want all modelers looking at until plans are confirmed and communicated.

You could put this TOM design in a separate repository. But what if you want to trace/model the impact on current state ?

As ever with Sparx there are several "alternatives" - you could just use VC (without a DB backing it). Then on the VC system restrict access to your TOM packages.

Or look at creating several repositories backed with a DB, but using VC or the Reusable Asset Service (as your requirement dictates) to pull in the elements of the model you need / have access to...

Both these alternatives are in my mind problematic from an admin perspective (when you have a large model - with lots of uses - as is the case in the real world :-)).

64
General Board / Re: Add Hyperlink To A Data Object
« on: July 02, 2015, 07:26:47 pm »
Hi,

The default way to do this in Sparx would be to add a 'Web address' in the DataObjects Properties->Links page. In your html the user would click on the DataObject on a diagram, the property page of the DataObject would then be shown, it contains a tab for Links, the user would click the URL here to open the word doc...not quite what you want - but the default behavior...

65
General Board / Re: User Tracking Statistics
« on: June 09, 2015, 10:03:17 pm »
Well for SQL server you would have:

USE [sparx_bpm]
GO

/****** Object:  Table [dbo].[th_object]    Script Date: 09/06/2015 13:01:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[th_object](
      [Object_ID] [int] NOT NULL,
      [Object_Type] [nvarchar](255) NULL,
      [Diagram_ID] [int] NULL,
      [Name] [nvarchar](255) NULL,
      [Alias] [nvarchar](255) NULL,
      [Author] [nvarchar](255) NULL,
      [Version] [nvarchar](50) NULL,
      [Note] [ntext] NULL,
      [Package_ID] [int] NULL,
      [Stereotype] [nvarchar](255) NULL,
      [NType] [int] NULL,
      [Complexity] [nvarchar](50) NULL,
      [Effort] [int] NULL,
      [Style] [nvarchar](255) NULL,
      [Backcolor] [int] NULL,
      [BorderStyle] [int] NULL,
      [BorderWidth] [int] NULL,
      [Fontcolor] [int] NULL,
      [Bordercolor] [int] NULL,
      [CreatedDate] [datetime] NULL,
      [ModifiedDate] [datetime] NULL,
      [Status] [nvarchar](50) NULL,
      [Abstract] [nvarchar](1) NULL,
      [Tagged] [int] NULL,
      [PDATA1] [nvarchar](255) NULL,
      [PDATA2] [ntext] NULL,
      [PDATA3] [ntext] NULL,
      [PDATA4] [ntext] NULL,
      [PDATA5] [nvarchar](255) NULL,
      [Concurrency] [nvarchar](50) NULL,
      [Visibility] [nvarchar](50) NULL,
      [Persistence] [nvarchar](50) NULL,
      [Cardinality] [nvarchar](50) NULL,
      [GenType] [nvarchar](50) NULL,
      [GenFile] [nvarchar](255) NULL,
      [Header1] [ntext] NULL,
      [Header2] [ntext] NULL,
      [Phase] [nvarchar](50) NULL,
      [Scope] [nvarchar](25) NULL,
      [GenOption] [ntext] NULL,
      [GenLinks] [ntext] NULL,
      [Classifier] [int] NULL,
      [ea_guid] [nvarchar](40) NULL,
      [ParentID] [int] NULL,
      [RunState] [ntext] NULL,
      [Classifier_guid] [nvarchar](40) NULL,
      [TPos] [int] NULL,
      [IsRoot] [int] NOT NULL,
      [IsLeaf] [int] NOT NULL,
      [IsSpec] [int] NOT NULL,
      [IsActive] [int] NOT NULL,
      [StateFlags] [nvarchar](255) NULL,
      [PackageFlags] [nvarchar](255) NULL,
      [Multiplicity] [nvarchar](50) NULL,
      [StyleEx] [ntext] NULL,
      [EventFlags] [ntext] NULL,
      [ActionFlags] [nvarchar](255) NULL,
      [User_Id] [varchar](100) NOT NULL,
      [Change_Date] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Then create a trigger on t_object:

USE [sparx_bpm]
GO
/****** Object:  Trigger [dbo].[t_object_history]    Script Date: 09/06/2015 13:02:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[t_object_history]
ON [dbo].[t_object]
AFTER UPDATE
AS
DECLARE @i_Object_ID int
DECLARE @i_ModifiedDate datetime
DECLARE @d_ModifiedDate datetime
SELECT @i_Object_ID = [Object_ID], @i_ModifiedDate = [ModifiedDate] FROM inserted
SELECT @d_ModifiedDate = [ModifiedDate] FROM deleted;
IF @i_ModifiedDate != @d_ModifiedDate
BEGIN
INSERT INTO th_object
( [Object_ID]
, [Object_Type]
, [Diagram_ID]
, [Name]
, [Alias]
, [Author]
, [Version]
, [Note]
, [Package_ID]
, [Stereotype]
, [NType]
, [Complexity]
, [Effort]
, [Style]
, [Backcolor]
, [BorderStyle]
, [BorderWidth]
, [Fontcolor]
, [Bordercolor]
, [CreatedDate]
, [ModifiedDate]
, [Status]
, [Abstract]
, [Tagged]
, [PDATA1]
, [PDATA2]
, [PDATA3]
, [PDATA4]
, [PDATA5]
, [Concurrency]
, [Visibility]
, [Persistence]
, [Cardinality]
, [GenType]
, [GenFile]
, [Header1]
, [Header2]
, [Phase]
, [Scope]
, [GenOption]
, [GenLinks]
, [Classifier]
, [ea_guid]
, [ParentID]
, [RunState]
, [Classifier_guid]
, [TPos]
, [IsRoot]
, [IsLeaf]
, [IsSpec]
, [IsActive]
, [StateFlags]
, [PackageFlags]
, [Multiplicity]
, [StyleEx]
, [EventFlags]
, [ActionFlags]
, [User_Id]
, [Change_Date]
)
SELECT t_object.[Object_ID]
, t_object.[Object_Type]
, t_object.[Diagram_ID]
, t_object.[Name]
, t_object.[Alias]
, t_object.[Author]
, t_object.[Version]
, t_object.[Note]
, t_object.[Package_ID]
, t_object.[Stereotype]
, t_object.[NType]
, t_object.[Complexity]
, t_object.[Effort]
, t_object.[Style]
, t_object.[Backcolor]
, t_object.[BorderStyle]
, t_object.[BorderWidth]
, t_object.[Fontcolor]
, t_object.[Bordercolor]
, t_object.[CreatedDate]
, t_object.[ModifiedDate]
, t_object.[Status]
, t_object.[Abstract]
, t_object.[Tagged]
, t_object.[PDATA1]
, t_object.[PDATA2]
, t_object.[PDATA3]
, t_object.[PDATA4]
, t_object.[PDATA5]
, t_object.[Concurrency]
, t_object.[Visibility]
, t_object.[Persistence]
, t_object.[Cardinality]
, t_object.[GenType]
, t_object.[GenFile]
, t_object.[Header1]
, t_object.[Header2]
, t_object.[Phase]
, t_object.[Scope]
, t_object.[GenOption]
, t_object.[GenLinks]
, t_object.[Classifier]
, t_object.[ea_guid]
, t_object.[ParentID]
, t_object.[RunState]
, t_object.[Classifier_guid]
, t_object.[TPos]
, t_object.[IsRoot]
, t_object.[IsLeaf]
, t_object.[IsSpec]
, t_object.[IsActive]
, t_object.[StateFlags]
, t_object.[PackageFlags]
, t_object.[Multiplicity]
, t_object.[StyleEx]
, t_object.[EventFlags]
, t_object.[ActionFlags]
, SYSTEM_USER
, SYSDATETIME()
FROM t_object
WHERE t_object.[Object_ID] = @i_Object_ID
END


Then you can add SQL to charts in v12 that pull change history from th_object...

66
General Board / Re: User Tracking Statistics
« on: June 09, 2015, 02:15:26 am »
Hi,

We are doing this by putting an update trigger on t_object which writes to an audit table (t_object with an extra user_id and timestamp column) ... this way we can write custom SQL in our dashboards that tracks who has changed what and when...

67
General Board / Re: EA capabilities
« on: June 06, 2015, 01:40:07 am »
Hi,

Can't answer in Spanish. But simple answer is yes to all questions. Check out the "Resources" section on this site. There is a good Webinar / Video that describes BPMN capability in Sparx.

68
General Board / Re: Document generation
« on: April 29, 2015, 10:06:42 pm »
It does work. However there have been bugs reported against this in the past ... which version of Sparx are you using ? v8 / v9 had the bugs I think. If your using a later version ... delete the table and recreate ... it will only work if "Name", "Description" appear in cells on the first row...if there is a row above them it want work...

69
General Board / Re: Document generation
« on: April 29, 2015, 04:07:58 am »
Try selecting "name" and "description" cells and right click select Table -> Header Row....

70
General Board / Re: Labeling BPMN elements
« on: April 30, 2015, 11:17:01 pm »
Have you tried looking at Project -> settings -> Auto names and number - you can set it up for Activities for example against your Alias field, then under Tools->Options -> Diagram -> Behavior check Use Alias and Name. Then on your diagrams as required view the properties and select use Alias if available

71
General Board / Re: HTML Report and Navigation Tree
« on: April 25, 2015, 02:20:46 am »
No.

72
General Board / Re: Running Sparx on a server
« on: April 16, 2015, 08:09:12 pm »
Hi Olad,

I'd love to here how you get on with this; I tried following the advice that Geert points to but still hit issues. I suspect its down to our corporate build of windows server 2008 - security restrictions etc...the issue I hit occurs when I try to load a sparx repository that uses an ole connection to an SQL server instance (local access server is fine). My connection is using a fixed username/password for the sql server which works fine when I open the eap directly on win server, but fails when launched as an unattended service. My current nasty solution is to ensure that I'm always logged onto the win server....

73
General Board / Re: Does EA support DOORs Next Generation
« on: April 14, 2015, 01:52:59 am »
Hi,

V12 of Sparx includes limited support for OSLC, which DOORS also supports - so it would be an interesting test to see if they actually integrate using OSLC.

Regards,

Jon.

74
General Board / Re: Modeling a stepwise implementation
« on: March 23, 2015, 11:57:40 pm »
You could assign each step an ID. Then add the ID, to the keyword field of each element that is covered by a step. You can then use 'Diagram Filters' (see help) to show elements in scope for a specific step...


75
General Board / Re: Link Role to (organizational) function
« on: March 20, 2015, 04:52:16 am »
You could also consider creating a library of Participants to represent both Roles and "Organisational Functions" (although all in your post feel like roles to me but that's a different conversation). Relate them as required. Set their type to "Role".

Add Participants to the partitionElementRef of your Lane (tip blank the Lane name and it will default to the Participants name).

Regards,

Jon.

Pages: 1 ... 3 4 [5] 6 7 ... 31