Enterprise Architect version 15.2

download
purchase

enzh-CNcsnlfrdehiiditkoplptruskessv

My Profile

Social Media Channels

facebook  twitter  youtube   linkedin

Displaying items by tag: enterprise architect

Sunday, 17 January 2016 16:42

Script move/delete items from Search Result

Delete or move elements to package which are found by Searches (SQL, Query Builder, Standard Searches). These vbscripts allow you to easily handle found elements and to develop your own vbscripts to manipulate found things. In effect these scripts use bookmarked or elements copied to clipboard. It's an extension fo Geert Bellekens VBScripting Library.  

Abstract:

  • Use SQL Searches to move or delete found elements, diagrams or packages copied to Clipboard
  • Use Bookmarked elements from e.g. Standard / QueryBuilder Searches to move or delete elements
  • Handle bookmarked or result of SQL searches with your individual script

These scripts are using Geert Bellekens Script Framework (powerful!, Open Source)

  • See also there for updates, folder ho

 

Standard Search / Bookmark:

  • Set bookmarks
    • e.g. by Standard Search
  • If move: Select target package in ProjectBrowser 
  • Run Script:
    • hoModelSearch, DeleteBookmarkedItems or
    • hoProjectBrowser, MoveBookmarkedToSelectedPackage

 

Standard Search / Clipboard:

  • Run SQL Search 
    • each row shall contain GUID of the items to handle
  • Copy wanted rows to clipboard (eg: CTRL+A, CTRL+C)
  • If move: Select target package in ProjectBrowser 
  • Run Script:
    • hoModelSearch, DeleteClipmarkedItems or
    • hoProjectBrowser, MoveClipmarkedToSelectedPackage

 

In Action: Delete item found by SQL Search or Query Builder Search

  • Run SQL Search with element GUID as result / Run Query Builder Search
  • Copy to Clipboard (SQL Search / Bookmark (Query Builder Search)
  • Run Delete ClipboardedItems /  Delete BookmarkedItems

Delete clipboarded items from a SQL search

 

Move items found by SQL Search to package

  • Copy found elements to Clipboard
  • Select Package, Right Click, Scripts,...

 

Move bookmarked items
(
bookmarked in eg. Diagram or found by Standard Search / Query Builder Search) to selected package)

 

  • Run Standard Search or Query Builder Search
  • Bookmark wanted elements
  • Select Package, Right Click, Scripts,...
  • It works 

Install

  • Project DataManagement, Import ReferenceData, Select File (Script.xml)
  • Select 'Automation Scripts'
  • Import
  • See the scripts for details:
    • ho (reusable groups to extend functionality according to your needs)
    • hoModelSearch Group of type ModelSearch
      • DeleteBookmarkedItems
      • DeleteClipboardedItems
    • hoProjectBrowser Group of type ProjectBrowser
      • DeleteBookmarkedItems
      • DeleteClipboardedItems

 

Bookmarks (see also EA help):

  • Search Window: Query Builder Results,  Right Click, Bookmark Element,
  • Diagram: Select elements, Shift + Space
  • Diagram: Select elements, Edit, Bookmark selected,
Published in Community Resources
Tuesday, 22 December 2015 03:15

Sparx Systems has an Updated Forum

The Sparx Systems forum has undergone a much-requested update, giving it a fresh appearance and improved indexing - making it easier and faster to connect with relevant information and knowledge than ever before.

new forum screenshot

Since way back when in 2001 and Enterprise Architect version 3, the Sparx Systems Forum has performed an integral service, bringing together most enquiring and resourceful members of the user community. Since that time the forum has grown to include over 115,000 posts, covering a plethora of topics including methodologies and add-ins to usage issues and feature requests.

We encourage you to visit the forum and let us know what you think.

Published in News
Thursday, 17 December 2015 01:11

Enterprise Architect Rated #1 by IT Central Station

Sparx Systems Enterprise Architect has been ranked #1 by the user community at IT Central Station - the dynamic community site providing unbiased user based critiques  and comparisons of software products.

 

