DataTables

DaveBurns

If the Ajax call to get data from the server fails and bProcessing is set to true, the box with "Processing..." remains. Is this expected behavior? Is there an official way to dismiss it? (Obviously I can find the element and set it to hidden but that doesn't feel "clean").

allan

Yes - there has been an error that shouldn't occur, so DataTables remains in that state (mainly to indicate to the developer that there has been an error that needs to be fixed with the JSON source).

The "fix" in DataTables would be to modify the $ajax call's error handler to hide the processing element, but I'm reluctant to do that since it will make it less likely the developer will see the problem.

Allan

fbas

is there a preferred way to hide the processing message? there was an occasion I needed to clear it and used jQuery .hide() on the div container.

allan

The internal function _fnProcessingDisplay (exposed in oApi) is the preferred way of doing it - although currently all it really does is set display:none on the element - rather like what hide() does.

Allan

DaveBurns

Allan - Just so future readers don't misunderstand, this can come up with more than just malformed JSON. If the server returns an HTTP result code such as a 404 or 500, this occurs too. I think (?) the issue is that DataTables sets no default error handler for the Ajax call.

In the end, I added a fnServerData handler and in the $.ajax call, I added:

"error": handleAjaxError

In the function handleAjaxError, among other cleanup, I called

table.fnProcessingIndicator( false );

db

trishdev

DaveBurns -- can you show the entire fnServerData handler and handleAjaxError code? I have been looking for ajax error handling / load handling with processing indicator.. thanks...

DaveBurns

@trishdev - It's a little tough to remember because I've since incorporated the pipelining code into my $.ajax call but I think this is what you want to add to your datatables options:

"fnServerData": function ( sSource, aoData, fnCallback ) {
    $.ajax( {
        "dataType": 'json',
        "type": "POST",
        "url": sSource,
        "data": aoData,
        "success": fnCallback,
        "timeout": 15000,   // optional if you want to handle timeouts (which you should)
        "error": handleAjaxError // this sets up jQuery to give me errors
    } );
},

And then my error handling function:

function handleAjaxError( xhr, textStatus, error ) {
    if ( textStatus === 'timeout' ) {
        alert( 'The server took too long to send the data.' );
    }
    else {
        alert( 'An error occurred on the server. Please try again in a minute.' );
    }
    myDataTable.fnProcessingIndicator( false );
}

And then finally, code I got from elsewhere on this site to define that function I'm using to turn off the processing indicator:

jQuery.fn.dataTableExt.oApi.fnProcessingIndicator = function ( oSettings, onoff ) {
    if ( typeof( onoff ) == 'undefined' ) {
        onoff = true;
    }
    this.oApi._fnProcessingDisplay( oSettings, onoff );
};

Hope this helps.
db

trishdev

Hi DB just wanted to thank you (rather late) for posting your code. I had moved onto other thing but am circling back around and will try it out.. thanks again

guerrila

@DaveBurns

This solution worked perfectly. Thanks so much!

DataTables

Howdy, Stranger!

Support

Categories

In this Discussion