Data Tables

These notes demonstrate the WordPress wpDataTables plug-in using a simple worksheet exported from Excel and which provides a simpler on-line alternative to traditional databases. Once imported into WordPress, the table is stored in the same MySQL database containing the WordPress application and, at the discretion of the site administrator, may be updated by nominated Users from within this page. Data can be imported from several sources but at this stage, it is NOT recommended to use Google Sheets as its data can only be updated from within Google Sheets and there can be a 15 minute time lapse before the data is presented to the web page. We have successfully created tables from Excel and CSV (comma separated variable) files and a wpDataTable using an MySQL query. Note that adding a sum in sum row for formula columns is not yet supported. Note that this data is NOT dynamic as it is snapshot images taken from our WordPress site.