Messages

1

Suggestions and Requests / Could Sparx Systems be more Agile in their delivery?

« on: March 14, 2018, 08:03:31 pm »

Hi,

One for the Sparx moderators - you have release the beta of v14 to get early customer feedback - that's great, hopefully some of the feedback will be taken on board - in order to make Sparx an even better product !

My question here is about WebEA - any chance you can setup a sandbox where we can use and feedback on early beta releases of WebEA ? I'm aware that there are a couple of new features in the upcoming release of WebEA. I'd like to test/view these and feedback. It strikes me that early customer feedback on features on a web platform, such as WebEA, is something Sparx should be driving for... just a thought :-).


Regards,

Jon.

2

Suggestions and Requests / WebEA view child diagrams

« on: March 08, 2018, 11:06:59 pm »

Hi,

We have raised an official feature request via my company; but wanted to post here as well to see if there is general support for a feature that I think is very much needed in WebEA.

We have a large process model in Sparx. Its hierarchical, in that users can click on a 'Sub-process' to see its child/composite diagram. Or they can until we move to WebEA - which we would very much like to as its a steps up from static html.

However in WebEA if you click on any element with a child diagram, you are taken to the elements property sheet, from which there is no way to navigate to the child diagram !

The ideal solution would be a pop-up context menu when you click on an element with a child diagram, from which you can either select the elements property page or the child diagram. Failing that a clearly visible link on the elements property page to the child diagram.

Regards,

Jon.

3

Automation Interface, Add-Ins and Tools / Re: API to add external document (word/pdf etc) to model ?

« on: February 23, 2018, 10:44:11 pm »

Hi,

Turns out it is possible - but only if you generate the doc as PDF (extension = ".pdf" below) due to encoding/zipping... this code did the trick for me..

p.RunReport thePackage.PackageGUID, "DB Diagram and Element Details (A3)", fname & extension
            
            Set theElement = thePackage.Elements.AddNew ("Baseline Approval Document [" & theDate & "]" & extension, "Artifact")
            theElement.LoadLinkedDocument (fname & extension)
            theElement.Update
            sql = "UPDATE t_object SET style = 'ExtDoc=1;' WHERE object_id = " & theElement.ElementID
            Repository.Execute (sql)
            
            sql = "UPDATE t_document SET DocName = '" & theElement.Name & "', ElementType = '" & extension & "', DocType = 'ExtDoc' " &_
               "WHERE ElementID = '" & theElement.ElementGUID & "' AND ElementType = 'ModelDocument'"
            Repository.Execute (sql)
            

Regards,

Jon.

4

Automation Interface, Add-Ins and Tools / Re: API to add external document (word/pdf etc) to model ?

« on: February 22, 2018, 12:51:12 am »

Ok, thanks both - I think I might be able to hack my way around it with EAElement.LoadLinkedDocument (string Filename) - assuming it does the zipping/encoding of the document into t_document.strcontent ...

Regards,

Jon.

5

Automation Interface, Add-Ins and Tools / API to add external document (word/pdf etc) to model ?

« on: February 20, 2018, 04:51:05 am »

Hi,

Anyone know if there is an API that can be used to add a document (as an artefact in t_object and corresponding extdoc entry in t_document) to a Sparx repository ? If there isn't' an API has anyone got a script that does this ?

Regards,

Jon.

6

Automation Interface, Add-Ins and Tools / Re: Open the Relationship Matrix via script

« on: January 17, 2018, 07:57:51 pm »

Hi,

What I'm really after is a way via a script. I think I remember sometime ago reading that there were some undocumented features that could be used to simulate a menu/ribbon click via script. I can't find the thread on the group however. Ring any bells with anyone ?

Regards,

Jon.

7

Automation Interface, Add-Ins and Tools / Open the Relationship Matrix via script

« on: January 12, 2018, 11:36:36 pm »

Hi,

Is there a way to open the Relationship Matrix via a script ? Ideally also set the 'profile' and/or source and targets ?

Regards,

Jon.

8

Automation Interface, Add-Ins and Tools / Re: Use cached diagram images in v13

« on: October 20, 2017, 02:27:00 am »

Hi,

As you have found its in t_document, it is in png format - however its zipped/compressed - so you need to unzip before you can save as png.

9

General Board / Re: BPMN Model folder structure

« on: October 19, 2017, 01:39:34 am »

Hi,

I think I'd qualify Simons advice. If you are creating a small (less than 10 diagrams) process mode,l then fine put everything in a single folder. If however you are documenting the processes for a medium to large business, you should think about using a Process Classification Framework (PCF) (see APQC for example) and creating a folder structure based on the PFC. I'd also recommend that you create a separate folder(s) for any elements that are reused across your model. Finally I'd recommend having a look at this webinar on the Sparx site:

http://www.sparxsystems.com/resources/webinar/partners/bpmn/bpmn-enhancements-cephas.html

