Scripts should be easily executable from a batch file

[sharprajat]

Hi

Is it possible to invoke Sitecore Powershell from a batch file?

I tried
powershell.exe Install-UpdatePackage -Path "Package.zip" -UpgradeAction 1 -InstallMode 1 –Verbose

but it returned an error "The term 'Install-UpdatePackage' is not recognized as the name of a cmdlet.

This makes sense since it is trying to invoke Windows Powershell and the cmdlet is not available.

How do I then call a Sitecore Powershell cmdlet from a bacth file. Not sure if this is even possible.

Rajat

[AdamNaj]

The PSE functionality cannot currently be used directly like you requested, the commandlet is only available in the console ran directly within the Sitecore process.

There are a few options for remote script calls like calling the restful service:
http://hostname/Console/Services/PowerShellWebService.asmx
(this requires an earlier authentication and a valid session though)

or using the WSDL Service at the following URL:
http://hostname/Console/Services/RemoteAutomation.asmx
(We use this in some of our projects to initialize integration tests)

but those are not meant to be used this way and their execution from a PowerShell script can be somewhat complicated.

You might want to explore using PowerShell tunnel but that's also not trivial. http://archive.msdn.microsoft.com/PowerShellTunnel

We will be introducing a functionality for Windows PowerShell integration in one of the next releases so PSE for the purpose of using it in your build scripts.

[sharprajat]

Hi

Thanks for providing the links for WSDL and Restful service.

I tried using the ExecuteScript service in the WSDL.

Not sure what value should I pass in returnVariables field.

If I do not pass anything for returnVariables and click the Invoke button I get the following XML

If I pass a string say "output" and click the Invoke button I get the following XML

• output

  Rajat

Rajat Sharma | MCP .NET, MCTS MOSS 2007
Softbits Inc. | Director
Mobile: 647-928-7880
Email: softbits@yahoo.ca
Windows Live: bitshot@hotmail.com
Google: sharprajat@gmail.com
Skype name: sharprajat
LinkedIn Profile: http://ca.linkedin.com/pub/rajat-sharma/14/812/48b

Date: Tue, 27 Aug 2013 14:32:55 -0700
From: notifications@github.com
To: Console@noreply.github.com
CC: bitshot@hotmail.com
Subject: Re: [Console] Sitecore Powershell from a batch file (#80)

The PSE functionality cannot currently be used directly like you requested, the commandlet is only available in the console ran directly within the Sitecore process.

There are a few options for remote script calls like calling the restful service:

http://hostname/Console/Services/PowerShellWebService.asmx

(this requires an earlier authentication and a valid session though)

or using the WSDL Service at the following URL:

http://hostname/Console/Services/RemoteAutomation.asmx

(We use this in some of our projects to initialize integration tests)

but those are not meant to be used this way and their execution from a PowerShell script can be somewhat complicated.

You might want to explore using PowerShell tunnel but that's also not trivial. http://archive.msdn.microsoft.com/PowerShellTunnel

We will be introducing a functionality for Windows PowerShell integration in one of the next releases so PSE for the purpose of using it in your build scripts.

—
Reply to this email directly or view it on GitHub.

[AdamNaj]

The content of the value you provide in the script parameter gets executed in this case. but you can use an "Execute-Script" commandlet there to execute scripts defined in your Script library.

The returnVariables is a pipe separated list of variables that you want to get back (serialized).
try putting the following in the parameters:
script: $FirstChildOfContentItem = get-childitem master:\content\* | select Name -first 1
returnVariables: FirstChildOfContentItem|AppPath

will return something like:

<ArrayOfNameValue xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/">
  <NameValue>
    <Name>FirstChildOfContentItem</Name>
    <Value>@{Name=Home}</Value>
  </NameValue>
  <NameValue>
    <Name>AppPath</Name>
    <Value>
      C:\Projects\ZenGarden\Cognifide.SiteCore\Cognifide.SiteCore.Web\
    </Value>
  </NameValue>
</ArrayOfNameValue>

Where the first is just the value I gort from my script and the second item being a variable that PSE defines itself.

[AdamNaj]

Ok, this is implemented.
In version 2.3 you will be able to call script as follows:
http://myhost/Console/Services/RemoteScriptCall.aspx?scriptDB=master&script={48588DFC-6F5F-4B42-BA01-B13A93945336}&user=admin&password=b&itemDB=master&item={0DE95AE4-41AB-4D01-9EB0-67441B7C2450}
Parameters:
user - user name for which the script should be executed
password - password for the user name for which the script should be executed
scriptDB - database where script is located
script - script item path or ID (path can be given starting from sitecore root or relative to Script Library)
itemDB - _optional_ - database where item that you want your script to work on is located
script - _optional_ - path or ID of the item that you want your script to work on

The returned content is text that PowerShell would otherwise shown on the console in plain text.
Return codes:
200 - OK- If the script executed without errors.
424 - Method Failure - if script encountered any errors.