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). 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" ,(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.xml gadget doesn't 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 -~----------~----~----~----~------~----~------~--~---
