Hi William,
william gunn wrote:
> I'm having an issue with dates converting from Excel to JSON for Exhibit.
> I'm converting from an Excel file, and the only way I can get the dates to
> show up as dates and not numbers in Exhibit is by using the text() Excel
> function to make a new column converting the original dates to text as shown
> here: http://www.pcmag.com/article2/0,1895,1927710,00.asp, then doing
> "paste-special-values" into a new spreadsheet, omitting the original date
> columns.
>
> If I leave in the original columns, the dates show up as 0 in Exhibit, and
> if I try to format the original columns using the format cells menu option,
> the dates turn into numbers.
>
> I know David's been working on this, but I don't know if it's been worked
> out yet. It's not a big deal, really, but has anyone figured out a
> workaround that doesn't involve copying and pasting?
I have been using dates for quite some time with no problems in either
version 1x or 2x of Exhibit. Granted, this is a hosted Google
spreadsheet and not a direct conversion to JSON, but the Google hosted
option works well and is easy to maintain.
Make sure and label your columns with {var:date}; I also used the
mm/dd/year format, e.g., 10/17/2007.
You can see this working at my Sweet Tools listing
(http://www.mkbergman.com/?page_id=325) for the Posted and Updated facets.
Thanks, Mike
_______________________________________________
General mailing list
[email protected]
http://simile.mit.edu/mailman/listinfo/general
