I've simplified your page. I don't know if it's you need. The example uses your spreadsheet and a simplified version of your html page translated to exhibit 3 syntax [1]
[1] http://lmorillas.github.io/exhibit_tests/testoacurriculum/ Saludos, -- luismiguel (@lmorillas) El jue, 9 sept 2021 a las 1:00, jjon (<[email protected]>) escribió: > > Luis, Daniel, David, et al. > I have an exhibit page that worked fine for a long time using jsonp to > retrieve data from a public google spreadsheet. The php generated a <link/> > in the head like this: > ```<link rel="exhibit/data" > type="application/jsonp" > > href="https://spreadsheets.google.com/feeds/list/1QFApf8MGr-ZP-OqvKtPFUEASuaq9_vuvLOfanC4NGHQ/od6/public/basic?alt=json-in-script"; > ex:converter="googleSpreadsheets" />``` > That doesn't work any more. > Following your discussion, I tried to find a way to fetch and parse the data > as csv. > Like Daniel I thought Ben Borgers solution might take too much fiddleing > (just hacking off the function call seems, well, hacky). > Luis's example doesn't seem to work either. > I finally figured out a url that would return the spreadsheet data as csv. > This is what the <link/> element now looks like: > ```<link > > href="https://docs.google.com/spreadsheets/d/1QFApf8MGr-ZP-OqvKtPFUEASuaq9_vuvLOfanC4NGHQ/export?format=csv"; > type="text/csv" > rel="exhibit/data" > > data-ex-properties="label,itemID,Link1,Link2,Link3,Short_Description:single,Long_Description:single,Developer,Category,Activity_Type,imageURL,Tags,Grade_Band,OA_Principle" > data-ex-has-column-titles="true" > /> > This successfully retrieves csv from the spreadsheet, but Exhibit does not > seem to parse it correctly. > On load, in the console I get, among other things: > a warning: Item entry has no label and no id: {} debug.js:57:21 > a report: Failed to create view Summary (0) debug.js:35:21 > and an error: TypeError: Exhibit.Formatter._constructors[valueType] is not a > constructor. ...debug.js:90:25 > > any clues as to how I might repair this would be welcome. > best > Jon > > On Saturday, August 21, 2021 at 9:21:11 AM UTC-7 Luis Miguel Morillas wrote: >> >> Hola, Daniel, >> >> Well, the first approach, as Ben says, works fine now, but it returns >> a json that you must arrange to work with exhibit[1] if you use this >> spreadsheet for example [2] with this url [3] as Ben suggests. >> >> I think it's easier to use csv from google spreadsheets directly. Or >> you can get the csv and convert internally to json, but exhibit can >> read right the csv. >> >> [1] https://gist.github.com/lmorillas/cbf2a0fb4a28ba7d016568ac9269bd37 >> [2] >> https://docs.google.com/spreadsheets/d/1v-b_AaChE431LvPLlGFSykJFoD--OKRBOjqgiZ7hqPA/edit#gid=180101019 >> [3] >> https://docs.google.com/spreadsheets/d/1v-b_AaChE431LvPLlGFSykJFoD--OKRBOjqgiZ7hqPA/gviz/tq?tqx=out:json >> >> Saludos, >> >> -- luismiguel (@lmorillas) >> >> >> El vie, 20 ago 2021 a las 21:46, dhinostroza (<[email protected]>) escribió: >> > >> > Hi Luis Miguel and David, >> > I tested Ben Borgers solution first and it didn't work on the first go. >> > Maybe it's just a matter of tweaking it a bit further to get the settings >> > right... >> > So, I then tested Luis Miguel's solution (publishing the Google >> > spreadsheet to csv and replacing the json link with the full published as >> > csv link in my SIMILE page) and it worked perfectly. >> > It looks like this (I made up the column titles for this example): >> > <link >> > href="https://docs.google.com/spreadsheets/d/e/2PACX-1vSq-fac7XtI1IXXXXXXxxXXXXXxxXXXXXXxXXXXNXXXXXXXXXXXX_XXXXXXXXX_XXXXXXXXXXXXXXXX/pub?gid=1300000000&single=true&output=csv"; >> > type="text/csv" rel="exhibit/data" >> > data-ex-properties="label,ID,Lname,Fname,Email,Observations" >> > data-ex-has-column-titles="true"/> >> > I'm using the full path to exhibit-api >> > (http://api.simile-widgets.org/exhibit/3.1.2rc2/exhibit-api.js) url but >> > the shortened (//api.simile-widgets.org/exhibit/current/exhibit-api.js) >> > has also worked for me in other projects. >> > Thank you! >> > Daniel >> > >> > On Friday, August 20, 2021 at 2:01:37 AM UTC-5 Luis Miguel Morillas wrote: >> >> >> >> David, I think that it is the old method that has been removed now. >> >> >> >> Saludos, >> >> >> >> -- luismiguel (@lmorillas) >> >> >> >> El vie, 20 ago 2021 a las 4:08, David Karger (<[email protected]>) escribió: >> >> > >> >> > According to this article: >> >> > >> >> > https://benborgers.com/posts/google-sheets-json >> >> > >> >> > the following should work: >> >> > >> >> > https://spreadsheets.google.com/feeds/list/spreadsheet_key/1/public/values?alt=json >> >> > >> >> > that is, replace /od6/public/basic?alt=json-in-script at the end with >> >> > /1/public/values?alt=json >> >> > >> >> > >> >> > On 8/18/2021 11:08 AM, Luis Miguel Morillas wrote: >> >> > > I'm afraid the Data API is down [1]. Look at >> >> > > https://docs.google.com/feeds/list/1H38J-cLEAt8VhDuhMvJgSGH4KzT0LrhFl9tvGTQpqWI/1/public/values?alt=json-in-script >> >> > > You can use csv export either. >> >> > > >> >> > > [1] https://developers.google.com/gdata/docs/json >> >> > > >> >> > > Saludos, >> >> > > >> >> > > -- luismiguel (@lmorillas) >> >> > > >> >> > > El mié, 18 ago 2021 a las 15:13, Andrea Borruso (<[email protected]>) >> >> > > escribió: >> >> > >> Hi, >> >> > >> I used for some simile pages this kind of URL: >> >> > >> >> >> > >> https://spreadsheets.google.com/feeds/list/1H38J-cLEAt8VhDuhMvJgSGH4KzT0LrhFl9tvGTQpqWI/od6/public/basic?alt=json-in-script >> >> > >> >> >> > >> But none of these URLs work anymore. >> >> > >> >> >> > >> What's the new URL schema for this kind of output? >> >> > >> >> >> > >> Thank you >> >> > >> >> >> > >> -- >> >> > >> 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/8b661bc0-6887-4491-8349-34fb0f290a25n%40googlegroups.com. >> >> > >> >> > -- >> >> > 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/43e5cf7b-783f-68fb-129f-e93e33f7ddfa%40mit.edu. >> > >> > -- >> > 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/0caa446b-b900-49f6-8138-feacb2531057n%40googlegroups.com. > > -- > 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/21b011f7-c59b-4ee5-9107-c15d8e681a36n%40googlegroups.com. -- 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/CAFQDTO1xDrHrqhuRXyARRSRJn2mb8vew2xyCr2QmzH7X6osBzg%40mail.gmail.com.
