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

XML files

Table of Contents
  • PREPARATION
  • CREATION

XML files are supported, but require a very specific format: dataset > row > columns. Please scroll down for a valid XML sample.

To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.

PREPARATION #

Make sure your XML file is available from a public URL before you start the remote connection wizard. Test your public URL. Your URL should return the XML content only. (read more…)

CREATION #

  • Start the Data Explorer
  • Click the Connect icon to open the remote connection wizard
  • Select XML file from the Connection type drop-down list
  • Enter the public URL (see preparation) of your data file in the field File path
  • Define an Update interval or leave it blank if automatic updates are not required
  • Enter a Table name
  • Click the Create button
WP Data Access - Premium Data Services - XML connection wizard

XML sample #

<?xml version="1.0" encoding="ISO-8859-1"?>
<dataset>
  <row>
    <empno>7369</empno>
    <ename>SMITH</ename>
    <job>CLERK</job>
    <mgr>7902</mgr>
    <hiredate>1981-09-18</hiredate>
    <sal>1600.97</sal>
    <comm>10</comm>
    <deptno>20</deptno>
  </row>
  <row>
    <empno>7499</empno>
    <ename>ALLEN</ename>
    <job>SALESMAN</job>
    <mgr>7698</mgr>
    <hiredate>1981-02-21</hiredate>
    <sal>1680.98</sal>
    <comm>30</comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7521</empno>
    <ename>WARD</ename>
    <job>SALESMAN</job>
    <mgr>7698</mgr>
    <hiredate>1981-01-23</hiredate>
    <sal>1250.00</sal>
    <comm>500</comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7566</empno>
    <ename>JONES</ename>
    <job>MANAGER</job>
    <mgr>7839</mgr>
    <hiredate>1981-04-01</hiredate>
    <sal>2975.00</sal>
    <comm></comm>
    <deptno>20</deptno>
  </row>
  <row>
    <empno>7654</empno>
    <ename>MARTIN</ename>
    <job>SALESMAN</job>
    <mgr>7698</mgr>
    <hiredate>1981-09-28</hiredate>
    <sal>1250.00</sal>
    <comm>1400</comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7698</empno>
    <ename>BLAKE</ename>
    <job>MANAGER</job>
    <mgr>7839</mgr>
    <hiredate>1981-05-01</hiredate>
    <sal>2850.00</sal>
    <comm></comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7782</empno>
    <ename>CLARK</ename>
    <job>MANAGER</job>
    <mgr>7839</mgr>
    <hiredate>1981-06-09</hiredate>
    <sal>2450.00</sal>
    <comm></comm>
    <deptno>10</deptno>
  </row>
  <row>
    <empno>7788</empno>
    <ename>SCOTT</ename>
    <job>ANALYST</job>
    <mgr>7566</mgr>
    <hiredate>1982-12-09</hiredate>
    <sal>3000.00</sal>
    <comm></comm>
    <deptno>20</deptno>
  </row>
  <row>
    <empno>7839</empno>
    <ename>KING</ename>
    <job>PRESIDENT</job>
    <mgr></mgr>
    <hiredate>1981-11-17</hiredate>
    <sal>5000.00</sal>
    <comm></comm>
    <deptno>10</deptno>
  </row>
  <row>
    <empno>7844</empno>
    <ename>TURNER</ename>
    <job>SALESMAN</job>
    <mgr>7698</mgr>
    <hiredate>1981-09-08</hiredate>
    <sal>1500.00</sal>
    <comm></comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7876</empno>
    <ename>ADAMS</ename>
    <job>CLERK</job>
    <mgr>7788</mgr>
    <hiredate>1983-01-12</hiredate>
    <sal>1100.00</sal>
    <comm></comm>
    <deptno>20</deptno>
  </row>
  <row>
    <empno>7900</empno>
    <ename>JAMES</ename>
    <job>CLERK</job>
    <mgr>7698</mgr>
    <hiredate>1981-12-03</hiredate>
    <sal>950.00</sal>
    <comm></comm>
    <deptno>30</deptno>
  </row>
  <row>
    <empno>7902</empno>
    <ename>FORD</ename>
    <job>ANALYST</job>
    <mgr>7566</mgr>
    <hiredate>1981-12-03</hiredate>
    <sal>3000.00</sal>
    <comm></comm>
    <deptno>20</deptno>
  </row>
  <row>
    <empno>7934</empno>
    <ename>MILLER</ename>
    <job>CLERK</job>
    <mgr>7782</mgr>
    <hiredate>1982-01-23</hiredate>
    <sal>1300.00</sal>
    <comm></comm>
    <deptno>10</deptno>
  </row>
</dataset>
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-28
MS AccessPublic URL

Submit a Comment Cancel reply

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

Table of Contents
  • PREPARATION
  • CREATION

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