Database export/import plugin

Started by Hervé, April 15, 2016, 14:37:31 PM

Previous topic - Next topic

Hervé

Wow, I'm very far from it, much more "manual". I definitely need to industrialise my process  :-[

Hervé

#61
Dear all,

After quite a long time I must admit, I'm happy to announce that the version 0.10 of my plugin is available on GitHub (https://github.com/archi-contribs/database-plugin).

Installation instructions and an embryonic wiki is available on GitHub.

What's new :

  • I now support the Neo4j database
  • The database plugin can now be configured directly in the Archi preferences
  • Several databases can be configured in the preferences
  • Possibility to choose to chich database to connect on the import/export windows
  • The preferences file has been moved int the same folder than all other Archi preferences files
  • As it is mostly used at the moment, the "standalone" import mode is now the default.
  • Code rewrite to improve relaibility
  • bugs resolution
  • the filter when selecting the model to import has been (temporarily) deactivated when connected to a Neo4j database

The plugin has been compiled and tested against the versions 3.3.1 and 3.3.2.

I will update the GitHub wiki in the coming days.

Please note that I updated a bit the datamodel. If you previously created the database, you may manually create the 4 new columns in the diagrammodelreference table. New people may safely use the database scripts provided on GitHub.

Please do not hesitate to drop me a line should you have any question or comment, found a bug or require a new functionality that is not already in my roadmap.

Best regards
Hervé

Phil Beauvoir

If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.

Hervé

Thanks Phil,

But I've been a bit too much enthusiastic and just corrected few things. The version 0.10b is available on GitHub (https://github.com/archi-contribs/database-plugin).

The key changes are :

  • Change the internal ID separator as the on that was used ('-') could be part of the Archi generated ID
  • Correct a bug where several models could not imported at the same time
  • Correct a bun in the delete model procedure
  • Check if a model has already been imported prior to import a model
  • Add a check to validate that the database has not been converted for Archi 4.0 yet

Best regards
Hervé

pbelkin

Hi Herve,

Thank you for your work.
I tried plugin to export data in russian to my_sql db with UTF8 charset.
Russian letters appears incorrectly as '????????'

Maybe you can add option to choose charset (as it done in csv export in archi) in future release?
It would be very helpful

Best regards

Hervé

Hi,

Thanks a lot for pointing me this bug.

I'll try to do some testing regarding UTF8 beacuse it should definitively work. At the same time I'll have a look to the CSV plugin to check how they've done.

Would you be able to provide me with a sample archimate file (only few elements are needed) that does not exports corretly to your database that I can check if my correction works ?

Best regards
Hervé

pbelkin

Hi,Hervé

I created simple model "Модель" with one application component with name "Пример текста на русском языке".

Best regards,
Pavel

Hervé

Thank you very much Pavel.

I'll have a look this weekend.

Best regards
Hervé


Hervé

Hi Pavel,

I exported your model and imported it back. I checked with PostGreSQL, MySQL (MariaDB) and SQLite databases.

In all cases, the data stored in the database was in Cyrillic and the imported model was still using Cyrillic characters.

Could you please check that your database is correctly configured to use UTF8 characters ?

Best regards
Hervé

pbelkin

Hi, Herve

Thank you for trying my model.
It was a problem with charset configuration on my db server.

Best regards,
Pavel

Hervé

Hi Pavel,

Good news as I thought I had another bug in my plugin. Please do not hesitate should you have other questions ...

A new version will be released in the coming days, including few bugs correction and this new release will be available for Archi 3 and Archi 4 for those who downloaded the source code and compiled it  :D

Best regards
Hervé

Hervé

Dear all,

I'm happy to announce that the version 0.11 of my plugin is available on GitHub (https://github.com/archi-contribs/database-plugin).

It is now available for Archi 3 and Archi 4.

The Archi 3 plugin is not able to import Archi 4 models, but the Archi 4 plugin is able to import Archi 3 models with the following caveats :

  • views viewpoint are reset to "none"
  • text position is set to default (top)
  • RealisationRelationship relations are converted to RealizationRelationship relations
  • SpecialisationRelationship relations are converted to SpecializationRelationship relations
  • UsebByRelationship relations are converted to AssociationRelationship relations

What's new in this release:

  • Several bug corrections (of course)
  • Several updates to the datamodel
  • Add the ability to import several models at the same time
  • Add coloured icons on tab items titles to summarise their status (in progress, success, error)

If you are using the plugin for the first time, I provided tables creation scripts on GitHub.
If you are already using the plugin, it is safer to configure a new database and import your .archimate files but if you prefer to upgrade you existing database to the new datamodel, please check the FAQ on the GitHub wiki : https://github.com/archi-contribs/database-plugin/wiki.

Of course, please do not hesitate to contact me should you have any question or comment.

Best regards
Hervé

Hervé

Dear all,

I'm happy to announce the version 0.12 of my database plugin which is available on GitHub (https://github.com/archi-contribs/database-plugin).

It is available for Archi 3 and Archi 4 for those who downloaded the sources of Archi and compiled it.

The key updates are :

  • Add missing column "diagrammodelid" to table "diagrammodelreference"
  • Complete rewriting of the source and target connections import procedure
  • Add missing column names in Neo4J requests
  • Rewrite of the NetO4 relationships export request to allow self relationships

I'm currently completing the wiki (https://github.com/archi-contribs/database-plugin/wiki) to provide some information about the plugin, please do not hesitate to read it and tell me if some information you require is missing.

As a reminder, to install the plugin, you just have to :

  • Download the JAR file to the plugins folder of Archi
  • Sart Archi (or restart it if it was already started)
  • Go to Archi preferences and configure your database(s)
, launch Archi and . It is as simple as that  ;D.

Best regards
Hervé

Hervé

By the way, JB or Phil,

Would you add a line about my plugin in the "Archi Extensions and Plugins" of the http://www.archimatetool.com/resources page ?

Thanks
Hervé

Phil Beauvoir

Quote from: Hervé on October 25, 2016, 10:31:34 AM
By the way, JB or Phil,

Would you add a line about my plugin in the "Archi Extensions and Plugins" of the http://www.archimatetool.com/resources page ?

Thanks
Hervé

Hi,

when I get back from The Open Group Paris meetings I will do this.

Phil
If you value and use Archi, please consider making a donation!
Ask your ArchiMate related questions to the ArchiMate Community's Discussion Board.