WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search formimportsqlqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Table Settings
  • Column Settings
  • Search Settings
  • Geolocation Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Known limitations

  • Features that rely on ajax support are not available with the Blue Host plugin enabled. The Blue Host plugin generally blocks all ajax requests. Disabling the Blue Host plugin solves the issue.
  • If you add list tables or data entry forms to your web pages, you might get a 404 error for column names that interfere with reserved terms, your theme or other plugin parameters. Solution: rename your column. For example: rename column ‘name’ to ‘person_name’.
  • To support data entry and table bulk actions a table must have a primary key or a unique index.
  • Media items are not supported in data entry forms on web pages.
  • On activation the plugin creates a repository. If the plugin is networked activated on a multisite installation a repository is created for every blog. For blogs added later, the repository must be created manually (Plugin Settings > Repository).
  • WP Data Access uses plugin tables which are prefixed with $wpdb->prefix. If you change the WordPress database tables prefix after installing WP DAta Access, you’ll need to change the prefix of the WP Data Access table equally.
  • There is a limit on the file size for imports. The maximum file size depends on your installation. Read more…
  • Please make sure your WordPress date format is defined as “Y-m-d” if you want to make your date columns searchable in the Search Builder. Other date formats are currently not supported.
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2023-01-11
PatchesFAQ

14 Comments

  1. Mieke van Kooten
    Mieke van Kooten on 2019-10-16 at 6:19 am

    Hi Peter,
    Is it possible when entering multiple child-records to clear the entry form after entering each child? Instead of leaving the screen, returning to the list and push the add new button again.
    kind regards
    Mieke

    Reply
  2. Peter Schulz
    Peter Schulz on 2019-10-16 at 7:19 am

    Hi Mieke,

    Not sure if I understand your question correctly. The intended flow is as follows:
    – Click button Add New to insert a new child record
    – Enter child record
    – Save
    – Click button Back To List
    You need to repeat these steps if you want to add multiple child records.

    The reset button is to reset the form. Suppose you entered or changed some data and want to return to the old values, you click the reset button.

    If I understand your question correctly, you like the Add New button to be visible all the time? Is that right?

    Best regards,
    Peter

    Reply
    • Mieke van Kooten
      Mieke van Kooten on 2019-10-20 at 6:58 am

      Hi Peter,

      Yes, to see the add new button all the time would be a good solution.
      I thought that by pressing the reset button after saving my new child record, I could enter the next new child record. Clearing the values = returning to the old situation and because it is add new, it would be logical to be able to enter a new cild record.

      kind regards
      Mieke

      Reply
  3. Peter Schulz
    Peter Schulz on 2019-10-21 at 8:42 pm

    Hi Mieke,

    The buttons “Add New” and “Add Existing” for child rows are always visible in the next version (2.7.0) which I hope to publish this week. I see now how this has a positive effect on data entry. 😉 Thank you for your feature request!

    Best regards,
    Peter

    Reply
  4. pawan kumar
    pawan kumar on 2019-11-05 at 9:14 am

    Hi,
    I want to show, Only search data from search box by exact match.
    Can is it possible.
    Kindly help me.

    Reply
  5. Peter Schulz
    Peter Schulz on 2019-11-05 at 10:49 am

    Hi Pawan,

    Sorry, but the plugin uses wildcards in queries. I added your request to my to do list. See if I can add a feature for exact searching. I let you know if when is available.

    Best regards,
    Peter

    Reply
  6. Mark Hill
    Mark Hill on 2022-01-20 at 4:40 pm

    Can you confirm if I purchase Data Access on premium monthly for a number of months to improve our website, then cancel premium and go back to free version, would I loose any access to the tables or php code work I carry out in WordPress.
    In particular, I will build new tables, link to existing via query and display linked output on pages for visitors, what if anything would I loose by reverting back to free version of Data Access?
    It is the case that I am not absolutely sure this plugin will do everything I will need it to, but have to use Premium to confirm.
    Also can I use Premium single site in my sandboxed localhost as well as in Live, if all goes to plan with the same single site premium license?
    Many Thanks, and so far I have to say, this looks to be the best plugin I have come across for a lot of my requirements.

    Reply
    • Peter Schulz
      Peter Schulz on 2022-01-21 at 9:44 am

      Hi Mark,

      You will not lose any data when you switch from premium to free. The only difference is that some features will no longer be available in the free version. The premium version is free on localhost. You just a need a premium license for your public server.

      Hope this helps,
      Peter

      Reply
  7. Mark Hill
    Mark Hill on 2022-02-01 at 5:36 pm

    Peter,

    Thank you for the response.
    I have just purchased the Premium on a monthly basis for now, but activated it on the localhost first.
    Will there be any issues if I then use the same activation code on the public site?
    Thank you for the great application. Saves me a lot of time and effort with my work.
    Regards,
    Mark H

    Reply
    • Peter Schulz
      Peter Schulz on 2022-02-01 at 7:30 pm

      Hi Mark,

      Thank you for upgrading to premium!

      You can use an activation code on one system only. You can transfer your activation code anythime from here:
      https://users.freemius.com/store/2612

      The premium version is free on your localhost! Just activate it and use your premium activation code on your public server.

      Hope this helps,
      Peter

      Reply
  8. Matt
    Matt on 2022-11-22 at 3:32 pm

    Hello there,

    I have the premium plugin and am using the wpdadiehard shortcode in my pages.
    On the page/frontend I need users to be able to sort an ASC/DESC column with a lookup relationship but this sorting feature is disabled by default, how can I enable this on my page?

    Cheers!
    Matt

    Reply
    • Peter Schulz
      Peter Schulz on 2022-11-23 at 11:18 am

      Hi Matt,

      Sorting on child table columns should be available per default, but does not work with lookup columns. Is this your case?

      Thanks,
      Peter

      Reply
      • Matt
        Matt on 2022-11-26 at 3:04 pm

        Hello Peter,

        Yes, that is correct. I need to create a lookup relationship in some of my columns, but when I do that the sorting (that one that happens when you click in the with the name of the column) become inactive, the link to click is removed.

        It seems that the column lost the Javascript function in the , this one:

        Is there a way to keep the functionality using the lookup relationship in the column?

        Thank you,
        Matt

        Reply
        • Peter Schulz
          Peter Schulz on 2022-11-29 at 8:14 am

          Hi Matt,

          Sorting on lookup columns is currently not supported and there is actually no workaround. Sorry! But we added your request to our to do list. We need a little time to implement this. Hope to add it first quarter next year. Thanks for your contribution!

          Best regards,
          Peter

          Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved