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.
Wordpress Plugin to present a CSV file in a DataTable. This will import data from a CSV file and display in a DataTable.
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.
- Install and activate the plugin via
WP-Admin > Plugins. - Add shortcode to a post or page:
[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id].
This plugin utilizes some excellent open source scripts, functions and images whose creators deserve to be recognized.
- Shaun Scovil, for inspiring me through his CSV to Sortable Plugin.
- World renowned DataTables Library by Allan.
- V.Krishn wrote a handy PHP function that enables users of PHP < 5.3 to utilize the
str_getcsv()function that powers this plugin.
Please visit this page for a realtime example.
- 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.
- Added options to disable DataTable searching, pagination, sorting and showing of bInfo.
- First public release.