Another way I tried : 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 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. pls let me know ...its quite important!! thanks On Thu, Jun 18, 2009 at 8:04 PM, Anjali Jain <[email protected]> wrote: > i am trying on my google apps domain so cant share its credentials with > you. sorry about it. > But if you have a google apps domain account you can follow similar steps. > > I also tried similar using gmail account . I have shared the spreadsheet > with you Chartman that I am using. > > This spreadsheet has a gadget inserted. If you get the gadget url from this > spreadsheet into your site you should be able to reproduce the problem. > > The gadget url is following: > http://www.google.com/ig/modules/table.xml > > Seems this is an official google gadget with filter and grouping > capabilities. > http://www.google.com/ig/directory?url=www.google.com/ig/modules/table.xml > > > > thanks > > > > > On Thu, Jun 18, 2009 at 6:20 PM, Anjali Jain <[email protected]> wrote: > >> wondering as I am working on my google app domain so cant provide it >> publicly. >> >> Let me know how can I help you. But if you have a google app domain, then >> you can simply follow the steps as mentioned below. You can try with any >> spreadsheet >> >> >> >> thanks >> >> >> >> On Thu, Jun 18, 2009 at 5:00 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 -~----------~----~----~----~------~----~------~--~---
