DataTables in VisualForce Page, Setting swfPath as Static Resource

Question

I have been working with the DataTables library in VisualForce and have everything working except for the export features. I followed the sample initialization on the DataTables website, but am getting an error that ZeroClipboard.js is undefined in the TableTools.js file. However, I have checked and re-checked multiple times and the zeroclipboard.js is listed as a resource in the Chrome.

The only thing I am doing differently, and was not able to determine in adapting the function to VisualForce was how to properly call the swf file. Currently I am hosting the file on a local server and referencing it explicitly in the function. Could this be my issue? The error above does not seem to be related, but it is the only thing left I think after extensive troubleshooting.

Does anyone know how I can make the swf file a static resource in Salesforce and call it that way from the function so the file is on the same server as everything else?

Below is my current function setting up DataTables (Question in reference to the swfPath: call, how do I do this with a static resource?)

      var oTableTools = new TableTools( oTable, {
        "sSwfPath" : "www.MyWebsite.com/resources/copy_csv_xls_pdf.swf",
        "buttons": [
                    "copy",
                    "csv",
                    "xls",
                    "pdf",
                    { "type": "print", "buttonText": "Print me!" }
                   ]
      });
            $('#demo').before( oTableTools.dom.container );

Answer 1

I'd expect your reference to the static resource to look something like:

"sSwfPath" : "{!URLFOR($Resource.ZipFileName,'SubfolderPath/copy_csv_xls_pdf.swf')}"

If not, I'd expect it to look very similar. Try it and see if it works.

I'm suggesting this because a static resource reference to an image file would look like:

img src="{!URLFOR($Resource.ZipFileName,'SubFolderPath/ImageName.xxx')}"

All you'd really be doing is replacing the http://www.mywebsite.com/path link in your sSwfPath with the Salesforce URL pointer to retrieve it from where it's being stored internal to Salesforce, plus any path saved within the zip file.

Answer 2

You can do this by uploading swf file(you can find this in the media/swf/copy_csv_xls_pdf ) as a static resource in salesforce and then accssesing it

For example

  oTable = $('#example').dataTable(
        {
            "iDisplayLength": 20,
            "sDom": '<C><"H"T><"clear"><"H"l>t<"F"ip>',
            "oTableTools": {
            "sSwfPath": "{!$Resource.SWF_File}"
            },
            "oColVis": 
            {
                "activate": "mouseover"
            },
            "bAutoWidth": false,
            "bJQueryUI": true, 
            "sPaginationType": "full_numbers",
            "aaSorting": [[ 2, "asc" ]] ,
            "bLengthChange": false, 
            "bFilter": true

The static resource SWF_File consists copy_csv_xls_pdf.swf