If you are getting the correct data from the file, is it still not working? Do you see any errors in the developer's console?
On Thursday, August 8, 2013 2:00:41 PM UTC-4, kpj wrote: > > The double forward slashes work and i am able to see my data array file in > the response. > i tried using single forward slash and its throwing error. > Do you think everything else in the code works fine? > Thanks alot for ur support > > > On Thursday, August 8, 2013 12:55:05 PM UTC-5, asgallant wrote: > >> I don't think you can do AJAX calls on the "file" protocol. If you want >> to try it again and see if it works this way, then you will need to fix the >> URL's, which shouldn't have doubled forward-slashes in them (you have to >> double up the backslashes because they are javascript's string escape >> character): >> >> url:'file://172.23.106.55/C$/Users/jastik/Desktop/DataArray.txt', >> On Thursday, August 8, 2013 1:42:33 PM UTC-4, kpj wrote: >>> >>> Hi, >>> >>> i have made few changes to the code >>> 1) accessing the local file using IP address in the path >>> 2) changing type:json to dataType:JSONP >>> >>> Now i am not getting any errors but,, nothing is being shown..also, i >>> dont see any request for my second text file.. >>> I changed the data in StatArray.txt to a single row array( suggested by >>> you) >>> Please look into the code and let me know if there is anything thats >>> blocking the html page to show up. >>> Thanks for your support >>> >>> On Wednesday, August 7, 2013 2:33:00 PM UTC-5, asgallant wrote: >>> >>>> 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.
