I got this table somehow working. I don't is this was the Google Visualization requirement or a random approach. the response that i was sending from the server was JSON but it was not being wrapped in *google.visualization.Query.setResponse(*JSON*);* I just did it and the table was generated.
Is this the thing missing ? ..alee http://techboard.wordpress.com On Fri, Jan 30, 2009 at 11:22 AM, alee amin <[email protected]>wrote: > that's the basic html code i am using .. and it is not working .. even for > one row of one column .. > > --------------------------------------------------------------------------------------------------------------------- > <html> > <head> > <script type="text/javascript" src="http://www.google.com/jsapi > "></script> > <script type="text/javascript"> > google.load("visualization", "1", {packages:["table"]}); > google.setOnLoadCallback(initialize); > > function initialize() { > // Replace the data source URL on next line with your data source URL. > var query = new google.visualization.Query(' > http://pkdev168:8080/tracker-web/report/rawList.action'); > > // Send the query with a callback function. > query.send(drawTable); > } > function drawTable(response) { > > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + > response.getDetailedMessage()); > return; > } > var data = response.getDataTable(); > var table = new > google.visualization.Table(document.getElementById('table_div')); > table.draw(data, {showRowNumber: true}); > } > </script> > </head> > > <body> > <div id="table_div"></div> > </body> > </html> > > ------------------------------------------------------------------------------------------------------------------ > ..alee > http://techboard.wordpress.com > > > > On Fri, Jan 30, 2009 at 10:47 AM, alee amin <mailing.list.mail.id@ > gmail.com> wrote: > >> thanks. >> well right now we don't have any live server. the application is being >> made for local intranet. that's why i can't give you url. >> >> Can you please send me the client side code. It may be I am doing >> something wrong with the html page? >> >> or should i send you eclipse workspace for the server side code? i guess >> first one is more appropriate at the moment. >> >> ..alee >> http://techboard.wordpress.com >> >> >> >> On Thu, Jan 29, 2009 at 7:18 PM, VizBoy <[email protected]> wrote: >> >>> Hi, >>> >>> I tried using just the table and didn't get an error. >>> Could you give a link to your server so I can try it and actually get the >>> response? >>> >>> - VizBoy. >>> >>> >>> On Thu, Jan 29, 2009 at 1:54 PM, alee amin <mailing.list.mail.id@ >>> gmail.com> wrote: >>> >>>> I created that just to test the library. which i later realized that is >>>> a wrong approach. >>>> Now I am getting error on the new response that is being generated by >>>> the DataSource. the response that is being sent is listed below (i have >>>> formated for readibility) - FireBug console gives error that "invalid >>>> label" >>>> when this response is being received. I am unable to figure which label is >>>> it pointing to .. ? >>>> { >>>> "reqId":"1", >>>> "sig":"5277771", >>>> "status":"ok", >>>> "table": >>>> { >>>> "cols": >>>> [ >>>> {"id":"user","label":"User","type":"string"}, >>>> {"id":"title","label":"Title","type":"string"}, >>>> {"id":"application","label":"Application","type":"string"}, >>>> {"id":"duration","label":"Duration","type":"number"} >>>> ], >>>> "rows": >>>> [ >>>> { >>>> "c": >>>> [ >>>> {"f":"string","v":"PKDEV168"}, >>>> {"f":"string","v":"Some Title"}, >>>> {"f":"string","v":"firefox.exe"}, >>>> {"f":"1","v":"45"} >>>> ] >>>> }, >>>> { >>>> "c": >>>> [ >>>> {"f":"string","v":"PKDEV168"}, >>>> {"f":"string","v":"Some Title Part 2"}, >>>> {"f":"string","v":"chrome.exe"}, >>>> {"f":"1","v":"40"} >>>> ] >>>> } >>>> ] >>>> }, >>>> "version":"0.5"} >>>> >>>> >>>> ..alee >>>> http://techboard.wordpress.com >>>> >>>> >>>> >>>> On Thu, Jan 29, 2009 at 1:09 PM, VizBoy <[email protected]> wrote: >>>> >>>>> Hi! >>>>> >>>>> I didn't quite understand why you tried to create a full response in >>>>> your javascript code. >>>>> It's hard for me right now to think of a usecase for this... >>>>> Such responses are parsed by the library's internal mechanisms when >>>>> using google.visualization.Query and such and are not meant to be used in >>>>> this way. >>>>> >>>>> For this example, i would keep only the datatable part (something like >>>>> {"cols":[{"id":"user","label": >>>>>> >>>>>> "User","number":"string"}, >>>>>> {"id":"title","label":"Title","number":"string"}, >>>>>> {"id":"application","label":"Application","number":"string"}, >>>>>> {"id":"duration","label":"Duration","number":"number"}],"rows":[{"c": >>>>>> [{"f":"string","v":"PKDEV168"},{"f":"string","v":"Some Title"}, >>>>>> {"f":"string","v":"firefox.exe"},{"f":"1","v":"45"}]},{"c": >>>>>> [{"f":"string","v":"PKDEV168"},{"f":"string","v":"Some Title Part 2"}, >>>>>> {"f":"string","v":"chrome.exe"}, >>>>>> {"f":"1","v":"40"}]}]} >>>>> >>>>> >>>>> ) and feed it to the constructor of google.visualization.DataTable. >>>>> >>>>> Please elaborate if i didn't understand you correctly. >>>>> >>>>> - VizBoy. >>>>> >>>>> >>>>> >>>>> On Wed, Jan 28, 2009 at 4:11 PM, alee amin <mailing.list.mail.id@ >>>>> gmail.com> wrote: >>>>> >>>>>> Ok, the deal is here that i am trying to create the custom RESPONSE >>>>>> object. which should be of type QueryResponse but I am not able to >>>>>> create it >>>>>> and send it to drawTable method. >>>>>> If i try to call my local JSON dataSource (created in struts) then I >>>>>> am always getting TIME_OUT error .. :s >>>>>> ..alee >>>>>> http://techboard.wordpress.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wed, Jan 28, 2009 at 6:09 PM, _alee <mailing.list.mail.id@ >>>>>> gmail.com> wrote: >>>>>> >>>>>>> >>>>>>> I am trying to create a proof of concept implementation to evaluate >>>>>>> the decision of Google Visualization API. I have written this sample >>>>>>> code but it is not rendering the barchat. >>>>>>> >>>>>>> <html> >>>>>>> <head> >>>>>>> <script type="text/javascript" src="http://www.google.com/jsapi >>>>>>> "></ >>>>>>> script> >>>>>>> <script type="text/javascript"> >>>>>>> google.load("visualization", "1", {packages:["table, barchart, >>>>>>> areachart"]}); >>>>>>> google.setOnLoadCallback(initialize); >>>>>>> >>>>>>> function initialize() { >>>>>>> alert ("alert called"); >>>>>>> drawTable >>>>>>> ({"reqId":"3","sig":"5982206968295329967","status":"ok","table": >>>>>>> {"cols":[{"id":"user","label":"User","number":"string"}, >>>>>>> {"id":"title","label":"Title","number":"string"}, >>>>>>> {"id":"application","label":"Application","number":"string"}, >>>>>>> {"id":"duration","label":"Duration","number":"number"}],"rows":[{"c": >>>>>>> [{"f":"string","v":"PKDEV168"},{"f":"string","v":"Some Title"}, >>>>>>> {"f":"string","v":"firefox.exe"},{"f":"1","v":"45"}]},{"c": >>>>>>> [{"f":"string","v":"PKDEV168"},{"f":"string","v":"Some Title Part >>>>>>> 2"}, >>>>>>> {"f":"string","v":"chrome.exe"}, >>>>>>> {"f":"1","v":"40"}]}]},"version":"0.5"}); >>>>>>> } >>>>>>> function drawTable(response) { >>>>>>> alert ("entered in dataTable"); >>>>>>> //response.isError is creating ERROR - no line of code execute after >>>>>>> isError method is called >>>>>>> if (response.isError()) { >>>>>>> alert ("in if condition - there is som >>>>>>> error"); >>>>>>> alert('Error in query: ' + >>>>>>> response.getMessage() + ' ' + >>>>>>> response.getDetailedMessage()); >>>>>>> return; >>>>>>> } >>>>>>> alert ("getting dataTable"); >>>>>>> var data = response.getDataTable(); >>>>>>> alert ("No.: of cols: "+ data.getNumberOfColumns()); >>>>>>> var table = new >>>>>>> google.visualization.Table(document.getElementById >>>>>>> ('table_div')); >>>>>>> table.draw(data, {showRowNumber: false}); >>>>>>> >>>>>>> // var barchart = new google.visualization.BarChart >>>>>>> (document.getElementById('chart_div')); >>>>>>> // barchart.draw(data, {width: 600, height: 340, is3D: >>>>>>> true, >>>>>>> isStacked: true, title: 'Hourly usage'}); >>>>>>> >>>>>>> } >>>>>>> </script> >>>>>>> </head> >>>>>>> >>>>>>> <body> >>>>>>> <div id="table_div"></div> >>>>>>> <div id="chart_div"></div> >>>>>>> </body> >>>>>>> </html> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >>> >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
