Also, the problem with the HTML is in this line: <script type="text / javascript">
it should be this (no spaces around the "/"): <script type="text/javascript"> On Saturday, August 10, 2013 10:52:15 PM UTC-4, asgallant wrote: > > I probably should have asked this a while ago, but what are you doing with > the KML file? > > On Saturday, August 10, 2013 9:58:28 PM UTC-4, kpj wrote: >> >> Thanks for fixing that.. >> But, when i pass the same code into the <BalloonStyle> using CDATA, in my >> Excel to KML converter ,,its not showing up anything in the balloon..but, >> when i copy, paste the same code in each balloon style..the charts are >> showing up in the balloon.. >> Is there any specific reason? >> I have written functions in VBA to print the dataArrays inside CDATA.I am >> printing in the right format too,, >> But, i just dont know, why its not showing up.. >> If you want to look at my Kml file,,please find it in the attachment.. >> Thanks alot for helping me out..I really appreciate your help >> >> On Saturday, August 10, 2013 10:44:19 AM UTC-5, asgallant wrote: >> >>> There are a few things you need to fix here. First, you cannot use the >>> variable name "Array" for your data structure, as doing so overwrites the >>> Array object! Change it to something safe like "dataArray". Second, you >>> are missing the "columnsTable" DataTable that drives the column selector; >>> you need to add that back in. Here's a jsfiddle with the fixes applied: >>> http://jsfiddle.net/asgallant/RtcGu/ >>> >>> On Friday, August 9, 2013 7:16:03 PM UTC-4, kpj wrote: >>>> >>>> Hi, >>>> >>>> I have dropped the idea of doing AJAX requests for reading text files. >>>> Instead, i got the data array and extended data arrays into the html >>>> code using cdata.. >>>> now, for some reason,, the code isnt functioning and nothing is shown >>>> in the page.. >>>> Could you please take a look at the code.. >>>> please find the file in the attachment >>>> Thanks a ton for helping me out >>>> >>>> >>>> On Thursday, August 8, 2013 6:14:35 PM UTC-5, asgallant wrote: >>>>> >>>>> Examine the console.log(json) output to see if it is being parsed as a >>>>> string or as a javascript array. If it is a string, you need to >>>>> deserialize the string using JSON.parse: >>>>> >>>>> var data = google.visualization.arrayToDataTable(JSON.parse(jsonp)); >>>>> On Thursday, August 8, 2013 6:40:41 PM UTC-4, kpj wrote: >>>>>> >>>>>> The input text file is being read and then at success(json) it is >>>>>> jumping into done status. >>>>>> so, i am sure it has something to do with the input through json..it >>>>>> is not getting passed, i guess..as i am not an experienced front end >>>>>> developer,, i am not able to see why and how it is not accepting the >>>>>> data.. >>>>>> >>>>>> thanks alot for looking into the issue.. >>>>>> please let me know if you have anything to say on this.. >>>>>> >>>>>> On Thursday, August 8, 2013 3:32:59 PM UTC-5, asgallant wrote: >>>>>> >>>>>>> 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.
