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). > > 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 -~----------~----~----~----~------~----~------~--~---
