2 Replies Latest reply on Apr 20, 2017 10:10 PM by Chadd Dumagas

    HELP!!! Tableau Data Extract Command-Line Utility to refresh extract

    Chadd Dumagas

      Ok I'm having a situation here. First, the error is

      The data source has no extract.

       

      Goal

      Somewhere around visual basic code i want to run the command line below to automate the refresh every time the report needs to be updated.

      So its more of ah, forcing a full refresh.

       

      Situation

      I have an excel file> created an extract> published it over the server.

      Then manually I've tried testing the command line but it isn't working.

      I have tried and tested each parameter and they were working but when i have added the last parameter which is

      --original-file it shows the above error. Im sure that the path i have added is correct since i also tested that by

      copy pasting it into windows explorer.

       

      I have tried both command line 1 and 2 but no luck at all.

      >>>> I dont have tabcmd installed (i think). <<< ill need to do the workaround using the regular command line.

       

      Datasource File Path

      \\network name\shares\CustomerSupport\Knowledge Management\Content Architecture\Tableau\RMG\datasource

       

      Files within the path

      DataSheet (progsched).tde

      progsched.accdb

      progsched.xlsx

       

       

      Report File Path

      \\network name\shares\CustomerSupport\Knowledge Management\Content Architecture\Tableau\RMG\report

       

      Files within the path

      Program Schedule.twb

       

      Available parameter using --help

      Valid options are:

        --source-username USERNAME       The username to sign in to the original data

                                         source with.

        --source-password PASSWORD       The password to sign in to the original data

                                         source with.

        --original-file FILEPATH         For file-based data sources, the path to the

                                         original data file.

        --force-full-refresh             Force a full extract refresh. If not set, an

                                         incremental refresh will be performed. Not

                                         all data sources support an incremental

                                         refresh.

       

       

      Data Source Options:

        -s [ --server ] SERVER           The server where the extract is published.

        -t [ --site ] SITE               The ID of the site where the extract is

                                         published.

        --datasource DATASOURCE          The name of the data source containing the

                                         extract.

        --project PROJECT                The name of the project the data source

                                         belongs to. If not provided, the Default

                                         project is used.

        -u [ --username ] USERNAME       The username to sign in to the server with.

        -p [ --password ] PASSWORD       The password to sign in to the server with.

       

       

      Proxy Options:

        --proxy-username PROXY-USERNAME  The username for the proxy server.

        --proxy-password PROXY-PASSWORD  The password for the proxy server.

       

       

      Global Options:

        -c [ --config-file ] FILEPATH    The path to the file containing

                                         configuration options for the command.

       

      commandline1

      c:\Program Files\Tableau\Tableau 10.0\bin> tableau refreshextract

      --server "http://tableauservername" --site "CS" --project "CS Knowledge Management"

      -u "myusername" -p "mypassword" --datasource "DataSheet (progsched)"

      --original-file "\\network name\shares\CustomerSupport\Knowledge Management\Content Architecture\Tableau\RMG\datasource\

      DataSheet (progsched).tde"

       

      commandline2

      c:\Program Files\Tableau\Tableau 10.0\bin> tableau refreshextract

      --server "http://tableauservername" --site "CS" --project "CS Knowledge Management"

      -u "myusername" -p "mypassword" --datasource "DataSheet (progsched)"

      --original-file "\\network name\shares\CustomerSupport\Knowledge Management\Content Architecture\Tableau\RMG\datasource\

      progsched.xlsx"

       

       

      Publish Settings