Tuesday, 29 August 2023 09:27

BPMN Components on Excel & Enterprise Architect

Written by
Rate this item
(3 votes)

In the most recent release of MDG Office Integrations (v1.4.40), an exciting enhancement known as the "BPMN Visualizer" has been introduced, offering an excellent utility for BPMN users. This feature facilitates the seamless transfer of BPMN Components between Microsoft Excel documents and Sparx Enterprise Architect Models.

The key feature of 'BPMN Visualizer' in MDG Office Integration

  • Simplified Approach that eliminates the necessity for Profile Creation during import and export for mapping items. This drastically minimizes user time and the possibility of manual errors.
  • Through a single click of "Excel to EA" menu, users can quickly synchronize BPMN Components, seamlessly updating and aligning data between Excel and the Enterprise Architect model.
  • The visual representation of diagrams from the Enterprise Architect model, as well as the related preconfigured mapping table, can be displayed within Excel.
  • The capability to incorporate multiple diagrams is supported when a package is selected. This involves displaying all diagrams in the selected packages along with their corresponding predefined mapping tables on separate sheets.

BPMN Components on Microsoft Excel

MDG Integration for Microsoft Office provides seamless integration within Microsoft Excel (Version 2007 and above). A newly introduced feature named ‘BPMN Visualizer’ now resides in the ‘Feature’ dropdown of the Enterprise Architect ribbon in Excel. This feature facilitates the seamless transfer of ‘BPMN Components' between an Excel document and Enterprise Architect, allowing for bi-directional data exchange.

Excel_Enterprise_Architect_Ribbon.png

To import BPMN Components into Enterprise Architect from Excel

Excel FeatureDropdown

The Feature dropdown offers the following selection options:

‘Export to EA’: Export the elements to Enterprise Architect using Profiles

‘SysML Requirement Manager’: Import SysML requirements from Enterprise Architect and Export SysML requirements and their connectors to Enterprise Architect.

‘BPMN Visualizer’:  Import BPMN Components from Enterprise Architect and export BPMN Components to Enterprise Architect.
Open project icon in Excel

Allows one to select a *.eap or *.eapx or *.feap or *.qea or *.qeax or *.eadb through local project, server connection, or cloud connection.

Local Project: To connect the Local Enterprise Architect model.

Server Connection: To connect to an Enterprise Architect repository through a database

Cloud Connection: To connect to an Enterprise Architect repository through the Pro Cloud Server
Excel_Diagram_Selection_option Allows users to select a Package or BPMN Diagram to Load from the Enterprise Architect Model to Excel with the respective diagram image.

Select a package

  • This window will be displayed when the Package Icon is clicked.
  • It displays all the models and packages from the selected Enterprise Architect model, with BPMN Components being imported specifically.

Excel_BPMN_PackageSelection

Select a BPMN Diagram

  • This window will be displayed when the Diagram button is clicked.
  • It provides a hierarchical overview of all diagrams within the packages of the model. Users have the ability to choose a specific BPMN diagram from this view.

Excel_BPMN_Diagramselection.png

Note: The ‘Ok’ button will only enable when the selection type is BPMN Diagram

Utilizing Excel for BPMN Components

  • The selected diagram is imported to an Excel sheet along with its predefined mapping table.
  • The Excel sheets are named in the format of Diagram Name with Diagram ID.

Excel_BPMN_Intialpage.png

Excel column definition

Action ID The Unique ID of BPMN Elements. It’s used to map the connectors and parent.
Action Name Name of the BPMN Element
Action Type Type of the BPMN Element
Next Action ID Target BPMN Element to connect based on the Action ID.
Connector Name Name of the BPMN Connector
Connector Type Type of the BPMN Connector
Parent The parent of a selected BPMN Element based on the Action ID.

Creation of element from Excel to Enterprise Architect model

  • To create a new element, enter a name in the ‘Action Name’ column (mandatory).
  • By default, the ‘Action Type’ is ‘Activity’. Users can change the type using the drop-down list.
  • Mapping the parent element for the newly created element is also achievable using the ‘Parent’ column.

Excel_BPMN_Element_Creation

Note: Supported Element types are Activity, Gateway, StartEvent, IntermediateEvent, EndEvent, DataStore, DataObject, BusinessProcess, BPELProcess, GlobalTask, Pool, and Lane.

Establishing connectors for the newly created element in Excel

‘Next Action ID’ creates a connector between two BPMN elements. Choose the appropriate ‘Action ID’ in the checklist box of ‘Next Action ID’ to connect. By default, the connector type is ‘Sequence Flow’

Excel_BPMN_Connectorcreation

Note: Supported connector types are SequenceFlow, MessageFlow, Conversation Link, DataAssociation, and Association.

Excel to EA iconTo update the changes from the mapping table in Excel to the Enterprise Architect model utilize the ‘Excel to EA’ Icon available in the Excel Ribbon; The preview form is presented to the user to ensure that the intended changes are ready for export. Once you click the ‘Export’ button, synchronization is initiated between the Enterprise Architect Model and Excel, causing the changes to be updated in Excel as well.

Excel_BPMN_Preview

As depicted in the image below, you can observe that the recently generated ‘Process goods’ element has been incorporated into the Excel diagram. This element establishes a connection with the ‘Gateway5’ element, as indicated in the mapping table. Likewise, this synchronization is also reflected in the Enterprise Architect model.

Excel_BPMN_Element_and_Connector_Update

EA to Excel iconThe ‘EA to Excel’ icon enables users to revert the produced items back to their original state as Enterprise Architect Models, providing an opportunity to undo changes made in Excel. Additionally, it facilitates the synchronization of changes made from Enterprise Architect to Excel.

 

BPMN Components from Enterprise Architect to Microsoft Excel

Through the ‘BPMN to Excel’ menu, users can export data pertaining to BPMN Components, which have been accumulated within Enterprise Architect, into the Predefined mapping tables along with diagrams in separate sheets within Excel.

Enterprise_Architect_Ribbon

After selecting the package or BPMN Diagram, the Enterprise Architect will begin exporting data to an Excel sheet and proceed with Refer "Utilizing Excel for BPMN Components"

Check out the BPMN on Excel and Enterprise Architect video here

To know more or to request a demo, please reach out to This email address is being protected from spambots. You need JavaScript enabled to view it.

Read 882 times Last modified on Tuesday, 05 September 2023 05:00
Login to post comments