With your example, I don't have problem with the error anymore. Thank you so much for your kindness and your time to help me with this.
On Thursday, November 1, 2012 11:46:29 AM UTC+7, asgallant wrote: > > I tested it here: http://jsfiddle.net/asgallant/wJbmx/, and it works in > all the browsers I have access to at home (FF, Chrome, IE10). If that > doesn't work for you, then I'll test it in IE 9 tomorrow. > > On Wednesday, October 31, 2012 10:42:51 PM UTC-4, QSint wrote: >> >> In Firefox and Chrome the chart display normally but in IE the red error >> message is loaded 4 times before the chart appear. I use IE9. Firefox >> 16.0.2 and Chrome 22.0.1229.94 m. >> Here is the url of the spreadsheet, >> https://docs.google.com/spreadsheet/ccc?key=0Ai9V1GjfC6zfdG9ZOE9sTU9qN3Jnd1RmZzlCVjhOMkE >> >> On Thursday, November 1, 2012 12:42:19 AM UTC+7, asgallant wrote: >>> >>> The only problem I see in your code is that you have two charts trying >>> to draw in the same div (visualization and geochart), but that wouldn't >>> cause the error you are seeing. I would expect that error if the query >>> failed, but then the error handler should catch that and spawn the alert >>> statement. >>> >>> You said this error comes up in IE, what version of IE? Do things work >>> correctly in Firefox and Chrome? >>> >>> Also, it would help to have the spreadsheet url to test with, if you can >>> share it. >>> >>> On Tuesday, October 30, 2012 11:25:54 PM UTC-4, QSint wrote: >>>> >>>> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" >>>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";;> >>>> <html xmlns="http://www.w3.org/1999/xhtml";;> >>>> <head> >>>> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> >>>> <title>MAP TEST</title> >>>> <script type="text/javascript" src="http://www.google.com/jsapi >>>> ";></script> >>>> <script type="text/javascript"> >>>> google.load('visualization', '1', {packages: ['geochart']}); >>>> >>>> function drawVisualization() { >>>> var query = new >>>> google.visualization.Query('I PUT MY GOOGLE DOC FILE URL HERE'); >>>> query.send(handleQueryResponse); >>>> } >>>> >>>> function handleQueryResponse(response) { >>>> if (response.isError()) { >>>> alert('Error in query: ' + response.getMessage() + ' ' + >>>> response.getDetailedMessage()); >>>> return; >>>> } >>>> >>>> var data = response.getDataTable(); >>>> visualization = new google.visualization.GeoChart(document. >>>> getElementById('visualization')); >>>> visualization.draw(data, null); >>>> >>>> var geochart = new >>>> google.visualization.GeoChart(document.getElementById('visualization')); >>>> google.visualization.events.addListener(geochart, 'select', >>>> function() { >>>> var selectionIdx = geochart.getSelection()[0].row; >>>> var countryName = data.getValue(selectionIdx, 0); >>>> window.open('I PUT THE URL I WANT HERE'); >>>> }); >>>> >>>> geochart.draw(data, { >>>> width: 1000, >>>> height: 550 >>>> }); >>>> } >>>> >>>> google.setOnLoadCallback(drawVisualization); >>>> </script> >>>> </head> >>>> <body style="font-family: Arial;border: 0 none;"> >>>> <div align="center" id="visualization"></div> >>>> </body> >>>> </html> >>>> >>>> On Tuesday, October 30, 2012 10:57:06 PM UTC+7, asgallant wrote: >>>>> >>>>> Post the code you are using and I'll take a look. >>>>> >>>>> On Monday, October 29, 2012 10:21:45 PM UTC-4, QSint wrote: >>>>>> >>>>>> Thank you so much. I tried this way but when I open the page on >>>>>> Explorer, there's an error saying, Unable to set value of the >>>>>> property 'data': object is null or undefined >>>>>> On Firefox and Chrome, I don't see this message. Do you have any >>>>>> ideas, how should I fix this? >>>>>> >>>>>> On Friday, October 26, 2012 10:03:28 PM UTC+7, asgallant wrote: >>>>>>> >>>>>>> The easy way is to upload the spreadsheet to google docs and use a >>>>>>> query to read the contents. >>>>>>> >>>>>>> On Thursday, October 25, 2012 10:35:23 PM UTC-4, Fiorella wrote: >>>>>>>> >>>>>>>> Is there the way to get data from table in excel spreadsheet to >>>>>>>> display on Geochart and put the link for each country to specific url >>>>>>>> we >>>>>>>> want? >>>>>>>> >>>>>>>> On Friday, September 7, 2012 8:54:34 PM UTC+7, asgallant wrote: >>>>>>>>> >>>>>>>>> I don't know how Sharepoint works, so I can't help you set it up, >>>>>>>>> but yes, you should be able to use it as a data source. There are >>>>>>>>> other >>>>>>>>> threads on this forum that deal with Sharepoint, perhaps one of them >>>>>>>>> will >>>>>>>>> help (search "Sharepoint"). If not, try >>>>>>>>> stackoverflow<http://stackoverflow.com/> >>>>>>>>> . >>>>>>>>> >>>>>>>>> On Friday, September 7, 2012 3:56:07 AM UTC-4, Kate wrote: >>>>>>>>>> >>>>>>>>>> I have one more question :D >>>>>>>>>> Is it possible to get data column from external data source? >>>>>>>>>> I use SharePoint Online and I put this map on my SharePoint Site >>>>>>>>>> and I'm just thinking it would be great if the map can get data from >>>>>>>>>> SharePoint list column to display on the map. >>>>>>>>>> Do you have any suggestions for this? >>>>>>>>>> >>>>>>>>>> On Tuesday, September 4, 2012 10:44:42 PM UTC+7, asgallant wrote: >>>>>>>>>>> >>>>>>>>>>> You're welcome. >>>>>>>>>>> >>>>>>>>>>> On Tuesday, September 4, 2012 3:07:42 AM UTC-4, Kate wrote: >>>>>>>>>>>> >>>>>>>>>>>> Thank you so much for your help. I really really appreciate >>>>>>>>>>>> this and this is inspiring me for learning ^_^ >>>>>>>>>>>> >>>>>>>>>>>> On Tuesday, September 4, 2012 10:55:22 AM UTC+7, asgallant >>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> You add the extra column in the chart the exact same way you >>>>>>>>>>>>> added the other columns to the chart. You use a DataView (or the >>>>>>>>>>>>> view >>>>>>>>>>>>> property of a ChartWrapper) to select which columns should be >>>>>>>>>>>>> used to draw >>>>>>>>>>>>> a chart. See an example here: >>>>>>>>>>>>> http://jsfiddle.net/asgallant/9BLSc/ >>>>>>>>>>>>> >>>>>>>>>>>>> On Monday, September 3, 2012 10:30:25 PM UTC-4, Kate wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>> asgallant: Yes the urls are in this form and thank you very >>>>>>>>>>>>>> very much for the solution. It works well now and I'm so happy >>>>>>>>>>>>>> ^_^ >>>>>>>>>>>>>> However I still want to know another solution you mentioned. >>>>>>>>>>>>>> Could you please show me by code example how to add an extra >>>>>>>>>>>>>> column in the >>>>>>>>>>>>>> DataTable and how to hide the column from the chart? >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Tuesday, September 4, 2012 6:46:05 AM UTC+7, asgallant >>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Are the urls for the countries in the form >>>>>>>>>>>>>>> "mainUrl/countryName.aspx"? If so, then just add ".aspx" to >>>>>>>>>>>>>>> the end of the >>>>>>>>>>>>>>> string in the window.open call: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> window.open('main url' + countryName + '.aspx'); >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> If the url's aren't formulaic like that, then you can add >>>>>>>>>>>>>>> them as an extra column in the DataTable and hide that column >>>>>>>>>>>>>>> from the >>>>>>>>>>>>>>> chart. You can then reference the DataTable to get the url in >>>>>>>>>>>>>>> the "select" >>>>>>>>>>>>>>> event handler. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Sunday, September 2, 2012 11:10:38 PM UTC-4, Kate wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> Marc: I tried window.open('main url' + countryName) but it >>>>>>>>>>>>>>>> doesn't work for my site as all pages end with .aspx. Could >>>>>>>>>>>>>>>> you please give >>>>>>>>>>>>>>>> me suggestion how to make this make this work or is there any >>>>>>>>>>>>>>>> way that I >>>>>>>>>>>>>>>> can put individual url for each region manually? >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Tuesday, June 26, 2012 6:44:45 AM UTC+7, Marc Lucchini >>>>>>>>>>>>>>>> wrote: >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> You'll have to listen to the >>>>>>>>>>>>>>>>> "select<https://developers.google.com/chart/interactive/docs/gallery/geochart#Events>" >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> or the >>>>>>>>>>>>>>>>> "regionClick<https://developers.google.com/chart/interactive/docs/gallery/geochart#Events>" >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> event. >>>>>>>>>>>>>>>>> An example using the select event: >>>>>>>>>>>>>>>>> http://jsfiddle.net/dz2xS >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> If your country pages already exist and you can't or don't >>>>>>>>>>>>>>>>> want to change their URLs, you may have to put these URLs in >>>>>>>>>>>>>>>>> your datatable >>>>>>>>>>>>>>>>> and pass a dataview to the geochart. >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Le lundi 25 juin 2012 23:25:41 UTC+2, Susanna Murley a >>>>>>>>>>>>>>>>> écrit : >>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>> I want to create a geochart that allows me to set urls >>>>>>>>>>>>>>>>>> for regions. For example, if someone clicks on California in >>>>>>>>>>>>>>>>>> my map, I want >>>>>>>>>>>>>>>>>> it to link to a separate page on my site. How do I do this? >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/IbaTipBYwlgJ. 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.
