Add-ecsfiletrustedlocation: Stsadm operation (Office SharePoint Server)

  • Article

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

Operation name: Add-ecsfiletrustedlocation

Description

Lets an administrator to add a file to the trusted location list.

This operation is equivalent to the Location user interface setting that is located on the Excel Services Add Trusted File Location page of the SharePoint Shared Services Administration Web site.

Syntax

stsadm -o add-ecsfiletrustedlocation

**   -ssp <SSP name>**

**   -location {URL | UNC}**

**   -LocationType {SharePoint |UNC |HTTP}**

**   -IncludeChildren {True | False}**

**\[-SessionTimeout \<time in seconds\>\]**

**\[-ShortSessionTimeout \<time in seconds\>\]**

**\[-MaxRequestDuration \<time in seconds\>\]**

**\[-MaxWorkbookSize \<file size in MB\>\]**

**\[-MaxChartSize \<size in MB\>\]**

**\[-VolatileFunctionCacheLifetime \<time in seconds\>\]**

**\[-DefaultWorkbookCalcMode {File | Manual | Auto | AutoDataTables}\]**

**\[-AllowExternalData {None | Dcl | DclAndEmbedded}\]**

**\[-WarnOnDataRefresh {True | False}\]**

**\[-StopOpenOnRefreshFailure {True | False}\]**

**\[-PeriodicCacheLifetime \<time in seconds\>\]**

**\[-ManualCacheLifetime \<time in seconds\>\]**

**\[-MaxConcurrentRequestsPerSession \<number of requests\>\]**

**\[-AllowUdfs {True | False}\]**

**\[-Description \<descriptive text\>\]**

Parameters

Parameter

Value

Required?

Description

ssp

A valid SSP name such as "SharedServices1"

Yes

The name of the SSP that provides the resources for the Excel Calculation Services you want to configure.

location

A valid location to the folder that is trusted

Valid values are:

  • URL in the form http(s)://host/path

  • UNC in the form \\server_name\share)

The maximum length is 1024 characters.

Yes

This is the URL of the directory that is trusted. The format of this parameter is determined by the value of the locationtype parameter for a specific location.

locationtype

One of the following supported types:

  • SharePoint

  • UNC

  • HTTP

Yes

Specifies a location type. The value of this parameter determines the authentication method for retrieving workbooks. If the value is either SharePoint or HTTP, the value of the location parameter is a valid URL. If the value is UNC, the value of the location parameter is a valid UNC.

This parameter works in conjunction with the location parameter.

includechildren

One of the following values:

  • True

  • False (Default value)

Yes

True indicates that subdirectories or child libraries are trusted; False indicates they are not.

sessionTimeout

One of the following valid integers:

  • -1: No timeout

  • 0: The session expires at the end of a single request

  • 2073600 (24 days)

  • A range between the values, for example, 1 to 2073600

No

Maximum time, in seconds, that an Excel Calculation Services session can remain open and inactive before it expires, as measured from the end of each request.

shortSessionTimeout

One of the following valid integers:

  • -1: Disables short session timeout

  • 0: The session expires at the end of a single request

  • 2073600 (24 days)

  • A range between the values, for example, 1 to 2073600

No

Maximum time, in seconds, that an Excel Calculation Services session can remain open and inactive, prior to any user interaction, before it is closed. Time is measured from the end of the initial open request.

maxRequestDuration

One of the following valid integers:

  • -1: No limit

  • 1 to 2073600 (24 days)

No

Maximum duration, in seconds, for a single request in a session.

maxWorkbookSize

A valid integer between 1 and 2000

No

Maximum size, in megabytes (MB), of a workbook that can be opened by Excel Calculation Services.

maxChartSize

A valid integer between 1 and 2147483647

No

Maximum size, in MB, of a chart that can be opened by Excel Calculation Services.

volatileFunctionCacheLifetime

One of the following valid integers:

  • -1: Calculated once on load of the workbook

  • 0: Always calculated

  • 1 to 2073600 (24 days)

No

Maximum time, in seconds, that a computed value for a volatile function is cached for automatic recalculations.

defaultWorkbookCalcMode

One of the following values:

  • File (Default value)

  • Manual

  • Auto

  • AutoDataTables (same as Auto, but data table are not recalculated)

No

Calculation mode for all workbooks.

allowExternalData

One of the following values:

  • None: Data connections are not allowed (default value).

  • Dcl: Only connections defined in trusted data connection libraries are allowed.

  • DclAndEmbedded: Both connections defined in trusted data connection libraries and connections embedded in the files are allowed.

No

Specifies the types of external data connections that are allowed.

warnOnDataRefresh

One of the following values:

  • True (Default value)

  • False

No

True: Displays a prompt before refreshing an external data source that uses the user's identity.

False: Does not display a prompt before refreshing an external data source.

stopOpenOnRefreshFailure

One of the following values:

  • True (Default value)

  • False

No

True: Stops the open operation on a workbook.

This behavior occurs under the following circumstances: The workbook contains a Refresh on Open data connection and the workbook cannot be refreshed while it is opening, and the user does not have Open Item permissions to the workbook.

False: Does not stop the open operation on a workbook.

For further information about workbooks, see Excel Services Technical Overview. (https://go.microsoft.com/fwlink/?LinkId=110301&clcid=0x409)

periodicCacheLifetime

One of the following valid integers:

  • -1: Never refresh after first query

  • 0 to 2073600 (24 days)

No

Maximum time, in seconds, that the system can use results from an external data query.

manualCacheLifetime

One of the following valid integers:

  • -1: Never refresh after first query

  • 0 to 2073600 (24 days)

No

Maximum time, in seconds, that the system can use results from explicit manual external data queries.

maxConcurrentRequestsPerSession

A valid integer between 1 and 2147483647

No

Maximum number of concurrent external data queries per session.

allowUdfs

One of the following values:

  • True

  • False (Default value)

No

True: Indicates that user-defined functions can be called from workbooks in this trusted location.

False: Indicates that user-defined functions cannot be called from workbooks in this trusted location.

description

A valid string value, for example, "This is a trusted location"

No

Optional description of the trusted location.

The maximum character length is 4096 characters.

Remarks

A trusted location list allows the Excel Calculation Services to only load files from locations that are deemed safe by the administrator. This list is used to load both files that are explicitly loaded by a user (browsing and showing in the renderer), as well as those implicitly loaded when an Excel Web Access Web Part resides on a digital dashboard.

When a file is checked to see whether it is in a trusted location, only the file or URL that is initially requested should be checked. This may be different than the file or URL that is requested by the user, because there may be redirects prior to determination of the file or URL that will be loaded.

The list of trusted locations is stored in Shared Service Provider database and applies to the logical server.

See Also

Concepts

Add a trusted file location
Remove-ecsfiletrustedlocation