wpDataTables Settings

Video versionSee a video tutorial on configuring the plugin

Main settings tabSkin, data formats, and other primary plugin settings

Main settings option one

Interface language

wpDataTables comes with 45 worldwide languages for the main interface features (provided by jQuery DataTables internationalization). You can have the interface presented in your language by selecting it from this select box.
Only the main table features are covered in this language interfacing package. This means that table tools such as “Copy”, “Print”, “Excel”, etc., and advanced filtering labels aren’t translated, although you can translate them yourself if you wish.

Date format

This select box allows you to choose from 17 common date formats for use in the date columns, and for all responsive date pickers.

Time format

This select box allows you to choose between a 12H time format and a 24H time format. It will be used in the time column and for all time pickers.

Main settings option two

Base skin

wpDataTables has several built-in skins you can use to set the general look and feel of the table front-end. With this tab, you can choose one of them. (Aqua, Graphite, Material, Light, Purple, and Dark)

Aqua

Aqua skin for WordPress table

Light

Light skin for WordPress table

Purple

Purple skin for WordPress table

Graphite

Graphite skin for WordPress table

Material

Material skin for WordPress table

Dark

Dark skin for WordPress table

Number format

With this tab, you can choose the output format for the numbers – which sign to use for the thousands separator, and which sign to use for decimals.

Render advanced filter

With this tab, you can select the advanced filtering position when filtering is enabled – in a table header or footer (it is also possible to render filters in a form above the table, and this can be defined per table).

Tables sorting directions on the admin page

Here you can set sorting direction by ID for browsing tables and charts. By default is in ascending order.

Decimal places

This tab allows you to define how many decimal places the floats will have, so they’ll render in a similar manner. This setting can be overridden for specific columns.

CSV delimiter

Ever since wpDataTables v2.2.3, you can choose and set the CSV delimiter. wpDataTables recognize a comma ( , ) as a delimiter, but now you can import CSV files with different delimiters. Once you create a table go to Settings, choose the delimiter that matches the one in your file, click Apply and the plugin will recognize the delimiter and create a table.

Main settings options three

Tablet width

With this setting, you can redefine the width the plugin will recognize as the tablet width. It can be used to trigger the responsive mode on desktops as well – and set the width (to 1920 for example).

Mobile width

This setting allows you to redefine the width the plugin will recognize as the mobile device width.

Tables per admin page

This setting allows you to determine how many tables will be visible on the “Browse wpDataTables” admin page. This setting is also used for “Browse wpDataCharts”.

Align numbers to the right

If this checkbox is checked, all numbers will be aligned to the right in the table columns.

Main settings functions

Sum functions label, Average functions label, Minimum functions label, Maximum functions label

This is where you can set the labels that will be used for the Sum, Average, Minimum, and Maximum functions. If you leave these inputs blank, the default labels will be “Sum =”, “Avg =”, “Min =”, “Max =”

Prevent deleting tables in the database

You can choose whether you want to keep the tables after deleting the plugin from the Plugins page (by default the tables will be saved in the database after deleting the plugin).

Include full bootstrap front-end and back-end

If bootstrap.js is already included in one of the theme files it is recommended to uncheck this option. The unchecked option means that bootstrap.js is still included but in the no-conflict mode which should prevent errors.

Remove pages from the admin menu

If you don’t need “Gettings Started” and “Lite vs Premium” pages from the admin menu, you can check those options to remove them.

Separate database connection tabSeparate database connection

Enable this setting if you want to build tables using data from a database or host different from the one you use for your WordPress installation.

Do not check this checkbox if you want to use the WordPress database connection.

Separate database connection

From the 2.3 version of wpDataTables, there is an option to add more than one separate database connection. Now every table can have its own separate database connection, so tables can pull data from multiple databases and servers.

There are separate database connections for MySQL, MS SQL, and PostgreSQL databases.

Please note: in order to use MS SQL as your separate database connection the minimum required version should be MS SQL server 2012.

If you enable this switch, you’ll also need to provide the following data to be able to query the chosen database:

  • Connection Name: Set the connection name
  • Vendor: Pick vendor MySQL, MSSQL, or PostgreSQL
  • Name: The name of the database you intend to use.
  • Host: The address of the host, domain, or IP address.
  • Port: If you use a non-standard (different from 3306 for MySQL, 1433 for MSSQL, and 5432 for Postgre SQL ), you can define it here.
  • User: The username to be used for login.
  • Password: The password to be used for login.
  • Test DB settings: Use this button to check if your settings are correct.
  • Default Connection: You can choose which connection will be the default one.
  • Driver: You can choose a driver for your connection.
Table creation wizard in WordPress

If you successfully connected to your separate database, now when you create a new table you will have an option to choose which database will be used for creating the new tables.

Color and font settings tabConfiguring the plugin frontend design

Table global options
Other global table options

Here you’ll find a list of the settings that allow you to change the look of the tables rendered by the plugin. You can change:

 

  • Table font
  • Table font color
  • Header background-color
  • Header border-color
  • Header font color
  • Header active and hover color
  • Table inner border-color
  • Table outer border-color
  • Remove table borders
  • Remove header borders
  • Even row background-color
  • Odd row background-color
  • Hover row color
  • Cell color inactive (sorted) columns for even rows
  • Cell color inactive (sorted) columns for odd rows
  • Background color for selected rows
  • Buttons background-color
  • Buttons border-color
  • Buttons font color
  • Buttons background hover color
  • Buttons hover font color
  • Modals (popups used in the plugin) font color
  • Modals font color
  • Modals background-color
  • Overlay background color (a background below popups that overlays the site content when they appear)
  • Buttons hover border-color
  • Buttons and inputs border-radius (in pixels, if you wish to have them rounded)
  • Modals and overlay color
  • Pagination background-color
  • Pagination color
  • Pagination current page background-color
  • Pagination current page color
  • Pagination other pages hover background-color
  • Pagination other pages hover color

 

You will find a short explanation beside each style setting explaining which element it will change.

Custom JS and CSS tabConfiguring JavaScript and Stylesheets for the plugin

Custom JS and CSS fields

Custom wpDataTables JS

With this setting, you can define any custom JavaScript you executed on the pages that have wpDataTables; e.g. auto-refresh, or something similar.

Custom wpDataTables CSS

With this setting, you can define any CSS rules you applied to the pages that have wpDataTables. For example, hiding the search block, pagination, etc.

Use minified wpDataTables JavaScript

By default, the minified files are attached to the pages. You can uncheck this if you wish; for example, to modify the JavaScript – it’s much easier to edit the unminified files.

Google Spreadsheet settings tabConnect to Google Sheets API

Connect to Google Sheet API

Here you can connect with Google Sheet API. For detailed instructions on how to do that, please check this link.

Cache settings tabCaching data in non-server-side tables

cache-settings

Activation tabPurchase code information

Activation options for plugin

From the 2.5.1 version, there is a new tab Activation on the wpDataTables settings page, where you can enter your purchase code.

Purchase code

If you bought the plugin directly on our website, enter the TMS Store purchase code to enable auto-updates.

Envato API

If you bought the plugin on Envato (CodeCanyon), activate the plugin using Envato API to enable auto-updates.

Please note that the “Activation” tab isn’t available on the Lite version of the plugin.