Skip to main content
100%

Tableau2csv

✓ Published0🌍 Public
Aantichaos
Last edited Jul 25, 2023
Created on Jul 25, 2023

This example shows how to export a Tableau view’s underlying data to a CSV file via the Tableau REST API. It connects to a Tableau server using personal access tokens, iterates through all workbooks to find a matching workbook and project, then populates the specified view and writes its CSV content to a local file. The script uses the `tableauserverclient` library, with `TSC.Server`, `TSC.PersonalAccessTokenAuth`, `TSC.Pager`, and `server.views.populate_csv` to retrieve the data, and logs success or failure to `tableau2csv.log`.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 7341a6a9b561ea0d52ce422e6c2fb69f

This example shows how to programmatically export high-resolution images of Tableau workbook views, specifically filtering a view to display data for Belgium. The script uses the `tableauserverclient` (TSC) Python library to authenticate with a personal access token, iterate through workbooks, and locate a workbook named “Fiche Generator.” It then populates the workbook’s views, sets an image request option with high resolution and a filter on the “SelectedCountry” field, and saves each rendered view as a PNG file locally. The code demonstrates the TSC API’s `populate_image` method and `ImageRequestOptions` for customized view rendering.

Aantichaos
73% match
Loading thumbnail…

Gist ca337219d8bccaec5a6c0cd23b196863

This example shows a Windows batch script that automates Tableau Server maintenance by creating timestamped backups of logs, repository data, and configuration settings. The script uses the `wmic` command to generate a date-time string, then calls Tableau’s `tsm maintenance` and `tsm settings export` APIs to archive log files, perform a full backup, and export topology JSON. It finishes by invoking `tsm maintenance cleanup` to delete logs older than seven days. No visualization libraries are used; the output is purely file-based backup artifacts.

Aantichaos
60% match
Loading thumbnail…

Gist adad8e220a1e17f2d97fbabd7315d685

This example shows how to create a Tableau data extract from a shared expression table, mapping source columns `Name` and `Value` into a two-column table within the `tab` database. The code uses the Tableau `.tmsl` metadata format, specifically the `create` and `partitions` APIs, to define the table structure and pull data from the `#sections[main][SharedExpression]` expression. The table is named `SharedExpressionTable` and is built with a full data view, demonstrating how to programmatically generate a Tableau data model from an embedded expression source.

HHugoberry
56% match
Loading thumbnail…

Tableau con dos solapas

This example embeds a Tableau Public visualization of population data in an HTML page, displayed as a single chart without tabs despite the title referencing two. The code loads the Tableau JavaScript API (`viz_v1.js`) and initializes a `tableauViz` object with an 804x669 pixel canvas, enabling the toolbar and static image fallback. It renders the workbook named "Población" from a public Tableau server, with interactive transitions and overlay controls provided by the API. The visualization shows population statistics, though the underlying data source is not detailed in the code.

Aaaizemberg
55% match
Loading thumbnail…

Gist a24cfeae50d77b7826884907ab4659bb

This example shows a Tableau dashboard extension that displays the data from a worksheet named "articlelist" in an interactive HTML table. When the user changes a filter on that worksheet, the table reloads to reflect the updated data. It uses the Tableau Extensions API to access summary data and the DataTables jQuery plugin to render the table with features like fixed headers and row striping. The code listens for filter-changed events and re-populates the table dynamically.

Aantichaos
55% match
Loading thumbnail…

Activity 6

This example demonstrates a workflow for fetching and inspecting tabular data from a remote CSV file using D3 version 5 within a Vue framework. It begins by showing the first ten rows of the dataset in a formatted JSON structure, revealing the data's shape and content. The visualization relies on D3's `csv` function to load the data and the `select` API to target the HTML body for display, with raw SVG embedding a background image.

Iindushashi.g@gmail.com
54% match
Loading thumbnail…

Gist f43601b1f490d87ec6f8

This example shows a Python script that downloads a Google Spreadsheet as a CSV file and prints its rows. The code defines a `Spreadsheet` class and a `Client` class that handles authentication via Google’s ClientLogin API, using `urllib` and `urllib2` for HTTP requests and `re` for parsing the authentication token. It then fetches the spreadsheet’s contents through the Google Sheets export feed, specifying the format as CSV and a worksheet ID, and parses the result with the standard `csv` module. The script demonstrates a straightforward command-line workflow for accessing spreadsheet data programmatically.

Aandybak
54% match
Loading thumbnail…

Display table Students Dataset

This example displays a tabular view of a student dataset loaded from a remote CSV file hosted on GitHub. Using D3 v5, the code fetches the data with `d3.csv` and dynamically builds an HTML table by appending a header row with `Object.keys` and body rows with `Object.values`. The page structure includes a standalone `index.html` with a linked stylesheet, and the table is styled via CSS. The visualization demonstrates straightforward data import and DOM manipulation with D3 selections like `selectAll`, `enter`, and `append`.

Zzeyneb.mhamedi@gmail.com
54% match