Thank you Toby,
My goal is to export a twbx file from a server from a workbook that is connected to a data source. Any suggestions on how to achieve that?
I have no idea
What is the reason why you want to do this? Maybe if someone understands the "why" they can offer another solution.
The reason is to export the worksheet with data .i.e as twbx and place it on a shared location. Which can be accessible by any user without connecting to server. Goal is to avoid users connecting to server and work with isolated worksheets that has all the data.
2 of 2 people found this helpful
Well you can hack by getting the tde file directly from Tableau program data (I hate this way but frequently will need do when dealing with tableau software
The published extract (tde) either use in workbook or data source should be in (when you install tableau server on default folder):
There is one or more folder and inside there are many folder start with name upload_
Find your tde
Thank you for the suggestion. I was able to find the tde. Realized, it is useless to me unless it is combined with a worksheet. I wish there is a way that could package worksheet and the server extract which we can download.
Of course you can package your workbook (.twb) and the extract (.tde) into a packaged workbook file (.twbx).
.TWBX actually is a zipped file contains .twb, .tde and other localized file (image file, etc). You can change the .tde file with the server extract successfully only when the extract is the correct one.
This is my scenario..
I have a worksheet on server. Which uses an extract that is also on server(i.e. workbook and extract are published to server separately) . I am trying to automate the exporting of this worksheet as a packaged workbook. In order to do so, I am using the below tabcmd.
tabcmd get "http://server/workbooks/worksheet.twbx" --filename "E:\TestFolder\test.twbx"
When this tabcmd is executed, it exports a twbx file;however it asks for server credentials because the extract is located on server. This is where I am struggling. I am trying to find any other alternatives other than publishing packaged workbook to the server.
From your above response, if I can export both tde and twb via tabcmd, how can I package them..something that can be automated?
To clarify, did you mean your published workbook using data connection to Tableau Server (as Tableau Server data source? (many confusing terms and starting to mixed up )
I believe yes, because when you open the twbx you will be asked to connect to TS.
Hence your worksheet in twbx is actually have no data extract (since the data source located on server).
To make your worksheet got local extract data (hence you don't have to login to TS), perhaps it will need more deep hacking (if possible) by modifying the xml (.twb). I'm not sure if it is doable
Another alternatives is you create another workbook that use local extract (you need to download / make a local copy from server data source) and then use the workbook to publish to server as well as to export (tabcmd) and change the .tde file with the server extract file (.tde).
Yes, that is correct. It is confusing indeed.
I will try to see if I can dig around xml file to see if we can do any tweaking. And the alternative solution(your last paragraph) is a good one, but in my business scenario it wont fit; because the same extract are used by multiple dashboards.
Thank you for input. I will do more research and see if I can find out.
2 of 2 people found this helpful
I know this post is a little old and maybe functionality has changed since this post. But this works for me when trying to download a published extract only.
tabcmd get "/datasources/mydataExtract.tdsx" -f "C:\Temp\mydataExtract.tdsx"