Wordpress Plugin to present a CSV file in a DataTable. This will import data from a csv file and display in a DataTable.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
css
img
js
lib
nbproject
AJ-CSV-to-DataTable.zip
LICENSE
README.md
aj-csv-to-datatable.php
readme.txt

README.md

AJ CSV to DataTable

Contributors: anjanasilva Tags: data, table, csv, import, datatable Requires at least: 4.3.1 Tested up to: 4.7.5 Stable tag: 4.7

Import data from a CSV file and display it in a DataTable.

Description

Wordpress Plugin to present a CSV file in a DataTable. This will import data from a CSV file and display in a DataTable.

How To Use

Insert following code snippet into any page or post using this shortcode, make sure you use an unique id :

[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id]

You can now disable DataTable search, pagination, sorting and displaying of bInfo with the recent 1.1 release. The purpose of this is to render a static looking HTML Table out of a CSV file.

[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id disable_search=true disable_paging=true disable_binfo=true disable_sorting=true]

Save it, just refresh the page and see. Less hassle, all your csv data is inside a DataTable now.

Installation

  1. Install and activate the plugin via WP-Admin > Plugins.
  2. Add shortcode to a post or page: [aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id].

Credits

This plugin utilizes some excellent open source scripts, functions and images whose creators deserve to be recognized.

  1. Shaun Scovil, for inspiring me through his CSV to Sortable Plugin.
  2. World renowned DataTables Library by Allan.
  3. V.Krishn wrote a handy PHP function that enables users of PHP < 5.3 to utilize the str_getcsv() function that powers this plugin.

Demo

Please visit this page for a realtime example.

Common Errors

  1. If the datatable misbehaves, this is probably due to an incorrect csv format. In that case, open csv file in excel and re-save it as a new csv. Most likely this will resolve your issue.

Changelog

1.1

  • Added options to disable DataTable searching, pagination, sorting and showing of bInfo.

1.0

  • First public release.