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 (<[email protected] > <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" <[email protected]> >>> To: "SIMILE Widgets" <[email protected]> >>> 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 [email protected]. >>> To post to this group, send email to [email protected]. >>> 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 [email protected] <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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/simile-widgets/6a5d4791-45b7-4ae9-8d56-5f734f46112a%40googlegroups.com.
