This page demonstrates the WordPress wpDataTables plugin using a snapshot of data from a worksheet exported from Excel, and which provides a simpler online 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.
RO-NO
TECH NO
WORK DT
SOLD HOURS
SOLD AMOUNT
OP-CODE
DESCRIPTION
165.993
638
02/01/2017
0,00
0,00
99
REPLACE LT REAR AXEL
165.993
638
02/01/2017
2,00
8.995,00
99
4-WHEEL ALIGNMENT
165.993
638
02/01/2017
24,00
39.345,00
99
REPLCAE LT REAR AXEL
167.596
26
02/01/2017
13,00
9.094,00
12-P31R
DIAGNOSE DRIVABILITY CONCERNS
167.596
26
02/01/2017
0,00
0,00
99P
MULTI POINT INSPECTION COMPLETED
167.596
26
02/01/2017
5,00
5.072,00
11S18B
11S18B REPLACE CLOCKSPRING TO DRIVE
167.596
26
02/01/2017
-5,00
0,00
MEMO
RECALL MOVED TO NEW RO
167.596
26
02/01/2017
0,00
0,00
GBATT
BATTERY CONDITION IS GOOD
167.596
26
02/01/2017
0,00
0,00
GBK
BRAKE LININGS ARE OK AT THIS TIME
167.596
26
02/01/2017
0,00
0,00
GTIRE
TIRE TREAD AND WEAR IS OK AT THIS T
167.674
723
02/01/2017
4,00
225,00
BSALEV
INSTALL LEVEL KIT
167.674
723
02/01/2017
0,00
0,00
BSAWHL
INSTALL A/M WHEELS
167.674
723
02/01/2017
2,00
6.999,00
99
ALIGNMENT
168.069
370
02/01/2017
75,00
575,00
WRKS
INTERVAL BUNDLE SERVICE WITH TIRE R
168.069
370
02/01/2017
0,00
0,00
GBATT
BATTERY CONDITION IS GOOD
168.069
370
02/01/2017
0,00
0,00
RBK
BRAKE LININGS REQUIRE IMMEDIATE REP
168.069
370
02/01/2017
0,00
0,00
GTIRE
TIRE TREAD AND WEAR IS OK AT THIS T
168.069
370
02/01/2017
0,00
0,00
NC
NO CHARGE
168.069
370
02/01/2017
0,00
0,00
99P
MULTI POINT INSPECTION COMPLETED
168.378
396
02/01/2017
0,00
0,00
HEAVY ENGINE
168.378
396
02/01/2017
0,00
0,00
NC
NO CHARGE
168.378
396
02/01/2017
0,00
0,00
99P
MULTI POINT INSPECTION COMPLETED
168.378
396
02/01/2017
0,00
0,00
NCW
NO CAR WASH!!!!
168.441
781
02/01/2017
0,00
0,00
Q2D
YOUR OPINION COUNTS!!! SURVEYS ARE
168.441
781
02/01/2017
0,00
0,00
QS
QUICK LANE EXPRESS SERVICE GUEST
168.441
781
02/01/2017
0,00
0,00
RELEC
ELECTRICAL SYSTEM REQUIRES IMMEDIAT
168.441
781
02/01/2017
0,00
0,00
RWIPER
WIPER(S) REQUIRES IMMEDIATE REPAIR/
168.441
781
02/01/2017
0,00
0,00
GBATT
BATTERY CONDITION IS GOOD
168.441
781
02/01/2017
0,00
0,00
GBK
BRAKE LININGS ARE OK AT THIS TIME
168.441
781
02/01/2017
0,00
0,00
GTIRE
TIRE TREAD AND WEAR IS OK AT THIS T
168.441
781
02/01/2017
1,00
9.883,00
MT
REPLACE SWAY BAR LINKS
168.441
781
02/01/2017
0,00
0,00
Q99P
QUICK LANE VEHICLE CHECK UP
RO-NO
TECH NO
WORK DT
SOLD HOURS
SOLD AMOUNT
OP-CODE
DESCRIPTION
IMPORTANT - The chart below is derived from the above table and should update automatically when the table values are changed. The table values can only be updated from a revised Excel worksheet. To change the chart type, you must update using wpDataCharts and after update, copy the shortcode to this page. This chart has been rendered using the chart.js render engine. Note that the three engines display different chart types and parameters, and follow data filtering must be selected to allow interactive update.
Experiment with the various icons and update the data table values to appreciate the value of this resource. For example, the columns icon in the administrator allows omission of columns from the display, or users can filter on any column by entering a filter value. Finally, click the Excel icon to download the updated table as an Excel spreadsheet.