Data Explorer

Posts under the "Data Explorer" category

Getting started

The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several...

Navigation

Show Data Explorer getting started page Show What's new? page (red if news is available, blue after reading) Starts the Data Designer Allows to (de)select listed columns Allows to upload SQL files (uploads ZIP files containing multiple SQL files if ZipArchive is...

Explore tables & views

The Data Explorer allows you to administer any table in your WordPress database. The following features are available: View, insert, update and (bulk) delete rows (List tables) (Data entry forms) Import (SQL and CSV) and export (SQL, XML, JSON, Excel and CSV) rows...

Manage tables & views

Click on the Manage link of a table or view on the Data Explorer main page to get access to table and view structures. Tables and views have different tabs and action buttons. Example of Table LayoutExample of View LayoutTabs Actions Available for tables and views....

Naming conventions

To manage database schemas, tables and columns, the plugin often generates HTML elements, CSS classes and JavaScript variables in the back-end with their original names. Unfortunately, MySQL, HTML, CSS and jQuery all have their own limitations, which can easily lead...