See if you are getting data back from the AJAX query by inserting a console.log(json); call in the "success" function. The console should contain output that resembles your data array.
On Wednesday, August 7, 2013 3:04:59 PM UTC-4, kpj wrote: > > Hi, > I dont get any errors in the console now..but nothing is shown on the > page..its just blank > I tried putting a <h1>test</h1> in the body of html page.. > its showing the test on the page..but nothing else shows up > please help > On Wednesday, August 7, 2013 1:41:40 PM UTC-5, kpj wrote: > >> Hi, >> >> I downloaded WAMP , created a folder with my html and text files >> and tried to open the html file .It didnt show anything..Also, in the >> console i see a JSON 501 not implemented error(for DataArray.txt). >> I tried using jsonp instead of json . it didnt work either, >> I have no clue about how to deal this...I am so sorry for bugging you >> with this.. >> Please help me . Thanks >> >> >> On Wednesday, August 7, 2013 10:11:13 AM UTC-5, asgallant wrote: >> >>> Sorry, I forgot to attach it, use this one. >>> >>> If you are getting those errors, then you need to run this from a >>> webserver (you can use WAMP <http://www.wampserver.com/en/> or >>> XAMPP<http://www.apachefriends.org/en/xampp-windows.html>to run a local >>> webserver on Windows) instead of just opening the HTML file. >>> >>> On Wednesday, August 7, 2013 8:55:42 AM UTC-4, kpj wrote: >>>> >>>> Thanks for working on this.. But, i dont see any attachment with your >>>> reply.. >>>> Also, when i opened your previous version in the browser( chrome/IE) >>>> its giving the following errors >>>> >>>> 1. OPTIONS *file:///C:/Users/jastik/Desktop/DataArray.txt* Origin >>>> null is not allowed by Access-Control-Allow-Origin. >>>> jquery.min.js:2<http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js> >>>> >>>> XMLHttpRequest cannot load >>>> file:///C:/Users/jastik/Desktop/DataArray.txt. Origin null is not >>>> allowed by Access-Control-Allow-Origin. chart.html:1 >>>> Please attach the modified file...Thanks >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Wednesday, August 7, 2013 6:35:00 AM UTC-5, kpj wrote: >>>> >>>>> Thanks for working on this.. But, i dont see any attachment with your >>>>> reply.. >>>>> Please attach the modified file...Thanks >>>>> On Tuesday, August 6, 2013 3:56:45 PM UTC-5, asgallant wrote: >>>>> >>>>>> You don't want to put the HTML inside a KML file, it should be run >>>>>> directly as an HTML file from your browser. For that matter, the >>>>>> DataArray >>>>>> and StatArray files aren't really KML files, but the Visualization API >>>>>> doesn't care about that. >>>>>> >>>>>> I reworked the HTML example to handle the dynamic columns (see >>>>>> attached). It makes the assumption that column 0 is always the x-axis >>>>>> column and that the StatArray file is structured like this: >>>>>> >>>>>> ['Inventory', 'Safety stock', 'weight', 'hdsjka'] >>>>>> >>>>>> I can't test this locally, as my system rejects AJAX requests made >>>>>> from the "file" protocol, so you will have to debug it yourself. Use >>>>>> the >>>>>> developer's console in Chrome or Firefox to see what errors pop up. >>>>>> >>>>>> On Tuesday, August 6, 2013 2:04:04 PM UTC-4, kpj wrote: >>>>>>> >>>>>>> thanks for your support >>>>>>> >>>>>>> I pasted your code in a kml file..But, No charts are showing up. >>>>>>> Again, My columns are dynamic .. Thats the whole reason to read the >>>>>>> column labels and keep it in a different file.. >>>>>>> Please find my Kml file in the attachment. >>>>>>> Also, Please let me know a way to read the column lables from the >>>>>>> file rather than entering the column labels in the code. >>>>>>> I would really appreciate if you could help me with the control >>>>>>> wrapper for the columns >>>>>>> >>>>>>> Thanks a ton for your help >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tuesday, August 6, 2013 12:23:09 PM UTC-5, asgallant wrote: >>>>>>> >>>>>>>> The best way to handle this depends on how frequently the data >>>>>>>> changes in your Excel spreadsheet. If you are updating that data >>>>>>>> frequently, then it makes sense to set up a query like this. Any data >>>>>>>> that >>>>>>>> doesn't change (like, perhaps, the columns in the column filter) is >>>>>>>> easier >>>>>>>> to hard-code in the javascript. I attached a sample HTML file that >>>>>>>> assumes >>>>>>>> your data can change but the columns do not. >>>>>>>> >>>>>>>> On Tuesday, August 6, 2013 11:58:50 AM UTC-4, kpj wrote: >>>>>>>>> >>>>>>>>> Thanks for your response. >>>>>>>>> Please find the data file and also columnfilter file in the >>>>>>>>> attachments. >>>>>>>>> I have written an Excel to KML converter in VBA which has modules >>>>>>>>> that convert the excel data into array format and also has a module >>>>>>>>> that >>>>>>>>> pulls all the column lables and puts it in a column array(for >>>>>>>>> creating >>>>>>>>> column filter controlwrapper) >>>>>>>>> so, My excel to kml converter outputs a Main kml file which has a >>>>>>>>> cdata section..inside <Balloon style>.. I am including my google >>>>>>>>> charts in >>>>>>>>> that cdata section.. >>>>>>>>> please find my kml output file in the attachment.. >>>>>>>>> i would like to develop country,, city and column filter control >>>>>>>>> wrappers so, that the user can select his options and view the >>>>>>>>> statistics >>>>>>>>> data in charts.. >>>>>>>>> My converter writes the Main kml file and these two data files at >>>>>>>>> the same file path... >>>>>>>>> i have to pull the data by giving that URL >>>>>>>>> Please correct me if i am wrong.. >>>>>>>>> Thanks alot for your quick response >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tuesday, August 6, 2013 10:41:45 AM UTC-5, asgallant wrote: >>>>>>>>> >>>>>>>>>> First off, this needs to be in an HTML file with appropriate HTML >>>>>>>>>> structure or it won't do anything. Second, in order to help you >>>>>>>>>> with >>>>>>>>>> pulling the data from your local files, it would help to see what >>>>>>>>>> the >>>>>>>>>> contents of those files look like. Third, you have 3 controls, 1 >>>>>>>>>> chart, >>>>>>>>>> and two data sources - I need to know how these should relate to one >>>>>>>>>> another in order to help you make this work. >>>>>>>>>> >>>>>>>>>> On Tuesday, August 6, 2013 11:25:32 AM UTC-4, kpj wrote: >>>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> I am a new bie who is trying to chart the excel data. >>>>>>>>>>> >>>>>>>>>>> I have written the code..but, I am sure there are lot of >>>>>>>>>>> mistakes in it..Could you please help me code? >>>>>>>>>>> My requirements are: >>>>>>>>>>> 1) Reading data from the files which are in a url >>>>>>>>>>> First file is excel sheet data >>>>>>>>>>> second file consists of column labels for creating a column >>>>>>>>>>> filter control wrapper. >>>>>>>>>>> >>>>>>>>>>> 2) creating dashboard and drawing pie and bar chart based on the >>>>>>>>>>> column filter >>>>>>>>>>> >>>>>>>>>>> I need help in reading the formatted data and creating the above >>>>>>>>>>> control wrappers and also creating pie and bar charts.. >>>>>>>>>>> I have written( some of it copy pasted) a code...which is not >>>>>>>>>>> showing anything( obviously, it has lot of errors) >>>>>>>>>>> Could you please take a look at the code and correct it? >>>>>>>>>>> I would really appreciate your help, as this is an important >>>>>>>>>>> task to complete .... >>>>>>>>>>> please find the code in the attachment. >>>>>>>>>>> Thanks in advance >>>>>>>>>>> >>>>>>>>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
