Importing Attributes using Microsoft Excel

[syortsos]

Hi,

I am trying to use an "out-of-the-box" method for creating attributes of elements using Excel and the Microsoft Office Add-In. However, when I try to import either 1) new attributes of an existing element, or 2) update attributes of an existing element, or 3) a new element with attributes, the import fails. In case 3, the import is able to create the parent element but is NOT able to create the parent element's attributes. Currently, my excel file captures the following information:

Name: of Parent Element and Attribute
Notes: of Parent Element and Attribute
Stereotype: of Parent Element and Attribute
ObjectType: of Parent Element and Attribute
Type: for Attribute_Type
ELEMENT NAME: for Attribute's Parent Element Name

Does anyone know why the import is failing to create the parent element's attributes? Can you not create element attributes using Microsoft Excel?

Thanks,
Stevie

[Richard Freggi]

Use Belleken's importer - it's free and 100 times better

[jcampos]

Hi! The best way to import information from Microsoft Excel is doing a CSV.

1. Build a CSV Specification selecting existing tags (Name, notes, GUID, type, stereotype, etc) and new tags (another atributes)
2. Export that empty CSV, paste the information from excel
3. Import the full CSV, that gonna create new elements with those charateristics.

Read this article for more information:
https://sparxsystems.com/enterprise_architect_user_guide/16.0/model_exchange/csvimportexport.html

[Geert Bellekens]

Unfortunately you can't import attributes using the CSV import/export.

That's the reason I wrote my own importer back in the day: https://bellekens.com/product/ea-excel-import-export/

Geert

[Tafros]

Hi @syortsos

I have tried importing the attributes using your given scenario. I used a similar mapping as below, Can you make sure these are done in your MDG Office Integration Excel Profile as well and try

Name: of Parent Element and Attribute - (EA Element Property)Name
Notes: of Parent Element and Attribute - (EA Element Property)Notes
Stereotype: of Parent Element and Attribute - (EA Element Property)Stereotype
ObjectType: of Parent Element and Attribute - (EA Element Property)Type
Type: for Attribute_Type - (EA Element Property)Attribute_Type
ELEMENT NAME: for Attribute's Parent Element Name - (EA Element Property)Classifier

Earlier whenever I faced any challenges I used to mail Sparx Systems Support and got responses that helped me move on. I think you can email them mailto:[email protected] for your queries...


Thanks