El dom, 12 sept 2021 a las 22:05, jjon (<[email protected]>) escribió: > > Thanks Luis, > It's helpful to see that a simplified version of the page can be built from > the data retrieved via csv; however, I'd like to track down what about the > csv data is causing the TypeError: `TypeError: > Exhibit.Formatter._constructors[valueType]`.
OK. I see. The simplied version removed all external js because maybe there is some kind race condition conflict in your code. > For this wordpress page, I've been using a locally sourced copy of the > Exhibit code base, this copy is the same one as at > http://api.simile-widgets.org/exhibit/current/exhibit-api.js (3.1.2-rc3). > Before the jsonp method stopped working, this version was understanding my > unfortunate Exhibit2 syntax just fine. Just in case, I went in and updated > all the ver2 tag attribute syntax, but that didn't solve the problem. > > The fact that your simplified and updated page also does not correctly > interpret the semi-colons in cells as multiple values is also suggestive. Of > what, I don't know yet. I need to understand the code base better I guess. > I'm pretty far out on the edge of my understanding. Something about the csv > data, vs the json data, throws the TypeError. I need to understand why the > Exhibit.Formatter constructors don't recognize the `valueType` they're being > given. Then I can change the spreadsheet accordingly, or compensate for it in > the exhibit html, or maybe do some kind of js preprocessing of the incoming > csv. You can use data-ex-value-separator=";" for multiple values. > > Still puzzled, Tell me if I can help Best, -- @lmorillas > Jon > > On Saturday, September 11, 2021 at 10:56:59 AM UTC-7 Luis Miguel Morillas > wrote: >> >> 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/694d72dd-d15b-46dd-9255-8b7222b8da44n%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/CAFQDTO0LWy45Jq40bMG0VgjXfr15XuTD%3DfNbk9eM57Rbqo0n4A%40mail.gmail.com.
