Data Explorer

Posts under the "Data Explorer" category

Import file too large

PROBLEMThe message "ERROR: File upload failed" usually means that you are trying to import a file which is too large. Although the plugin checks the file size against your "upload_max_size" settings there are other settings which might cause problemsEASY SOLUTIONSThe...

InnoDB #rows estimation

If you start the Data Explorer from the WP Data Access menu, you'll see the list of tables in your WordPress database. The column #Rows shows the number of rows in the corresponding table. This number is a rough estimate of the number of rows (records) for InnoDB...

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...

Dashboard Menus

This feature allows admin users to add fully functional list tables and data entry forms for a database table to their own WordPress dashboard menu, as well as the dashboard menu of non-admin users. This is the simplest way to create data entry forms.Menu name - The...

Dynamic Hyperlinks

A dynamic hyperlink is a computed column generated on the fly. Column variables can be added to a hyperlink and are substituted on generation. Allows to add custom HTML (see icons in example below – click to enlarge).Adding dynamic hyperlinksHyperlink Label - Column...

Column Settings

WP Data Access > Data Explorer > Manage > Settings > Column Settings Column labels Column types (images, audio, video, attachments, hyperlinks) Inline editing (edit table data in an Excel like manner) Column LabelsColumn labels are automatically used...

Table Settings

WP Data Access > Data Explorer > Manage > Settings > Table Settings Row count (use estimation to improve performance) Row level access control (to improve security) Process hyperlink columns Row countTables are using pagination by default. Although...

Geolocation Settings

WP Data Access > Data Explorer > Manage > Settings > Geolocation SettingsFeatures Google Maps integration Map geolocation data to custom tables Run batch updates Generate maps from custom tables Add customizable markers Use user location on map Radius...

Search Settings

WP Data Access > Data Explorer > Manage > Settings > Search Settings Normal search Fulltext search Defining queryable columns Individual column search Search engine like search Indexes and performanc The premium version of WP Data Access offers a number of...

Run SQL script files

Button Import data/Execute script(s) can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper privileges (works...