Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: diag on January 23, 2020, 07:47:01 pm

Title: Import value from excel to enumerate type
Post by: diag on January 23, 2020, 07:47:01 pm

Dear all,

We are importing an Excel file into a customised Stereotype with MGD Office Integration (EA v15). Customised Stereotype contains a Resolution property (tagged value) with is an enumeration type: {HR, MR, LR}.

We have an excel like this:

Sensor Name/Value
OPTA034 LR
OPTA035 MR
OPTA036 HR


We want to import the value column into the Customised Stereotype’s Resolution property (which is an enumerate) but it is imported as a string, not as an enumerate with a value.

Is any way to import it as enumerated value and not as string? Excel file can be re-formatted as needed.

Thanks in advance.

Title: Re: Import value from excel to enumerate type
Post by: Geert Bellekens on January 23, 2020, 07:52:03 pm

You can import tagged values with the newest version (5.0) of my excel importer.

I haven't published it yet, but you can already download it from my google drive:

https://drive.google.com/open?id=10h6ijv1jqwWi6RtEXEHwUTFAsihzSa0E (https://drive.google.com/open?id=10h6ijv1jqwWi6RtEXEHwUTFAsihzSa0E)

Geert

Title: Re: Import value from excel to enumerate type
Post by: diag on January 24, 2020, 07:48:32 pm

Thanks a lot,

Regards