Hi,
I'm experiencing some issues with the date format in my exhibit data
imported from Google spreadsheet. I formatted my spreadsheet as plain
text, my column "date_de_publication" which contains date is written
with the date property {date_de_publication:date}, in each cell I
formatted the date as following ="YYYY-MM-DD" (as indicated here :
http://simile.mit.edu/wiki/Exhibit/How_to_make_an_exhibit_from_data_fed_directly_from_a_Google_Spreadsheet
). I also added the ex:formats in the Tile View div (ex:formats="date
{ mode: medium; show: date }") and the field "date_de_publication" is
in the schema.js file .
But when I load my exhibit, the field "date_de_publication" is loaded
as text, the date is written exactly as in the google spreadsheet
(YYYY-MM-DD), and the filtering is "a-z", "z-a", instead of "most
recent", "most old".
And strange thing, if I extract the data from this exhibit in the JSON
format and copy-paste in a *.js file, and then load it, dates are
correctly detected.
here are my files :
Google spreadsheet :
http://spreadsheets.google.com/pub?key=p2-svuLe2wo7Fb_U0JnlBHg
Exhibit with data from google spreadsheet (date as text) :
http://www.nogibble.com/publications.html
Same exhibit but with data from a .js file (extracted from the exhibit
above), dates are correctly detected :
http://www.nogibble.com/publications_JSON.html
schema.js : http://www.nogibble.com/schema.js
js data file (extracted from the google spreadsheet exhibit) :
http://www.nogibble.com/publications.js
could you give me some guidance ?
Many thanks in advance ;-) !
Frederic
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SIMILE Widgets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/simile-widgets?hl=en
-~----------~----~----~----~------~----~------~--~---
