Author Topic: Import value from excel to enumerate type  (Read 2013 times)

diag

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Import value from excel to enumerate type
« 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.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13387
  • Karma: +566/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Import value from excel to enumerate type
« Reply #1 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

Geert

diag

  • EA Novice
  • *
  • Posts: 9
  • Karma: +0/-0
    • View Profile
Re: Import value from excel to enumerate type
« Reply #2 on: January 24, 2020, 07:48:32 pm »
Thanks a lot,

Regards