Blog Post

Import Glossary using EA MDG Office for Excel Importer

Glossary can be used to store a list of terms and their definitions. The terms can be grouped into any number of user defined categories such as business, technical, domain specific grouping such as medical, scientific, or aviation. The power of having the terms defined in the model is realized when modelers write description in model elements as these will be linked automatically to terms defined in the Project Glossary. For more details on glossary refer here.

The MDG Office for Excel Importer allows users to import contents from Excel workbooks into Enterprise Architect. This includes importing spreadsheet data as UML Elements, Connectors, Attributes and Operations and also as Glossaries.

To import glossary into EA from Excel Workbook:

  • Create new or open existing eap file.
  • Right click Extension -> Microsoft Office -> Profile Manager for Excel.
    • It will list all the predefined profiles and user defined profiles.
    • Select “Add New -> Object Profile”. ( refer below screen )

  • Create an Import profile with a sample Excel Workbook, which doesn’t contain the type information. ( refer the attached excel file )
  • The sample document doesn’t contain the Element Type Information; hence “My Data has Element Type Information” is unselected.
  • In Element Type – choose “Glossary” available under EA Features Group
  • In Stereotype – Glossary does not support any stereotype so just skip it.

  • In Property Mapping section map the information in Excel to EA metadata as mentioned in the below image

Glossary Mapings:

Map the exact excel columns to Glossary Term,Glossary Type,and Glossary Meaning by selecting the  “More Properties’ from EA Element Property combo box

Using this “Additional Properties” form, map each columns in excel to the specific EA property.

  • Review the Profile definitions and select ‘Create’, to create the Profile.

To Import Glossary Worksheet Into EA :

  • Choose Extension -> Microsoft Office -> Import Excel Document
  • Select the Excel Workbook and the respective Worksheet that needs to be imported and also the appropriate profile created for glossary import(defined in the previous section)

  • Add Diagram for Each package: Not Applicable for glossary import
  • Enable Synchronization: If enabled, Unique GUID values of the glossary are written in the back up document for later sync with Enterprise Architect. For Glossary, no GUID values are created, it only updated by its term field.
  • Configure Hierarchy: Not Applicable for glossary import
  • Select Preview, to preview the content to import.

  • Select Import,to start importing glossary into the selected EA Model.

Once the import is done

  • Go to PROJECT->Glossary,to see the imported terms for the project.It is Project Specific properties.

Down load the Sample Excel and Model eap file here.

Drop mail to info@sparxsystems.in for any assistance.

14 Comments

  1. Thanks for excellent information. What trips can you recommend in 2024? Astro tourism, eco diving, home swapping, train stations are the new food destinations,sports tourism, coolcationing, gig tripping, private group travel?

    Reply
  2. This can be annoying when your relationships are disrupted and her phone cannot be tracked. Now you can easily perform this activity with the help of a spy app. These monitoring applications are very effective and reliable and can determine whether your wife is cheating you.

    Reply
  3. Monitor phone from anywhere and see what’s happening on target phone. You will be able to monitor and store call logs, messages, social activities , images , videos, whatsapp and more. Real-time monitoring of phones, No technical knowledge is required, no root is required.

    Reply
  4. Special offer for baclofen: buy baclofen online only 0.66 per pill – https://nieuws.top010.nl/wp-content/uploads/cms/buy-baclofen-online/, get free AirMail shipping or free courier delivery and discount for all purchased! Two free pills (Viagra or Cialis or Levitra) available with every order.

    Reply
  5. antibiotics purchase in united states buy antibiotics online fast shipping purchase antibiotics without rx cheap antibiotics for uti prophylaxis ordering buy antibiotics online Los angeles (ca) buy antibiotics Usa online get bonus for every order antibiotics overnight free shipping online canadian pharmacy no prescription, antibiotics side effects antibiotics interaction purchase antibiotics cheap antibiotics on lin buy antibiotics no prior prescrition canadian pharmacy no prescription needed

    Reply
  6. overnight cheap antibiotics buy cheap antibiotics without script cheap antibiotics in the UK antibiotic online buy ordering antibiotics online without prescription antibiotics sale canada cvs online delivery Usa antibiotics for sale low prices, nextday fedeX; best antibiotics for chlamydia buy without dr approval buy antibiotics online canada antibiotics overnigh delivery order antibiotics overnight delivery no fees or hidden cost

    Reply
  7. order amoxicillin online overnight shipping purchase amoxicillin overnight where to buy amoxicillin in the us antibiotic price amoxicillin online cheap & quick buy cheap generic amoxicillin get bonus for every order buy amoxicillin quick delivery get best deals and discounts, buy antibiotics without prescription online side effects of to much amoxicillin amoxicillin buy online cheap buy amoxicillin in piedmont omline buy amoxicillin free shipping reliable supplier of medications

    Reply
  8. Your article helped me a lot, is there any more related content? Thanks!

    Reply
  9. Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.

    Reply
  10. Wow, superb blog layout! How long have you ever been blogging for?
    you made blogging look easy. The whole glance of your website is great,
    as well as the content! You can see similar here sklep internetowy

    Reply
  11. bookmarked!!, I really like your site! I saw similar here:
    Dobry sklep

    Reply
  12. Hey! Do you know if they make any plugins to help with SEO?

    I’m trying to get my blog to rank for some targeted keywords but
    I’m not seeing very good success. If you know of any please share.
    Cheers! You can read similar blog here: Najlepszy sklep

    Reply
  13. It’s very interesting! If you need help, look here: ARA Agency

    Reply
  14. Hello! Do you know if they make any plugins to assist
    with SEO? I’m trying to get my website to rank for
    some targeted keywords but I’m not seeing very good gains.
    If you know of any please share. Kudos! I saw similar article here:
    Backlink Portfolio

    Reply

Leave a Comment

*