The table xml first userpref is the datasourceurl. The datasourceurl can have the following structure http://spreadsheets.google.com/tq?key=ABC&tq=select A Note the last part tq=.. which accepts a query string in the following language http://code.google.com/apis/visualization/documentation/querylanguage.html I think you can achive your needs by setting the apporpriate query string.
On Tue, Jun 30, 2009 at 2:15 PM, Amit <[email protected]> wrote: > > Hello ChartMan > And now, with this fix, i'm able to use table.xml ,provide URL of my > spreadsheet and insert it as a gadget in my page . Of course the > gadget shows all the columns of the spreadsheet. > > My Requirement: > 1) I don't want all the columns of the spreadsheet to be shown. I wish > to select columns as user preferences i.e dynamically. The selected > columns would be displayed in gadget. > This is an important requirement. > Can we have a user preference added in the gadget for sheet number and > columns > i think, following changes would then be required : > > <UserPref name="columnNumber" display_name="Select column" > required="true"/> > > var columns = prefs.getString("columnNumber"); > columns = columns.toUpperCase(); > > //var query = gadgetHelper.createQueryFromPrefs(prefs); > var query = new google.visualization.Query(_table_query_url + > "&gid="+gid ); > query.setQuery('select '+columns +' order by '+orderBy); > > > > 2) I edited table.xml to tailor my requirement along with table.js, > but then i need to save them and they have dependency threads of > calls. Nutshell, doesn't seem feasible. > > > Enlightenment/ suggestion appreciated. > > thanks > > On Jun 30, 2:05 pm, Amit <[email protected]> wrote: > > Thanks a lot. The fix works as expected. > > > > -ak > > > > On Jun 29, 10:31 pm, ChartMan <[email protected]> wrote: > > > > > I submitted a fix today. > > > Please check if this works for you now. > > > ChartMan > > > > > On Sun, Jun 21, 2009 at 12:11 PM, Anjali Jain <[email protected]> > wrote: > > > > Thanks ChartMan for all your efforts. > > > > > > Any idea by when we could have this bug fixed. This feature is very > > > > important for us and we are looking forward to add this into our site > asap. > > > > > > On Sun, Jun 21, 2009 at 11:53 AM, ChartMan <[email protected]> > wrote: > > > > > >> Hi Amit > > > >> Ok, could finally reproduce the issue you were mentioning. It seems > as if > > > >> this is a bug in the way sites is loading this specific gadget. > > > >> The gadget can still be loaded to iGoogle or "google spreadsheet". > > > > > >> I will add this to our bug list. > > > >> Thanks for reporting this. > > > > > >> ChartMan > > > > > >> On Thu, Jun 18, 2009 at 4:38 PM, Amit <[email protected]> wrote: > > > > > >>> Hello ChartMan, > > > >>> (credentials [email protected] / santosham) > > > > > >>> We have an Official Google Gadget. It's an interactive table, with > > > >>> filters and grouping (http://www.google.com/ig/modules/table.xml) > > > > > >>> I wish to get a google gadget which can show data of my spreadsheet > in > > > >>> a manner shown by this gadget (http://www.google.com/ig/modules/ > > > >>> table.xml <http://www.google.com/ig/modules/%0Atable.xml>). > > > > > >>> For this i followed these steps: > > > >>> 1. I have a google spreadsheet > > > >>> Address: > > > >>> > http://spreadsheets.google.com/ccc?key=ryBYOWBG27Gcju8O_LHG77w&hl=en > > > > > >>> 2. i wish to display content of this spreadsheet "as a filter & > > > >>> grouping table gadget" in my site > > > > > >>> Site is -http://sites.google.com/site/gurgaonclubsite/Home > > > > > >>> Insert->more gadgets->Add gadget by URL > > > >>> It asks for - Enter the URL for a gadget you want to add > > > >>> and i provide -http://www.google.com/ig/modules/table.xml > > > > > >>> 3. Now, it asks for "Data source url" which, i think is URL of my > > > >>> spreadsheet i.e > > > >>> > http://spreadsheets.google.com/ccc?key=ryBYOWBG27Gcju8O_LHG77w&hl=en > > > > > >>> Now i click preview and Bingo! nothing comes ! > > > >>> Can you please point out if anything is missed or followed > > > >>> incorrectly. > > > > > >>> Note: if i repeat all these steps with "http://www.google.com/ig/ > > > >>> modules/simple-table.xml< > http://www.google.com/ig/%0Amodules/simple-table.xml>" > > > >>> ,(pay attention its simple-table.xml) things > > > >>> work fine and i can see my spreadsheet data as a table gadget. But > > > >>>http://www.google.com/ig/modules/simple-table.xmlgadgetdoesn't<http://www.google.com/ig/modules/simple-table.xmlgadgetdoesn%27t> > > > >>> provide filtering & grouping, which indeed is my requirement. > > > > > >>> Help / suggestions appreciated. > > > >>> Thanks > > > > > >>> On Jun 18, 4:30 pm, ChartMan <[email protected]> wrote: > > > >>> > can you please send the example so I can see what the problem is. > > > >>> > Make sure I can access both the site and the spreadsheet. > > > > > >>> > ChartMan > > > > > >>> > On Thu, Jun 18, 2009 at 1:34 PM, anjs<[email protected]> wrote: > > > > > >>> > > I tried doing that but I am not able to see the gadget on my > google > > > >>> > > site. > > > > > >>> > > did following : > > > > > >>> > > 1. Created a spreadsheet with some data > > > >>> > > 2. Selected A-C columns and Inserted a gadget in spreadsheet > > > >>> > > 3. Then from Gadget Drop down menu, picked the datasource url > > > >>> > > 4. Get Gadget XML url from gadget drop down menu > > > >>> > > 5. Login to my google app account (premium account) > > > >>> > > 6. Created a google site > > > >>> > > 7. Inserted the gadget on google site by specifying the gadget > url > > > >>> > > 8. It gives following user preference options when I am > inserting the > > > >>> > > gadget. > > > >>> > > Data source URL -: I specified the URL that i saved earlier > > > >>> > > Show filters is checked > > > >>> > > Show groupings is checked > > > >>> > > 9. But the gadget does not display. It shows that some > processing is > > > >>> > > going on but nothing happens even after waiting for a long time > > > > > >>> > > Can you please let me know whats the issue. I tried giving > datasource > > > >>> > > url with ccc (withut any query) and with query(using tq) > > > > > >>> > > But no success.. > > > > > >>> > > Pls suggest > > > > > >>> > > On Jun 18, 11:56 am, ChartMan <[email protected]> wrote: > > > >>> > >> You an embed the gadget in any application that supports > inserting a > > > >>> > >> gadget (e.g., sites, iGoogle). > > > >>> > >> Select the gadget url you want to add (from the gadget left > menu in > > > >>> > >> spreadsheets select "get gadget xml"), > > > >>> > >> then after embedding of the gadget fill the 'data source url' > to be > > > >>> > >> the spreadsheet url with '/ccc' replaced with '/tq'. > > > > > >>> > >> Alternatively if it is your own site you can get an html > snippet > > > >>> that > > > >>> > >> embeds the gadget with all its setting - the snippet can > > > >>> > >> be retrieved from the same gadget menu when you select > "publish > > > >>> gadget". > > > > > >>> > >> Hope this help > > > > > >>> > >> ChartMan > > > > > >>> > >> On Thu, Jun 18, 2009 at 8:11 AM, anjs<[email protected]> > wrote: > > > > > >>> > >> > The same can be achieved if I create a gadget inside a > spreadsheet > > > >>> by > > > >>> > >> > selecting thr desired columns. But the concern is that the > gadget > > > >>> is > > > >>> > >> > embedded inside the spreadsheet. And I am looking for a > gadget > > > >>> that > > > >>> > >> > can be placed on my Google Site. > > > > > >>> > >> > Can I use this gadget externally and insert it on my google > site? > > > >>> Can > > > >>> > >> > this gadget accept spreadsheet as an input so that it can be > used > > > >>> with > > > >>> > >> > any user supplied spreadsheet. > > > > > >>> > >> > thanks > > > > > >>> > >> > On Jun 18, 1:49 am, ChartMan <[email protected]> wrote: > > > >>> > >> >> Hi > > > > > >>> > >> >> This is indeed a nice feature to add to the table. > > > >>> > >> >> In the mean while you - you can create your own select > elements > > > >>> and > > > >>> > >> >> when they are changed you can filter the underlying data > table > > > >>> > >> >> accordingly and re-draw the visualization. > > > >>> > >> >> This requires little bit coding but may be a reasonable > solution > > > >>> for > > > >>> > >> >> your problem. > > > > > >>> > >> >> ChartMan > > > > > >>> > >> >> On Wed, Jun 17, 2009 at 7:46 PM, anjs<[email protected]> > wrote: > > > > > >>> > >> >> > Hello, > > > > > >>> > >> >> > For any spreadsheet, google provides a list view (Can be > chosen > > > >>> from > > > >>> > >> >> > View-->List View from any open Google spreadsheet). We > are > > > >>> expecting a > > > >>> > >> >> > similar gadget that takes spreadsheet as an input , fires > a > > > >>> query on > > > >>> > >> >> > that spreadsheet and displays the resultant spreadsheet > data > > > >>> with > > > >>> > >> >> > filters and sort as provided by List View option under > google > > > >>> > >> >> > spreadsheet. > > > > > >>> > >> >> > Is there any way by which filtering and sorting is > provided ? I > > > >>> know > > > >>> > >> >> > about Table Visualization but that does not seem to have > > > >>> filters on > > > >>> > >> >> > the headers as in List View. > > > > > >>> > >> >> > Any comments/suggestions is appreciated. > > > > > >>> > >> >> > thanks- Hide quoted text - > > > > > >>> > >> >> - Show quoted text -- Hide quoted text - > > > > > >>> > >> - Show quoted text - > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
