I tried changing it to "Items" -- Exhibit still choked.
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/f49bd416-4395-4dcf-b6d6-7a9e44902fedn%40googlegroups.com.
