Table tools v2 copy/xls/csv/pdf dont work

bocode

Hi I just downloaded the table tools v 2 and followed all the documentation to plug it/customize it on my site. Unfortunately only the print button is working and the other 4 buttons are not working. I looked in firefox error console
and i see the following error:

Error: uncaught exception: Unable to load SWF file - please check the SWF path

and am getting this error as well:

b is null
Source File: http://localhost/shlk/js/jquery.dataTables.min.js
Line: 61

I looked at the datatables website and buttons there work properly when accessed from my browser (i can save pdf, csv, xls, and copy to clipboard).

Any ideas?
Bo

4giedrius

Set path to .swf file.

[code] "oTableTools": {
"sSwfPath" : "media/swf/copy_cvs_xls.swf"
}[/code]

bocode

Hi 4giedrius,

This is a given, and i did set this path before i started using TT. BTW the problem is coming from tabletools.js file from the zeroclipboard code. I copied ZeroClipboard.swf in all the places i can think of but still it does not seem to work.

Only print preview is working rest of the buttons dont.

am lost for any logical explanation :-(

allan

It is as 4giedrius suggests I think :-). You mentioned ZeroClipboard.swf, but the default TableTools 2 files are called copy_cvs_xls.swf and copy_cvs_xls_pdf.swf. What SWF path are you using? Is it relative or absolute?

Allan

bocode

Hi Allan,

I've set the path of copy_cvs_xls_pdf.swf properly and that does not seem to pose any problem. I'm referring to this piece of code in TableTools.min.js


var ZeroClipboard={version:"1.0.4-mod",clients:{},moviePath:"ZeroClipboard.swf",


The path i set in my tabletools initialization code is as follows:


"oTableTools": {
"sSwfPath": "/abc/swf/copy_cvs_xls_pdf.swf",
"aButtons": [ "copy", "csv", "print" ]
},


The path, as you can i see, is absolute and it is reachable.

Thank you
Bo

allan

As you can see in this example ( http://datatables.net/release-datatables/extras/TableTools/swf_path.html ) that should be all that is needed. Could you give me a link to the page please, so I can see what might be happening? You can send it to http://datatables.net/contact if you don't want to make it public.

Allan

bocode

Allan,

Thank you very much for offering to help. The website is on the intranet and is not accessible from outside.

However, i wanted this to work very badly so i searched for older version of table tools and i got it from this website: http://www6b.wittenberg.edu/lib/include/jquery/dataTables-1.6/extras/TableTools/

And it is working as expected except that there is no PDF export.

One thing i fail to understand is why does new TT version refer to ZeroclipBoard.swf when all it needs is either copy_xls_csv.swf (or the pdf version)?

Regards,
Bo

allan

The ZeroClipboard.js file does refer to ZeroclipBoard.swf you are right - but that's effectively redundant, as TableTools will always instruct ZeroClipboard to look else where for the SWF.

PDF export is something that was new in TableTools 2 - so you would need to use that if you want PDF export.

If you have Chrome around or Safari have a look at the inspector's console, it will tell you if there are any 404 errors. Likewise have a look at your server logs for 404 errors.

Allan

n.pirlot

Good evening,

Firstly, I would like to express my gratitude for such great add-ons.

Now, I am having very similar issues, and in ways trying to fix this, have found:
1. the bundle of all extras with DataTables contains obsolete versions (in particular of TableTools)
2. all paths work fine, all checked with consoles, only I have a feeling there is an issue with the files contained into the 'as3' directory, is that a likelyhood? does this directory, as well as the 'docs' directory have an impact on the functionning of TableTools?

Many thanks & kind regards to all.
Nic

n.pirlot

I have tried everything I could think of... relocated qll files to match the samples, used the same links.. and tried removing all the unnecessary scripts & libraries... Basically Chrome gives me a momentary freeze and crash, and Firefox does not respond at all... (just installed the latest version of Firefox + Flash)

Any help or advice would be greatly appreciated... I spent my whole evening attempting to figure it out :S

PS: actually, I am having exactly the problem described in: TableTools: tableTools2 example doesn't work in firefox, but only in IE (forums)

gowri

I had the same issue when i fix sSwfPath all works fain
Thanks Allan

But I have another issue


When i am using [b]Table tools[\b] , the bJQueryUI is not working .. the jquery ui theme is not applying to Data tables

My Table Configuration
====================

[code]
var oTable = $('#user_table').dataTable( {
"aoColumns": [
{ "sClass": "number", "bSortable": false },
{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false },{ "sClass": "nonedit", "bSortable": false }

],
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "../js/DataTables/media/swf/copy_cvs_xls_pdf.swf",
"aButtons": [
"copy",
"csv",
"xls",
{
"sExtends": "pdf",
"sPdfOrientation": "landscape",
"sPdfMessage": "Your custom message would go here."
},
"print"
]
},
"bProcessing": true,
"bServerSide": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",

"sAjaxSource": 'ajax_userreport_table?custom_field=a:14:{i:0;s:9:"user_name";i:1;s:15:"user_first_name";i:2;s:14:"user_last_name";i:3;s:13:"user_password";i:4;s:10:"user_email";i:5;s:11:"user_gender";i:6;s:10:"user_phone";i:7;s:8:"user_dob";i:8;s:12:"user_address";i:9;s:12:"user_country";i:10;s:10:"user_state";i:11;s:9:"user_city";i:12;s:12:"user_zipcode";i:13;s:13:"user_reg_date";}'

});

[\code]

allan

You need to alter your sDom ( http://datatables.net/usage/options#sDom ) from:

[code]
"sDom": 'T<"clear">lfrtip',
[/code]
to
[code]
"sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
[/code]
Allan

gowri

Thanks you so much Allan you always great .That works i am always your fan

newbietonie

Hi bocode,

We have the same problem as yours! And I contacted Allan for help. The solution is that try to test and upload it on your web-server and it won't work from the file system (i.e. file://) as Allan said that there are some security settings in Flash, and that is why it is not working. Print button is working because it is not part of the Flash at all.

Btw, Thanks Allan for the help! :)

s8472

I had same problem too and I didn't get the 404 error message.
The problem was that I was hiding my datatable so all offset values were 0. So my all embed width and height were 0.
I hope it helps

NJDave71

I downloaded DataTables-1.8.2

navigated to DataTables-1.8.2\extras\TableTools
The Flash Buttons don't work and I have the Latest Version of Flash.

I click on the buttons and nothing happens.



Thanks

allan

Is the swf path correct for your installation? Have a look in your server error log for 404 errors.

Allan

NJDave71

I downloaded DataTables-1.8.2

navigated to DataTables-1.8.2\extras\TableTools
The Flash Buttons don't work and I have the Latest Version of Flash.

I clicked on the buttons and nothing happens.

I tried this in Firefox and IE.

NJDave71

I added

[code]
"oTableTools": {
"sSwfPath": "http://datatables.net/release-datatables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"}
[/code]

It Still doesn't work.

It works fine here http://datatables.net/extras/tabletools/

allan

You don't want to pull the SWF (or indeed any other file) off the datatables.net site, since it is not a CDN, and Flash has some XSS protection. You want to put in your own server's address.

Allan

NJDave71

Allan

I changed the path to see if it would work like it does on your site. I cannot get this work and all the code is the same.

allan

Can you give us the link please?

Allan

NJDave71

Allan

I downloaded DataTables-1.8.2 from your Website. Extracted the zip file to my Local C Drive

Navigated to C:\DataTables-1.8.2\extras\TableTools2

Click on index.html and tried to click on Copy, CSV, Exce, and PDF nothing happens. When I click on The Print button highlights and It comes up in print preview.

bugreport

same problem here

allan

It won't work from a local drive, unless you have a security exception set up for Flash. This is a Flash security setting, and there is no way for me to get around it I'm afraid. You can change the security settings here: http://www.macromedia.com/support/documentation/en/flashplayer/help/settings_manager04.html .

A better solution is just to dump the files onto a web-server.

Allan

NJDave71

I copied the SWF files to my local server and it works now....
Thank you for the Explanation.

MemeDeveloper

Firstly to Allan and all the other who work on this fantastic stuff - thanks a million, amazing stuff, love it !

I had same issue - with flash buttons not working.

I had no 404, and if I used the path directly in the browser I got the flash swf fine.

so I was very ????

But as per @s8472 (I think) my problem was not about paths, nor about IIS / asp.net routing failing to serve the request properly (as I had issues with before on another system), but it was simply that I had hidden the buttons with css (and had some Jquery to show them when user wanted to export...)

I had following css

[code]
.DTTT_container {
display: none;
}
[/code]

Which was problem. Removing this and everything is hunkey dorey ! :)

