New Module Data Table

[Spritemarkiv]

Data Tables  Current Version 0.7.6
     Data Tables
* This module creates easy to sort, filter and edit tables for you web pages. The Data stored in mysql using the Jquery plugins: DataTables by Allan Jardine and Jeditable by Mika Tuupola.
Features
* Table data is stored in the mysql database
* Completely front-end editable, using AJAX
* Easy to edit individual cells using the JQuery JEditable plug-in
* Only authorized users can edit the table
* Table is sortable, filterable, paginated
* Show/Hide individual columns
* Add/Delete Rows,Columns
* En,De,Fr translation(>=0.72 the jquery datatables plug-in now uses native translations in many languages).
* HTML code is parsed for images, heading, paragraph, link tags
* Data is exportable to Clipboard,Excel, CSV, and Print using the table tools plugin.

Tested on
* WB2.8.1

Known Issues
* Currently only one Datatable section per page.
* WB search does not find data
* "Modified when" doesn't update when table is modified
* Fixed Header behaves strange when Show/Hide Tools button is clicked.

I created this module because 2 of the websites I run have lots of information stored in WYSIWYG tables which cannot be easily
accessed by code snippets or droplets. With this module the table data is stored directly in the mysql database making the data accessible.

Version 0.4
* Uses jQuery UI to control the style.
* Now jQueryAdmin compatible
* Style changeable with jQueryAdmin themes
Version 0.5
* Setting added to the backend(EN only)
* Minor CSS tweeks
Version 0.6
* Fixed issue when used with a TABLE_PREFIX defined.
* Modified the editable_ajax.php file (attempt to help with older mysql versions. Removed mysql_free_results command.
Version 0.7
* Fixed issue some servers had with the code in editable_ajax.php file.
Version 0.7.1
* Upgrading to this version may need a complete reinstall.
* Upated DataTable Jquery Plugin to v 1.7beta2
* Added more options
1. Hide the id column
2. Fixed Header
3. Save State
* Fixed bug when a column was hidden the wrong cell was edited.
Version 0.7.2
* Added Feature data is exportable to Clipboard, Excel, CSV, and Print using the table tools plugin.
* The jquery datatables plug-in now uses native translations in many languages.
Version 0.7.4
*Better show/hide column tool
*Upated DataTable Jquery Plugin to v 1.7.4
Version 0.7.6
*Feed back when column is added or fails
*Upated DataTable Jquery Plugin to v 1.7.6

DownLoad at AMASP http://www.websitebakers.com/pages/modules/interaction/data-table.php

[Stefek]

Hello,
I installed the module but it doesn't seem to work.
However, interesting stuff.

Regards,
Stefek

[Spritemarkiv]

view.php line 38 should read ".....jquery.dataTab les.min.js......."

I just corrected this and reposed the zip

[Argos]

Sounds like a very useful module! But after install I just see an almost blank page, without editable settings or fields or any usable content. Clearly I miss something or the modules misses something...

[Spritemarkiv]

It sounds like you are almost there. I assume that your page looks like this DataTablesFreshPage .jpg attached
Next click on Show/Hide Tools (only visible if you are logged-in and athorized). DataTablesShowTools .jpg
Start adding empty rows and columns using the tools.
After you have the rows and columns the cells can be edited simply by clicking on them.

Of course I am making a lot of assumptions.

Let me know how it goes.

[Argos]

Ooooo, I was looking in the backend 
Now I see it's a frontend input. Ah! I'll try it now. Thanks for the screenshots.

[Spritemarkiv]

That's just how it should be. You however need to go to the frontend.  This page is front end editable.

..you got it before I could respond .

[Argos]

Although this might be a handy module in itself, I had misinterpreted it. I thought it was a module to edit existing WB tables, but it seems to be meant for creating and editing regular, visual tables.

Nice addition to the WB repository though!

[Spritemarkiv]

I've considered making an Admin tool that lets you edit all WB tables.  This could either be a great efficient way to update the data or, a quick way to muck things up.

[DarkViper]

 
... and a really great efficient and quick way to destroy your installation too.....   

[Spritemarkiv]

New Version out at AMASP

Version 0.4
* Uses jQuery UI to control the style.
* Now jQueryAdmin compatible
* Style changeable with jQueryAdmin themes

note: If you are using jQueryAdmin 1.0 please see http://www.websitebaker2.org/forum/index.php/topic,17705.msg120958.html#msg120958

[snark]

is it possible to start with no rows visible and only display the results from the filter option

[mr-fan]

hi if you use a other module or your mod needs this module you should make a

"precheck.php" file for your mod that checks if jQueryAdmin is installed _before_ someone install your mod!

more info in a german threat /(but code is still international) 

http://www.websitebaker2.org/forum/index.php/topic,14574.msg91956.html#msg91956

keep up your good work to improve this mod

regards martin

[Spritemarkiv]

DataTable is not dependent on jQueryAdmin. But if jQueryAdmin is installed then I take advantage of it.

Code:

if(file_exists(WB_PATH.'/modules/jqueryadmin/index.php')){ .....} else{.........}

So, I don't think I need this file for that reason.  I might need it later when I get a chance to test it on < WB2.8.

Thanks for the info. I hadn't found the precheck.php type file before, since it's not listed on the /example-module-hello-world.php page

[Spritemarkiv]

Snoork,

The ability to do what you want is not easily implemented.  Though shouldn't be impossible. It might be something for future development.

Thanks for the input

[sebulba]

Hi,

it doesn't function to me.
When i try to edit the cell, it doesn't save my entry and "click to edit" reappears.
Website version 2.81

Thank you for your help 

[Spritemarkiv]

It sounds like you are having trouble with the editable_ajax.php file not connecting properly to the mysql db.  I am using mysql 5.1.36, and haven't done any testing on older versions.  Are you using an older version?

Are you using a TABLE_PREFIX ? Look in the config.php file in your root directory line 8.

[sebulba]

Line 8 in config.php:

define('TABLE_PREFIX', '');


Version MySQL: 5.0.82sp1-log
... i can't change the version

Thank you 

[Spritemarkiv]

I'll look and see if there is something in the mysql versions.

I did look into the table prefix, there were some errors if used, but you wouldn't have gotten this far.

I'll keep you posted

[Spritemarkiv]

Hi sebulba,
I just uploaded a new version 0.6 at AMASP.  I have made some changes that might help.  I don't have the older version of mysql so I can't reproduce the bug. But from what I have read, these changes might help.

Give it a try and let me know if it helped.

[sebulba]

Thank you very much Spritemarkiv!!!

... but the problem still there

[Spritemarkiv]

I will look into finding an older version of xampp with your mysql version.  Of course at this point I am still assuming that its the mysql.  Something to play with anyway. 

[sebulba]

Ok Spritemarkiv
Thank you very much
 

[Spritemarkiv]

I have been doing some testing.

I have installed it on xampp v1.6.8(Oct. 2008) which has mysql v5.0.67 and set php version to 4.4.9 on an Windows XP sp3 system.  I then ran a clean install of WB 2.8.1 and DataTable v0.6.  So this set up(except for WB and Data Table) is several years out of date. And Data Table still worked.

Next, I tested for browser issues with this same setup.  I ran Chrome v5.0.375.55, Safari v4.0.5(531.22.7), and FF v3.6.3 and they all worked.  I then ran it on IE tester and it worked back to IE 6.  IE 5 would not work (JavaScript problems I think).

So, it would seem to be a pretty stable product, considering all the variables I just threw at it.

sebulba, I have to admit that at this point I don't know what the problem could be because I can't replicate the bug you reported.  If you want you could send me a copy of your phpinfo() via private message and I will keep exploring.  Is there any other Java Script on the page or in the template that might be causing the interference?

I was wondering if you could set up a public page with this for me to look at, but then I would need editorial rights to the page since the error occurs during that process.

[Spritemarkiv]

If anyone has been following this or comes across a problem like this in the future.  It was fixed in version 0.7.  There was an $array[] that was trying to be a string in the editable_ajax.php file line 70.  This caused an error only on some servers.