theinformationlab / tableau-extension-exportall Goto Github PK

I have need to be able to save the excel export results from a tableau "desktop" instance. We have no server instance which is able to run these extensions. Even if we did, there are other restrictions which can make it pretty inconvenient.

Nevertheless, we have a need (requirement really) to supply excel results with workbooks. We have discussed switching away from tableau for this specific reason. But, since there is an investment in tableau, I've been looking for alternatives. This ExportData extension seems to be 95% there, but I ran into some issues:

1. Could only get file results from a server instance.
2. The resulting file only produced strings, and on conversion would crash Excel.

After a lot of debug and code digging, I figured out the 2nd issue - hence the proposed "Col_Types" branch changes (https://github.com/shimrot/Tableau-Extension-ExportData/tree/Col_Types).

For the 1st issue, I was able to opening an external window via javascript Window.Open call. Then tried 3 different cross window messaging methods to transfer data between windows (postMessage/onmessage, BroadcastChannel, and a 3rd which escapes me now...) . Was not able to get any to work for varied reasons. Since I needed to show something, I punted and added some ajax calls to a local server I own, to squirrel away the generated excel data blob, and then have the new window able to download.

My end solution in the "indirect_server_save" (https://github.com/shimrot/Tableau-Extension-ExportData/tree/indirect_server_save) branch is not generalized enough for anyone else to use directly (because of the extra https server requirement). However, I hope someone else can think of some way to transfer between windows, or maybe can think of other alternatives.

Thanks
Kris

When i download to excel the field which are calculated field like Decimals / Percentages are not being formatted as shown in the worksheet. Even i went to the field and changed number format in the default properties of the calculated field but its not reflecting. Sorry for too much feedback @craigbloodworth i apologize

calculated %'s

Calculated Decimals Fields

we have the extension pointing to our internal Tableau Server (replacing 'https://exportallextension.theinformationlab.io' by our server URL in the ExportAll.trex file) but instead of displaying the Export button, it launches our tableau server url ... any idea on how to configure it so that we can add the button?

Any help is truly appreciated

Is there something I need to do to have this extension work on an iOS device?

Hello,

The export all extensions was working fine for me but not for other team members : the values were missing from the Excel worksheet.

I figured out that the issue came by the fact that my Language parameter on my Tableau Online user was set to English (UK) but theirs was undefined or French.
The export isn't impacted by the Localisation as I would have expected, but by the UI Language used for each user on Tableau Online :

Might be related to the issue #16

Is there a reason/workaround available ? All my team members are not fluent in english :)
Thanks

Could anybody please tell me about the maximum records that can be exported via Export All Extension

First of, the new version functionality is great!

For an enhancement, is it possible to add an option where the user can upload the button image?

Thanks!

we installed the extension in one of our web server and update the url appropriately in the .trex file.

we also added the extension to the list in our Tableau Server environment.

When adding the extension to a dashboard, while we can select it, no button are being displayed ....

... any pointers will be highly appreciated

It would be great if we could format the extension. I dropped this onto a dashboard that has a gray background. And trying to get rid of the white is almost impossible. So having the ability to apply a background color to the extension would be awesome. Thank you for such a wonderful extension!

The export file currently labels fields with Tableau's notation for SUM(FieldName), ATTR(FieldName), AGG(FieldName), etc. Are there plans to support aliases/the ability to rename columns in the exported file?

When exporting a table that has a column with currency, Excel gives the following error message:

After clicking yes, it displays the column, but only as decimal and not currency.

Hi, This is really useful extension but it would be great if this is used in regular dashboards as well instead of just charts, i have enabled this extension in normal table layout dashboard where there were 8 measure values and 8 measure names. when i enable this extension all the 8 measure names/measure values were downloading to excel in one single column instead of individual columns it would be great if any help is provided

We are still having the refresh issues and the colors are still blue...

Originally posted by @LyleEllerbach in #58 (comment)

I am a Tableau Admin and have a customer looking to enable this extension on the Server.. is this Extension able to function via the Server UI?

A few other questions:

1. For the extension to function does it have to go out to an external address? I see in the manifest file it is referencing the Information Lab URL so wanted to verify?
2. Does Full Data or Summary Data need to be enabled for this extension on Server?

Hello,

We are trying to develop a map that allows users to view and download the locations where they can receive physical and mental health services. We are using Tableau Server (version 2018.3.2) and have added the Source URL from the Export All .trex file to our server settings and set User Prompts to "hide" to prevent users from getting the Allow Extension popup window.

Unfortunately, after enabling the extension and trying to hide user prompts, we still get the Allow Extension popup window.

We are following the same process with other extensions and are not receiving the popup window when users load the visualization. Are we missing any other steps to enable this extension without our users getting the popup prompt?

Thank You.

Hi, I am using Tableau 2020.2.2. Export all extension is not working properly. Extension published on server on existing dashboards gets greyed out and for few dashboards, order of columns gets changed on server and few columns got duplicated with same name but does not showing any data when downloaded in excel.
For greyed out dashboards, i had to click on Reset and again added all sheets and columns.
But in one of the dashboard where sort order changes and duplicated columns added. I did reset and duplicated columns are not coming now but i am unable to change order of columns. After Saving, when i again click on Configure, sort order disturbs.

When a new sheet is added, or an existing one is renamed, the change doesn't get reflected in the extension configurations.
Same for new/renamed fields in sheets.

Not sure if the 'Reset' button is supposed to do this - but doesn't seem so.
The only way I've found around this so far is to re-add the extension to the dashboard and set all the configurations again.
Would be great if such changes could get propagated through.

Currently using with Tableau 2019.2.2

Hi Craig,
This feature has been instrumental with a number of executive dashboards, thank you for creating it and sharing it with the broader community! One of the dashboards its incorporated in uses a sheet-selector parameter. I am finding that only the data from the first sheet downloads. Do you know if this could be a user error, extension limitation, and/or provide guidance? Thanks again, Lindsey

Tableau version: 2019.4.7

Chinese and Japanese users in our company are no longer able to use the extension to download data in excel: by clicking on "export all" on our published dashboards, the excel file that they download is completely empty (only the titles of the metrics show up, no data).
This issue seems to happen only in China and Japan, so maybe it's linked to language encoding? The export works for me and my colleagues in Italy.

When I try and click on the download data button I get the following error:

Uncaught (in promise) TypeError: Cannot read property 'getSummaryDataAsync' of undefined

And nothing happens. Any idea of the cause?

First of all, thank you for your development and assistance of this tool, it is a big shame that still in 2019 Tableau is not able to offer download buttons. Thank you guys to make this possible

I have an issue with data download, It displays blank values with only the name of columns, I checked multiple versions of Chrome, IE, and still having the same income. Only worked in firefox.

The client has Chrome and with the latest version Version 77.0.3865.90 (official build) (64 bits) I am not able to get data.

What can I do?

Thanks in advance

This is more a question than an issue for @craigbloodworth. We would like to use this extension, however, we have some security needs that would likely require us to run this extension on our internally hosted server vs. using the extension as it is available. Are we ok to download a copy of this code here and stand this extension up internally on our own servers where it would be allowed to work in our intranet and not move outside our firewalls?

Team,
Good Morning/Evening !
I am using Trusted authentication for my users to get authenticated(Embedded view into website), when my users are trying to download data using the Export all Extension(over 20mb file) on IE11, it spins for 2~3 minutes(wont download)and tries to refresh the page with same URL string (throwing an error "Could not locate unexpired trusted ticket error". Would someone please help me if there is way to tweak the code for the application to download larger files on IE.
Thanking you in anticipation.

Please.. Please

Hi!

When you have a lot of rows to be downloaded, the recursive call inside 'decodeRows' is causing a "Maximum call stack size exceeded" error. Any workaround to fix it?

Thank you so much for " "Extract All" Tableau Extension, it's really helpful however Tableau Desktop Crashed when using "Extract All" Tableau Extension to extract the total record more than 1,048,576 and this is the record limit for single excel sheet. Please take a look at it.
It would be great if you write the records on multiple sheets if the total records exceeds the excel max limit.

Thank you So much

Your sincerely
Rama
+91 966305579

Using the extension from Tableau Server 2020.1.7, the Excel file contains only dimension fields (No sum() measure). Any idea where this might come from? it works on Tableau Desktop.

Hi @craigbloodworth

I have downloaded 2.1.1 release & tried to set it up on my localhost just for testing. Configuration window is opening empty. Am i missing something?

Thanks

There appears to be a 10,000 record limit for the Export All extension. Is there a setting so the Tableau workbook developer or server admin can make changes to this exort record limilt setting?

Hi, We're trying to add the Export extension to our workbooks and having some problems viewing those workbooks in IE11. We've been able to get around some javascript syntax that's not supported on IE11 (lambda functions, template literals), but now we're getting an "Access is denied" error deep within the xlsx library. Do you have any experience running the extension on IE11 and is IE11 in the plans? Thanks.

"Extract All" Tableau Extension turned out to be a life savior for downloading files in no time however Tableau Server Crashed when using "Extract All" Tableau Extension to extract the total record 165459. As i figured out, the data limit was resolved in V2 of this Extension but i haven't got the download link for that. Request you to pl

ease look into this.

Hi,

downloaded the extension and tested it in a dashboard.

It generates the excel file but when opening it, I get the message below

Then, once opened in Repaired mode, I get the following

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

but no more details ... anyone experiencing the same issue?

Hi, I've developed this dashboard and added this extension to it. It was working perfectly fine at the beginning, as I uploaded this to the PROD server, and people were able to click on the button to export the Excel file. However, recently there was one guy who came to me saying that the export button was not showing. I checked the dashboard on the PROD server and the export function worked fine for me. I asked him if he's the only one who couldn't see the export button, and the answer was yes. I got stuck on this and couldn't understand why this is not working for one person. Does anyone know what might be the reason? Really appreciate your help on this!

Thanks

I'm having this issue on one specific workbook. When I go to "Configure" in the extension menu, nothing happens. I'm not getting the usual pop-up that allows me to customize the download. Everything is enabled in Tableau (Java, etc.). Also, the extension works as expected in other workbooks.

The configure menu is working when I upload to Tableau Server, but the issue there is that it resets the configuration every time I log in to view the dashboard.

Thanks!

Tableau crosstabs are ugly and if you don't have a measure value on the marks card, there will be an ugly 'ABC' row to the far right. When exported, this column will show up as "NULL" if you export the table. I want to cover that column up - when exporting a table, I don' want my end user to have to have to clean the data (and delete that column) they just exported.

I try to work around the ABC column by Putting INDEX() on the rows shelf and my actual column Name on the Text Marks card. But when exporting this with the button, suddenly the order of the rows is inverted, sorted in descending order for some reason.

Tableau Screenshot:

After Exporting, row order is inverted:

Am new to extensions in general so have a few questions upon using this extension to allow my business user to export and inventory table we are using for tracking purposes....

1. It seems the export rearranges all of the dimension columns alphabetically and then lists the measures, is there a way to prevent this?? i.e. can i preserve the format that exists in tableau?

2. This is a network enable extension, so if I'm reading correctly, does this mean “you” have access to my data since you are hosting it to generate the excel? It seems there should be an option to restrict or deny access but I do not have this option under the “reset permissions” option within the configuration settings so wondering what kind of access your network has?? I am not an expert “coder” so not sure looking into the code for this extension would be helpful to me so please let me know if you are able to answer my questions.

Thanks!

Do you think you will make this a sandbox extension? I would love for this to run on our servers rather than network enabled.

Hi,
when exporting anything from Tableau (Server) every single column inside the Excel file is a String. This leads to the problem that you can't calculate with numbers, build sums etc.

Is there any way to avoid this behaviour? The underlying SheetJS should have no problems with real numbers but it seems that Tableau somehow masks every attribute as String. The same thing happens when using the internal csv export option of Tableau by the way.

Under TDesktop, I used the measure names and values to display data in a worksheet, then add it on a dashboard, publish to the server to add this awesome extension, then allowed it when popuped and clicked to "Modify" under the TS before configured it, to be able to save the settings inside the workbook, on TS.
I wish I'd read the trouble with the measure N&V displayed in one unique column before.
Now, while the export button works fine, I need to change the measure N&V but...
no "rescan function" to update changes on the worksheet, sad it is,
and the Reset button just erase the "Select Sheets" and "Select Columns" contents, nothing is displayed anymore wherease the "Configure" section is properly reset to its original values.
well.. "Same player, shoot again" I guess. That means the configure part must be done as the very last thing on a approved workbook, unless Sisyphe.

If i have more than one view, then i configure the extension. it can see the 2 sheets and i can tick them, however on the select columns tab, there is no option how to select columns for table 2.
when downloading from server, it can download sheet 1 and 2 but only sheet 1 has contents. sheet 2 is blank but the sheet name is correctly correspond to view name..

Add the extension to the dashboard and configure it. When new fields are added to the targeted sheet(s), they do not appear in the configuration of the extension. Furthermore, if I add a new sheet to the dashboard and try to configure the extension to target the new sheet, the new sheet doesn't show up. If I remove the extension from the dashboard and add it back, the same problems exist. And the Reset button doesn't seem to cure the problems.

Hi Grand total which is part of Viz is not exporting to the Excel. Any help would be greatly appreciated

We use the Export All extension in some of our workbooks and some teams would rely on it heavily.
The extension randomly stops working on the server and the download button disappears from the workbook along with the dialog Tableau extension pop up.

We have asked our server team to check if anything has happened on the servers when the extension stops working and nothing jumps out to them such as any patches having being applied etc.
We had been in contact with Tableau about this and they suggested it might be to do with your servers that host the extension going down but we have two servers Dev and Prod, the extension will stop working on one and be fine on the other so for this reason I don't believe this would be the cause. As the Technical support team do not support third party extensions we have kind of come to a dead end with this line of investigation.

I have had a quick look through some of the log files from around the time it has gone down previously but with limited knowledge of what I am looking for I cant see the cause.

So far our fix for the issue has been a reboot of our server which has always brought the extension back up. However this needs to be scheduled in so it means the users are left without the extension for in or around 2 days.

Has this issue come up for anyone before?
Is there any solution for this or a known cause?

Thanks!

Hi,

I am working with some data that has user filter. The metrics gets affected by the hierarchy of the users as well (i.e. if I have area user then it will show some fields but for country user it will show some more fields). I was using Export All extension to download the data but recently it is not working. I am getting either blank sheets or wrong data.
Any suggestions? Is this a prevalent issue with new extension roll out?

Thanks in advance.

Tableau currently cannot provide us with a viewer license to test if our use of the extension will work if we switch from Explorer to Viewer for our users. Is this something the developer can answer? Or has anyone else successfully used the extension with Viewer licenses?

we installed version 2.1.1 on our Tableau Server. Can someone send the instructions on how to create the button that allows to export the content of a dashboard?

I started a dashboard while working in Tableau 2019.4 and the extension worked fine. When I upgraded the software I could no longer edit the existing configuration nor start over by adding a new button. Any guidance on getting this to work would be awesome. It is just a greyed out button and the configuration screen is empty anytime I try to add it.

Hi Craig,

I just saw that an update has been made. I checked my dashboards and the export buttons no longer work on the server. I also opened them in the desktop version, and they stopped working when i reloaded them. Is there something we need to do on our end to get the update to work?

Thanks

I've added the extension to my dashboard, configured it to use a worksheet that was already on the dashboard. When I publish to Server, the load time for the dashboard has doubled in time. But other dashboards I've added it to are not experiencing this issue. What could I be missing or doing wrong?