This feature is great for WordPress users who prefer to manage their tables with a spreadsheet program and publish them as professional responsive tables supporting several filter methods, sorting, styling and export formats. WP Data Access loads your CSV file into a database table and updates the table at configurable intervals, while you continue to maintain your table with your favourite spreadsheet program.
To use the remote connection wizard, you first have to enable our premium data service on your WordPress server.
PREPARATION #
Make sure your CSV file is available from a public URL before you start the remote connection wizard. Test your public URL. Your URL should return the CSV file content only. (read more…)
CREATION #
- Start the Data Explorer
- Click the Connect icon to open the remote connection wizard
- Select the CSV 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 blank if automatic updates are not required
- If your CSV file contains a header row these values will be used as column names, otherwise columns will be named: COL001, COL002, and so on
- You can change the default field delimiter if necessary
- Enter a Table name
- Click the Create button
USAGE #
- Use Data Tables to publish your table data
- Arrange your publication elements, enable interactive filtering and add export buttons
- Of course you can use this table in all other plugin tools as well
CSV Sample #
Empno,Name,Job,Mgr,Hiredate,Sal,Comm,Deptno
7369,"SMITH","CLERK",7902,"1981-09-18",1600.97,10,20
7499,"ALLEN","SALESMAN",7698,"1981-02-21",1680.98,30,30
7521,"WARD","SALESMAN",7698,"1981-01-23",1250.00,500,30
7566,"JONES","MANAGER",7839,"1981-04-01",2975.00,,20
7654,"MARTIN","SALESMAN",7698,"1981-09-28",1250.00,1400,30
7698,"BLAKE","MANAGER",7839,"1981-05-01",2850.00,,30
7782,"CLARK","MANAGER",7839,"1981-06-09",2450.00,,10
7788,"SCOTT","ANALYST",7566,"1982-12-09",3000.00,,20
7839,"KING","PRESIDENT",,"1981-11-17",5000.00,,10
7844,"TURNER","SALESMAN",7698,"1981-09-08",1500.00,,30
7876,"ADAMS","CLERK",7788,"1983-01-12",1100.00,,20
7900,"JAMES","CLERK",7698,"1981-12-03",950.00,,30
7902,"FORD","ANALYST",7566,"1981-12-03",3000.00,,20
7934,"MILLER","CLERK",7782,"1982-01-23",1300.00,,10
