8 Replies Latest reply on Feb 7, 2018 8:23 PM by Muhammad Mubashir Mukhtar

    Posting Tableau Packaged Workbooks on Sharepoint

    Nicole Le Prohn

      Many of our staff have Reader. I want to post packaged workbooks on Sharepoint for staff to access. When I try it, Sharepoint makes the user download the workbook, rather than just open it (the way other documents work). Is there a way to make this work? Is it a Sharepoint or Tableau issue? I've searched the forums but found nothing close to this.

        • 1. Re: Posting Tableau Packaged Workbooks on Sharepoint
          Alex Kerin

          I would guess a Sharepoint problem - possibly handled by Mime type? http://www.javaworld.com/javaworld/javatips/jw-javatip94.html

           

          I know very little about this though.

          • 2. Re: Posting Tableau Packaged Workbooks on Sharepoint
            Steve Martin

            Did you manage to solve this? I was under the impression that this couldn't be done, that the only way of interacting with workbooks on Sharepoint is to host the vis/packaged workbook on a Tableau Server (or use Tableau Public Server), then drop the resultant url to Sharepoint - Sharepoint handles the user access and connections but TS is responsible for the interaction - though this method would negate the need for Reader.

            • 3. Re: Posting Tableau Packaged Workbooks on Sharepoint
              Alex Kerin

              The OP wasn't trying to get the book to open in the browser, but rather that the downloaded file would automatically open Tableau, just like you can open a word document straight from a URL.

              • 4. Re: Posting Tableau Packaged Workbooks on Sharepoint
                Steve Martin

                "When I try it, Sharepoint makes the user download the workbook, rather than just open it "

                 

                Apologies, I misunderstood the question,  I was under the impression that the OP wanted to be able to interact with the workbook direct in the same sense as you would interact with TS workbooks (in browser) not to download them to the client pc and then open the local copy within Reader.

                 

                I have to ask the question why you would want to do this - we looked at the sharepoint with TS solution here but TS is a little over our budget so we have opted for a company-wide deployment of Reader and dropping the file to the intranet. We can control who has access to the file and we don't have to shell out for SP licences.

                • 5. Re: Posting Tableau Packaged Workbooks on Sharepoint
                  Xavier P

                  Hi Nicole

                   

                  I experienced the same problem on Sharepoint 2010 and with a bit of investigation noticed that if users save as opposed to open the .twbx workbook then it works as intended on Reader.

                   

                  I tried to zip the .twbx too and it would not work as if Winzip though the packaged workbook was a zip file, maybe it is, in disguise.

                   

                  Try again and let me know if that works.

                  • 6. Re: Posting Tableau Packaged Workbooks on Sharepoint
                    olivier BAERT

                    Dear all,

                     

                    The way IE uses to open an downloaded file is explained here :

                    http://msdn.microsoft.com/en-us/library/ms775148.aspx

                     

                    To work around this problem, it is possible to set the iexplore.exe DWORD value to 0 in the following registry subkeys, and then open the online version of the file:

                    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_MIME_HANDLING

                    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_MIME_SNIFFING

                     

                    A nearly identical solution is given on the website of tableau

                    http://kb.tableausoftware.com/articles/knowledgebase/ie-twbx-zip

                     

                    Unfortunaltly, these solutions open a security flaw on the computer (possibility of opening a malicious program unwittingly).

                    It should be possible to fix the issue at the server level.

                     

                    BR,

                    Olivier

                    • 7. Re: Posting Tableau Packaged Workbooks on Sharepoint
                      Scott Johnson

                      This is older thread but I was unable to find any information on how to configure SharePoint to open Tableau Workbooks in Internet Explorer.  I was able to cobble together a few posts and came up with the below solution.  Hope it helps.

                       

                      1. Locate a Tableau Reader image and resize it to a 16x16 pixel image
                      2. Add the image to the below directory (15 for SharePoint 2013)
                        • 14\TEMPLATE\IMAGES
                      3. Register the image by editing 14\TEMPLATE\XML\DOCICON.XML, and add this line somewhere in the <ByExtension> section: 
                        • <Mapping Key="twb" Value="TableauReader.png" />
                        • <Mapping Key="twbx" Value="TableauReader.png" />
                      4. Open IIS and add new MIME Types
                        • File name extension: .twb MIME type: application/twb
                        • File name extension: .twbx MIME type: application/twbx
                      5. Declare the MIME type as “Downloadable”

                                     $web.AllowedInlineDownloadedMimeTypes.Add(“application/twb”)

                                     $web.Update()

                                      $web.AllowedInlineDownloadedMimeTypes.Add(“application/twbx”)

                                      $web.Update()

                          6.  IISRESET is required

                      1 of 1 people found this helpful
                      • 8. Re: Posting Tableau Packaged Workbooks on Sharepoint
                        Muhammad Mubashir Mukhtar

                        Hi - I was facing the same problem and found the solution by Scott Johnson. Our SharePoint specialist, Eldho George also came up with a solution which I am pasting for reference:

                         

                        "Solution:

                        1. Edited the docicon.xml file

                                         Added the following code to the docicon.xml file

                                        <Mapping Key="twbx" Value="twbx_logo_16.png" EditText="Tableau Reader" />

                                        Value of the image have to be the same as the name of the image you use

                         

                        2. The file is located under

                                        For SharePoint 2016

                                        C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\XML

                         

                                        For SharePoint 2013

                                        C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\TEMPLATE\XML

                         

                                        For SharePoint 2010

                                        C:\Program Files\Common Files\microsoft shared\Web Server Extensions\14\TEMPLATE\XML

                         

                        3. Added an image (icon/logo) to following location

                                        C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\IMAGES

                                       reader logo.png

                        4. After this open IIS, select mime type, add a new mime type

                                        Under file name .twbx

                                        MIME type - application/twbx

                         

                        5. Open command prompt as an administrator – type in iisreset .

                                        Done all the changes will be applied.

                         

                        Remember all the above steps have to be done on SharePoint farm admin server with the right account.

                         

                        Hope this helps

                        Thanks

                        Eldho"

                        2 of 2 people found this helpful