your server is returning a data table json. If you are using the google.visualization.Query the json response has some more info on top of the data table json. See http://code.google.com/apis/visualization/documentation/dev/implementing_data_source.html#jsondatatable Note that the response 'table' property is a json in the format you are using at the moment.
On Tue, Jun 30, 2009 at 1:10 PM, xspotlivin <[email protected]> wrote: > > drk2cmp, > > I'm trying to accomplish the same thing as you. I've looked at the > code submitted above, but my code is still not working. Here's what I > have: > > <script type="text/javascript" src="http://www.google.com/jsapi";></ > script> > <script type="text/javascript"> > google.load('visualization', '1', {packages: ['motionchart']}); > > > function sendAndDraw() { > var query = new google.visualization.Query('http://web.mit.edu/ > dmbrown/www/example2.json'<http://web.mit.edu/%0Admbrown/www/example2.json%27> > ); > query.send(handleResponse) > } > function handleResponse(response) { > if (response.isError()) { > alert(response.getMessage() + ' ' + response.getDetailedMessage > ()) > return; > } > var data = response.getDataTable(); > var motionchart = new google.visualization.MotionChart > (document.getElementById > ('visualization')); > motionchart.draw(data, {'width': 800, 'height': 400}); > > } > google.setOnLoadCallback(sendAndDraw); > > </script> > > > Do you see what's wrong with this? Thanks for your help. > > On Jun 29, 4:08 pm, drk2cmp <[email protected]> wrote: > > Thanks for the help. Works swimmingly. :-) > > > > On Jun 29, 1:06 am, ChartMan <[email protected]> wrote: > > > > > First, here is an example of how to create a data table from a static > > > content - > http://code.google.com/apis/ajax/playground/?type=visualization#json_... > > > Second, you are doing too many things in your code. > > > You can either create the dataTable on the client or get it using a > Query > > > object. For the first case you can write something like > > > > > <script type="text/javascript"> > > > google.load("visualization", "1", {packages:["Table", > "MotionChart"]}); > > > google.setOnLoadCallback(initialize); > > > > > var dataTableObj = > > > {cols:[{id:'Col1',label:'',type:'number'}, > > > {id:'Col2',label:'',type:'number'}, > > > {id:'Col3',label:'',type:'number'}], > > > rows:[{c:[{v:1.0,f:'1'},{v:2.0,f:'2'},{v:3.0,f:'3'}]}, > > > {c:[{v:2.0,f:'2'},{v:3.0,f:'3'},{v:4.0,f:'4'}]}, > > > {c:[{v:3.0,f:'3'},{v:4.0,f:'4'},{v:5.0,f:'5'}]}, > > > {c:[{v:1.0,f:'1'},{v:2.0,f:'2'},{v:3.0,f:'3'}]}]}; > > > function initialize() { > > > var data = new google.visualization.DataTable(dataTableObj); > > > var table = new > google.visualization.Table(document.getElementById > > > ('chart_div')); > > > table.draw(data, {showRowNumber: true}); > > > > > } > > > </script> > > > > > and for the second > > > > > <script type="text/javascript"> > > > google.load("visualization", "1", {packages:["Table", > "MotionChart"]}); > > > google.setOnLoadCallback(sendAndDraw); > > > > > function sendAndDraw() { > > > var query = new google.visualization.Query(__URL__); > > > query.send(handleResponse) > > > } > > > function handleResponse(response) { > > > if (response.isError()) { > > > alert(response.getMessage() + ' ' + > response.getDetailedMessage()) > > > return; > > > } > > > var data = response.getDataTable(); > > > var table = new > google.visualization.Table(document.getElementById > > > ('chart_div')); > > > table.draw(data, {showRowNumber: true}); > > > > > } > > > </script> > > > > > On Mon, Jun 29, 2009 at 10:14 AM, drk2cmp <[email protected]> wrote: > > > > > > I'm having a bit of a problem. I want to create a visualization, but > > > > load the data from an external file using the JSON format. > > > > > > Every example I can find is using static JSON within the > visualization > > > > script, without calling if from an external file. > > > > > > For testing my source file is: > > > > > > {version:'0.6',reqId:'0',status:'ok',sig:'5982206968295329967',table: > > > > {cols:[{id:'Col1',label:'',type:'number'}, > > > > > > {id:'Col2',label:'',type:'number'}, > > > > {id:'Col3',label:'',type:'number'}],rows:[{c:[{v:1.0,f:'1'},{v: > > > > 2.0,f:'2'}, > > > > > > > {v:3.0,f:'3'}]},{c:[{v:2.0,f:'2'},{v:3.0,f:'3'},{v:4.0,f:'4'}]},{c:[{v: > > > > 3.0,f:'3'},{v:4.0,f:'4'},{v:5.0,f:'5'}]},{c: > > > > > > [{v:1.0,f:'1'},{v:2.0,f:'2'},{v:3.0,f:'3'}]}]}} > > > > > > My visualization script is as follows: > > > > > > <script type="text/javascript" src="http://www.google.com/jsapi > "></ > > > > script> > > > > <script type="text/javascript"> > > > > > > google.load("visualization", "1", {packages:["Table", > > > > "MotionChart"]}); > > > > google.setOnLoadCallback(initialize); > > > > > > function initialize() { > > > > var opts = {sendMethod: 'xhr'}; > > > > var query = new google.visualization.Query(' > > > >http://localhost/ > > > > analytics/source.csv?tqx=reqId:0;< > http://localhost/%0Aanalytics/source.csv?tqx=reqId:0;> > > > > ',opts); > > > > > > response = query.send(); > > > > > > data = > google.visualization.Query.setResponse(response) > > > > > > data = google.visualization.Query.getDataTable(query); > > > > > > var table = new > > > > google.visualization.Table(document.getElementById > > > > ('chart_div')); > > > > table.draw(data, {showRowNumber: true}); > > > > > > } > > > > </script> > > > > > > I get no error messages, the JSON file is loaded according to > Firebug, > > > > but the screen is blank. What am I doing wrong? Any help would be > > > > appreciated!! Thanks. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
