Integration of Microsoft Office and Enterprise Architect
In this webinar you will learn how to:
The MDG Integration for Microsoft Office allows teams to seamlessly leverage the information authored in Microsoft Word & Excel documents within Enterprise Architect.
Upgrade your existing static documents into rich traceable models. Automatically map document sections and tables to corresponding element properties and tagged values in Enterprise Architect. Utilize your model directly within a PowerPoint presentation to ensure that your presentation remains up-to-date with your latest model changes.
Integration of Microsoft Office and Enterprise Architect
|We have provided the example Enterprise Architect model and associated Word, Excel and PowerPoint resources used in the webinar.|
|Example Model: bookstore-example.eap|
|Word Document: system-requirements-simple-table.docx|
|Word Document: requirements-with-connectors.docx|
|Excel Document: usecase-excel.xlsx|
|PowerPoint Document: srs-demo.pptx|
Questions from the AudienceClick on a question to see the answer.
What version of Enterprise Architect supports this integration?
Enterprise Architect 12 (Build 1212 and above).
What version of Enterprise Architect was used throughout the presentation?
Enterprise Architect 12, build 1215.
Is the MDG Integration for Microsoft Office included in the Ultimate Edition of Enterprise Architect?
What does the "MDG" acronym stand for?
MDG stands for Model Driven Generation.
Is this office import tool free?
No. The MDG Integration for Microsoft Office is not free. Please refer to the page below for pricing information:
Is Enterprise Architect 12 required to run the MDG Integration for Microsoft Office?
Yes. Enterprise Architect 12 (Build 1212 or higher)
Will the MDG Integration for Microsoft Office work with version 10 of Enterprise Architect?
No. Enterprise Architect 12 (Build 1212 or higher)
Which edition of Enterprise Architect has the office integration? It is not showing in my corporate edition.
For the Corporate Edition, The MDG Integration for Microsoft Office add-in must be purchased from Sparx Systems website.
We haven't upgraded to Enterprise Architect 12 yet. On what versions is this extension supported?
Enterprise Architect 12 (Build 1212 or higher). Please use the link below to purchase the latest version of Enterprise Architect:
We use Enterprise Architect version 12. It is the Ultimate Edition. I do not see the Office Integration option under 'Extensions'.
You need to install the “MDG Integration for Microsoft Office” using the link below:
Could you show where this add-in is available for download and how to install it?
The MDG Integration for Microsoft Office add-In can be downloaded from this page:
The page includes system requirements and installation instructions.
I have the Ultimate edition and the MDG Technologies dialog can be opened, but it doesn't show any Microsoft Office Suite Products. How do I make them appear?
If the “MDG Integration for Microsoft Office” was installed on your machine then the add-in will be shown under Extensions | Microsoft Office.
With regards to the importation of connectors, how many layers of associations can be used? (i.e. chains of requirements, Parent-child-etc.)
The current release just supports single layer of parent-child association, however, for supporting multi-layer parent-child relationships, you can map multiple columns as connectors and each valid entry in the columns will be converted into connectors.
Can you specify that you want the requirements to be imported as SysML 1.3 requirements?
SysML requirements can be imported by mapping the data in Excel or Word to Requirements, setting the stereotype as ‘SysML1.3::requirement’. You can also map id and text tagged values (to the ID and Description in the Excel or Word document)
Can the tool import custom tagged values?
Yes. Custom tagged values can be imported. Refer to the‘Tagged Values’ section in the Help.
Is Office 365 (2013) supported?
What version of MS Office is the minimum? What version of MS office does this integrate with?
All office products from Microsoft Office 2007 and above are currently supported.
Is there a way to export Enterprise Architect diagrams and use cases to Excel as a reverse process?
Using Excel exporter, you can export elements and element details including tagged values and diagram only objects.
Does the Enterprise Architect tab get installed in the Office Applications when you install the MDG Integration for Microsoft office add-in?
Yes. For 32 bit Office applications, install the MDG Integration for Microsoft Office installer from:
would enable Enterprise Architect Ribbon in the Office applications.
Will this work with earlier versions of Office? I am using a surface running windows 8. Where can I find how to make the profiles? Do you have Visio integration?
Office Integration supports Office 2007 and above. You can define profiles from Enterprise Architects’ ‘Extensions’ menu or from within the Word or Excel documents’ ‘Enterprise Architect’ ribbon.
Could you suggest how to create separate slides for each requirement in a package?
This is not possible at the moment, however this could be lodged as a feature request.
Where can the MDG Integration for Microsoft Office be downloaded?
The MDG Integration for office is available from the product page or registered download section. See the links below:
I don't see MS Office in the Extensions menu. How do I enable them?
The MDG Integration for Microsoft Office will only be visible if you have the MDG Add-In installed.The first step is to download the extension from the Sparx Systems website:
Once the product is installed, the Microsoft Office option will appear under the Extensions Menu.
I downloaded the plugin today, but the "ribbon" does not appear - I think this is down to my PC having a 64 bit version of office. Will there be a separate download for a 64bit office plugin?
For office 64 bit, an additional installer to enable Ribbons for 64 bit Office setup is under development.
Once you have imported from Word or Excel, are you able to import the same thing again to update what is in Enterprise Architect? Or, is it a one-time thing.
You can enable synchronization while importing from Word and Excel documents and re-import documents to update the contents in the Enterprise Architect model.
If you import requirements and make links (realization links) between them and model elements (like a class) what happens when you change the base word document and reimport?
If the import is done with ‘Synchronization’ enabled, the MDG Integration for Microsoft Office will update the changes , and create any new connectors if required ( however if any connector information is removed, it will not be deleted)
Can we convert Word, PP, or Excel to PDF successfully without losing the synchronized data, like a regular document? Is the MDG Integration for Microsoft Office not a part of the Universal Edition?
Converting documents to PDF is still possible, however the synchronization data may not be relevant as a PDF.
Does the add-on support sync with Enterprise Architect repository with users editing a Word document?
Yes, as long as the Word document is saved and available for the importer to read, it can import the document.
Is there a way to do the opposite - generate a document from the model with all the embedded links in Word, make changes in Word, and then re-import/re-synch into Enterprise Architect?
Enterprise Architect provides a comprehensive inbuilt documentation capability.
Working with MS Word, by inserting sections of model into document can be achieved by referring to the following link.The following webinar outlines document generation features in Enterprise Architect:
Is it possible to have built-in MS Word sections with the content of Enterprise Architect objects (name, notes, some attributes) in a list, separated by objects names as headers? Is this possible?
Yes, you have to map the headers as the respective Enterprise Architect Element and its associated metadata as its properties (either delimited values or inline tables). Refer to the BRD Document example from sample documents.
Visio and Sharepoint
The webinar looked at Word, Excel and Powerpoint. Is Visio Integration different from the import that has been around for a few years?
Visio integration allows users to import Visio diagrams into Enterprise Architect. Key diagrams such as BPMN and UML are converted to respective stereotypes in Enterprise Architect. The functionality is the same as the Visio Importer that was available previously, with some minor enhancements to improve mapping of stereotypes and properties.
Can you link to a file in SharePoint and use the Sync functionality?
SharePoint integration may be considered in a future release. However we cannot advise an indicative timeframe now.
Does this work with Enterprise Architect on Mac via Crossover? Does this also work for the Mac?
The MDG Integration for Microsoft Office add-in has not been tested on a Mac
I noticed that only standard UML connector types can be created. Will there be support for MDG Technology based connector types?
Yes, support for stereotypes during connector import is under development and will be available in upcoming builds.
Can you use track changes in Word and import them?
Not supported at the moment, but a feature request or suggestion would be helpful.