wpDataTables Lite

Description

wpDataTables Lite is a basic version of a well-known premium table creator plugin. While some of premium features are cut, wpDataTables is still quite a handy tool which would allow you to quickly create interactive tables from a number of sources:

Tables are created in several very basic steps:

  1. You prepare the data source (for example the CSV file)
  2. You create a new wpDataTable in the WP-admin panel and upload your file
  3. You optionally configure the columns of the table (rename, reorder, hide, change colors)
  4. Paste the generated shortcode in your post or page (you can also use the TinyMCE button that plugin adds)

All tables will become sortable and will have pagination by default.
Additionally, each table will have a search bar, and can have “Copy to Clipboard”, “Export to CSV”, “Export to PDF”, “Export to XLS” functions.

Following column types are supported (most column types, except the images, have its own sorting rules):

Please note some limitations of the Lite version:

  1. Plugin will allow only tables up to 150 rows.
  2. MySQL-query based tables supprt is not included.
  3. Server-side processing for large tables is not included.
  4. Responsive mode for the tables is not included.
  5. Front-end editing is not included.
  6. Excel-like editing is not included
  7. Google Charts and HighCharts are not included.
  8. Table Constructor Wizard (step-by-step table generator) is not included.
  9. Access to our premium support system is not included.

You can get all of these features by purchasing the full version on plugin’s site.

Please note that plugin requires PHP 5.4 or newer!

Screenshots

  • Front-end table preview.
  • Back-end table editor preview.
  • Table preview from the back-end
  • Table browser example

Installation

Installation of the plugin is really simple.

  1. Upload the extracted plugin folder to the /wp-content/plugins/ directory of your WordPress installation, or upload it directly from your plugins section in the WordPress admin panel.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.
  3. That’s it!

FAQ

Installation Instructions

Installation of the plugin is really simple.

  1. Upload the extracted plugin folder to the /wp-content/plugins/ directory of your WordPress installation, or upload it directly from your plugins section in the WordPress admin panel.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.
  3. That’s it!
I added a table but see no sorting, filtering or pagination

Usually this happens when PHP version older then 5.4 is installed. Please first check this, and upgrade to PHP 5.4 – 5.6 if that’s the issue.

How to hide “Showing X of X entries” in pagination?

The easiest way to do this is to put this CSS block somewhere in your theme’s CSS file, or in inline CSS:
div.dataTables_info { display: none !important; }

If you wish to apply this code to all of your wpDataTables tables, you can put it in “Custom wpDataTables CSS” text area on wpDataTables Settings page,
or if you wish to apply it only on specific pages, you can put it in between style tags in for example html editor bellow tables short codes. E.g.

div.dataTables_info { display: none !important; }

How to disable opening links in a popup?

File that is responsible for rendering link columns is /source/class.link.wpdatacolumn.php
By opening that file you can see code for creating html anchor element with attribute “target=’_blank’”.
By changing ‘_blank’ value to ‘_self’ will cause link to open in same page instead of new window.

How to hide “Show X entries” block from pagination?

The easiest way to do this is to put this CSS block somewhere in your theme’s CSS file, or in inline CSS:
div.dataTables_length { display: none !important; }

If you wish to apply this code to all of your wpDataTables tables, you can put it in “Custom wpDataTables CSS” text area on wpDataTables Settings page,
or if you wish to apply it only on specific pages, you can put it in between style tags in for example html editor bellow tables short codes. E.g.

div.dataTables_length { display: none !important; }

Adding text before/after column values without affecting sorting

In wpDataTables table edit page in section ” Optional column setup”, for every table column there are text fields “Display text before” and “Display text after”.
Values from those text fields will be used for adding text before or/and after every cell content in a column.
This feature uses css for displaying entered text, therefore sorting of the columns will not be affected.

How to change display date format of a date column?

Display date format of a date column can be changed in wpDataTables Settings page from “Date format” drop-down menu.

How to change thousand and decimal separators for number columns?

This can be changed from “Number format” drop-down menu in the wpDataTables Settings page.

Reviews

A decent plugin

The plugin is quite a decent one for a free software. I ended up installing a paid version, because I needed more than 150 rows and MySQL-based tables, but for the testing purposes Lite was more than enough. Yes it does require a learning curve, but that’s merely because of broad functionalities provided with the plugin. I don’t understand why do other guys throw negative ratings just for the sake of it, there’s always space for criticism, but it doesn’t make wpDataTables lite a bad plugin in any way.

False Claims made

Don’t waste your time with this plugin. It is poorly written and the feature claims are unsupported!

SPECIAL FORMATTING FOR A LINK IS REQUIRED.
We only found this to be true after much digging through the documentation.
This means the claim of excel data importation is FALSE.
Your table “ALSO WILL NOT DIAL A PHONE NUMBER ON MOBILE”
THIS MAKES YOUR CLAIM OF RESPONSIVE DESIGN ALSO FALSE.
What a waste of time and money trying to use your poorly programed plugin!

once was good but has been reduced

Now that the wordpress community has tested the original WPdataTables plugin and dealt with bugs, they’ve removed a bunch of features from the original, renamed it Lite so they can sell those features back to you in the form of a Pro version.

Nice plugin

Nice plugin, though it does require some learning curve, after it’s done you can achieve really good results. After getting a better feel of a plugin I went ahead and purchased a full version of the plugin as there I can also use charts and create tables manually in WP

Read all 20 reviews

Contributors & Developers

“wpDataTables Lite” is open source software. The following people have contributed to this plugin.

Contributors

Translate “wpDataTables Lite” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

1.2.3

  • Security issues fixed for deleting and loading wpDataTable.

1.2.2

  • Security issues fixed for all save actions.

1.2.1

  • Compatibility with WP 4.7 approved
  • Problem with PHPExcel components resolved

1.2

  • DateTime column type added
  • Time column type added
  • Extended multisite support
  • Improved Settings page
  • Compatibility with WP 4.6.1 approved
  • Numerous bugfixes

1.1

  • Migrated Table Tools to use HTML5 instead of Adobe Flash
  • Advanced settings for configuring Table Tools (individually per button)
  • Wide tables can be configured to be horizontally scrollable
  • Upgraded used libraries
  • Compatibility with WP 4.5.2 approved
  • Numerous bugfixes

1.0

  • Launch of the Lite version