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
General Board / Re: Cloud Services questions
« on: July 29, 2015, 03:32:08 am »

Cloud service is available with engineering, corporate and ultimate editions I think for free... not sure about personal, desktop...

RAS is not a feature of the Cloud Service, you need to enable separately. Its useful for sharing as its name suggests reusable assets - i.e. libraries/taxonomies of elements. Its useful in my mind if you have a set of elements that you want to reuse across multiple models. If however you only have one model RAS is not going to help.

Document templates are stored in the repository, so if you have a shared DBMS repository - the templates will be available to all.

General Board / Re: Bind a text with a field in template of docume
« on: July 25, 2015, 01:06:19 am »
Create a fragment with custom sql that uses the #OBJECTID#. If the SQL returns no data the fragment body will not be included in your report.

General Board / Re: Bind a text with a field in template of docume
« on: July 24, 2015, 05:08:11 pm »
I believe you can use a fragment to achieve conditional inclusion of text and a field value.

General Board / Re: Search SQL Query - Composite Diagram
« on: July 23, 2015, 12:55:22 am »

The tables to look at are t_object, t_diagramobjects, t_diagram and t_connector.

All elements on a given t_diagram can be found by joining

t_diagram.diagram_id = t_diagramobjects.diagram_id
and t_object.object_id = t_diagramobjects.object_id

If a t_object has a composite its ntype = 8 and pdata1 is the t_diagram.diagram_id of the composite diagram.

t_connector.start_object_id and t_connector.end_object_id join to t_object.object_id

Hope that helps.

General Board / Re: About Generating FlowChart From Code File
« on: July 17, 2015, 05:51:35 pm »

Look at the guides on Importing Source code. Then look at the guides on generating sequence diagrams from a class model.

General Board / Re: BPMN2 Off Page Connector
« on: July 13, 2015, 08:04:13 pm »
Yes - set the eventDefinition tagged value to Link.

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

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

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 :-)).

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

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

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

USE [sparx_bpm]

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



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



Then create a trigger on t_object:

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

ALTER TRIGGER [dbo].[t_object_history]
ON [dbo].[t_object]
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
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]
FROM t_object
WHERE t_object.[Object_ID] = @i_Object_ID

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

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

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

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

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.

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

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

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

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