An operating version using a txt file is at http://rtcutler.com/HSCArchive/HSCHistoryRTC.htm. You can pick up the various files from that Web site.
On Monday, September 9, 2024 at 7:25:32 AM UTC-5 [email protected] wrote: > Roger, I'll try to look at the script issue but in the meantime you > probably just need to make a small change to what is coming out of the json > converter. I downloaded the example xls and loaded it into the converter, > and it produced json that starts like this: > > { > "Spies": [ > { > > probably because the filename was Spies.xls . Change the word "Spies" to > "items" and see what happens. > > > On 9/8/2024 6:01 PM, Roger Cutler wrote: > > Thank you for the excel-to-json application link. It did convert my Excel > spreadsheet to something that looks somewhat like the Jason Babel used to > give me, Unfortunately, however, Exhibit will not display this data. > > If I knew how to replace the following script in STABLE it would help a > lot. > > <script type="text/javascript"> > var rowStyler = function (item, database, tr) { > var TimesPerf = database.getObject(item, "TimesPerf"); > var BackColor = "white"; > var ForeColor = "black"; > switch (TimesPerf) { > case 0: BackColor = "#CCCCCC"; ForeColor = "white"; break; > } > tr.style.background = BackColor; > tr.style.color = ForeColor; > }; > </script> > > > On Saturday, September 7, 2024 at 11:00:08 PM UTC-5 [email protected] > wrote: > >> Hi Roget. Per the previous post on this mailing list, Babel had to be >> shut down due to a server migration I had no idea that anyone was still >> using it for anything. tsv should work fine with the newer exhibit; i'll >> try to look into what's wrong. Do you need to generate your json data on >> the fly or do you just make a new static json file every few months? There >> are plenty of online tools supporting the latter kind of manual conversion, >> such as https://codebeautify.org/excel-to-json >> On 9/7/2024 6:23 PM, Roger Cutler wrote: >> >> I had to move from api.simile-widgets.org/exhibit/3.0.0rc1/exhibit-api.js >> to https://api.simile-widgets.org/exhibit/STABLE/exhibit-api.js because >> Simile/Babel has disappeared and I don't know how else to turn my Excel >> spreadsheet into Jason -- and the former version does not appear to accept >> txt/tsv that I can get from Excel. So now I'm using STABLE so I can use >> txt files, and the following code, which worked in the earlier version, >> does not work any more. Can someone tell me how to update this to work in >> the STABLE version? Frankly I don't know how I got this to work in the >> first place, and I don't really understand it now at all -- and I can't >> find whatever docs I had to figure this code out in the first place. So >> I'm afraid I'm pretty ignorant. >> >> <script type="text/javascript"> >> var rowStyler = function (item, database, tr) { >> var TimesPerf = database.getObject(item, "TimesPerf"); >> var BackColor = "white"; >> var ForeColor = "black"; >> switch (TimesPerf) { >> case 0: BackColor = "#CCCCCC"; ForeColor = "white"; break; >> } >> tr.style.background = BackColor; >> tr.style.color = ForeColor; >> }; >> </script> >> >> Also, is there any way I can honor special characters like in "Dvořák" >> and "Fauré"? This worked in Babel/Jason but not in DOS txt from Excel. I >> can output unicode txt from Excel, but Exhibit STABLE doesn't seem to >> handle that very well. >> >> -- >> 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/b0320c5f-bfe2-4eed-9a34-e82f0cb14b00n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/simile-widgets/b0320c5f-bfe2-4eed-9a34-e82f0cb14b00n%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/36fef05a-0b24-429a-9652-f6f428a1412en%40googlegroups.com > > <https://groups.google.com/d/msgid/simile-widgets/36fef05a-0b24-429a-9652-f6f428a1412en%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/f237f10e-2f37-4aec-be34-31dadd2dac7dn%40googlegroups.com.
