anjanasilva

<p>WordPress Plugin to present a CSV file in a DataTable. This will import data from a CSV file and display in a DataTable.</p>
<h3>How To Use</h3>
<p>Insert following code snippet into any page or post using this shortcode, make sure you use an unique id :</p>
<pre><code>[aj-csv2dt src=http://e-innoving.com/samples/SacramentocrimeJanuary2006.csv id=datatable_id]
</code></pre>
<p>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.</p>
<pre><code>[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]
</code></pre>
<p>Save it, just refresh the page and see. Less hassle, all your csv data is inside the DataTable.</p>
<h3>Credits</h3>
<p>This plugin utilizes some excellent open source scripts, functions and images whose creators deserve to be recognized.</p>
<ol>
<li>Shaun Scovil, for inspiring me through his CSV to Sortable Plugin.</li>
<li>V.Krishn wrote a handy <a href="http://github.com/insteps/phputils" rel="nofollow ugc">PHP function</a> that enables users of PHP < 5.3 to utilize the <code>str_getcsv()</code> function that powers this plugin.</li>
</ol>
<h3>Common Errors</h3>
<ol>
<li>If the datatable misbehaves, this is probably due to an incorrect csv format. In that case, open csv file in excel<br />
and re-save it as a new csv. Most likely this will resolve your issue.</li>
</ol>


AJ CSV to DataTable

Wordpress Plugin to import data from a CSV file and display it in a DataTable.

rikemsen

<p>This plugin allows you to display the content of MySql tables into sortable html tables thanks to the DataTable jQuery Plugin.</p>
<p>You don’t need any configuration and once installed, it is ready to use.</p>
<p>Simply add the shortcode <code>[dbtable]</code> into an article or a page and you will have a nice and clean table.</p>
<h3>Examples:</h3>
<p>All parameters that contain more than one value have to be separated by commas without spaces.</p>
<p>Minimum needed : <code>[dbtable from=MysqlTableName]</code></p>
<ul>
<li><code>select=field1,field2,field3</code> will display all rows of the table and only specified fields</li>
<li><code>except=field1,field2,field3</code> will display all rows of the table except specified fields</li>
<li><code>cssClass=class1,class2</code> will add class1 and class2 to the class attribut of the table</li>
<li><code>comments=true|(false)</code> true will use comments specified in each field of the MySql table as datatable column names. If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.</li>
<li><code>pagination=true|(false)</code> will show/hide the bottom pagination links. If false, make sure you have the limit parameter large enough to display all your datas</li>
<li><code>limit=25</code> Display 25 rows by default.</li>
</ul>


AJ CSV to DataTable vs DbTable to DataTable