Re, I noticed a small strange issue when I started to fill my google spreadsheet exhibit. There is a one day gap between what I fill in the spreadsheet and what it's displayed on the exhibit. It's not really an issue for my dataset, but I tought it might interest you.
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 Frederic On Feb 13, 3:16 pm, David Karger <[email protected]> wrote: > 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_f... > > ). 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 -~----------~----~----~----~------~----~------~--~---
