export to csv in Spotfire web player. with custom message on header

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.
from System.IO import *
from Spotfire.Dxp.Application.Visuals import VisualContent
vc=Visuals.As[VisualContent]()  #Visuals = Script parameter for Table/Cross Table visualization
memStream = MemoryStream();
sWriter = StreamWriter(memStream);
#Exporting the data to Memory Stream
vc.ExportText(sWriter);  #exports data in tab separated text
sReader = StreamReader(memStream);
memStream.Seek(0, SeekOrigin.Begin);
filename="C:\WebPlayer\spotfireexport.csv"
f=open(filename,"w")
f.write('This report is provided to support ABC project. \n\n')
counter=0
j=0
str1=''
while (sReader.Peek()>=0):
line=[]
counter=counter+1 #counts the number of rows in dataset
a=sReader.ReadLine()
lines=a.split("\t")
for elem in lines:
j=j+1 # counts the number of columns in dataset
print elem
if str(elem).find(",")<>-1:
elem='"'+elem+'"'  # escaping comma already present in string
line.append(elem)
str1 = ','.join(str(e) for e in line)
f.write(str1+'\n')
f.close();
MemoryStream.Dispose(memStream);
sReader.Close()

from Spotfire.Dxp.Application.Visuals import HtmlTextArea
html = None
for vis in Document.ActivePageReference.Visuals:
 if vis.Title == 'HTML':
  html = vis.As[HtmlTextArea]()
  html.HtmlContent =  '

Click here to download CSV'

How to Export Table/Cross Table visualization data in csv file using TIBCO Spotfire® Using IronPython Scripting

https://community.tibco.com/wiki/how-export-tablecross-table-visualization-data-csv-file-using-tibco-spotfirer-using-ironpython


# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.
from System.IO import *
from Spotfire.Dxp.Application.Visuals import VisualContent
vc=Visuals.As[VisualContent]()  #Visuals = Script parameter for Table/Cross Table visualization
memStream = MemoryStream();
sWriter = StreamWriter(memStream);
#Exporting the data to Memory Stream
vc.ExportText(sWriter);  #exports data in tab separated text
sReader = StreamReader(memStream);
memStream.Seek(0, SeekOrigin.Begin);
filename="C:\Use\spotfire export\spotfireexport.csv"
f=open(filename,"w")
f.write('This report is provided to support. \n\n')
counter=0
j=0
str1=''
while (sReader.Peek()>=0):
line=[]
counter=counter+1 #counts the number of rows in dataset
a=sReader.ReadLine()
lines=a.split("\t")
for elem in lines:
j=j+1 # counts the number of columns in dataset
print elem
if str(elem).find(",")<>-1:
elem='"'+elem+'"'  # escaping comma already present in string
line.append(elem)
str1 = ','.join(str(e) for e in line)
f.write(str1+'\n')
f.close();
MemoryStream.Dispose(memStream);
sReader.Close()

Hadoop installation guide

https://github.com/MuhammadBilalYar/Hadoop-On-Window/wiki/Step-by-step-Hadoop-2.8.0-installation-on-Window-10

Spotfire import using cmd

E:\Apps\tibco\tss\7.8\tomcat\bin>  config import-library-content -p=E:\Apps\tibco\tss\7.8\tomcat\application-data\library\MasterCopy_07102017.part0.zip -u=Ambi@eb.com -l=/Test3 -i=all_items -t=Password01 -m=KEEP_NEW

redirect dependent elements spotfire

https://docs.tibco.com/pub/sfire-analyst/7.5.1/doc/html/WebHelp/id/id_redirecting_the_information_model.htm

spotfire-library-migration

https://www.extendanalytics.com/blog/spotfire-library-migration/

Chart sample

http://datavizproject.com/

spotfire custom theme

https://exchange.ai/downloads/theme-mdb/

Spotfire data science

https://datashoptalk.com/category/data-science/

Spotfire AWS Integration

https://www.youtube.com/watch?v=_yn7oOV4h90

Clickable column in Spotfire

https://community.tibco.com/wiki/how-make-clickable-links-spotfire-table


To add email as clickable.
Main Menu> Edit: Column Properties > Properties tab> Link Template -> mailto:{$}

Open table in chart and email will be linked and open outlook with email address when we click. 

It may not work in Chrome. only IE tested.