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