Save csv, excel & pdf

noko

Hi Im trying to get the save button to work. The print button works fine but when I click on the save button all I see are the three options csv, excel & pdf and nothing happens, when I right click in it, it says movie not loaded. Any help ?

my code is
order: [ 1, 'desc' ],

"tableTools": {
        "sRowSelect": "os",

          "sSwfPath": "/flash/copy_cvs_xls_pdf.swf",
        "aButtons": [

            { "sExtends": "editor_create", "editor": editor },
            { "sExtends": "editor_edit",   "editor": editor },
            { "sExtends": "editor_remove", "editor": editor },


            "print",
            {"sExtends":    "collection","sButtonText": "Save","aButtons":    [ "csv", "xls", "pdf" ] }

    ]
    }
} );

} );

headshot9x

Try with save .xls file

"dom": 'T<"clear">rftip',
                "tableTools": {
                    "aButtons": [
                         {
                             "sTitle": "List Area",
                             "sFileName": "FMS - *.csv",
                             "sExtends": "xls",
                             "mColumns": [0, 1, 2, 4, 5]
                         }
                    ],
                    "sSwfPath": "theme/datatable/tabletool2.2.4/swf/copy_csv_xls_pdf.swf"
                }

allan

Is Flash enabled for your browser? TableTools requires Flash.

Another option is to use Buttons which is the replacement for TableTools and does not require Flash.

Allan

noko

yes my browser is flash enabled, still only the printer works

allan

Can you link to the page so I can debug it please.

noko

Thank you allan - http://www.merlinlibrary.com/admin/backup_orders_cms.php

another weird thing that is happening in that table is that some rows are just vanishing. The would be inserted into the database because I receive a confirmation email from the front end but as soon as they arrive at the back end, some rows randomly vanish. I've been a week trying to figure it out

noko

Hey Allan any news on the save csv, excel & pdf buttons ? greatly appreciated

allan

If you look at the console in your browser, or the server's error log, you will see something like:

http://www.merlinlibrary.com/swf/copy_csv_xls_pdf.swf Failed to load resource: the server responded with a status of 404 (Not Found)

Which explains why it isn't working. Put the SWF file in place and it should.

The would be inserted into the database because I receive a confirmation email from the front end but as soon as they arrive at the back end, some rows randomly vanish.

Without being able to see the full code base, I couldn't say what that is happening. If it is a DataTables issue, the DataTables support options would cover it, although not if it is a server-side issue.

Allan