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

Basic mode

Data Designer basic mode is meant for users with no database experience!
I hope this video helps especially those plugin users with no database experience to create their own database tables and use these tables in other plugin tools to publish and manage their data.
Are you new the database modelling? Start reading here…
Are you an experienced database developer? Read how the plugin can help you to execute SQL script files directly from the dashboard…
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-20
Introduction

6 Comments

  1. Hien Doan
    Hien Doan on 2021-03-10 at 7:42 pm

    I use Vietnamese and Chinese characters. I would like to create a lookup table with 2 fields, field 1 is the characters before : and field 2 is everything after the :
    I define both fields as varchar type but they don’t show up correctly. Is there a column type to display Vietnamese and Chinese characters?

    Here is the sample:
    Ác hoá 惡化: Biến thành xấu kém, trở thành xấu.

    Thanks,
    Hien Doan

    Reply
    • Peter Schulz
      Peter Schulz on 2021-03-12 at 1:47 pm

      Does anyone know this? I have absolutely no idea! Sorry Hien…

      Thanks,
      Peter

      Reply
  2. Amy
    Amy on 2021-10-08 at 4:19 pm

    I am struggling with the CREATE table command. It keeps telling me that I have improper SQL syntax. I admit to being very new, but from what I can tell I have good code (plus, I used the advanced designer to make it). So is my database wrong somehow? I put a query in at the support tab but hadn’t heard back yet and thought I would bug you here.

    Thanks

    Reply
    • Peter Schulz
      Peter Schulz on 2021-10-09 at 10:48 am

      Sorry my late reply Amy,

      I answered your email. Just didn’t come to it earlier. Thanks for being so patient and not giving up! 🙂

      Best regards,
      Peter

      Reply
  3. Peter de Pradines
    Peter de Pradines on 2022-03-18 at 3:01 pm

    It would be appreciated if your videos reflected the new interface layout. Those of us just joining are having to learn two different IDEs – one for work and another for learning [from the old videos]. Do you have plans to update these anytime soon, please? I have great hopes for this software.
    Best wishes, Peter
    Sent: 16:00m
    Friday 18 Mar 2022

    Reply
    • Peter Schulz
      Peter Schulz on 2022-03-19 at 8:17 am

      Good point Peter! 🙂

      Let me answer your question first:
      Yes, I do have plans to update the whole tutorial and demo sections. I absolutely see the need!

      There are some new features and changes on my to do list that I want to finish first. Otherwise we’ll have outdated tutorial after the updates again. Time is my constraint!

      To anyone reading this:
      Please contact me if you have the time, knowledge and skills to create WP Data Access tutorials. I can really use your help! A compensation is possible.

      Thank you for contribution Peter,
      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