How to import composition relationship from excel into Cameo

I have a set of legacy which expresses a composition relationship between a high-level UAF Capability and a set of lower-level Capabilities which compose the higher-level one.

I've created an abstract example of the data that I want to import

High-Level CapabilityLower Level CapabilityLower Level Capability DescriptionOwned ByCapability Role NameIs Composite
Capability 1Capability aCapability alphaCapability 1ATRUE
Capability 1Capability bCapability bravoCapability 1BTRUE
Capability 2Capability aCapability alphaCapability 2ATRUE
Capability 2Capability cCapabiltiy charlieCapability 2CTRUE

Note, the last three columns are additions to the data I'm starting with to facilitate the import.

The import should result in five capabilities (1, 2, a, b, and c). Capability 1 should be composed of a and b, and Capability 2 should be composed of a and c.

I am using the file->import from->excel/csv method to pull the data into my UAF model.

Importing the Capabilities is not a problem, but I'm struggling with the composition relationship. I've tried importing the relationship as an "association" element or as a CapabilityRole. It seems that I need to do both, or that I'm missing a detail when I import the association.

Is there a better way to import this data into Cameo? Getting the settings right and importing the CapabilityRole and Association in separate steps seems difficult to get right.


Here are the details of my two relationship related import steps.

These are the settings that I have tried when importing the CapabilityRole
 

 

These are the settings I've used when importing the association

these steps result in the following model (Note, I manually added Capability 3 and Capability e to see how it should really be captured in the model)