When using Archimate 5.3 some metadata is not saved during model export to DB and/or lost on import from DB

[bedundon2]

During testing, the following behaviors were observed:

The following were not Stored in DB during export and/or lost on Import from DB.

• Relationship Text Alignment
• Note Properties
• Group Properties
• Technology Element Properties
• Technology Element Documentation
• Strategy Element Documentation
• Label is lost on everything within all views except: Note (which retains its label).

Environment: Windows 64 Bit Installation, Archimate 5.3, Database Plugin 4.9.8, MS SQL Server 2022 Development.

This is an excellent plugin, but these items will keep us from making the plugin available to our EA team for use., as we are making extensive use of Properties and Labels in our models. I appreciate your efforts on this excellent plugin and for helping to correct these issues. Thank you!

[herve91]

Hi,
I'll do more testing on this and come to you asap

[bedundon2]

Thank you. I ran another test today and got different results, so it looks like I had some testing errors (my apologies). This time the only issue I see during an Export and Import cycle into a freshly initialized DB, was that the Label definitions on everything expect the Note, are lost on the views exported. The Properties and Documentation items were preserved during my latest test. I've attached my Archi file if that helps your efforts. Thanks again.
Import Test 2.zip

I'll run some more testing also on the update and refresh processes, which is where I first saw encountered the issues I reported.

[herve91]

Regarding your first post, I do not use (yet) version 5.3 at work, so I will do some double checks just in case.

Thanks for your test file, I will conduct tests on it and let you know asap as well.

[herve91]

By the way, could you please mote detailed instructions because I failed to reproduce your issue. What I did:

• load your model from the Archimate file you provided
• export your model to a fresh sqlite database
• close your model
• import the model from the sqlite database

All the labels are correctly imported back, including on the note ...

[bedundon2]

Sorry for the delay, here is my most recent testing results (in an XLSX file). Let me know if you need this in another format. I certainly appreciate your time and attention.
Archi DB Plugin Testing.xlsx

[herve91]

Thanks for these results. I'll have a look and let you know ASAP.

[bedundon2]

Good morning. Any progress in your investigation?

[herve91]

Sorry, not yet. I'm quite very busy at the moment.

[InceptusSolutions]

Hi Herve91,
Great work on this plugin.
Have you any plans to develop it any further?
Archi is up to version 5.6.0 now it must be difficult to keep it in line with the latest version.
Just wondering if you were planning to include the latest options such as line and fill opacity in view elements etc.

[herve91]

I'm sorry but the plugin require a lot of time to follow Archi versions and at the moment, I do not have enough free time to spend on the plugins development.

[InceptusSolutions]

OK Fair enough.
It's great the work you've managed to put in so far.
I think later versions have caused a couple of issues as well (I was getting an odd error message but I'll have to remember where).
If I get time perhaps I'll see if there's anything I can do.