-
1. Re: automation by tabcmd
maneesh.gaddam Feb 12, 2019 6:49 AM (in response to Twinkle Bansal)Twinkle,
Install tabcmd and run this script
cd C:\Program Files\Tableau\Tableau Server\Version\extras\Command Line Utility
tabcmd login "Server Name" -u username -p password
tabcmd export -t sitename "workbookname/Sheetname" --csv -f "Destinationfolder\Filename.csv" -u username-p password
pause
This exports sheet to csv and stores in a specific location. Using other smtp tools like Blat, you could pick this file up and send it as an email. I've only did that once but you could research on internet on how to send an email using command scripts.
-
2. Re: automation by tabcmd
Twinkle Bansal Feb 12, 2019 6:53 AM (in response to maneesh.gaddam)Thank you so much Maneesh
-
3. Re: automation by tabcmd
Twinkle Bansal Feb 12, 2019 6:55 AM (in response to maneesh.gaddam)One doubt Manish, does this command helps in exporting the whole workbook or only a particular sheet in csv?
-
4. Re: automation by tabcmd
maneesh.gaddam Feb 12, 2019 7:14 AM (in response to Twinkle Bansal)I believe we can export the entire workbook only to pdf not csv. You can read more about it here tabcmd Commands - Tableau
-
5. Re: automation by tabcmd
Twinkle Bansal Feb 12, 2019 7:28 AM (in response to maneesh.gaddam)thank you maneesh