Addin with Tools for SPARX Enterprise Architect (EA)

• Helmut.Ortmann@hoModeler.de
• hoModeler.de

• Windows
• .NET 4.5.2 or greater
• EA 10.0 or greater
• Local administration rights for installation (register COM dll)

• No

• Port, Move, Label, Rotate,..

Collection of useful tools (see also Wiki):

• hoTools Assortment of tools
  • Toolbar for Searches, SQL, Services and Scripts
    • 5 Searches (EA or from SQL File)
    • 5 Services (Predefined hoTools Services, your beloved Script (VBScript, JavaScript, JScript))
  • Global Keys for Searches, SQL, Services and Scripts
    • e.g.: F1+Ctrl executes your beloved Search (EA, SQL-File)
    • e.g.: F1+Ctrl+Shft locks the selected Package
    • e.g.: F2+Ctrl+Shft runs your beloved Script (VBScript, JavaScript, JScript)
  • Set diagram Line Style
  • Version Control + SVN
  • Quick Search
    • Auto complete Search, Find Search + List all Searches
  • Port support
  • Favorites
  • Export SQL query results to Excel (hoTools, SQL, Script)
  • Clipboard CSV to Excel
  • Diagram Style/Theme
  • ..
• SQL with tabbed Windows
  • Select, Insert, Delete, Update
  • Export SQL query results to Excel
  • Templates
  • Macros (easy access to EA items / Packages or complete Branches, a lot more than EA delivers)
  • Easy handling of SQL errors
  • Conveyed Items
  • *.sql files in file system (you may use favorite Editor)
  • Find Search
• Script which runs for SQL results
  • All EA script languages (vbScript, JScript, JavaScript)
  • Compatible to Geert Bellekens great VBScript Library
  • Script can be called from Search Results, Key, Toolbar
• Find&Replace
  • Find simple string or Regular Expression
  • Name, Description, Stereotype, Tagged Value
  • in Packages, Elements, Diagrams, Attributes, Operations
• COM Server for SQL searches
• Configure
  • Buttons & Global Keys
  • Searches & Services & Scripts
  • GUI appearance
• Administration of EA
  • Version Control
• Intuitive GUI
• Wiki

