Demos
Collated list of demos featuring plugin features
Data Tables
Show Demo List for Data Tables
- Flat Data Table
- Responsive Data Table
- Free styling
- Premium styling
- SEO friendly data tables
- Export buttons
- Search Panes
- Search Builder
- Search form
- Advanced search
- Google Maps integration
- Data Table using GPS
- Responsive Master-Detail
- Master-Detail
- Server-side row grouping
- Client-side row grouping
- Static hyperlinks
- Dynamic hyperlinks
- Media library integration
Data Apps
Data Projects is a tool that allows plugin users to build data management pages for back-end and front-end usage. Projects are table based. Pages are generated on the fly. Database constraints and triggers are integrated automatically. Transaction levels can be added using WordPress roles.
Show Demo List for Data Apps
Geolocation
With geolocation your users can search places stored in a database table. The users position or a fixed position can be used to search within a range. An interactive map allows your users to change the range from a dropdown list. The plugin needs a Google Maps API to retrieve the geolocation information and stores this information in a database table for fast access.
Show Demo List for Geolocation
Charts
Charts can be added to dashboards and webpages. It is also possible to embed charts on external web pages.
I’ve got the WP Data Access plugin installed, and I’ve managed to create a table and display the shortcode so that it shows on the test sample page. However, how do I get data into those tables? I have a lot of data in many different excel spreadsheets. So I was looking at a way to potentially take the data from excel and import it into these WP data access tables, or at least manually enter it in. What I am trying to do is essentially have a portal where our employees can collaborate more efficiently to update company records/site addresses/internet service provider accounts, etc.
Hi John,
You can export your Excel data to CSV (save as) and use the plugin to import your CSV data into your database table. The CSV import is available from the Data Explorer main page. Here is a link to a tutorial for CSV imports:
https://wpdataaccess.com/docs/data-explorer-manage/imports-sql-csv/
Hope this helps,
Peter
Hi Peter,
i want to build a database for marketing, so i need some sums for columns after a search. For example: 34.000 people over 50 in Lyon, 345.000 in Paris and so on. Is it possible with a trick – or must i do an export to CSV for Excel to count?
I need a plugin like yours to generate several reports.
Thank you in advance.
Rgds. Jaques
Hi Jaques,
I am actually working on an update which supports row grouping. Not sure if this fits your needs, but here is a demo:
https://wpdataaccess.com/row-grouping-client-side/
This demo uses client side processing which first loads all the data into the browser and allows the user to search and reorder afterward. This is what you need. Please be aware that loading all your table data into the browser is not possible if your table contains – for example – a million rows. For large tables you’ll need the server-side solutions:
https://wpdataaccess.com/row-grouping-demo/
The server side solution however does not support reordering after the page load.
This feature is new. Is is not yet available in the current release. I hope to update asap…
Thanks,
Peter
How are ancient dates managed (eg 01/01/1500)?
The date time picker changes the dates to (30/11 / -0001 00:00).
Looks like a bug Alessandro. It works with format Y-m-d. It does not work with your format. I need to investigate this issue and hope to fix it with the next update. Can you temporarily switch to format Y-m-d?
Thanks,
Peter
very useful demos. Please suggest how we can have a dropdown list for data entry through the “project templates” design. Thanks
Good point! Never realized this was missing…
There are three ways to add a dropdown list:
(1) Add a lookup
(2) Use data type enum
(3) User data type set
(1) A lookup of type listbox will automatically add a dropdown list. This is explained here:
https://wpdataaccess.com/docs/project-templates/relationships/
Please follow the links for more info. If your lookup table contains a large number of rows I advice to use the autocomplete instead of the listbox. This increases performance.
(2) The plugin also automatically adds a dropdown list for columns of data type enum.
(3) Like enum the plugin automatically adds a dropdown list for columns of data type set. The difference is that a set allows users to select multiple values. The first two options do not support multiple selections.
The first option is a dynamic option. When you add a record to the lookup table it will show up in the dropdown list. The second and third options are static option. Values are stored in the table definition. To change the list, you need to change your table definition.
We are currently working on a completely new website which we hope to launch next week or the week after. I will add a new page to the documentation covering this issue. I see the need!
Merry Christmas
Peter
Hi. Im trying to display some essays captured in a table, then those essays must be graded by a 6 different moderators. the grades must be recorded in the same table, in a respective moderator column. Once I show the essays now I need an empty field in order to be filled by the moderators. Is there a functionality do do that? The grades are numbers from 1 to 5 in 6 different rubrics. hope you can help, thank you!
Hi Rodrigo,
Sorry for my extremely late reply. I had some deadlines to catch…
I think you can do this with a Data Project. Hope I understand your question correctly!
I presume the grade table has a lookup column to the essay table? When you add the lookup to a Project Template you can show the essay along side with the grade. The user just needs to select the grade for each selected essay. Here is an screenshot of a grading page for the online Student Adminstration System demo: https://ibb.co/PZJfBk6
The demo actually does the same for grading students. Please be aware that you need a premium license to enable inline editing. You can also do without inline editing but that requires your users to edit each essay separately.
If each moderator has access to his own grades only, you need to create a template for each moderator group and make sure they get access to the their specific template only. This is explained here:
https://wpdataaccess.com/docs/data-apps-advanced-features/user-roles-and-where-clauses/
https://wpdataaccess.com/docs/data-apps-advanced-features/managing-roles-and-user-access/
Enabling inline editing for a column is just a matter of enabling it as explained here:
https://wpdataaccess.com/docs/data-explorer-settings/column-settings/
Hope this helps,
Peter
Hi Again.. just trying to be more accurate, in this link
https://congresoamcico.org.mx/wp-content/uploads/2023/02/califictl-1.jpg
I set the screem the imagine of how I need to show the data. There should be more fields on the screen but just made this for the example. So once the moderators enter with the proper access keys, then they sould put the grades on the 10 classes on the dropdown boxes, then make the sum and send the total to the general Table. Once they send the grade then keep navigating through the rest of the works and do the same. One plus could be the recording session, where the moderator could enter one day and grade 20 Works, and next day could enter and get right to the las work he left graded. Hope I explained myself. thank you!!!
Hi Rodrigo,
For such a data entry page you need to create a grade table that holds all the different grades and create a project page for it. When the moderator presses the edit link for a specific student, all grades can be entered. Enum columns and lookups will be converted to drop down lists automatically.
But there is no standard feature to add a summary field. You’ll need to add custom code using the wpda_before_simple_form and wpda_after_simple_form filters as explained here:
https://wpdataaccess.com/docs/hooks-and-filters/hooks-and-filters/
Best regards,
Peter
Ok thank you Pete, for all orientation, just one detail I left. The categories must be showed just in the form but actually I don’t need to save the grade of each separately, just the sum of all as the final grade to save in the table. Just need to arrange the drop downs to make the sum on the form, and save that grade in the respective field of each work in order to have just one table and make it easier to manage.
Please, sorry if I don’t explain myself good.!
Thank you Pete!