it central station ranks sparx systems number 1Enterprise Architect has been identified as a 'stand-out' solution in the areas of Architecture Management and also Business Process Design; registered members of IT Central Station can download a free detailed report.

 

The highly positive result is based on a number of factors, including the rating reviewers have given to products, as well as the number of reviews and interest displayed by visiting members.

 

IT Central Station is an online 'Community Built on Trust' with a strong focus on enterprise professional members being 'validated' and a 'zero-tolerance' for fake reviews; community managers actively monitor the site to ensure credibility of the brand.

 

We would like to take the opportunity to thank our User Community for their feedback and ongoing interest in Enterprise Architect.  

Published in News

Prominent Business/IT publication CIO Review Magazine has identified Sparx Systems as one of the '20 Most Promising Productivity Tools Solution Providers' for 2015.

cio review productivity tools logo nov 2015 sparx systems

Published in the November issue of CIO Review, Editor-in-Chief Pradeep Shankar described Sparx Systems as "A vendor of a productivity platform for the planning, design, and construction of software intensive systems based on the Unified Modeling Language (UML)."

 

The selection committee of prominent CEO's, CIO's and analysts, including the CIO Review's editorial board was responsible for deciding the final list from hundreds of potential solution providers. The selection process involved evaluating potential vendor's ability 'to fulfill the need for cost-effective and flexible solutions that add value to the Productivity Tools landscape.

 

Sparx Systems Founder and CEO, Geoffrey Sparks, spoke candidly with CIO Review, "As a tool vendor we are focused on on providing high precision modeling tools that match the needs of consultants, trainers, and industry in general..."

 

Read the full inteview, 'Agile Modeling Patform for Seamless Enterprise Operations', by clicking on the link above (450Kb PDF download).

 

 

 

 

Published in News

AI logoSparx Systems Founder and CEO, Geoffery Sparks, spoke with Acquisition International Magazine last month about the Sparx Systems business model, the early days and the power of the Sparx Systems Global Partners Network.

 

Geoff was featured in the magazine's CEO of the Month section and offered a unique insight into how Sparx Systems began, first releasing Enterprise Architect in 2000.  With 15 years of continious development and growth, the Enterprise Architect platform has a strong feature set "... that would be expected in an industrial strength modelling solution, in a single, highly functional, low cost package." stated Geoff.

 

The company founder also highlighted the importance of the Global Network Partners to the growth of Sparx Systems. "We have reached out to experts in reselling, training and consultancy services and created a global partner network to support client companies."

 

Read Geoff's full interview with Acquisition International Magazine on ISSUU here

Published in News
Friday, 27 November 2015 04:20

Reader's Choice Award for Enterprise Architect

2015vsm RCA medal bronze 200x263Enterprise Architect has recently been given the Bronze award in the Visual Studio Magazine 2015 Reader's Choice Awards.

The Sparx Systems design and build platform was recognised as an outstanding solution in the 'Software Design, Frameworks, and Modeling Tools' category.

In a recent Press Release (attached), Editor in Chief of Visual Studio Magazine stated that "The Visual Studio Magazine Reader’s Choice Awards offers a chance for readers to participate in giving public praise to those companies deserving of the recognition.”

More than 400 products across 31 categories were included in an online ballot run by Visual Studio Magazine, with hundreds of magazine subscribers responding over a 3 week period in late September.

Published in News
Find Real Orphans

Enterprise Architect comes standard with an Find Orphans search, which is supposed to give you a list of all elements that are no longer used in the model, and thus better be removed from the model altogether.

Find Orphans

The problem with this search is that it will only report elements that are not shown on a diagram; which should not be the only criterion to determine if an element is an orphan or not. Not being on a diagram is just fine. I have lots of elements in my model that are not on a diagram, that doesn’t mean they are not used anymore.

If you are going to delete all elements reported in the standard orphans search you might do serious damage to your model.

