Book a Demo

Author Topic: Change Requirement Type via Excel Export->Change->Reimport  (Read 6855 times)

Pegasus

  • EA User
  • **
  • Posts: 38
  • Karma: +0/-0
    • View Profile
Change Requirement Type via Excel Export->Change->Reimport
« on: February 18, 2016, 05:57:48 pm »
Hallo,
I want to change the type of Requirement to a type, which has been defined in my own MDG Technology which uses SysML 1.4 and added tagged values(seperate tab in Properties-Dialog beside SysML1.4-tab).
Proceeding: 1. I export the Requierement via MDG Integr. for MS Office Excel-Exporter to excel File (with GUID). 2. Change the Stereotype to the desired "funktionaleAnforderung" 3. Reimport via MDG Integr. for MS Office (successful)
Result: A lot of Requirements changed type, but some Requirement elements doesn't changed (seen in diagram). In Projektbrowser i do see first the desired stereotype, but after selekting in projektbrowser it resets to origin requirement stereotype <<requirement>>. Exporting it again, shows the desired stereotype for all Requirements.

What happens...?  Using EA Version 12.1 (1225), some Requirements in foretime with EA 11 created
Thanks
Pegasus

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #1 on: February 18, 2016, 07:12:10 pm »
Ah, those pesky stereotypes  ::)

The problem is that steretoypes are stored in different ways in Enterprise Architect.
The "main" stereotype is stored in the element itself (t_object), but the others are stored in the reference table (t_xref)

There is probably a conflict between those two locations, resulting in strange behavior.

Since you are using the standard office integration I would report that as a bug to support.

Geert

Pegasus

  • EA User
  • **
  • Posts: 38
  • Karma: +0/-0
    • View Profile
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #2 on: February 19, 2016, 11:42:21 pm »
Hallo Geert

thanks for reply. I do an bug-notice to sparx systems. I also be afraid in having much more trouble. I now recognise that the Notes are changed.  I did export them too and now, after reimport I do have _x000D_ in all the elements. Does you have/anyone  an idear (setting at EA or Excel?). I use Jet3.5, but i'm not sure if this is essential?

Thanks

Pegasus

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #3 on: February 19, 2016, 11:55:39 pm »
Have you thought about building your own excel import/export?

That would at least allow you to fix the bugs yourselves.
If you want a head start you can use my Excel Importer

Geert

Pegasus

  • EA User
  • **
  • Posts: 38
  • Karma: +0/-0
    • View Profile
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #4 on: February 23, 2016, 06:41:11 pm »
Hello Geert,

I do find another solution to "repair" the Modell. I export the original notes with csv export and import them in the Modell wird the _x000D_ Notes using UTF('8') as code page. But this can only be a workaround. The Problem with the MDG Integration for MS Office is therby not resolved.

A Question to your importer. I find an anotation that the macro used for ElementAndAttribute Tab does work well only with class-Element? I need to apply on requirements (requirements defined in my own profile under inclusion of MDG SysML1.4)


Pegasus

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #5 on: February 23, 2016, 06:56:42 pm »
Hi,

I've used my importer with other things as well (such as requirements)
The only thing you might need to test is if the stereotype is correctly resolved to the stereotype in your profile.
You might need to do a synchronize to get all the tagged values.

Geert

Pegasus

  • EA User
  • **
  • Posts: 38
  • Karma: +0/-0
    • View Profile
Re: Change Requirement Type via Excel Export->Change->Reimport
« Reply #6 on: February 24, 2016, 06:22:53 pm »
Hallo
for the sake of completeness this task mentioned.
I do get the Information from Sparx, that the Problem with the _x000D_ ist solved and ist expected to be included in the next build. This should be EA 12.1 > Build 1228

Besides the Problem with the Type Change of the stereotyped Requirment is also idetified as BUG an will be fixed (expected in next build)
Pegasus