Which gives a good overview on Sparx BPMN modelling.

10

Automation Interface, Add-Ins and Tools / Re: Element Usage list through API

« on: October 17, 2017, 03:08:54 am »

Hi,

Please see some vbscript I use with Repository.SQLQuery below (so I'm not using JavaScript):

set dom = CreateObject ("MSXML2.DOMDocument")

xml = Repository.SQLQuery (sql)
dom.setProperty "SelectionLanguage", "XPath"   
dom.loadXML (xml)

for each node In dom.SelectNodes ("//Row")
      pid = node.selectSingleNode("./pid").Text
      did = node.selectSingleNode("./did").Text
                 ...
NEXT

11

Automation Interface, Add-Ins and Tools / Clickable links in system output window

« on: September 20, 2017, 10:51:58 pm »

Hi,

I'm assuming this is possible - just not sure how. I want to include clickable links (hyperlinks) to model elements and diagrams in the text displayed in the Sparx system output window. Anyone have a VB script example of how to do this ? Any pointers to help/guides ?


Regards,


Jon.

12

Automation Interface, Add-Ins and Tools / Connector created date

« on: September 19, 2017, 03:19:35 am »

Hi,

Anyone aware of any secret db column holding the connector created date ? can't see it in t_connector. Can I get it at all or do I need to alter the table to include a created timestamp ?

Regards,

Jon.

13

Automation Interface, Add-Ins and Tools / Convert to local copy

« on: September 05, 2017, 07:57:53 pm »

Hi,

I can see a clone method on the Element Class. But I can't see the equivalent of the menu option Advanced -> Convert Linked Element to Local Copy in the API anywhere. Does the equivalent exist in the API ? Or do I clone the element and add (move) it to the required Package object ?

Regards,

Jon.

14

Automation Interface, Add-Ins and Tools / Re: Automatically show customer compartments...

« on: August 19, 2017, 02:10:38 am »

Hi,

Thanks; yes had to code something up in the end, see snippet of vscript for those that are interested below. You would need to replace the contents of the str variable with your own custom compartment names:

dim obj as EA.DiagramObject
dim elm as EA.Element
dim diagramObjects as EA.Collection
dim objRegEx
set objRegEx = CreateObject("VBScript.RegExp")
set diagramObjects = currentDiagram.DiagramObjects
style = currentDiagram.StyleEx
      
for each obj in diagramObjects
   set elm = Repository.GetElementByID (obj.ElementID)
         
   if elm.Stereotype = "Container" then
      uid = obj.InstanceGUID
      str = "OPTIONS_" & uid & "=CCOMP_Deliverables=1:CCOMP_Process=1:CCOMP_Measurement Points=1:CCOMP_Applications=1:CCOMP_Control Category=1;"
            
      if InStr (1, style, "OPTIONS_" & uid, 1) = 0 then
         style = str & style
      else
         objRegEx.Global = True
         objRegEx.Pattern = "OPTIONS_" & uid & ".+?;"
         style = objRegEx.Replace (style, str)
      end if
   end if
next
      
currentDiagram.StyleEx = style
currentDiagram.Update
Repository.ReloadDiagram (currentDiagram.DiagramID)
      

15

Automation Interface, Add-Ins and Tools / Automatically show customer compartments...

« on: August 11, 2017, 11:26:58 pm »

Hi,

Is there a way to automatically show custom compartments for a given stereotype? I've added a shapescript to a stereotype. It works and displays my compartments - but only if I select the Features & Properties -> Feature and Compartment Visibility and check the option to show my custom compartment. I'd like them to be shown by default somehow. My shapescript is below, it adds and compartment and shows the details of related Activities and Components...

shape RelatedElement
{

if(HasProperty("Element.Stereotype", "Activity"))
   {      
   SetCompartmentName("Process");
   AppendCompartmentText("#Connector.Name#   #TAG:taskType#: #Element.Name#");
   }   
   
      if(HasProperty("Element.Type", "Component"))
   {      
   SetCompartmentName("IT Systems");
   AppendCompartmentText("#Connector.Name#   #Element.Stereotype#: #Element.Name# - #Element.Alias#");   
   }         

   
   
   if(HasProperty("Element.Stereotype", "MeasurementPoint"))
   {      
   SetCompartmentName("Measurement Points");
   AppendCompartmentText("#Connector.Name#   #Element.Name#:  #Element.Alias#");
    }         
   
   if(HasProperty("Element.Stereotype", "ControlCategory"))
   {      
   SetCompartmentName("Control Category");
   AppendCompartmentText("#Connector.Name#   #Element.Name#");
    }
   
   
   if(HasProperty("Element.Stereotype", "DataObject"))
   {      
   SetCompartmentName("Deliverables");
   AppendCompartmentText("#Connector.Name#:  #Element.Name#");   
   }   
}