{"id":35392,"date":"2015-03-31T02:11:37","date_gmt":"2015-03-31T02:11:37","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/tabulate\/"},"modified":"2018-07-10T11:55:50","modified_gmt":"2018-07-10T11:55:50","slug":"tabulate","status":"closed","type":"plugin","link":"https:\/\/sl.wordpress.org\/plugins\/tabulate\/","author":34316,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"2.10.3","stable_tag":"trunk","tested":"4.9.29","requires":"4.7","requires_php":"5.6","requires_plugins":"","header_name":"Tabulate","header_author":"Sam Wilson","header_description":"","assets_banners_color":"ebc8b7","last_updated":"2018-07-10 11:55:50","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.bushheritage.org.au\/donatenow","header_plugin_uri":"","header_author_uri":"https:\/\/samwilson.id.au\/","rating":5,"author_block_rating":0,"active_installs":100,"downloads":21754,"num_ratings":8,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"":"<p>No special action needs to be taken to upgrade. Tabulate can be deactivated and\nreactivated without losing any data; if uninstalled, it will remove everything\nthat it&#039;s added (but you will be warned before this happens, don&#039;t worry).<\/p>\n\n<p>No custom database tables are modified during upgrade, activation, deactivation,\nor uninstallation.<\/p>\n\n<p>For more information,\nplease see <a href=\"http:\/\/tabulate.readthedocs.org\/en\/latest\/install.html\">the user manual<\/a>.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"8"},"assets_icons":{"icon.svg":{"filename":"icon.svg","revision":"1907045","resolution":"","location":"assets"}},"assets_banners":{"banner-772x250.png":{"filename":"banner-772x250.png","revision":"1347103","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.10.0","0.11.0","0.12.0","0.12.1","0.13.0","0.14.0","0.14.1","0.15.0","0.16.0","0.16.1","0.16.2","0.16.3","0.17.0","0.18.0","0.19.0","0.19.1","0.19.2","0.19.3","0.19.4","0.19.5","0.19.6","0.2.0","0.20.0","0.20.1","0.20.2","0.20.3","0.20.4","0.21.0","0.21.1","0.21.2","0.22.0","0.22.1","0.22.2","0.22.3","0.22.4","0.3.0","0.4.0","0.5.0","0.6.0","0.6.1","0.6.2","0.7.0","0.7.1","0.7.2","0.8.0","0.9.0","0.9.1","0.9.2","0.9.3","0.9.4","1.0.0","1.0.1","1.0.2","1.0.3","1.0.4","1.0.5","1.0.6","1.1.0","1.1.1","1.1.2","1.1.3","1.2.0","1.2.1","1.2.2","1.2.3","1.3.0","1.3.1","1.3.2","1.3.3","1.3.4","1.3.5","1.3.6","1.4.1","1.4.2","1.4.3","1.5.0","1.5.1","1.5.2","1.5.4","1.6.0","2.0.0","2.0.1","2.1.0","2.10.1","2.10.2","2.10.3","2.2.0","2.2.1","2.3.0","2.3.1","2.4.0","2.5.0","2.5.1","2.5.2","2.5.3","2.5.5","2.6.0","2.6.1","2.6.2","2.7.0","2.7.1","2.7.10","2.7.11","2.7.13","2.7.14","2.7.15","2.7.16","2.7.2","2.7.4","2.7.5","2.7.6","2.7.7","2.7.8","2.7.9","2.8.0","2.8.1","2.8.2","2.8.3","2.8.4","2.9.0","2.9.1","2.9.3","2.9.4","2.9.6","2.9.7","trunk"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1907055","resolution":"1","location":"plugin"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1907055","resolution":"2","location":"plugin"}},"screenshots":{"1":"The main screen of a single table, with provision for searching and navigating.","2":"The permission-granting interface. All roles are shown across the top, and\nall tables down the left side."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[56868,3524,19985,1627,1240],"plugin_category":[43,59],"plugin_contributors":[86542],"plugin_business_model":[],"class_list":["post-35392","plugin","type-plugin","status-closed","hentry","plugin_tags-crud","plugin_tags-data","plugin_tags-databases","plugin_tags-mysql","plugin_tags-tables","plugin_category-customization","plugin_category-utilities-and-tools","plugin_contributors-samwilson","plugin_committers-samwilson","plugin_support_reps-samwilson"],"banners":[],"icons":{"svg":"https:\/\/ps.w.org\/tabulate\/assets\/icon.svg?rev=1907045","icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/tabulate_ebc8b7.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/tabulate\/trunk\/screenshot-1.png?rev=1907055","caption":"The main screen of a single table, with provision for searching and navigating."},{"src":"https:\/\/ps.w.org\/tabulate\/trunk\/screenshot-2.png?rev=1907055","caption":"The permission-granting interface. All roles are shown across the top, and\nall tables down the left side."}],"raw_content":"<!--section=description-->\n<p><a href=\"http:\/\/tabulate.readthedocs.org\/en\/latest\/?badge=latest\"><\/a>\n<a href=\"https:\/\/travis-ci.org\/tabulate\/tabulate\"><\/a>\n<a href=\"\"><\/a>\n<a href=\"\"><\/a>\n<a href=\"https:\/\/wordpress.org\/plugins\/tabulate\"><\/a>\n<a href=\"\"><\/a>\n<a href=\"https:\/\/github.com\/tabulate\/tabulate\/blob\/master\/LICENSE.txt\"><\/a>\n<a href=\"https:\/\/scrutinizer-ci.com\/g\/tabulate\/tabulate\/?branch=master\"><\/a><\/p>\n\n<p>This plugin provides a simple user-friendly interface to tables in your database.\nSomewhat akin to phpMyAdmin, but easier to use and more focused on end users.<\/p>\n\n<p>The documentation can be found at <a href=\"https:\/\/tabulate.readthedocs.org\/\">tabulate.readthedocs.org<\/a>.<\/p>\n\n<p>Features (in no particular order):<\/p>\n\n<ol>\n<li>Tables can be filtered by any column or columns, and with a range of\noperators ('contains', 'is', 'empty', 'one of', 'greater than', 'less than',\nand the negations of all of these). Multiple filters are conjunctive\n(i.e. with a logical <em>and<\/em>).<\/li>\n<li>Access can be granted to <em>read<\/em>, <em>create<\/em>, <em>update<\/em>, <em>delete<\/em>, and <em>import<\/em>\nrecords in any or all tables. (This can be done by anyone with the\n<em>promote_users<\/em> capability.) Access can also be granted to <em>anonymous users<\/em>.<\/li>\n<li>CSV data can be imported, with the UI supporting column mapping, data\nvalidation, and previewing prior to final import. If an imported row has a\nvalue for the Primary Key, the existing row will be overwritten.<\/li>\n<li>Data can be exported to CSV, including after filters have been applied. <\/li>\n<li>A quick-jump navigation box is located top right of every page,\nand can also be added as a Dashboard widget.<\/li>\n<li>Records in tables with <em>date<\/em> columns can be viewed in a calendar.<\/li>\n<li>Entity Relationship Diagrams (drawn with <a href=\"http:\/\/graphviz.org\/\">GraphViz<\/a>)\ncan be automatically generated, with any specified subset of tables. Foreign\nkeys are displayed as directed edges. This feature is only available if the\n<a href=\"https:\/\/wordpress.org\/plugins\/tfo-graphviz\/\">TFO Graphviz plugin<\/a> is installed.<\/li>\n<li>All data modifications are recorded, along with optional comments that users\ncan provide when updating data.<\/li>\n<li>The <code>[tabulate]<\/code> shortcode can be used to embed tables, lists, row-counts,\nand data-entry forms into WordPress content. For more details,\n<a href=\"https:\/\/tabulate.readthedocs.org\/en\/latest\/shortcode.html\">read the documentation<\/a>.<\/li>\n<li>Tables with <em>point<\/em> columns can be exported to KML and OpenStreetMap XML.\nAlso, data entry for these columns is done with a small slippy map, on which\na marker can be placed.<\/li>\n<\/ol>\n\n<p>Development is managed on GitHub\nat <a href=\"https:\/\/github.com\/tabulate\/tabulate\">github.com\/tabulate\/tabulate<\/a><\/p>\n\n<!--section=installation-->\n<p>See <a href=\"http:\/\/tabulate.readthedocs.org\/en\/latest\/install.html\">tabulate.readthedocs.org\/en\/latest\/install.html<\/a><\/p>\n\n<!--section=faq-->\n<p>See <a href=\"https:\/\/tabulate.readthedocs.org\/en\/latest\/faq.html\">tabulate.readthedocs.org\/en\/latest\/faq.html<\/a><\/p>\n<dl>\n<dt>Installation Instructions<\/dt>\n<dd><p>See <a href=\"http:\/\/tabulate.readthedocs.org\/en\/latest\/install.html\">tabulate.readthedocs.org\/en\/latest\/install.html<\/a><\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<p>This is a reverse-chronologically ordered list of breaking or major changes to Tabulate.\nA full list of all changes can be found at (https:\/\/github.com\/tabulate\/tabulate\/commits\/master)<\/p>\n\n<ul>\n<li>November 2017: Version 2.10, removed dependency on the REST API plugin (which is not in core).<\/li>\n<li>January 2016: Version 2.5, introduced schema editing.<\/li>\n<li>October 2015: Version 2, switching to version 2 of the WP-API plugin.<\/li>\n<li>July 2015: Version 1, with basic functionality and after having\nbeen run for some months in a production environment by the plugin author.<\/li>\n<li>March to July 2015: Pre-release development.<\/li>\n<\/ul>\n\n<p>Prior to version 1, no changes were listed here (there were too many of them, and\nnothing was stable yet).<\/p>","raw_excerpt":"Manage relational tabular data using the full power of your MySQL database. CSV import\/export; access-control; foreign-keys; and lots more.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/35392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=35392"}],"author":[{"embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/samwilson"}],"wp:attachment":[{"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=35392"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=35392"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=35392"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=35392"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=35392"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/sl.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=35392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}