> > * The first column always gets to be the label property, regardless of
> > what you name it.
>
> This is due to the way Google Spreadsheets exports data. The first
> column gets to be the title of the whole record and all subsequent
> columns gets merged together as data. That's why I need that funky { }
> wrapping to help me parse out individual cells. If you know how to get
> Google Spreadsheets to export in nicer formats, let me know.Not yet, but their present form is just downright broken, as it does not publish the A:1 cell. I'd say that until it is fixed (perhaps by introducing a new, sane, JSON format), it's better to leave the first (A) column empty and let column headers rule, as with the table and local json formats. It's more confusing and frustrating than helpful to silently guess things you can't override. We could warn in the case where it seems like there is data in the first column, and inform the user that they better keep that empty, perhaps sparing a few words to give guilt where guilt is due. ;-) > > * It would similarly be *very* useful to get a default TabularView as > > well, listing all columns available, in the order they are listed. [...] > > Search for "Fix up configuration in case author makes mistakes" in > > http://static.simile.mit.edu/exhibit/api/scripts/views/tabular-view.js > > You probably want to change it to something like this: Thanks! Works like a charm, with minimum tweak. > That won't keep the same column order, though. I'm sure I'll be able to come up with something. :-) For now it'll probably do as is, though. >> I'm polishing up the last tweaks for an "instant Google Spreadsheets >> Exhibit" page at the moment, where you just paste the feed URL and it >> loads and renders an exhibit to it, and it would be even greater with >> Table view in place too. > > That would be neat! It's borrowing very shamelessly/liberally from your movie layout, though; do tell if I shouldn't keep it online: http://ecmanaut.googlepages.com/igse.html For now it loads the API with bundle=false, as I don't trust my computer to bundle up things, so it is a bit slow to load the first time. -- / Johan Sundström, http://ecmanaut.blogspot.com/ _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
