So close to getting this to work. I have used tabcmd to generate a single pdf once, but really want to batch a bunch of pdfs like you are doing. Using your .bat am unable to log in correctly. I have to specify a site in mine, so I added that to the parameters on top and referenced it with the -t call in the tabcmd logon.
For some reason it won't work.
invalid user name or password
Would love some help if you're willing...
I've triple checked all my username/password fields, again just used tabcmd and was able to log on. Just not via this .bat.
How do I use parameters and filters if they have spaces in the name and value?
I have tried that and it does not work for me. It says "for" is not recognized as an internal command. And then I get just one pdf . It does not loop. Please help me !
Was wondering if you ever got a response to your inquiry above regarding using a parameter instead of a filter. I am trying to implement this using a parameter as well and wanted to see if there was a best practice already in use.
Thanks for any insights you may be able to provide!
This is BRILLIANT! It works (Almost) perfectly for me. I have a text table that I am filtering and exporting as a PDF. Filtering and Exporting is working great - its just that the column headers do not show anymore. Do you have any suggestions?
The title shows but the text column/row headers itself does not.
Hey Tim - just put the whole file path in there like:
for /f "tokens=*" %%a in (C:\001_test\bat\grp_lst.txt) do call :processline %%a
Will this work with Tableau Online?
How can i pass the exact words to the end of the URL of the dashboards i.e. spaces in the words..
Thanks for providing such a wonderful solution to print PDF with Tabcmd command. I stumbled upon one issue when using multiple filters to export a PDF using Tabcmd command.
For example- I have a worksheet/view with two columns ManagerName & EmployeeName where each manager has multiple employees and I would like to print either, one pdf containing two pages one for Sam and Rick. OR print individual pdf one for John and employee Sam, another one John with employee Rick and likewise... I have filters for each of these dimensions.
As provided in your solution, I have created a batch script and text file with list of both ManagerName and EmployeeName respectively.
I am doing something like this,
for /f "tokens=*" %%a in (ManagerName.txt) do call :processline %%a
echo Creating PDF for Manager %*
tabcmd export "info/ManagerEmployee?ManagerName=%*&EmployeeName=%*" --pdf --pagelayout landscape -f D:\%*.pdf
Currently, I am getting PDF with all employees selected for each Manager like, on John PDF I have both Sam and Rick selected instead of only Sam in one page and Rick in another page or other PDF.
I think this needs another loop as it is not looping for each employees. As I have very limited experience with Bat file scripting, so I am hoping if you could help me out.
Thanks in advance,
I came across similar issue few weeks ago. If you have spaces in values of the fields, you can either use '%%20' to escape it or you can split the fields and concatenate using underscores or other characters so it becomes one word string.
As far as I know, Filter parameters are ignored when they contain spaces, or other characters requiring encoding.
Hope that helps.