2 Replies Latest reply on Aug 9, 2018 12:10 PM by Naveen B

    tabcmd refreshextract at project level

    Renee Chan

      Is it possible to refresh all workbooks within a specific project defining the workbooks with a wildcard (*)?

       

      For example:

      tabcmd login -s http://tableau:8000 -u <your user id> -p <your password> --project "My_Project_Name" --workbook "*"

      tabcmd logout

        • 1. Re: tabcmd refreshextract at project level
          Jeff Strauss

          It's not possible using wildcards.  But what you can do is to create a schedule, set it to disabled status, and then assign each of the extracts to the schedule.  And then you can do a tabcmd runschedule.  tabcmd Commands 

          1 of 1 people found this helpful
          • 2. Re: tabcmd refreshextract at project level
            Naveen B

            Hi Renee,

             

            to do this you need to integrate powershell and tabcmd

             

            1) Create a csv file or excel file --> feed with all the workbook name

             

            2) Call the csv file from power shell --> store all the values in a single variable called $workbook

             

            3) login statement

             

            tabcmd login -s servername -u userid -p password

             

            3) now use forloop

             

            for ($value in $workbook)

            {

            tabcmd refreshextracts --workbook $value --project "Sales External"

             

            }

             

            this steps will help you to do the refresh extracts of all workbooks in a project at a time

             

            Hope this helps, kindly mark this answer as correct or helpful so that it will help others

             

            BR,

            NB

            1 of 1 people found this helpful