I copied your exhibit and fixed the problem by swapping the order of
the included data files, on the theory that the schema file should get
the "last" chance to set the state of the system. I am guessing the
google spreadsheet reader is clearing something it shouldn't from the
schema. There is a way to embed your schema in the spreadsheet; if I
remember correctly, you should say "date_de_publication:date" in the
header line of your spreadsheet. But the way you are currently doing it
should work too.
<link
href="http://spreadsheets.google.com/feeds/list/p2-svuLe2wo7Fb_U0JnlB\
Hg/od6/public/basic?alt=json-in-script" type="application/jsonp"
rel="exhibit/d\
ata" ex:converter="googleSpreadsheets" />
<link href="schema.js" type="application/json" rel="exhibit/data" />
Frederic_L wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
