{"id":69487,"date":"2017-05-30T08:36:01","date_gmt":"2017-05-30T08:36:01","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/wordpress-tables\/"},"modified":"2018-02-11T12:01:17","modified_gmt":"2018-02-11T12:01:17","slug":"wptables","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/wptables\/","author":15413269,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"1.3.9","stable_tag":"1.3.9","tested":"4.9.29","requires":"3.0","requires_php":"5.4","requires_plugins":"","header_name":"WordPress Tables","header_author":"Ian Sadovy<ian.sadovy@gmail.com>","header_description":"WordPress Tables plugin will add a support of responsive data tables to your WordPress site.","assets_banners_color":"c8eafa","last_updated":"2018-02-11 12:01:17","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/wpwebtools.com\/wptables\/donate\/","header_plugin_uri":"https:\/\/wpwebtools.com\/wptables\/","header_author_uri":"https:\/\/wpwebtools.com\/wptables\/","rating":4.4,"author_block_rating":0,"active_installs":800,"downloads":44365,"num_ratings":0,"support_threads":1,"support_threads_resolved":0,"author_block_count":0,"sections":["description","faq","changelog"],"tags":[],"upgrade_notice":[],"ratings":{"1":4,"2":0,"3":1,"4":4,"5":25},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":"1667301","resolution":"128x128","location":"assets"},"icon-256x256.png":{"filename":"icon-256x256.png","revision":"1667301","resolution":"256x256","location":"assets"}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":"1675472","resolution":"1544x500","location":"assets"},"banner-772x250.png":{"filename":"banner-772x250.png","revision":"1675472","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.0","1.0.1","1.1.0","1.2.0","1.2.1","1.2.10","1.2.2","1.2.3","1.2.4","1.2.5","1.2.6","1.2.7","1.2.8","1.2.9","1.3.0","1.3.1","1.3.2","1.3.3","1.3.4","1.3.5","1.3.6","1.3.7","1.3.8","1.3.9"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1766425","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1766425","resolution":"2","location":"assets"},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1766425","resolution":"3","location":"assets"},"screenshot-4.png":{"filename":"screenshot-4.png","revision":"1766425","resolution":"4","location":"assets"},"screenshot-5.png":{"filename":"screenshot-5.png","revision":"1766425","resolution":"5","location":"assets"},"screenshot-6.png":{"filename":"screenshot-6.png","revision":"1766425","resolution":"6","location":"assets"}},"screenshots":{"1":"Visualise your data in the table","2":"Admin &gt; Adding new table","3":"Admin &gt; Managing the table","4":"Admin &gt; Editing table data","5":"Admin &gt; All tables list","6":"Admin &gt; Table live preview"}},"plugin_section":[],"plugin_tags":[21172,59157,147425,147424,1240],"plugin_category":[59],"plugin_contributors":[141759],"plugin_business_model":[],"class_list":["post-69487","plugin","type-plugin","status-closed","hentry","plugin_tags-csv-to-table","plugin_tags-data-tables","plugin_tags-excel-table","plugin_tags-mysql-to-table","plugin_tags-tables","plugin_category-utilities-and-tools","plugin_contributors-iansadovy","plugin_committers-iansadovy"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/wptables_c8eafa.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-1.png?rev=1766425","caption":"Visualise your data in the table"},{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-2.png?rev=1766425","caption":"Admin &gt; Adding new table"},{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-3.png?rev=1766425","caption":"Admin &gt; Managing the table"},{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-4.png?rev=1766425","caption":"Admin &gt; Editing table data"},{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-5.png?rev=1766425","caption":"Admin &gt; All tables list"},{"src":"https:\/\/ps.w.org\/wptables\/assets\/screenshot-6.png?rev=1766425","caption":"Admin &gt; Table live preview"}],"raw_content":"<!--section=description-->\n<p>Need to insert a table into your page or post? WordPress Tables plugin will take your data in CSV\/JSON format or directly from MySQL table and create an interactive data table. With WPTables plugin, you can easily create and manage your tables from the WordPress administration. Simply insert a shortcode into your page, article or post, and you are ready to go. That\u2019s it! Enjoy your new table.<\/p>\n\n<p><a href=\"https:\/\/wpwebtools.com\/wptables\/demo\/\">DEMO<\/a> | <a href=\"https:\/\/wordpress.org\/support\/plugin\/wptables\">SUPPORT<\/a> | <a href=\"https:\/\/wordpress.org\/support\/plugin\/wptables\/reviews\/\">REVIEWS<\/a> | <a href=\"https:\/\/wpwebtools.com\/wptables\/\">WEBSITE<\/a><\/p>\n\n<p>WP Tables plugin\u2019s main features are:<\/p>\n\n<ul>\n<li>Inserting data using powerful spreadsheet editor<\/li>\n<li>Importing data from CSV and JSON files<\/li>\n<li>Showing data directly from MySQL database: by selecting a table or writing custom SQL query<\/li>\n<li>Changing column titles, order and visibility<\/li>\n<li>Number formatting<\/li>\n<li>Sorting alphabetically and numerically<\/li>\n<li>Pagination with options<\/li>\n<li>Configurable width and height<\/li>\n<li>Exporting created table to CSV file<\/li>\n<li>6 predefined color themes<\/li>\n<li>Supporting shortcodes from other plugins inside the table<\/li>\n<li>Supporting links and images<\/li>\n<\/ul>\n\n<p>After installing the plugin, tables are created in few very basic steps:<\/p>\n\n<ul>\n<li>Navigate to the `WPTables` menu in the WordPress administration dashboard<\/li>\n<li>Click `Add New Table` and enter a name for the new table <\/li>\n<li>Choose a data source format and insert your data (for example the CSV file)<\/li>\n<li>After importing the data, you can edit table fields and other options<\/li>\n<li>Copy and paste the generated shortcode into your page or post (you can also use a button in the WordPress text editor to insert a table)<\/li>\n<\/ul>\n\n<!--section=faq-->\n<dl>\n<dt>How to change table width\/height?<\/dt>\n<dd><p>Width of the table is 100% by default. Height is auto. But you can override these parameters by modifying a shortcode as following: \n    [wp_table id=\"77\" width=\"640px\" height=\"480px\"]<\/p><\/dd>\n<dt>How to format numbers?<\/dt>\n<dd><p>You can define a custom number format for columns with type <code>Number<\/code>.\n1. In the WordPress administration open the table for editing.\n2. In the Fields section find the necessary field and make sure that the type is <code>Number<\/code>\n3. You will see the Formatting button next to the Type drop-down.\n4. Set the desired format and click <code>Apply<\/code>.<\/p><\/dd>\n<dt>How to add currency symbol to values?<\/dt>\n<dd><ol>\n<li>In the WordPress administration open the table for editing.<\/li>\n<li>In the Fields section find the necessary field and make sure that the type is <code>Number<\/code><\/li>\n<li>You will see the Formatting button next to the Type drop-down.<\/li>\n<li>Add currency symbol to the format (i.e. '$0,0.00').<\/li>\n<li>Click <code>Apply<\/code>.<\/li>\n<\/ol><\/dd>\n<dt>How to set link text?<\/dt>\n<dd><p>With <code>Link<\/code> field type you can use <a href=\"https:\/\/github.com\/adam-p\/markdown-here\/wiki\/Markdown-Cheatsheet#links\">Markdown syntax<\/a> to set the link text.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>VERSION 1.3.9<\/h4>\n\n<ul>\n<li>Added abitity to assign HTML ID to the table in the shortcode using <code>html_id<\/code> attribute.<\/li>\n<li>Fixed the issue with exporting tables that are created using MySQL query.<\/li>\n<li>Fixed the issue with exporting tables that contain characters like Chinese or Korean.<\/li>\n<li>Fixed the issue with exporting column names insted of titles.<\/li>\n<li>WordPress 4.9.4 support.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.8<\/h4>\n\n<ul>\n<li>Fixed the issue with MySQL when correct (but empty) query results \"Invalid query. Please check the syntax and try again.\" error.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.7<\/h4>\n\n<ul>\n<li>Added support for variables in the MySQL queries.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.6<\/h4>\n\n<ul>\n<li>Allow Editors to access WPTables.<\/li>\n<li>WordPress 4.9.2 support.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.5<\/h4>\n\n<ul>\n<li>Fixed the issue when table appears at the top of the page.<\/li>\n<li>Added compatibility with LABJS.<\/li>\n<li>Added compatibility with shortcodes plugins.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.4<\/h4>\n\n<ul>\n<li>Fixed the issue when jQuery is loaded in the footer.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.3<\/h4>\n\n<ul>\n<li>Fixed the issue with MySQL queries.<\/li>\n<li>Fixed the issue with removing rows.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.2<\/h4>\n\n<ul>\n<li>Added support for custom MySQL queries.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.1<\/h4>\n\n<ul>\n<li>Fixed horizontal alignment.<\/li>\n<li>Fixed mixing up tables with other post types.<\/li>\n<li>Fixed the issue with Unicode symbols.<\/li>\n<\/ul>\n\n<h4>VERSION 1.3.0<\/h4>\n\n<ul>\n<li>Brand new admin UI with drag'n'drop file import and much more.<\/li>\n<li>Brand new powerful data editor for imported files, including CSV and JSON.<\/li>\n<li>Support of importing JSON data.<\/li>\n<li>Improved CSV parsing.<\/li>\n<li>Adding\/removing new columns.<\/li>\n<li>Search and bulk actions for created tables.<\/li>\n<li>Cloning tables.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.10<\/h4>\n\n<ul>\n<li>Improved MySQL support: now it is possible to load data from any database that is available for the DB user, not only WP tables.<\/li>\n<li>WordPress 4.9 support.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.9<\/h4>\n\n<ul>\n<li>Fix fatal error on PHP &lt; 5.5.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.8<\/h4>\n\n<ul>\n<li>Added support for custom currency symbols in number formatting.<\/li>\n<li>Fixed the issue with saving table updates.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.7<\/h4>\n\n<ul>\n<li>Fixed compatibility with FancyBox library prior version 3.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.6<\/h4>\n\n<ul>\n<li>Fixed the issue with adding new table using CSV\/MySQL.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.5<\/h4>\n\n<ul>\n<li>Added support for custom number format (decimal places, thousand separator, currency symbol, percent, etc.).<\/li>\n<li>Added support for links inside the table.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.4<\/h4>\n\n<ul>\n<li>Added support for shortcodes inside the table.<\/li>\n<li>Fixed issue with missing sort icons.<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.3<\/h4>\n\n<ul>\n<li>Added support for Unicode characters.<\/li>\n<li>Fixed issue with an apostrophe (').<\/li>\n<\/ul>\n\n<h4>VERSION 1.2.2<\/h4>\n\n<p>Fixed CSV parsing with dots in column names.<\/p>\n\n<h4>VERSION 1.2.1<\/h4>\n\n<p>Fixed editing HTML-like data.<\/p>\n\n<h4>VERSION 1.2.0<\/h4>\n\n<p>Added 6 predefined color themes.<\/p>\n\n<h4>VERSION 1.1.0<\/h4>\n\n<p>Added a \"manual\" mode for creating tables. It is possible now to edit the data in a spreadsheet-like interface.<\/p>\n\n<h4>VERSION 1.0.1<\/h4>\n\n<p>Added help and about sections.<\/p>\n\n<h4>VERSION 1.0.0<\/h4>\n\n<p>Initial version where most features are ready and pretty stable.<\/p>","raw_excerpt":"Create, manage and design interactive tables without writing any code. Sorting, paging, formatting and lot more options.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/69487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=69487"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/iansadovy"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=69487"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=69487"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=69487"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=69487"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=69487"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=69487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}