EA-matic cannot see scripts in EA cloud repo

[etaha]

Hello!
I have EA cloud repository and installed EA-Matic plugin, this plugin cann't see scripts that are created within EA repo model while it sees the same script when open EA local file repository.
is there a solution for this?
Thanks in advance.

[Arshad]

Hi etaha

EA User defined scripts are model based.So you need to create\import the scripts into your EA cloud repository once from your local repository.


HTH
Arshad

[etaha]

Thanks Arshad,
I have them created already in cloud repo, however, EA-Matic cannot see them. User that created the scripts is model admin and has full permissions (Edit Scripts, Execute Scripts).
Any idea on this?
Thanks,

[Geert Bellekens]

Hi Etaha,

I've actually never tested EA-Matic in a cloud environment before, but my expectation is that this is (or should be) completely transparent for an add-in.

Is this actually the same model you are accessing?
And when you connect using the cloud it doesn't work, and when connecting directly it does work?

Or is the local model a different format than the model access through the cloud?

EA-Matic uses an SQL Query to get the details of the scripts stored in the model, so a difference in database (or the way queries are treated) might make a difference here.

Geert

[etaha]

Hello Geert,
Thanks for your reply.
Actually, local model is different model than cloud model. I've just created it to test if EA-Matic can see the same scripts locally.
Cloud repo is using MySQL as DB and using UTF8 encoding and it has model security/https enabled. I'm using EA V13 client on windows 8.1 to connect to cloud repository using admin privileges on both windows and cloud repo.
One thought is that this might happen as encoding of scripts is UTF8 and EA-Matic search for "EA-Matic" string in the script code and as code files might be in different encoding then it might not see those scripts? or something else?
I have tested the following: I've copied the script to %programfiles%\Sparx Systems\EA\Scripts, and EA-Matic can see that script when connected to cloud repository, but this requires each member copy that script to their PC.
Thanks in Advance.

[Geert Bellekens]

Hi,

Seems like it is most likely due to the difference in database.
IIRC MySQL is case sensitive where MS Access is not. That might explain why the add-in can't find the scripts.

To be sure you should connect to the MySQL database directly

Geert

[etaha]

Thank you Geert,
 I will check it out and return back with the results.
Best Regards.

[etaha]

Connecting to MySql repo using Server Connection from EA client v13 instead of Cloud connection making EA-Matic able to see the scripts.
I cannot figure out what's the issue with cloud connection!
Any ideas?
Thanks

[etaha]

After some monitoring to MySql log, I can see this script when accessing EA-Matic plugin
select s.ScriptID, s.Notes, s.Script,ps.Script as SCRIPTGROUP, ps.Notes as GROUPNOTES from t_script s
                inner join t_script ps on s.ScriptAuthor = ps.ScriptName
              where s.Script like '*EA-Matic*'

I couldn't know where * came from, maybe EA cloud service decode the % with *?

[Geert Bellekens]

My add-in code will check the type of database and based upon that use the appropriate wildcard for SQL queries.

But in this case I think that the routine that determines the type of database is not working correctly in case of cloud connections.
see https://github.com/GeertBellekens/Enterprise-Architect-Add-in-Framework/blob/master/EAAddinFramework/EAWrappers/Model.cs line 905.

It might be time to rewrite it. IIRC there is now a property in EA.Repository I can use to determine the database type.

Geert

[etaha]

Thanks for pointing this out.
Another suggestion is to make "EA-Matic" including its wildcard as configured value. If Repository cannot provide such info.
Thank you for your great efforts and plugin.