• Tabbed Editor or use your own editor
• Macro replacement (ID, GUID, Branch, DiagramSelectObject, ConveyedItem,..)
• DB specific (#DB=ORACLE#,..)
• Comment your SQL
• Easy find SQL error
• Load / Save to file
• History / Last opened
• Easy cooperation with your beloved editor (try e.g. atom,..)
• etc.

• Run SQL and do something by script with the results

• C#
• ActiveX for Addin GUI
• BookMe for Online Help (powerful!)
• Configuration (*.xml)
• Installation via WIX
• Load MDG during startup
• Handling Keys
• Integrated Geert Bellekens VBScript Library
• Useful Searches
• Installable for different customers (brands)
• Visual Studio 2017
• Visual Studio Debug: Select "Enable native code debugging"

Inside code are many powerful features to Reverse Engineer C/C++ Code for e.g. SPICE or FuSi (Functional Safety). With the existing code and a little knowhow it's easy to develop SPICE or FuSi compatible Architecture and Design.

Some features:

• Generate Activity Diagram from code snippets

• Uninstall hoTools
• hoTools.msi (Setup\bin\Release\hoTools.msi)
• In EA: Extension, Addin Windows is selected
• In EA: Manage Addins, MDG: hoTools is selected
• hoToolsRemove.ps1 (deinstall with PowerShell)
• Make sure only one instance of hoTools is installed
• See also: Installation

• c:\Users\<user>\AppData\Local\Apps\hoTools\
  • The application installation folder
  • Sql.zip Examples SQL files
• c:\Users\<user>\AppData\Roaming\ho\hoTools\
  • Data folder
  • user.config Configuration

• Macros (quotedName,..)
• Fixes
• linq2db
• Package.cs tracked in GIT
• Wix --> 5.0.0

• new macro BranchConditional, etc.,

• Create HoTools_x.xx.x.zip with HoTools.msi. HoTools.readme, HoToolsX64.msi
  • Requires 7Z to add X64 msi to archieve

• macro ConnectorID/Conveyed Items.
  • SL3/SQLite
• Debug registration of 64Bit AddIn

• TakeOver check XML names (Xml.MakeXmlName), integrate in ToXml()
• SQL for Diagram
• SQL for selected Elements in Diagram and Tree

• X64-Files have naming with X64 to indentify them
• About with type of dll (x86/x64)
• Using Build-Events to collect registry information of the two COM-Object ...Root, ...Gui (collect folder isn't used anymore))
• error fixing

• Macros: Concat, ToString, Left, Right, ToLower, Substring, If, Instr (JET+MySQL)

• Searches in hoToolsBasic.xml adapted to SQLite (EA 16)
• Fix import Glossary
• Fix WildCard Handling of SQL, supporting ' and " for string constants
• Fix DB Handling (#DB=Other# EA 16)
• Some searches adapted to MySql
• Conveyed Elements also supports Sequence (Sequence Diagrams)
• Bug fixing

• See project: SetupX64 (WIX installation)
  • Procedure to create an X64 environment
    • VS: Create Configuration for x64
    • Copy existing x86 WIX Setup project to a new folder
      • *.WixProj: Change Project GUID to a new value
      • *.WixProj: Change Project Name to a new name
      • *.WixProj: Change EA Registry key Addin to EAAddins64
      • Change Install-Directory (e.g. xxx64)
      • Change Output-Name (e.g. xxx64.msi)
    • Build x64
    • Run new xxx64.msi

    Set autoscale to DPI. Avoid issues with scaling in running application

• Fix error in Bulk Element Change

• Fix *.msi package for all users to delete everything after deinstallation ( 1)
• Copy properties from last selected elements to the other selected elements
  • implements an update of Tagged Values by its used stereotypes.
  • you may select only one element: hoTools just synchronizes the TaggedValues of all stereotypes of the selected element

• Searches in Context Menu:
  • Quick Seach
  • Simple
  • Diagram
  • Modified Diagrams
• ASIL Level for ZF projects in Context Menu

Update libraries.

Bulk change Stereotype/Tagged Value: EA checks profile of qualified Stereotypes. A message is added if no change of stereotype is done.

Handle error loading Searches, MDG gracefully. Store settings should work also in case of errors.

• Service Move Copied Search elements of clipboard to selected package
• Update nuget packages
• AddInSimple 1.2 Example AddinSearch with SQL (Requirements with LIKE '')
• Migration to VS2019
• Nuget changed from Package to reference
• Nuget packages updated and simplified installation with a NugetCollectorProject

• Fix Style Properties without nothing to change is now possible
• Fix export SQL results to Excel
• Fix Find & Replace (TaggedValue with <memo> and from MDG & more)

• Standard searches to search for updated to release 14.
• Simplified GUI for generation Activities for Operation, workaround EA error for inherited operations

• Fixed error nested query
• linq2db 2.20 updated

• Group (Un)Lock for Package, Package Recursive and element

• NestedElements

• AddInSearch for NestedElements like Requirements for selected Package/Element or GUID in SearchText
  • New Service Search/Show NestedElements like Requirements for selected Package/Element or GUID in SearchText
    • New Service 'Search nested elements like requirements'
    • Show the nested requirements in Search windows with indentation
  • See also ReqIF for EA
• Show errors of Script engine
• fixing
• AddInSimple fixed

• New service "Copy ID of Package, Element, Diagram,.. to Clipboard"
• Minor bug fixing/improvements
• Improve speed of creating/updating Activities from operations.
• Exception adding note to diagram fixed
• Nuget packages updated

• Settings were't accessable fixed
• No Error message if Settings.Json doesn't contain configuration chapter for Styles, Bulk changes and more
  • Menu entry shows the information of missing configuration

• Bulk change of Elements
• Find search: Coloring of matching characters optimised
• Fix create Note linked to connector (Feature, Note)

• Service Copy Type, Name, GUID, Review to Clipboard (for e.g. review)
• Fix Find Search
• Generating Activcity from Operation with combined create/update

• Toolbar searches configurable to use <Search Term> from configuration or from GUI '<Search Term>' in configuration to use GUI <Search term>
• Service Copy Type, Name, GUID, Review to Clipboard (for e.g. review)

• Setup for per-user and per-user (Single Package authoring, per user without admin right)
• NoAdmin install to show a simple per-user without admin rights and without dialog
• Integrate SQLite
• Integrate access to VS Code C/C++ Symbol Database
• Minor fixes error handling

• Update Glossary via *.csv
• Update linq2db to 1.9

• Fix some minor errors
  • locate type
  • update Activity from operation)
• Change Fuzzy Algorithm to find Search (EA+SQL)
• Repository informations (Help, Show Repository Properties)
• About with path of dll's and settings'

• Fixing error with Deployment
  • hoTools (3.1.8) has to be installed manually

• Output Repository information
• Port handling optimised
  • Default port position 1+2
  • Round robin ports around parend classifier
  • Rotate Port Label
  • Cofigurable with settings.json

• WIX Setup names the *.msi file according to ProductVersion in Product.wxs
• MIT License
• Advanced error checking in EA_OnPostNewConnector

• Error CheckIn/CheckOut fixed
• VC Set *.xml file optimised
• Sort Diagram Elements alphabetic (also packages in Diagram)

• Fix errors Port, Pin, Parameter, Label Handling
• Move all usages of source element to target element Types, Diagram usage, generalization, ..

• Error fixing
• LINQPad output html supported

• LINQPad support error fixing
• LINQPad additional example queries (show LINPad connections)
• LINQPad find connection according to EA connection string

• AddInSimple (1.0.5):
  • Example EA context information for LINQPad
  • About with versions
• hoTools
  • LINQPad queries from hoTools
  • Send context information to LINQ
  • Error fixing

• About with product version and linq2db version
• Port Services added
• Fix copy Port
• Improved LINQ to SQL and LINQPad support
  • Run Query to html, csv, text
  • Output query results in EA Model Search
  • AddInSimple: Example run LINQPad and output html, csv, text and output results to EA Search Window

• LINQ for SQL integrated (JET, SQLSVR, MySQL tested, other DBs implemented but not tested) Project: hoLinqToSql
• AddinSimple 1.0.3 With query example implemented with LINQ for SQL, tested with: JET, SqlServer, MySQL

• AddInSimple: Add-In Search 'AddInSearchSamplePackageContent' corrected
• hoTools: Reorganisation ReplaceWildCard
• Fix: Feature, Notes, Constraint for Diagram, Element, Package, Connector, Attribute, Operation
• optimise SQL to Excel (Check if SQL-file is available)

• Error fixed: hoTools installer doesn't create AppDataFolder'
• Default setting Linestyle. Activity corrected to 'no'
• Error fixed: hoTools configuration isAutoCounter = false

• Service Copy FQ (Package, Element, Diagram, Attribut, Operation, Stereotypes) to ClipBoard
• AddInSimple V1.0.1 added (AddInSimple to show Add-In and how to use Add-In for Shape Scripts )

• Update Hyperlinks of Notes in Diagram, Package, Element, Attribute, Operation
• Service Copy GUID to Clipboard
• Item/Connector name to Clipboard
• Error configuration Toolbar services fixed

• Auto Numbering for Name/Alias for type/stereotype
  • Setting.json: Define format, object_types, stereotype, ..
  • Drag and Drop Diagram
  • New numbering according to createtedDate
  • Correct numbering according for formal incorrect Name/Alias
  • EA 13.0 Specification Manager don't calls EA_OnNewPostElememnt (known EA bug) Roundabout: Use Auto Number New of dialog in Menu Spec
• Fixing error with empty SQL <Search Term>

• Error fixing Find & Replace (Some buttons weren't visible')
• Code HyperScripting without/own get Model added (Example for own replacemenent of GetObject(,"EA.App"))

• Error fix Diagram selection handling (LineStyle and more)
• Error fix non recursive change for package
• Diagram Object + Link Style recursive
• Completeness Marker for Diagram objects (complete global, complete Diagram, incomplete Diagram)

• Bulk change Diagram Styles (Diagram, Diagram Objects, Diagram Links)

One Click and:

• Show hidden links

• Let them disappear

• Change Style of Diagram (recursive, conditional, ..)

• Change Style of Diagram Objects (Package, Elements,..., conditional)

• Change Style of Diagram Links (Package, Elements,..., conditional)

• Apply EA Layout Styles (Font, Colors, Linewidth, bold) for a bunch of Diagram Nodes or Links

• Amount of Buttons extended to 10

• Fix error context diagram (leads to an exception if current diagram and context diagram differ)

• Code refactoring

• Diagram Styles, configurable via 'Settings.json'

• Hybrid Scripting for *.exe (Using C#, Java,.. instead of VB Script & co), Example

• Hybrid Scripting for *.dll (Using C# dll,.. instead of VB Script & co), Example

• Service Added: Copy Name to Clipboard

• Service Added: Copy Name to Clipboard and search with "Quick Search" for item name

• Service Added: Diagram Style 1

• Service Added: Diagram Style 2

• Error fixing

• Remember: Services can be bound to Keys or Buttons

• hoTools inventaries loaded MDGs (hoBasicMDG,..)
• Fixing error in Searches (CLASSID->CLASSGUID)
• Linestyle TH (Tree Horizontal) was implemented as Lateral Horizontal)
• Sorting Features (Attributes, Operations)
• Link features to a Note
• Preparation inventories C# Extensions to use as Scripts
• Error in Diagram.class fixed (last selected element is the first in the collection)
• Default line style StateMachine 'no' (need to delete configuration, %APPDATA%ho\hoTools\user.config, change per configuration)
• Reset settings to default settings
• Error fixing

• External SQL Editor integration improved
• Link to help improved
• FindUsage (Error Message if search not existed (catch try block))
• Find Usage (o.CLASSIFIER_ID=>o.CLASSIFIER_GUID, o1.CLASSIFIER_ID=>o1.CLASSIFIER_GUID corrected)
• Missing try catch in Show Specification
• Script: Catch error set SplitterDistance (I can't reproduce but it will do no harm)
• Change Author optimised
• Fixed: Modale windows stuck behind main window

• Wrong installation file 2.1.2 corrected
• Attribute up and down
• Set and view package folder optimised

• synchronisation Part Ports with its Type, usually a Class/Block
  • 'Show Ports' also synchronises ports between a block and its properties/parts (add/delete)
  • synchronised is the following information
    • Name
    • Stereotype
    • Notes
• Search with Context Menu (Right Click)
  • Edit current hoTools SQL Search with Editor
  • Open the folder of current hoTools SQL Search
  • Run Search and export results to Excel (no Excel required)
  • Export Clipboard with csv data to Excel (no Excel required)
• SQL Context Menu contains
  • Edit current hoTools SQL Search with Editor
  • Open the folder of current hoTools SQL Search
• Fixed error in example Script hoDemoRunSQL (leads to error message during initialisation)
  • Delete Script 'hoDemoRunSQL' in EA ScriptWindow
  • Comment the last line by inserting a ' character at start of a line

• Error fixing hoModelView MDG
• Port,Parameter,Pin support increased (UML + SysML) (Structural Elements)
  • Button + Services show/hide Port,Parameter, Pin
  • Button + Services show/hide Port,Parameter, Pin Label
  • Button + Services show/hide Port

• Add Note, Constraint to Diagram, link to Node, Link, Diagram
• Example Model Views 'hoModelView' to view Diagrams in Model View
• SQL Searches of MDG, 'My Searches' are now inventoried.
• Searches were faulty (ea_id instead of ea_guid), fixed in hoToolsBasic.xml,..
• File error "d:\temp\sql\Branch.sql" fixed, cause unclear
• Jump between a composite diagram and owning diagram fixed (null value)
• Wiki updated

• SQL Query Results can be exported to Excel (no Excel required)
• Clipboard CSV content can be exported to Excel (no Excel required)
• User SQL Search definitions possible
• Reverse direction of edge (connector, dependency, association, information flow, SysML Item Flow)
• Unused references deleted (no functional implication)
• Implementation documentation added
• Search can't find Tagged Values in of Package

• Favourites (Show Favourites didn't work)
• SysML Locate Part for Sequence Call by name
• Add Load Scripts (if a Script is changed the user has to update the Script in hoTools before using it)
• Script Examples for JavaScript
• EAModel with Clipboard functions (for usage in Scripts)
• Default Line style all none (delete *.xml file required, or File, Settings,) It's possible that Activity Diagrams and Statechart have a default Line style You may want to change it by File, Settings, Default Line style

• Consolidate Tag of release (skip 2.0.8)
• Fix: Conveyed Items for Information Flow and Connector
• Fix: Opened tabbed were duplicated by opening another repository
• optimisation: Only one Button Conveyed Items (former two, function decides from selected element/connector/flow)
• optimisation: Only one Button Notes (former two, function decides from selected element/diagram what to do)
• Switch off annoying Tooltip in SQL window
• Search description adapted to EA 13

• Global Keys with possible start Script (VBScript, JavaScript, JScript)
• Toolbar with possible start Script (VBScript, JavaScript, JScript)
• Fix: Automatic line style: Line-style of a length of 1 leads to Exception
• Error fixed Script usage of hoTools as COM Object

• QuickSearch selection with autocomplete for available Searches
• SQL Searches (multiple folders are possible, file name should be unique)
• MDG
• Own Searches
• Standard Searches
• Determine Search
  • Autocomplete (.NET standard feature)
  • Find the part of the string after Up, Down, Blank Key
    • Double Click in find starts Search

• Search Management (for Quick Search)
  • Enable Category (Settings)
  • Favourites (configuration via JSON)
  • EA Standard Searches (configurable via JSON, my EA Standard Searches)

I appreciate your feedback!!

Helmut.Ortmann@t-online.de

Helmut.Ortmann@hoModeler.de