Hi Melissa,
I can't say for sure what happened, not seeing what you pasted in,
but Babel can definitely handle more than 10 items. I just tried
going to the "How to make an exhibit" page you linked to and tried
doing what you said. I copied the table and pasted it in a few times
changing the names to make it unique and all that, and babel made 12
items for me.
My guess is that maybe you lost a tab in there or something, and
Babel got confused. If you try it again and it still doesn't work,
try pasting it into an e-mail to this list and we can try to see what
the problem is.
Extra lines at the bottom (or lack thereof) shouldn't be a problem.
As for how many rows work, I don't know the actual limits. I can say
that I've used it on an excel spreadsheet of mine and it converted
about 170 items, each with about 15 properties just fine. All I did
was open the Excel spreadsheet, command+a (that's "Select All" on a
mac), copy and then paste it into Babel.
You can only convert a sheet at a time that way, but Exhibit can use
several json files, one from each sheet of an excel file, no problem.
Also worth noting is that each sheet needs to have one column called
"label", or else it will just pick the first column which is not
always what you want. When pasting it from Excel this way, be sure to
choose "From tab separated values" on the Babel page.
Hope this helps some,
Gabe
On Aug 28, 2007, at 4:03 PM, Green, Melissa wrote:
Exhibit is such an exciting tool but I am confused but the easy-to-
use hype and wonderful examples when I can’t get my data reliably
into JSON format. I’ve tried using Babel’s copy and paste feature
but the max number of records seems to be less than what I’ve
pasted in.
From the http://simile.mit.edu/wiki/Exhibit/
How_to_make_an_exhibit_from_a_spreadsheet reference, I’ve copied
the three examples with first row, but duplicated each row several
times and edited the names for 12 unique records, the Upload /
Preview button reports back 10. Should there be extra line feeds at
the end of the data? How many rows of data can I expect Babel to
crunch for me?
List members (especially non MIT members), what is your experience
with using Babel? How are you preparing data? What tools are you
using to create JSON data? Has anyone created an Excel template to
export worksheet info in JSON format? Is a published Google
Spreadsheet the preferred solution?
The tutorial on creating the web page modifications really got me
jazzed. Now I need to create data from my own experience and for my
own needs.
Thanks for your thoughts. -- Melissa
_______________________________________________
General mailing list
[email protected]
http://simile.mit.edu/mailman/listinfo/general
_______________________________________________
General mailing list
[email protected]
http://simile.mit.edu/mailman/listinfo/general
