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
<http://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/3bb44a20-bb4f-4886-9e80-9a73e0c04f53%40mit.edu.
