topic Re: Command servlet in 5.0.2 in Alfresco Archive

Command servlet in 5.0.2

matthewpatin — Tue, 17 Nov 2015 10:35:32 GMT

Hi all,I'm trying to use the command servlet to execute database scripts in Alfresco 5.0.2 like so:http://localhost:8080/alfresco/command/script/execute/workspace/SpacesStore/dcf5c20c-5bef-411c-95f0-5fcae72ea25bHowever, this functionality seems to have disappeared in Alfresco 5. The wiki doesn't see

Re: Command servlet in 5.0.2

mrogers — Tue, 17 Nov 2015 15:31:18 GMT

You can't. It was part of the old Alfresco Explorer interface which no longer exists.

Re: Command servlet in 5.0.2

matthewpatin — Wed, 18 Nov 2015 10:15:43 GMT

It makes sense that it's gone. The thing is, developing repository scripts without it is a nightmare. The only alternative I have for now is creating a fake folder that runs the script when I copy up a file.

Could you recommend an easier way to execute repository webscripts? Or is that as "agile" as possible?

Also, how open would development be to porting the servlet (or something similar) to Share? Was the functionality something that was consciously left out? Or was it just a side effect of abandoning the old client?

Thanks,
Matthew

Re: Command servlet in 5.0.2

henryh — Mon, 11 Jan 2016 18:59:16 GMT

Hi,

I found out the same thing at the hard way when our corporation updated from 4.0 to 5.0. Creating the scripts are PITA without the command to execute them from client.

-Henry

Re: Command servlet in 5.0.2

jservajean — Mon, 26 Mar 2018 13:00:54 GMT

use GitHub - share-extras/js-console: Administration Console component for Alfresco Share, that enables the execution of arb…

Re: Command servlet in 5.0.2

fmstasi — Mon, 18 Feb 2019 10:07:01 GMT

Since this is one of the first hits when searching for a solution to this problem, I'll add another answer.

I found the approach of building a generic content stream webscript (described in this post on ServerFault) very convenient. In Data Dictionary/Web Script Extensions create a folder for your webscript, e.g. under it/myorganization/jsrunner, and in this folder create a descriptor, e.g. jsrunner.get.desc.xml, with the following content:

<webscript kind="org.alfresco.repository.content.stream">
     <shortname>Run script</shortname>
     <description>Webscript to execute a repository script</description>
     <url>/jsrun</url>
     <format default="">extension</format>
     <family>myorganization</family>
     <authentication>user</authentication>
     <transaction>required</transaction> 
</webscript>

Then create jsrunner.get.js:

// in this example we write the log directly in Company Home, YMMV
var log_node = companyhome.childByNamePath('jsrunner.log') ; 
companyhome.removeNode(log_node) ; 
var log_node= companyhome.createNode('jsrunner.log', 'cm:content') ;
var log_text = '' ;  

// your code goes here, append to log_text some useful messages

log_node.content = log_text ; 
model.contentNode = log_node ;

You need to refresh the webscripts once (from /alfresco/s/index), then you can change the js code and execute it again with no need to refresh. I had no need to add parameters to the webscript, but that is also quite straightforward. I think this approach is more flexible than the old execute command servlet.