WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search importsqlformqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Search Settings
  • Geolocation Settings
  • Table Settings
  • Column Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Export to PDF, CSV, Excel, SQL

Table of Contents
  • Inline demo
  • Extension Manager
  • Adding buttons manually
    • Explanation
    • Supported standard button types and their abbreviations
    • Adding row selection
    • Adding column selection
      • Add button to toggle columns from a list
      • Add a button for each column
  • Notes
The buttons extension allows premium users to export a data table to:
  • PDF
  • CSV
  • Excel
  • SQL (not added to the inline demo below)

Additional buttons are supported to:

  • Print a data table
  • Copy a data table to the clipboard
  • Toggle the visibility of specific columns (not added to the inline demo below)

Inline demo #

IDGenderDate Of BirthFirstnameLastnameAddressZipcodeCityCountyCountryEmailPhone NoRegistration Date
IDGenderDate Of BirthFirstnameLastnameAddressZipcodeCityCountyCountryEmailPhone NoRegistration Date

Extension Manager #

  • This is the simplest way to add buttons to a data table

Adding buttons manually #

Adding buttons manually gives us more control. Buttons can be added through advanced settings. Here is an example which adds the Excel, CSV and PDF export buttons to a data table.

{
	"dom": "Blfrtip", 
	"wpda_buttons": "CEF"
}
  • Adds export to CSV, Excel and PDF buttons to a data table
  • Options dom and wpda_buttons must be added to column table options advanced
  • Make sure column table options advanced contains valid JSON

    Explanation #

    • The B in { “dom”: “Blfrtip” } adds the buttons extension to the data table (case sensitive)
    • Characters CEF in { “wpda_buttons”: “CEF” } will add the standard buttons CSV, Excel and PDF (case insensitive)
    • Buttons are shown in the order they appear in option wpda_buttons

      Supported standard button types and their abbreviations #

        C = Export to CSV
        E = Export to Excel
        F = Export to PDF
        P = Print
        Y = Copy to clipboard
        S = Export to SQL
        V = Toggle column visibility – list
        T = Toggle column visibility – buttons

          Adding row selection #

            The previous example of export buttons will export all visible rows. Use option “select” to allow users to select specific rows to be exported:

            {
            	"select": {
            		"selector": "td:not(.dtr-control)",
            		"style": "multi" 
            	}
            }

            This option allows users to select rows. The row selection will be reflected in the export, print and copy actions.

            Adding column selection #

            Column selection is available from a list button or a toggle button per column. Use option wpda_buttons to add column selection.

            Add button to toggle columns from a list #

            {
            	"dom": "Bfrtip", 
            	"wpda_buttons": "V"
            }

            Add a button for each column #

            {
            	"dom": "Bfrtip", 
            	"wpda_buttons": "T"
            }

            Notes #

            • This option requires that the button extension is loaded (needs: “dom”: “Bfrtip”)
            • Toggle column visibility does not work when search and list boxes are added to the table header
            • Toggle column visibility is not reflected in SQL exports
            Share This Article :
            • Facebook
            • Twitter
            • LinkedIn
            • Pinterest
            Still stuck? How can we help?

            How can we help?

            Updated on 2023-01-14
            Print & copy buttons

            Submit a Comment Cancel reply

            Your email address will not be published. Required fields are marked *

            Table of Contents
            • Inline demo
            • Extension Manager
            • Adding buttons manually
              • Explanation
              • Supported standard button types and their abbreviations
              • Adding row selection
              • Adding column selection
                • Add button to toggle columns from a list
                • Add a button for each column
            • Notes

            Links

            Blogs
            Tutorials
            Demos

            Socials

            LinkedIn
            Twitter

            Get in touch

            Premium support
            Free support forum
            Contact us

            Resources

            WordPress plugin directory
            YouTube tutorials

            Passionate Programmers B.V. © 2017 - 2023 All rights reserved