The number 1 is just perfect and you may just add 1 to it each time. That would be perfect for me!
Christian 2009/12/3, Christian Legault <[email protected]>: > Hi George, > > If it's'for me it can be number and you just have to add 1 each time > the user complete a form. If I can manage myself the start number, > it'll be great but not a must. It may start at 1 and add another at > each time until the end of the year and start over or not. As you can > see, you may choose how to do it. I'll try to adjust myself and the > form/spreadsheet. > > Thanks! > > Christian > > 2009/12/3, gman <[email protected]>: >> Thanks for the link, but I am still lost as to how to implement this >> information. If I look at a simple example: >> >> If I create a csv file called test.csv that contains the following: >> >> Number >> 1 >> >> I then call this function using: >> >> http://localhost:8080/myWebApp/csv?url=http://localhost:8080/myWebApp/test.csv >> >> I get the following returned: >> >> google.visualization.Query.setResponse >> ({version:'0.6',status:'ok',sig:'1736046499',table:{cols: >> [{id:'Col0',label:'Number',type:'string',pattern:''}],rows:[{c: >> [{v:'1'}]}]}}); >> >> Can show me the code I need to add so that it returns 1 as a number >> and not a string? >> >> Thanks....George >> >> On Dec 1, 1:44 pm, Viz Kid <[email protected]> wrote: >>> You can find an example usage of this code in its test >>> file:http://www.google.com/codesearch/p?hl=en#aLJwv4TSmDw/trunk/src/test/j... >>> >>> Viz Kid >>> >>> >>> >>> On Tue, Dec 1, 2009 at 8:11 PM, gman <[email protected]> wrote: >>> > Viz Kid --- You are definitely on the right track. It looks like the >>> > package I am using expects to see strings only. This is the output I >>> > get: >>> >>> > google.visualization.Query.setResponse >>> > ({version:'0.6',status:'ok',sig:'1758220977',table:{cols: >>> > [{id:'Col0',label:'string',type:'string',pattern:''}, >>> > {id:'Col1',label:'number',type:'string',pattern:''}],rows:[{c: >>> > [{v:'Memory'},{v:'80'}]},{c:[{v:'CPU'},{v:'55'}]},{c:[{v:'Network'}, >>> > {v:'68'}]}]}}); >>> >>> > The first cloumn in the csv file is a string and the second is a >>> > number. This is returning them both as strings. The culprit seems to >>> > be the CsvDataSourceHelper. I am using the code from the examples, >>> > specifically CsvDataSourceServlet. In this code is the following >>> > comments: >>> >>> > // Note: We assume that all the columns in the CSV file are text >>> > columns. In cases where the >>> > // column types are known in advance, this behavior can be >>> > overridden by passing a list of >>> > // ColumnDescription objects specifying the column types. See >>> > CsvDataSourceHelper.read() for >>> > // more details. >>> > dataTable = CsvDataSourceHelper.read(reader, null, true, >>> > requestLocale); >>> >>> > So it looks like I need to change the options from the >>> > CsvDataSourceHelper. From the documentation the fields are defined as: >>> >>> > reader - The CSV input Reader from which to read. >>> > columnDescriptions - The column descriptions. If >>> > columnDescriptions is null, then it is assumed that all values are >>> > strings, and the number of the columns is equal to the number of the >>> > columns in the first line of the reader. If headerRow is set to true, >>> > and the columnDescriptions does not contain the labels of the columns, >>> > then the headerRow values are used as the column labels. >>> > headerRow - True if there is an header row. In that case, the >>> > first line of the csv is taken as the header row. >>> > locale - An optional locale in which to parse the input csv file. >>> > If null, uses the default from LocaleUtil#getDefaultLocale. >>> >>> > So it looks like the columnDescriptions needs to be changed to specify >>> > the data types. I cannot seem to find an example of what the syntax >>> > would look like for this code. >>> >>> > Can you show me what the syntax looks like or where I can look at an >>> > example. >>> >>> > As you may have guess by now, I am not much of a java expert -- more >>> > of a php guy :-) >>> >>> > ....George >>> >>> > On Nov 30, 8:20 am, Viz Kid <[email protected]> wrote: >>> > > First, in order to make sure that the problem indeed lies with the >>> > > second >>> > > column type, you can look at the response itself and verify what are >>> > > the >>> > > returned column types (this should be in json format). If indeed >>> > > both >>> > > columns are strings, you need to look at your code which generates >>> > > the >>> > > DataTable from the csv file. Otherwise, the problem is someplace >>> > > else. >>> >>> > > If you are using our external Java library to create the DataTable >>> > > from >>> > the >>> > > csv, you need to specify the the column types (this is not part of >>> > > the >>> > csv >>> > > file itself). The general documentation of the library is >>> > > here< >>> >http://code.google.com/apis/visualization/documentation/dev/dsl_javad...>, >>> > > you can look inside the package >>> >>> > com.google.visualization.datasource.util<com/google/visualization/datasourc >>> > e/util/package-frame.html> >>> > > , and specifically, the CsvDataSourceHelper >>> > > <CsvDataSourceHelper.html> >>> > class >>> > > which can construct the DataTable from the csv file/url. The read >>> > function >>> > > also expects a the type for each of the columns. >>> >>> > > Hope it will work now, >>> > > Viz Kid. >>> >>> > > On Mon, Nov 30, 2009 at 3:01 PM, gman <[email protected]> wrote: >>> > > > Thanks Viz Kid --- That would make sense. I just created the csv >>> > > > file >>> > > > using the linux vi editor and saving as a .csv file. >>> >>> > > > Does it have to be created a special way? >>> >>> > > > I thought a csv file was just a text file with comma separating >>> > > > the >>> > > > data fields, with each record on a new line. Am I missing >>> > > > something?. >>> >>> > > > On Nov 29, 5:26 pm, Viz Kid <[email protected]> wrote: >>> > > > > Hi. >>> >>> > > > > Is it possible that the data table which is constructed from the >>> > > > > csv >>> > has >>> > > > > both columns type to be 'string' and not one 'string' and one >>> > 'number'? >>> > > > If >>> > > > > this is the case, the outcome is indeed that no gauge is being >>> > displayed. >>> >>> > > > > Viz Kid >>> >>> > > > > On Sun, Nov 29, 2009 at 2:26 PM, gman <[email protected]> wrote: >>> > > > > > I just started playing with this yesterday and have run into a >>> > problem >>> > > > > > I just cannot seem to get by. >>> >>> > > > > > Using the sample code for gauges I can display the gauges >>> > > > > > fine. >>> > When I >>> > > > > > get the data from a csv file, no gauges are displayed. However >>> > > > > > if I >>> > > > > > change to display a table, it displays just fine. The csv file >>> > looks >>> > > > > > like this: >>> >>> > > > > > Label,Value >>> > > > > > Memory,80 >>> > > > > > CPU,55 >>> > > > > > Network,68 >>> >>> > > > > > This does work: >>> >>> > > > > > // var data = response.getDataTable(); >>> > > > > > var data = new google.visualization.DataTable(); >>> > > > > > data.addColumn('string', 'Label'); >>> > > > > > data.addColumn('number', 'Value'); >>> > > > > > data.addRows(3); >>> > > > > > data.setValue(0, 0, 'Memory');// >>> > > > > > data.setValue(0, >>> > 1, >>> > > > > > 80); >>> > > > > > data.setValue(1, 0, 'CPU');// data.setValue(1, >>> > > > > > 1, >>> > > > > > 55); >>> > > > > > data.setValue(2, 0, 'Network'); >>> > > > > > data.setValue(2, 1, 68); >>> >>> > > > > > var chart = new google.visualization.Gauge >>> > > > > > (document.getElementById('char >>> > > > > > t_div')); >>> > > > > > chart.draw(data, null); >>> >>> > > > > > This does not work: >>> >>> > > > > > var data = response.getDataTable(); >>> > > > > > // var data = new google.visualization.DataTable(); >>> > > > > > // data.addColumn('string', 'Label'); >>> > > > > > // data.addColumn('number', 'Value'); >>> > > > > > // data.addRows(3); >>> > > > > > // data.setValue(0, 0, 'Memory');// >>> > data.setValue(0, >>> > > > > > 1, 80); >>> > > > > > // data.setValue(1, 0, 'CPU');// >>> > > > > > data.setValue(1, >>> > 1, >>> > > > > > 55); >>> > > > > > // data.setValue(2, 0, 'Network'); >>> > > > > > // data.setValue(2, 1, 68); >>> >>> > > > > > var chart = new google.visualization.Gauge >>> > > > > > (document.getElementById('char >>> > > > > > t_div')); >>> > > > > > chart.draw(data, null); >>> >>> > > > > > Yet --- Exactly the same code, but changing to a table does >>> > > > > > work: >>> >>> > > > > > var data = response.getDataTable(); >>> > > > > > // var data = new google.visualization.DataTable(); >>> > > > > > // data.addColumn('string', 'Label'); >>> > > > > > // data.addColumn('number', 'Value'); >>> > > > > > // data.addRows(3); >>> > > > > > // data.setValue(0, 0, 'Memory');// >>> > data.setValue(0, >>> > > > > > 1, 80); >>> > > > > > // data.setValue(1, 0, 'CPU');// >>> > > > > > data.setValue(1, >>> > 1, >>> > > > > > 55); >>> > > > > > // data.setValue(2, 0, 'Network'); >>> > > > > > // data.setValue(2, 1, 68); >>> >>> > > > > > var chart = new google.visualization.Table >>> > > > > > (document.getElementById('char >>> > > > > > t_div')); >>> > > > > > chart.draw(data, null); >>> >>> > > > > > Any ideas or suggestions? >>> >>> > > > > > -- >>> >>> > > > > > 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]<google-visualization- >>> > > > > > api%[email protected]> >>> > <google-visualization-api%[email protected]<google-visualizati >>> > on-api%[email protected]> >>> >>> > > > <google-visualization-api%[email protected]<google-visualizati >>> > > > on-api%[email protected]> >>> > <google-visualization-api%[email protected]<google-visualiza >>> > tion-api%[email protected]> >>> >>> > > > > > . >>> > > > > > For more options, visit this group at >>> > > > > >http://groups.google.com/group/google-visualization-api?hl=en. >>> >>> > > > -- >>> >>> > > > 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]<google-visualization- >>> > > > api%[email protected]> >>> > <google-visualization-api%[email protected]<google-visualizati >>> > on-api%[email protected]> >>> >>> > > > . >>> > > > For more options, visit this group at >>> > > >http://groups.google.com/group/google-visualization-api?hl=en. >>> >>> > -- >>> >>> > 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]<google-visualization- >>> > api%[email protected]> >>> > . >>> > For more options, visit this group at >>> >http://groups.google.com/group/google-visualization-api?hl=en. >> >> -- >> >> 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. >> >> >> > > -- > Envoyé avec mon mobile > > > > Christian > -- Envoyé avec mon mobile Christian -- 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.
