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

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
  • Search Settings
  • Geolocation Settings
  • Table Settings
  • Column 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

Errors and messages

Table of Contents
  • Receiving messages and errors via email
  • Understanding errors
  • Fixing errors

The result of each action on our data server is logged. The Messages icon in the toolbar is green when there are unread messages and red if there are unread errors. A widget appears as shown in the screenshot below to view your messages when you click the icon.

WP Data Access - Premium connection wizard message box

If an action was completed successfully, you’ll see a message of type INFO. If an action resulted in an error, you’ll a message of type ERROR. In this case, you need to take action.

Receiving messages and errors via email #

Errors are communicated through the Data Explorer (as mentioned above) by default. You can register your email address with your account if you prefer to get your messages via email. You should use this feature if you plan to use the automatic update feature for remote data files. Automatic updates run unattended. Receiving results via email helps to identify errors immediately and take action when necessary.

WP Data Access - Premium data warehouse

Understanding errors #

When a data file is updated, the synchronization process might run into an error. The question is not if that wil ever happen, but when it will happen.

Start reading the message provided with the error. In many cases the error message helpsto clarify and solve the issue. The error in the screenshot above indicates that the value for field Name (the second field in my CSV) on line 15 is too long. With this information I can check the value which is causing the issue and take appropriate actions.

Please be aware that the line number given with the error is not always correct. A CSV file usually contains a header line which is not counted as a row. In this case the issue is cause by a value on line 16, not 15.

Please get in touch if you are receiving errors you don’t understand.

Fixing errors #

I found the error mentioned in the previous section. When my table was created from my CSV file, the Name column was defined as char(6). A new Name value in my CSV file has a length of 10. It is too long to be stored in a char(6) field.

WP Data Access - Premium connection wizard

There are a number of ways to solve this issue:

  • Update the CSV file (mostly not really an option)
  • Drop the table and recreate it
  • Update the table so it allows me to store longer values in the Name column

There is nothing against option 2. You just need to be careful with other resources depending on this table. This works only if your new table has the exact same table and column names. Besides, this option may lead to downtime. Users will not be able to access your table from the moment you drop the old table and create the new one.

A more elegant way is to update the table definition (option 3). This option has no downtime as it uses the old CSV file until you fixed the issue. You can use the Query Builder to execute an alter table command if you are familiar with SQL. If you are not familiar with SQL, click the Manage link of the table returning the error and click the ALTER button. Your table will be loaded into the Data Designer, where you can change the length of the Name column. Enter a higher value in the Max length field of the Name column and click Save Table Design. You might give it some extra space for future updates. You might also change the column type to varchar for more efficient storage usage. After saving your changes, the column should be highlighted in orange. Click the ALTER TABLE button. This will change your Name column definition and allow longer values and remove the orange highlighting.

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-07
START HERELimitations

Submit a Comment Cancel reply

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

Table of Contents
  • Receiving messages and errors via email
  • Understanding errors
  • Fixing errors

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