Skip to main content

Filebased datasource security

Are you seeing this error when using a file based datasource like excel in webplayer.?

The data source may be missing or has been changed.


This generally happens for one of the following reasons

First from a security perspective spotfire ensures that you cannot just open any file, you need to provide a white list of locations that should be accessible to the webplayer. Change the property for your case in the web.config file.
This is controlled by two settings in the web.config 

AllowedFilePaths 

Provide the full path to directories or files on a 
local disk, other than the Spotfire Web Player 
installation directory, that you want to access 

in the Spotfire Web Player.
Specify each file or directory in a separate 
<string> tag. 
For example:
<value> 
 <ArrayOfString> 
 <string> 
 C:\MyData\ 
 </string> 
 <string> 
 C:\Logs\spotfire.txt 
 </string> 
 </ArrayOfString> 

</value>

AllowedWebRootFiles 

Provide the full path to files stored in the 
Spotfire Web Player installation directory or 
any of it’s subdirectories that you want to 
access from the Spotfire Web Player. Separate 
entries with a semi-colon (;). All paths are 
relative to the webroot directory. For 
example C:\Program 
Files\Tibco\Spotfire Web Player\6.5\
Example: 
<value> 
 ..\Logfiles\PerformanceCounter.txt; 
 ..\Logfiles\Spotfire.Dxp.Web.log 

</value>

if you have done both these steps and still cannot access the file, then potentially the userid used for webplayer identity doesnot have access to the location.. so ensure that and the last option but it may be true is ensure that the location where you are expecting the file is accessible from your webplayer server too, you may have mapped a network location to H drive and now the webplayer is looking for H drive which is not mapped..  in those cases use network paths rather than mapped drives \\networkshare\mydatafolder\salesdata\ 


Hope this helps folks out there...


Comments

Popular posts from this blog

Using Accordions in Spotfire Text Areas

Spotfire 6.0 provides great tools for quickly building your dashboard, but here we will learn to spice up things with the help of new 6.0 text area. If you are not aware the new 6.0 Text area supports HTML, Javascript and CSS. This opens up possibilities for doing a lot more with the text area. Some of the basic stuff can be seen here http://spotfire.tibco.com/qrt/UBSAN/presentation.html?pcode=100044   One of the cool things you can do is build an accordion panel in the text area for better utilization of the valuable screen real estate and helping the overall experience.(Watch the 0:15 second video below to see how accordion works - Sorry for the jitter in the video. The screen recorder does not record fast enough) Here is the html behind the text area : Please note that Spotfire controls are automatically created when you add text area controls, like filters, drop down lists etc. <DIV id="myaccordion"> <H3>Analysis Details</

Calendar Chart in Spotfire

I recently had a colleague asking me to show him the data in a calendar format.. Something like this I basically used a scatterplot for this.  You can check out the original DXP here  http://bit.ly/spotcalendar Some key settings to make it a calendar. Please note Order date is the date of interest here These expressions are out of the box expressions, no need to handcode them, but select them in the axis value  X Axis    <BinByDateTime([Order Date],"DayOfWeek",0)> Y Axis    Week([Order Date]) Trellis into panels   <BinByDateTime([Order Date],"Year.Quarter.Month",2)> Manual layout 4 X 3 Labels  UniqueConcatenate(DayOfMonth([Order Date])) Shape Tiled Markers Marker by   <UniqueConcatenate([Order Date])> Happy plotting your calendar!!!

Spotfire Auto Save for recovery

This is an extension I build to auto save local copies of currently open DXP every 15 minutes.. I have tested briefly and it seems to be doing its job, please please please try and test it if you can access a server and deploy.. Key Notes - This add-on will Auto Save Files while only in Spotfire Analyst Client. The save time is hard coded for every 15 minutes. Files are saved only if they are changed or user has done some actions like marking, filtering etc. The Files are saved in temporary location of the system, generally which will be like C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave If a Library file is opened it will be saved on your local machine under the temp path C:\Users\<username>\AppData\Local\Temp\Spotfire AutoSave\Library Content\ Library path will be replicated in this autosave location. e.g. C:\Users\<username> \Local\Temp\Spotfire AutoSave\LibraryContent\mylibraryfolder\mylibraryfilename_mmddyyyy_HH