#Import0 personne en discute

@Matthias Johann Kurs​ 

Hi, I think it is possible. I have run this code and it worked:

#import os
from datetime import datetime, timezone
import datetime as DT
import tableauserverclient as TSC
 
literal_date = DT.datetime(2000, 1, 1)
SERVER = 'https://yourserver.com'
#tableau_auth = TSC.PersonalAccessTokenAuth(PAT_NAME,PAT_VALUE,site_id=SITE_NAME)
tableau_auth = TSC.TableauAuth('viewer', 'mypasswd', site_id='')
server = TSC.Server(SERVER, use_server_version=True)
with server.auth.sign_in(tableau_auth):
    print('Logged in')
    now = datetime.now(timezone.utc)
    print(now)
    datasources = [ds for ds in TSC.Pager(server.datasources) if (now-(ds.updated_at or literal_date)).days>=1 and ds.has_extracts]
    for ds in datasources:
        print((now-(ds.updated_at or now)).days, ds.name, ds.updated_at, ds.project_name)

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions.

Does the user has the view and connect permission for the published data source?

Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

@Saurabh Singh

I'm trying to build this out to load custom records to an opportunity. The button works but it doesn't seem to be pulling in the Opportunity ID from the record where the button is placed. When I try to load the records I'm getting this error. Do I need to have the ID in my file or should this URL map it to each record that I load? 

@Prachi Dalvi​ 

Hi, you may use a python code like:

#import os
from datetime import datetime, timezone
import datetime as DT
import tableauserverclient as TSC
 
PAT_NAME = 'yourtokenname'
PAT_VALUE = '/5QvK8pKa/wg==:JAIzqJlHjCMx4tt1'
SITE_NAME = 'yoursitename'
SERVER = 'https://prod-useast-b.online.tableau.com'
 
literal_date = DT.datetime(2000, 1, 1)
 
tableau_auth = TSC.PersonalAccessTokenAuth(PAT_NAME,PAT_VALUE,site_id=SITE_NAME)
#tableau_auth = TSC.TableauAuth(username, password, site_id='sitenameurl')
server = TSC.Server(SERVER, use_server_version=True)
with server.auth.sign_in(tableau_auth):
    print('Logged in')
    now = datetime.now(timezone.utc)
    print(now)
    datasources = [ds for ds in TSC.Pager(server.datasources) if (now-(ds.updated_at or literal_date)).days>=0 and ds.has_extracts]
    for ds in datasources:
        print((now-(ds.updated_at or now)).days, ds.name, ds.updated_at, ds.project_name)

You would need to create a PAT and allow PAT to be used in your site:

https://help.tableau.com/current/online/en-us/security_personal_access_tokens.htm

This code uses Tableau Server Client:

https://tableau.github.io/server-client-python/docs/

Change line 21 if you want to know datasources update more than x days ago. In this example I am using >=0 so every data source should be shown.

Finally, I don't remember, but I am like 90% sure, times shown will be in UTC.

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego Martinez

Tableau Visionary and Forums Ambassador

Hi @Sachin Gupta ,

Please check this article.

http://quintonwall.github.io/add-mobilesdk-to-project/index.html

https://github.com/forcedotcom/SalesforceMobileSDK-iOS/issues/1072

@Debbie Andre​ 

Ok, In this case, you can use the REST API to download the datasources. REST API have some functions devoloped for Python, but like I am old school, I like powershell. I find a module file for Powershell from Glen Robinson who has developed an awesome set of functions for Powershell. To use them, you only need to unzip the contents in a folder, and then use them in powershell.

https://github.com/glenrobinson72/Tableau-Powershell-Scripts/tree/master/REST-API

Next, you open Windows Powershell ISE, I created the following code, with is very easy to use:

#Import the library where you saved it, i.e
Import-Module "C:\Program Files\WindowsPowerShell\Modules\REST_API_Tableau\Tableau-REST_3_8.psm1" -Verbose
⌗For default site
TS-Signin -server www.yourserver.com -username 'youruser' -password 'yourpassword' -protocol https -siteID ""
⌗For other site
#TS-Signin -server www.yourserver.com -username 'youruser' -password 'yourpassword' -protocol https -siteID "yoursiteid"
⌗Download Data sources in zip. These contain the tds, and the hyper
TS-DownloadDataSource -DatasourceName "Your Data Source 1" -ProjectName "Your Project" -FileName "D:\Where\you\savedatasource1.zip"
TS-DownloadDataSource -DatasourceName "Your Data Source 2" -ProjectName "Your Project" -FileName "D:\Where\you\savedatasource2.zip"
TS-DownloadDataSource -DatasourceName "Your Data Source 3" -ProjectName "Your Project" -FileName "D:\Where\you\savedatasource3.zip"
TS-DownloadDataSource -DatasourceName "Your Data Source 4" -ProjectName "Your Project" -FileName "D:\Where\you\savedatasource4.zip"
TS-DownloadDataSource -DatasourceName "Your Data Source 5" -ProjectName "Your Project" -FileName "D:\Where\you\savedatasource5.zip"
#Signout
TS-SignOut
#Extract Zip files and overwrite if needed
Expand-Archive -LiteralPath 'D:\Where\you\savedatasource1.zip' -DestinationPath "D:\Where\you\wantdirectoryextact1" -Force
Expand-Archive -LiteralPath 'D:\Where\you\savedatasource2.zip' -DestinationPath "D:\Where\you\wanddirectoryextact2" -Force
Expand-Archive -LiteralPath 'D:\Where\you\savedatasource3.zip' -DestinationPath "D:\Where\you\wantdirectoryextact3" -Force
Expand-Archive -LiteralPath 'D:\Where\you\savedatasource4.zip' -DestinationPath "D:\Where\you\wantdirectoryextact4" -Force
Expand-Archive -LiteralPath 'D:\Where\you\savedatasource5.zip' -DestinationPath "D:\Where\you\wantdirectoryextact5" -Force

After that, in each of the extract path, you will find a data directory, with the hyper file. From there you could use Tableau Prep, or Tableau Hyper API, to upload the final result to your destination server.

If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego