export pdf into one folder and then schedule the email.
create one batch file with tabcmd and export pdfs then same file you can add the febotimail command line details and to send email.
If you create two command in a single file then we can schedule the bat file with windows task scheduler.
I can use tabcmd export "Path" --fullpdf to generate the file and im using blat for the email blast.
Is there anyway you can post the batch file you used to for the tabcmd command? I need to save my tableau report to a shared drive and execute the report thru the windows scheduler. Not sure how to do this. Any assistance would be most appreciated.
This is very easy method. first create batch file with tabcmd login and all details.
open task schedular and create basic task.
select the name of schedule and then set time.
browse then batch file and give o.
so every day it will run and get pdf in your folder.
If you can use the cost based command line then go with febootimail and create the single bat file. it will send daily mail
I also doing the same thing, Im using the tabcmd and create a batch job to distribute the file to multiple shared folder.
I also done the email but instead of feebotimail (which is a paid apps) I use blat.
tabcmd export "Path" --fullpdf
Can you please explain this. I have 2 workbooks.
How to get the path for the entire workbook of any one
Here is the script to export dashboard into pdf and send to recipients through email.
$recipients = “SD<email@example.com>”
Set pathname =”x\Command Line Utility” /*x replace with Location where tabcmd utility is installed on server */
# login Tableau server
tabcmd login -s https://zz -u bb -p cc /*Replace zz with Tableau server name, bb with User account through which you want script to execute on Tableau server and cc with password for account used */
# Using Tabcmd with export command generate pdf
tabcmd export “Dashboard/Report” –pdf -f “C:xx\Report.pdf” /* replace xx with location where you want to save the generated file */
tabcmd export “Dashboard /Report” –fullpdf -f “C:\xxx\Dashboard.pdf” /* replace xxx with location where you want to save the generated file */
#Lines for sending attachment in emails#
Set pathname =”C:\Windows\System32\WindowsPowerShell>”
send-mailmessage -to “$recipients”-from “SD<firstname.lastname@example.org>” -subject “Dashboard PDF ” -Attachments “C:\xxx\Report.pdf”,”C:\xxx\Dashboard.pdf” -smtpServer exmail.brocade.com /* replace xxx with location where you want to save the generated file */
I have another question on top of this query. My users are getting dashboard pdf file in email via their subscription but it is practically a snapshot of the dashboard and if there is any scroll bar in dashboard it doesn't expand so they are not able to view whole data. They ado not want to go on tableau server and download the workbook. Is there anyway we can burst the data in pdf which they get in email?