So in order to aid with the maintenance of a large model I wrote the following SQL Search.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
select distinct o.ea_guid as CLASSGUID,o.Object_Type as CLASSTYPE,o.Name as Name, o.Stereotype,
package.name as PackageName ,package_p1.name as PackageLevel1,package_p2.name as PackageLevel2 ,package_p3.name as PackageLevel3
from ((((((((((((((((( t_object o
left join t_diagramobjects dob on dob.[Object_ID] = o.[Object_ID])
left join t_object inst on inst.[Classifier] = o.[Object_ID])
left join t_objectproperties otv on otv.VALUE = o.[ea_guid])
left join t_connectortag ctv on ctv.VALUE = o.[ea_guid])
left join t_attributetag atv on atv.VALUE = o.[ea_guid])
left join t_operationtag optv on optv.VALUE = o.[ea_guid])
left join t_object u on u.Pdata1 = o.ea_guid)
left join t_connector cs on cs.Start_Object_ID = o.Object_ID)
left join t_connector ce on ce.End_Object_ID = o.Object_ID)
left join t_attribute att on att.Classifier like o.Object_ID)
left join t_operation op on op.Classifier like o.Object_ID)
left join t_operationparams opp on opp.Classifier like o.Object_ID)
left join t_object owned on owned.ParentID = o.Object_ID)
inner join t_package package on o.package_id = package.package_id)
left join t_package package_p1 on package_p1.package_id = package.parent_id)
left join t_package package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package package_p3 on package_p3.package_id = package_p2.parent_id)
where
o.Package_ID in (#Branch#)
and (o.name is null or o.Name like '#WC#<Search Term>#WC#')
and o.Object_Type not in ('Package')
and (o.Stereotype is null or o.Stereotype not in ('model document'))
and dob.Object_ID is null
and inst.Object_ID is null
and otv.VALUE is null
and ctv.Value is null
and atv.Value is null
and optv.Value is null
and u.Object_ID is null
and cs.Start_Object_ID is null
and ce.End_Object_ID is null
and att.Classifier is null
and op.Classifier is null
and opp.Classifier is null
and owned.Object_ID is null

This search will look for all elements that

  • Are located in the currently selected package branch
  • Are not a package or a model document  (section in a virtual document)
  • Are not used on a diagram
  • Are not used as the Classifier of an instance
  • Are not referenced by any tagged value
  • Are not used as the source or target of any relation
  • Are not used as the type of an attribute
  • Are not used as the return type of an operation
  • Are not used as the type of a parameter
  • Do not own any other elements

Elements that show up in this search are most probably real orphans that clutter your model and can be safely deleted.

Of course, before you delete anything from the model, make sure you have a backup!

Find Real OrphansIn order to use this search create a new search of type SQL and paste the above query into the query builder field.

If you find anything that should be added to this search please let me know.

Related

Published in Community Resources

Dunstan Thomas Consulting - Sparx Systems Authorised Training PartnerNew training course from Dunstan Thomas Consulting

Course design by Phil Chudley

Who Should Attend?

This course is suitable to anyone who models ArcGIS Geodatabases and wishes to create both a visual representation of the ArcGIS Geodatabase and an XML ArcGIS workspace file for input to other tools such as ArcCatalog.

What will I learn?

Upon completion of the course you will have learned the following:

  • How Sparx Systems Enterprise Architect supports ArcGIS Geodatabase Modelling
  • How to configure Sparx Systems Enterprise Architect for ArcGIS Geodatabase Modelling
  • How to structure a model repository for efficient ArcGIS Geodatabase Modelling using libraries of re-usable elements
  • The practical skills of creating and maintaining ArcGIS Geodatabase Modelling via a worked example
  • Productivity tips and tricks when using Sparx Systems Enterprise Architect
  • How to validate an ArcGIS Geodatabase Model
  • How to import and export a ArcGIS Geodatabase Modelling via XML
  • How to import a ArcGIS Geodatabase Model created in Sparx Systems Enterprise Architect into ArcCatalog

Course Content

  • Overview of Enterprise Architect and its support for ArcGIS Geodatabase Modelling
    • Practical – Configuring Enterprise Architect for ArcGIS Geodatabase modelling
  • Development of an example:
    • Design;
    • Practical use of Enterprise Architect to create an ArcGIS Geodatabase model
    • Productivity Aids when use Enterprise Architect
    • Capturing ArcGIS data within Enterprise Architect using ArcGIS tagged values
    • Dealing with relationships
  • Validation
    • Validating the model using the ArcGIS validation script
  • Implementation
    • Exporting the model to ArcGIS Workspace XML
    • Importing to the ArcGIS workspace XML to ArcCatlaog

Pre-requisites

It is assumed that all attendees for this course will be familiar with the ArcGIS Geodatabase Meta-Model. Previous knowledge of Sparx Systems Enterprise Architect is desirable but not essential.

If you would like to know more about our training & consulting services then please visit our website or This email address is being protected from spambots. You need JavaScript enabled to view it..

Published in News

As part of an EA add'in implementation, I had to import all Enterprise Architect table and column names in enumeration classes.

Having access to a database that stores a Sparx Systems Enterprise Architect project (e.g. MySQL, SQL Server, or even an EAP file via ODBC), there was a number of ways to populate enumeration classes with literal values using a small application in C# or another programming language. As Enterprise Architect 12 includes the Database Builder, an integrated tool to work on DB schemas, I took the opportunity to use it. Compared with the result of a C# application, this feature would let me capture the enumeration classes in my EA modelling project in addition to generating C# enumeration classes in my add'in solution.

This article only covers a small portion of Sparx EA Database Builder features: it illustrates how I managed to import Enterprise Architect table names as literal values in the EADBTableType enumeration class, and their column names as literal values in separate enumeration classes e.g. t_diagramColumnType, t_objectColumnType...

Import all tables in Enterprise Architect

- Open the menu Tools > Database Builder

- Right click and select New Data Model:

- Select the DBMS used, e.g. MySQL and confirm Ok

- Right click on MySQL > Load

- Right click on Connections > Add new DB connection

- Open the new DB connection and select ODBC based datatype

- Select an existing ODBC DSN (or create one) to the DB that stores the Enterprise Architect project where the schema needs to be imported

- Right click on MySQL > Import DB Schema from ODBC

- Click on Import and select all tables:

- All tables, columns, primary keys, foreign keys, indexes, etc. have been imported.

- Go back to the Database builder and open the Tables tabs: all tables are displayed. Selecting one of the tables provides access to all columns' details.

Generate the enumeration classes

The Database Builder let me achieved what I needed. Having all tables and columns stored in a single package, I wrote a simple script to perform the following:

- create an enumeration class named EADBTableType

- for each table:

    - create a literal value with the table name in EADBTableType e.g. t_object

    - create an enumeration class named after the table based on the following format: <table name>ColumnType e.g. t_attributeColumnType

    - for each column in the table:

       - create a literal value with the column name in the current table's enumeration class (e.g. Classifier in t_attributeColumnType)

Having executed this script, the following enumeration classes have been generated:

Transform enumeration classes to dotNet C# classes

The MDA model transformation can be used to generate C# enumeration classes for the above enums:

- Right click on the package that contains all enums > Advanced > Transform Package

- Select C# as the target, select the package, and click on Do Transform

- Having all C# enumeration classes created, and making sure the namespace is correct (e.g. create packages myaddin.common.enums), the code can be generated: right click on package > Code Engineering > Generate Source Code.

- The generated code can be used in Visual Studio IDE:

Published in Tutorials

 

Hippo Software’s new ‘EA for GUI Design’ course teaches delegates how to capture end user requirements and create wireframe diagrams to design the layout of user interfaces, mobile apps or websites.

http://www.hippo-software.co.uk/pages/EAforGUIDesign.htm

Published in News
Page 9 of 17