Thanks all.

dshapiro

Sorry, so what is the fix for this issue? I have the same problem where the swf buttons show, but clicking on them makes them all vanish accept for the Print button, which pops up preview mode. I want to have the users have the cvs option.

The code so far:

[code]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">





@import "/media/css/demo_page.css";
@import "/media/css/demo_table.css";
@import "/css/jquery-ui/css/redmond/jquery-ui-1.8.4.custom.css";
@import "/TableTools/media/css/TableTools.css";

a { font-family: Arial, Verdana, sans-serif; font-size: 18px; color: #483D8B; text-decoration: none }
a:hover { font-family: Arial, Verdana, sans-serif; font-size: 18px; color: #A52A2A; background-color: #FAEBD7}
h1 { font-family: Arial, Verdana, sans-serif; font-size: 32px; color: #A52A2A }
h2 { font-family: Arial, Verdana, sans-serif; font-size: 24px; color: #A52A2A }





PERC Entity Location Report


$(document).ready(function() {

var oTable = $('#percloc3').dataTable({
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "/TableTools/media/swf/copy_cvs_xls_pdf.swf",
}
});
new FixedHeader( oTable );
});



This displays the buttons, but if you move the mouse over them they vanish, leaving just the Print option. If I add an aButton for just xls, then no buttons appears.
[/code]

dshapiro

Please note that the swf is located on our apache2 server in a subdirectory of htdocs called TableTools, so I think that satisifies the comment above to not run it local.

dshapiro

Another note is that if I go and pull up /TableTools/index.html with its example, it works. Other than using sSwfPath and new FixedHeader ( oTable ), I think my stuff is the same now (switched to try TableTools.js just like the index.html that comes with TableTools.

dvnandover

i on the other hand have a slightly different problem. Everytime the table loaded with data i got the following error:
Microsoft JScript runtime error: Object required

and the code stopped at the function below:

function __flash__addCallback(instance, name) {
instance[name] = function () {
return eval(instance.CallFunction("" + __flash__argumentsToXML(arguments,0) + ""));
}
}

Can some expert help?

Edit: Everything worked fine when the table load the fist time but error out everytime after the first time.

@dshapiro:
1. Maybe your sSwfPath is wrong and it should be "TableTools/media/swf/copy_cvs_xls_pdf.swf",
did you try this:
var oTable = $('#percloc3').dataTable({ "sDom": 'T<"clear">lfrtip', "oTableTools": { "sSwfPath": "TableTools/media/swf/copy_cvs_xls_pdf.swf", } });
2. Are You missing ?