Hi, Luis Miguel: The page loads fine from the MIT server but if you download it to localhost the page complains about Math dependencies. I deleted the dependencies and the page loaded without the cloud tags. Although I tried the csv option suggested by David, I couldn't make SIMILE Exhibit to load the Google sheets file. It just stops. I managed to make the project work by copying the new spreadsheet contents to an old Google spreadsheet that had been validated by Sheets to JSON a few years back. Best, Daniel
On Thursday, November 14, 2019 at 9:00:16 AM UTC-5, Luis Miguel Morillas wrote: > > Hi, Daniel > > What's the issue with this page? I can see it ok > > > Saludos, > > -- luismiguel (@lmorillas) > > > El jue., 14 nov. 2019 a las 14:47, dhinostroza (<dhino...@gmail.com > <javascript:>>) escribió: > >> Hi David, >> The url http://people.csail.mit.edu/karger/Exhibit/Papers/ >> <http://www.google.com/url?q=http%3A%2F%2Fpeople.csail.mit.edu%2Fkarger%2FExhibit%2FPapers%2F&sa=D&sntz=1&usg=AFQjCNHD4ux7k45rFUdkb1Eq030KZySxaA> >> complains >> about MathZoom.js & similar dependencies. If you disregard the >> 'ReferenceError: Exhibit is not defined' the page can be loaded locally. >> As Sheets to JSON isn't working anymore I tried using Google Publish to >> web with the csv option but so far haven't been able to make the csv file >> load. >> Is there any plan to get Sheets to JSON up and running again or is csv >> definitely the way to go from here on? >> All the very best, >> Daniel >> >> On Saturday, December 1, 2018 at 5:21:53 PM UTC-5, David Karger wrote: >>> >>> Note that the latest incarnation of gdocs will also let you get a link >>> to the data as a csv file that you can read into exhibit using the text/csv >>> data type. See for example >>> http://people.csail.mit.edu/karger/Exhibit/Papers/ >>> >>> ------ Original Message ------ >>> From: "jjon" <crum...@gmail.com> >>> To: "SIMILE Widgets" <simile-...@googlegroups.com> >>> Sent: 12/1/2018 4:32:11 PM >>> Subject: [Simile-Widgets] Re: Using Sheets to JSON >>> >>> Hi Shawn, >>> >>> This is what worked for me. I had a spreadsheet at >>> >>> https://docs.google.com/spreadsheets/d/1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk/edit#gid=0 >>> >>> Note that 1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk is the ID for the >>> sheet. >>> >>> I did "publish to the web" and the dialog gave me this url: >>> >>> https://docs.google.com/spreadsheets/d/e/2PACX-1vSXmb6tv3ThsUp_uBnvLuB9PEA7C5eifsDpV5Wa1q68Xq0j8xerH6liR_IWuL-ykPQJzWVSalRPKkrj/pubhtml >>> >>> Now ignore that URL. This is the <link> I put in the head of my Exhibit >>> page to access JSON from that spreadsheet: >>> <link rel="exhibit/data" type="application/jsonp" >>> href=" >>> https://spreadsheets.google.com/feeds/list/1qZ6Sgu2qcKy-Rbc-L_5YN-zJD2jErOw2BUhur3-yWlk/od6/public/basic?hl=en_US&alt=json-in-script >>> " >>> data-ex-converter="googleSpreadsheets" /> >>> >>> >>> Notice that it uses the ID from the URL used to access the sheet >>> directly. >>> >>> More recently, for a different Exhibit, I found I had to further tinker >>> with a data link URL such that: >>> https:// >>> spreadsheets.google.com/feeds/list/standardSheetURL_ID/1/public/basic?hl=en_US&alt=json-in-script#gid=115609054 >>> " >>> >>> >>> >>> >>> Notice that /od6/ has been replaced by the number of the sheet: /1/; >>> and, the gid has been tacked on to the end. >>> I found this blog post >>> <http://cwestblog.com/2018/03/25/google-sheets-data-as-json-jsonp/> >>> instructive as well. >>> >>> Also, note David Karger's post >>> <https://groups.google.com/d/msg/simile-widgets/ctqxFM9dvgA/Yl8dwybIEQAJ> >>> to the list here. >>> >>> Google keeps tinkering with stuff, and is not always very transparent >>> about it. >>> >>> Jon >>> >>> On Saturday, December 1, 2018 at 12:59:47 PM UTC-8, Shawn Day wrote: >>>> >>>> I used to use the lovely URL converter to take a shared Google Sheet >>>> and make it available as a JSON data source for Exhibit. >>>> When I attempted to use : >>>> https://docs.google.com/spreadsheets/d/e/2PACX-1vQIJyC-n5M3OKQbRT7FgdPrhxxDNuZZNebJprFRFlhgTLAUUpk97hTvoct0P5nn2Gye0T2bVd6DUfN8/pubhtml >>>> >>>> a very simple google sheet, it returns the error "Could not access >>>> page/Could not find page data." despite the fact that the sheet is both >>>> shared and published. >>>> Any assistance greatly appreciated. I attempted to truncate the URL by >>>> removing the pubhtml with no luck. >>>> Thanks in advance, >>>> Shawn >>>> >>> >>> >>> On Saturday, December 1, 2018 at 12:59:47 PM UTC-8, Shawn Day wrote: >>>> >>>> I used to use the lovely URL converter to take a shared Google Sheet >>>> and make it available as a JSON data source for Exhibit. >>>> When I attempted to use : >>>> https://docs.google.com/spreadsheets/d/e/2PACX-1vQIJyC-n5M3OKQbRT7FgdPrhxxDNuZZNebJprFRFlhgTLAUUpk97hTvoct0P5nn2Gye0T2bVd6DUfN8/pubhtml >>>> >>>> a very simple google sheet, it returns the error "Could not access >>>> page/Could not find page data." despite the fact that the sheet is both >>>> shared and published. >>>> Any assistance greatly appreciated. I attempted to truncate the URL by >>>> removing the pubhtml with no luck. >>>> Thanks in advance, >>>> Shawn >>>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "SIMILE Widgets" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to simile-...@googlegroups.com. >>> To post to this group, send email to simile-...@googlegroups.com. >>> Visit this group at https://groups.google.com/group/simile-widgets. >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "SIMILE Widgets" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to simile-...@googlegroups.com <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/simile-widgets/967094a6-7ae7-4ca0-8995-41b40d94545e%40googlegroups.com >> >> <https://groups.google.com/d/msgid/simile-widgets/967094a6-7ae7-4ca0-8995-41b40d94545e%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To unsubscribe from this group and stop receiving emails from it, send an email to simile-widgets+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/simile-widgets/6a5d4791-45b7-4ae9-8d56-5f734f46112a%40googlegroups.com.
