I I worked a bit on your example [1]. I hope it helps. I converted the Excel spreadsheet to CSV (I use LibreOffice) in Unicode, I made syntax changes to exhibit 3, and a correction in the JavaScript function.
[1] https://lmorillas.github.io/exhibit_tests/hschistory Saludos, -- luismiguel (@lmorillas) El lun, 9 sept 2024 a las 19:46, Roger Cutler (<[email protected]>) escribió: > > 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. >> >> -- >> 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. > > -- > 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. -- 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/CAFQDTO1AFOWstOqpZdZyicY7wYerwGy4_dQrarK8t7EuKK6-_A%40mail.gmail.com.
