Importing Relationships via Excel Import

[bcole]

Hello folks,

I'm trying to get the Excel Import (v18.5) to support importing Dependencies. I don't see any instructions on how to refer to elements so I tried making a mapping Diagram with the UML2 metamodel with attributes profile. I have a <<classMapping>> diagram where my <<fileSchema>> has two properties: Source and Target, both of type String [built-in UML Primitive]. I bound Source to the client metaproperty on Dependency and Target to the supplier metaproperty.

The Excel import will create three Dependencies (three entries in my test Excel sheet), but I get a corrupted model because client and supplier is not assigned by the importer. Is there a better way I should set up this map?

Thanks,

Bjorn

[supatp]

Hello Bjorn,

For your case, I'd recommend the CSV Import plugin. You may find it via Resource/plugin Manager under (no cost) section.

Here's the sample.
You may prepare the data like this:

csv01.png

The with CSV Import is under menu File> Import From> Import CSV...
You may specify the CSV file location and follow the wizard.

csv02.png

csv03.png

Best Regards,
Supat P.

[bcole]

Fair enough. I was checking out the differences between Excel and CSV Import and I think this gives a good indication. Thanks!