19
SEP
2018

Tableau Extension API – Write Back – Updated Source Code for Tableau 2018.2

Kommentare : 6

Due to the Google Analytics analysis I’ve done for the current quarter one can easily see that you – the Tableau community which we call “Tableaufans” – have been asking for more write back content. Would you agree?

So as a very first step I’m going to attach a quick tutorial around how to get “Tableaufans-WriteBack-2018.2” up and running for Tableau’s latest release (2018.2) and above. If you haven’t heard about “Tableaufans.com’s Write Back Extension” yet, you might want to watch the ~4min video from one of the previous posts to understand what you could get by following these steps.

  1. In order to be able to leverage the write back extension you need to have a webserver and a MySQL database
    1. I’m using XAMPP version 7.0.23 which contains both. You can download it here.
    2. Once you’re done downloading it you can extract the folder directly into C:
      (By copying it directly into C: it would simply allow you to follow all of my tutorials around extensions and JS API just a little bit easier in the future.)
    3. Start “C:\xampp\xampp_start.exe” as administrator
  2. Download the latest extension-api-master here: https://github.com/tableau/extensions-api
  3. Extract the content and paste it into your webserver (C:\xampp\htdocs)
  4. Extract the zip below and create a new file path where you extract it’s content into:
    Tableaufans-WriteBack-2018.2.ServerLogic(HTML,PHP,JS,CSS,)
  5. Extract the *.trex file and copy it into C:\Users\<USERNAME>\Documents\My Tableau Repository\Extensions
    Tableaufans-WriteBack-2018.2
  6. Make sure your XAMPP (Webserver+MySQL database) is up and running
    1. Apache should use port 8888
    2. Mysql 3306
      -> (If this is not the case, please change your ports accordingly as it will help you to use more assets from Tableaufans.com in the near future)
  1. MySQL should have a database called ‘yoursqldb’ with a table ‘getdataandwriteback’:
    (if not, please use ‘yoursqldb.sql’ attached to create the table within a database called ‘yoursqldb’)
  2. Add a new user to MySql (direct link to the right user interface on MySql)
    1. User name: admin
    2. Host name: localhost
    3. Password: admin
    4. Re-type: admin
    5. Privileges: Data, Structure & Administration
  3. Extract and Open “Tableaufans-WriteBack-2018.2.twbx.zip” with Tableau Desktop
  4. Drag and drop extension into the canvas and choose the one you copied into C:\Users\<USERNAME>\Documents\My Tableau Repository\Extensions
  5. Allow data access to the extension:
  6. Choose “Pipeline” as sheet to choose data selections from:
  7. Happy write back your data 😉

 

 

Troubleshooting:

  • If the data doesn’t get written into the database make sure that you’ve got a user called “admin” in MySQL with password “admin” with the following permissions:
    • http://localhost:8888/phpmyadmin/server_privileges.php?db=&viewing_mode=server
    • http://localhost:8888/phpmyadmin/server_privileges.php?username=admin&hostname=localhost&dbname=&tablename=&routinename=
  • If you want to debug Tableau Extensions generally you might want to have a look the following 2:21 min tutorial

    Start Tableau Desktop (with Extension in Debug Mode).bat
  • If you’re having any troubles in getting the extension up and running please leave us a comment below.
Timo Tautenhahn
Über den Autor
Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API
  1. Timo Tautenhahn
    Timo Tautenhahn Reply

    Hey Tableaufans,
    I’ve just updated the tutorial. ! In the alpha version of Tableau’s Extensions I’ve been zipping my whole Xampp where the admin user did already exist. As this tutorial should work for everyone I’ve extended this post by describing how to create the admin user.

  2. Adrien Reply

    Hi Timo,

    We met a week ago and you showed us this capability. It is brilliant, I followed all the steps but at the moment, we use tableau 10.5. is there any limitation to use tableau extension? Which version do I need? if not, could you share the tableau workbook in previous version?

    thanks for your help
    Adrien

  3. Pingback: » Tableau Extension API – Write Back

  4. Sam Reply

    Hi Timo
    We use 10.5 as of now on my complany server but I have 2018 installed on my local machine,
    Would it be possible to install the writeback for me on my local machine with above steps ??

    • Timo Tautenhahn
      Timo Tautenhahn Reply

      Hey Sam,
      yes, if you’re using Tableau Desktop 2018.2 or above you can absolutely use it locally with the steps above! 😉

Kommentare

*

captcha *