Run script from API

[Stefan Bolleininger]

Hi guys,

in order to make my Addin's more generic and adjustable by the model and project file i tried to source out some functions from the hardcoded addin into some scripts.

However, i need to call the script from the addin and get back the return value.

Is there any way or maybe a functionality which i don't know, to do that?

Best regards

Stefan

[Nizam Mohamed]

AFAIK it wasn't possible to invoke EA's scripting engine from an add-in,

But you can use something like ScriptControl (.NET) to run the script. As you may already know, you can retrieve the Script information from t_script table.

[Stefan Bolleininger]

Yes, but with the search query i can only get the content of the script, but not execute it.

I need to execute it and get its return value.

Regards

Stefan

[Nizam Mohamed]

Yes, but for that we've to use ScriptControl (or something like that) to execute the script.

(As 'tis not possible in EA to run the script)

ScriptControl help
http://social.msdn.microsoft.com/Forums/vstudio/en-US/179a5554-84c5-4f77-b358-76b73b563b82/how-to-use-microsoft-script-control-in-vbnet
http://msdn.microsoft.com/en-us/magazine/cc302278.aspx

[Stefan Bolleininger]

Quite interessting.

So it is possible to retrieve the script by sql and save it as "script.vbs" and then load it from the executable.

However, I need to run it on the model to retrieve the data of the selected package. Do you have some ideas for? In the conditions outside of the EA-api I'm very new.

Do you have a little code snippet which could show for example:
How can I load a script, which is inside the model which just retrieves the name of the currently selected package?

Maybe i can get closer to my answer :-)

Thank you

Stefan

[Nizam Mohamed]

Hi Stefan.
Firstly, to retrieve the name of the currently selected package, have you considered using the API call? Repository.GetTreeSelectedPackage? This should do the trick.
But if your scenario is such that you have to execute a script for more logic.
The below sniplet should give a rough idea of how it could be achieved.

Code: [Select]

Dim SC As New ScriptControl
SC.AddObject("Repository", Repository, True) ' Adding Repository Object to be used in the Script
SC.AddCode(SourceScript)
' Script retrieved from Repository.SQLQuery("SELECT * FROM t_script")
result = SC.Run(FuncName)
'FuncName is the method in the script that you would like to call

the corresponding script will be something like

Code: [Select]

Function FuncName()
      ' Repository object was set before invoking the script!
      ' Get the currently selected element in the tree to work on
      dim thePackage
      set thePackage = Repository.GetTreeSelectedPackage()
      
      if not thePackage is nothing then
            FuncName= thePackage.Name;
      end if
End Function

[Stefan Bolleininger]

Dear Nizam,

thanks for your script.

The above montioned code works great, except the sc.RUN-command needs additional objects.

For completeness:

Code: [Select]

               SC.AddCode(Repo.SQLquery(""));
                Object[] runobject = { };
                    result = SC.Run("FuncName", runobject);
                }
Best regards

Stefan

[MathiasK]

Hi, may i add a question to this topic:

Is the SQLQuery method the key for efficient navigation between the different levels and components of a model ? (started by a Addin).

Greetings Mathias

[qwerty]

Definitely it is the lowest level you can reach. So it is the fastest but the most likely to run into problems on EA version change (though that has happens almost never since V4 or so)

q.

[Andreas Morgenstern]

Hi,

I've just started working with EA and find this discussion really interesting, since this is exactly what I was looking for. But I'm a Little bit confused. Is the code from :

Dear Nizam,

thanks for your script.

The above montioned code works great, except the sc.RUN-command needs additional objects.

For completeness:

Code: [Select]

               SC.AddCode(Repo.SQLquery(""));
                Object[] runobject = { };
                    result = SC.Run("FuncName", runobject);
                }
Best regards

Stefan

used in your addin, i.e. is it a VBA addin ?
If yes, I'm trying to achieve the same in an addin implemented in C#. Does this also work?

Andreas
 

[Stefan Bolleininger]

Hi Andreas,

I used it in c#

Code: [Select]

               MSScriptControl.ScriptControl script = new ScriptControl();
                script.Language = "VBScript";
                script.AddObject("Repository", Repository);
            script.AddCode(SBO_enartalis.ENARTalis_main.delxml(Repository.SQLQuery("SELECT script from t_script WHERE Notes LIKE 'script_to_run'")));
                }
                Object[] runobject = {oguid, objecttype.ToString() };
                script.Run("Function_to_run", runobject);  
This works very well.

Currently I'm planning to create a little abstract for the call-for-paper for the EAUG in Munich this oktober. There are a few do's and dont's when working with scripts and the API.

Best regards

Stefan

[Andreas Morgenstern]

Hi,

thanks for your help. Now it is running. May I add another question?
Have you ever tried to Exchange data between the addin and the script (in both directions)?

Andreas

[Stefan Bolleininger]

Hi Andreas,

Yes, I Do :-) I'm using the API-script-combination for handling extended workflows with broadcast-events and the configuration within the project model

e.g.

Code in API

Code: [Select]

               MSScriptControl.ScriptControl script = new ScriptControl();
                script.Language = "VBScript";
                script.AddObject("Repository", Repo);
                   script.AddCode(SBO_enartalis.ENARTalis_main.delxml(Repo.SQLQuery("SELECT script from t_script WHERE Notes LIKE '*scripttorun*'")));
                
                Object[] runobject = { };
                    output = script.Run("funvalue", runobject);Output is the Return value from Script "scripttorun" and function "funvalue"

Code in Script:

Code: [Select]

Function funvalue()
funvalue = "Myreturnvalue"                                    
end Function
Best regards

Stefan

[Tehila1]

This may be off-topic:

If I run a script from an addin, I would like to import it programmatically  to each model.

How should the script be imported?
As xmi (by GetRepository.CustomCommand("Repository", "ImportRefData", XML); command)
or by another way?

Thanks.

[qwerty]

You could fiddle around with the t_scripts table. But the way you suggested is likely the cleaner one.

q.