Needed separate class to send data.

andrewwatts said:

Post edited 08:01 – 19/11/2009 by andrewwatts
Post edited 08:03 – 19/11/2009 by andrewwatts
Post edited 08:04 – 19/11/2009 by andrewwatts

Hello Ed, we spoke in the TG forum about this issue and I just stumbled on your posts here.

Now that I've seen your code I can say a bit more and I believe you need to go back and double check all your script and css paths.  If you followed the instructions at /jqgridwiki/doku.php?id=wiki:jquery_ui_intro you'll notice that you are missing the jquery ui script file and also that your locale file is in the wrong place (at least according to the installation).

I copied and pasted the code from your first post of this thread and get the error you describe. I fixed the js paths for my environment and the errors went away and the grid successfully renders.  Here is a diff of what I changed (lines that begin with '-' are your original code, lines that begin with '+' are how I changed them)

Also, if it helps, here are the TG controller methods I used to test with.

Again, simply updating the javascript src includes for my environment successfully rendered a chart using the rest of your code.

Hope this helps.

- Andrew

I have been working on other things and am now back to sorking on this section of my application. I had some selection fields on the top of the grid and moved them to a prior page.

The user selects the date and type of transaction, on submit the grid page is called. The issue now is really a Turbogears thing. If I have:

@expose('json')

def griddisplay:

......select data

return dict(....... proper form)

I get the data and no HTML.

If I change the @expose('jason') to @expose(template.name), I get the HTLM with no data.

How do I get both?

Thanks to all of you that have helped with this! It is finally working! Hallelujah!! 

I will be adding to the prototype I have now and am sure I will be asking for help in the future. The Jquery widget tools are just too good not to use with Turbogears.

I will continue to monitor this forum.

Thanks again.

Ed
Now we need to get a tw developer to develope jqquery as a widget with the tw2 core. With the documentation available it might not be that difficult for them. I may play with it, but I am not that strong of a developer, I'm just an accountant trying to write a school accounting application.

Hello Ed, we spoke in the TG forum about this issue and I just stumbled on your posts here.

Now that I've seen your code I can say a bit more and I believe you need to go back and double check all your script and css paths.  If you followed the instructions at /jqgridwiki/doku.php?id=wiki:jquery_ui_intro you'll notice that you are missing the jquery ui script file and also that your locale file is in the wrong place (at least according to the installation).

I copied and pasted the code from your first post of this thread and get the error you describe. I fixed the js paths for my environment and the errors went away and the grid successfully renders.  Here is a diff of what I changed (lines that begin with '-' are your original code, lines that begin with '+' are how I changed them)

Also, if it helps, here are the TG controller methods I used to test with.

Again, simply updating the javascript src includes for my environment successfully rendered a chart using the rest of your code.

Hope this helps.

- Andrew

notnow said:

As far as I can tell, the controller, html, and scripts from your first post looks about the same as my application.  In fact I emulated your setup with my application and just changed to 'get' and it worked.  Can you help with css when you get yours displaying.  I am getting a  “404 Not Found” when I click edit in firebug in the css section.

How are you generating your response? Are you using a "return dict( page=page, ........) or some other way??  Can you send the raw response?

I think this is where I am having my issues?

Thanks.

The response is:

HTTP/1.0 200 OK
Server: PasteWSGIServer/0.5 Python/2.5.4
Date: Mon, 16 Nov 2009 03:18:45 GMT
Pragma: no-cache
Cache-Control: no-cache
Content-Type: text/html; charset=utf-8
Content-Length: 260

{page:”1″,total:”1″,records:”5″, rows:[{"279976","10009901","0","None","None"}{"279977","10009901","0","11014912","None"},{"279978","10009901","4423","11024421","None"},{"279979","10009901","4425","11014910","None"},{"279975","12194001","0","11083108","1"},]}

With NO cr/lf in the data, one long string.

I am getting an error "invalid object initializer"  at line 59 of grid.base.js

