Cannot open *.csv and *.txt files but can open Excel files work from shared drive using the TIBCO Spotfire Web Player

Cannot open *.csv and *.txt files but can open Excel files work from shared drive using the TIBCO Spotfire Web Player

book

Article ID: KB0072000

calendar_today

Updated On:

Products Versions
Spotfire Web Player 7.5 and higher

Description

When trying to access files on shared drives in the TIBCO Spotfire Web Player, you find that you cannot open .csv and .txt files, but can open Microsoft Excel files from the same location. This can be caused by a few reasons:

  • If the "AllowedFilePath" tag is missing  from "Spotfire.Dxp.Worker.Host.exe.config" file.
  • If using Kerberos with delegation, for Microsoft Office file types like Excel the Node Manager service Account is used for access, but for all other file the logged in user is delegated.

Environment

All

Resolution

Resolution 1:

Always applicable. Check the "Spotfire.Dxp.Worker.Host.exe.config" file to see if the below tag exists. Ensure the shared path is specified here.
<!--A list of paths determining which parts of the file system may be accessed by file data sources-->
      <setting name="AllowedFilePaths" serializeAs="Xml">
        <value>
          <ArrayOfString>
            <string/>
          </ArrayOfString>
        </value>
      </setting>

See KB 000029119 How to configure access to local and shared network directories for the TIBCO Spotfire Web Player for more details.

Resolution 2:

Applicable only when your Spotfire environment is configured to use Kerberos with delegation authentication. Confirm the Node Manager service account has access to the share file folder. See KB 000029204 How to open analysis files on the Web Player when they contain linked data located on a network share for more details.

Issue/Introduction

Cannot open *.csv and *.txt but excel can open successfully files from shared drive using the Web Player.

Additional Information

KB: 000029119 How to configure access to local and shared network directories for the TIBCO Spotfire Web Player KB: 000029204 How to open analysis files on the Web Player when they contain linked data located on a network share