I agree that such an option is helpful yet it is also very specific. It is straightforward writing your own gadget adding all the specific userprefs you need. The gadget would then use the google visualization api internally - see here http://code.google.com/apis/visualization/documentation/gallery/table.html You can also inspect the simple-table gadget xml as a reference.
On Tue, Jun 30, 2009 at 4:20 PM, Amit <[email protected]> wrote: > > Very correct. > The users for whom this functionality is desired are not that > technical, so providing the columns in the url would not be feasible > here. > Perhaps the requirement here is : the user has to configure/provide > the columns which would be shown in the gadget. > Like we provide refresh interval, height, width, Grouping check... > In a similar way user will provide columns (for eg. A, B, D, G) of the > spreadsheet. > > > > On Jun 30, 4:48 pm, ChartMan <[email protected]> wrote: > > The table xml first userpref is the datasourceurl. The datasourceurl can > > have the following structurehttp:// > spreadsheets.google.com/tq?key=ABC&tq=selectA > > Note the last part tq=.. which accepts a query string in the following > > languagehttp:// > code.google.com/apis/visualization/documentation/querylanguage... > > 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> > <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 -~----------~----~----~----~------~----~------~--~---