parse : function(jsonString) {
        var js = jsonString, msg;
        if (js.substr(0,9) == "while(1);") { js = js.substr(9); }
        if (js.substr(0,2) == "/*") { js = js.substr(2,js.length-4); }
        if(!js) { js = "{}"; }
        ($.jgrid.useJSON===true && typeof (JSON) === 'object' && typeof (JSON.parse) === 'function')
            ? msg = JSON.parse(js)
            : msg = eval('(' + js + ')');                                  <<<<< THIS LINE
        return  msg.hasOwnProperty('d') ? msg.d : msg;
    },
    empty : function () {
        while ( this.firstChild ) this.removeChild( this.firstChild );
    },

Is this indicate the response is not formatted correctly? Incorrect quotes????

In all of this effort, I have identified that the location of files and sub-directories is most important. The CSS section includes and calls files based on the installation instructions. I would check all of the files and locations if you are getting the 404 error.

Thanks for all of the help.

[Exception... "Component returned failure code: 0x80040111 (NS_ERROR_NOT_AVAILABLE) [nsIChannel.contentType]" nsresult: "0x80040111 (NS_ERROR_NOT_AVAILABLE)" location: "JS frame :: file:///C:/Program%20Files/Mozilla%20Firefox/components/FeedProcessor.js :: FP_onStartRequest :: line 1440" data: no] from firefox

jquery-1.3.2

firefox 3.5.5

This may not be correct thread.  I am trying to thread for turbogears folks, but I don't think this is unique to turbogears.

If I set the datatype = 'jsonstring' in the html, there is no request sent back to the host.

Any error in the console.

Also in this case you should set cell to empty string in jsonReader: See here:

http://www.trirand.com/jqgridw.....eving_data

Save the response to a file and try to load via data string - I mean  - set datatype to jsonstring and put a part from the response in string an see the result.

Regards
Tony

Any suggestions?

Does the content-type need to be "json"?

HTTP/1.0 200 OK
Server: PasteWSGIServer/0.5 Python/2.5.4
Date: Mon, 16 Nov 2009 03:18:45 GMT
Pragma: no-cache
Cache-Control: no-cache
Content-Type: text/html; charset=utf-8
Content-Length: 260

{page:"1",total:"1",records:"5", rows:[{"279976","10009901","0","None","None"},{"279977","10009901","0","11014912","None"},{"279978","10009901","4423","11024421","None"},{"279979","10009901","4425","11014910","None"},{"279975","12194001","0","11083108","1"},]}

No jqGrid does not replace the table. It just add some additinal elements below and above it, but table stay the same. If you have FireBug you can easy see the the table is still here, and after that we populate the table with data.

I do not known what TurboGear do, so I can not  give you some point to where you can start.

Best Regards

Tony

All of the response viewers are showing the full page without <table id="list" class="scroll"></table>
being replaced with data.

Is the page supposed to load and then send the data request and load the data? I am thinking that Turbogears as I have it know is passing the page and the json data to the stack in TG2 and TG2 expects to do the replacement in the page.

If jqgrid is to do the replacement of  <table id="list" class="scroll"></table> with the data then I need to change my TG2 code.

Thanks for your help. Tell me when I need to send payment for your time.

I think yes. In this case you should escape it by example:

Regards

Tony

23:06:59,946 DEBUG [sensadata.controllers.root]
{'records': '5', 'total': '1',
'rows': [{'cell': ['10009901', '0', '"11024438"', 'None'], 'id': '279976'},
{'cell': ['10009901', '0', '"11014912"', 'None'], 'id': '279977'},
{'cell': ['10009901', '4423', '"11024421"', 'None'], 'id': '279978'},
{'cell': ['10009901', '4425', '"11014910"', 'None'], 'id': '279979'},
 {'cell': ['12194001', '0', '"11083108"', '0'], 'id': '279975'}],
  'page': '1'}

The sample has ", this has ' . Is that a problem?

My suggestion is using a tool like Fiddler or FireBug to see what really gets sent back to the client (View Source in Browser will not work sinice the grid uses client-side rendering based on JSON)

Another thing to try - you can hook the loadError event of the grid and see if it gets fired and with what data.

Regards,

Rumen Stankov