Email Bursting

Step 1: Install and set-up BLAT

• go to: http://sourceforge.net/projects/blat/files

• download latest version
• extract
• copy all files within to C:\WINDOWS\System32

• open command prompt
• run:

c:\ blat -install [server address] [sender's email address]

example:: blat -install emailserver.company.com useraccount@company.com

•  test:

c:\ blat C:\testfile.txt -s test_subject -to useraccount@company.com

blat syntax

Step 2: GetReport.bat

:: Change directory to tabcmd location

cd "C:\Program Files (x86)\Tableau\Tableau Server\9.2\bin"

:: login to Tableau via tabcmd

tabcmd login -s http://localhost:8000 -username fshih -password password -no-prompt

:: run tabcmd get

:: reports are saved to pdf

tabcmd get "views/Sales/GrowthofWalmart" -f "C:\Users\fshih\Downloads\test.pdf"

:: logout of tabcmd when done

tabcmd logout

:: back to root

cd \

:: send email with pdf attachments using blat

blat "C:\Users\fshih\Downloads\test.pdf" -to fshih@tableau.com -s "test"

/* 

:: use pdftk library to combine reports based on system

pdftk "C:\report1.pdf" "C:\report2.pdf" cat output "C:\report.pdf"

:: delete all pdf files generated during the process

del "C:\Users\fshih\Downloads\test.pdf"

febootimail.exe 

-SMTP yourSMTPhost.yourcompany.com 

-TO "recipient1@yourcompany.com; recipient2@yourcompany.com;recipient3@yourcompany.com" 

-FROM sender@yourcompany.com 

-SUBJECT "Generated Tableau View 

- Tableau Server Automated Alert System (TSAAS)" 

-ATTACH " C:\Program Files\Tableau\Tableau Command Line\progressReport.pdf" 

-BODY"this is the text of the body"

 */

note

get url

Gets the resource from Tableau Server that's represented by the specified URL. The result is returned as a file.

Note the following when you use this command:

• Permissions: To get a file, you must have the Download/Web Save As permission. By default, this permission is allowed or inherited for all roles, although permissions can be set per workbook or view.
• File extension: The URL must include a file extension, for example, "/views/Finance/InvestmentGrowth.csv".The extension (.csv) determines what's returned. A view can be returned in PDF, PNG, CSV (summary data only), or XML (information only) format. A Tableau workbook is returned as a TWB if it connects to a published data source or uses a live connection, or a TWBX if it connects to a data extract.
  To figure out the correct extension, you can use a web browser to navigate to the item on Tableau Server and add the file extension to the end of the URL.
  When you type the URL for the GET request, exclude the session ID (:iid=<n>) that appears at the end of the file name. For example, use"/views/Finance/InvestmentGrowth.pdf" instead of "/views/Finance/InvestmentGrowth?:iid=3.pdf".
  Note: If you are downloading a view to a PDF or PNG file, and if you include a --filename parameter that includes the .pdf or .png extension, you do not have to include a .pdf or .png extension in the URL.
• The saved file's name and location (optional): The name you use for --filename should include the file extension. If you don't provide a name and file extension, both will be derived from the URL string. If you don't provide a location, the file is saved to your current working directory. Otherwise, you can specify a full path or one that's relative to your current working directory.
• PNG size (optional): If the saved file is a PNG, you can specify the size, in pixels, in the URL.

Step 3: Run batch file

• use windows scheduler to automate running of the batch file