search

okfn / timemapper

Create and share elegant timelines and timemaps fast
http://timemapper.okfnlabs.org/
MIT License
273 stars 60 forks source link

My TimeMapper is just "Loading data" but not publishing. #154

Closed mheimstaedt closed 9 years ago

mheimstaedt commented 9 years ago

Hi folks,

I tried TimeMapper for the first time, but I just can't make it work. Everytime I want to connect the spreadsheet it just states "Loading data" but nothing happens. I already tried out different date formats and excluded all data except the title & start & description but it never worked out. Can you help me?

My spreadsheet: https://docs.google.com/spreadsheets/d/1LSYgvM41V72_U2ti0VKdP-WfvbitbcBRGs4xpYoXhjo/pubhtml

Thanks a lot!

Max.

rufuspollock commented 9 years ago

Can you give me the link to your actual live timemap - looking at the console debug will help here. Also please paste the full spreadsheet url link (not the pubhtml one which is not what you should give timemapper ...)

I suspect this is the same as #132 where the problem is related to google changes so that you do need the gid part of the url for timemapper to work (they use to default gid to 0 but now its something random ...)

mheimstaedt commented 9 years ago

Sure, this should be the TimeMapper url: http://timemapper.okfnlabs.org/anon/4gay1a-okf-de-timemapper

...and I hope this is the right spreadsheet url: https://docs.google.com/spreadsheets/d/1LSYgvM41V72_U2ti0VKdP-WfvbitbcBRGs4xpYoXhjo/edit#gid=1557951544

Thanks a lot!

2014-07-11 17:46 GMT+02:00 Rufus Pollock notifications@github.com:

Can you give me the link to your actual live timemap - looking at the console debug will help here. Also please paste the full spreadsheet url link (not the pubhtml one which is not what you should give timemapper ...)

I suspect this is the same as #132 https://github.com/okfn/timemapper/issues/132 where the problem is related to google changes so that you do need the gid part of the url for timemapper to work (they use to default gid to 0 but now its something random ...)

— Reply to this email directly or view it on GitHub https://github.com/okfn/timemapper/issues/154#issuecomment-48747148.

_Mobil: +49 (0) 162 6754947Skype: maximilianheimstaedt

Blog: heimstaedt.com http://heimstaedt.com Twitter: @Heimstaedt https://twitter.com/Heimstaedt

rufuspollock commented 9 years ago

Try creating a timemap using that full spreadsheet url (rather than selecting in google drive). Also I strongly suggesting logging in to create the timemap because that means you can edit it later (including changing the spreadsheet url).

rufuspollock commented 9 years ago

OK, this is complicated. It seems that the Google JS API doesn't want that random #gid value but actually wants 1 as the index of the sheet. specifically, this url fails:

https://spreadsheets.google.com/feeds/list/1LSYgvM41V72_U2ti0VKdP-WfvbitbcBRGs4xpYoXhjo/1557951544/public/values?alt=json

But this works:

https://spreadsheets.google.com/feeds/list/1LSYgvM41V72_U2ti0VKdP-WfvbitbcBRGs4xpYoXhjo/1/public/values?alt=json

I'm fixing this right now ...

rufuspollock commented 9 years ago

OK. This is fixed. Your timemapper works:

http://timemapper.okfnlabs.org/anon/4gay1a-okf-de-timemapper

Not an issue with timemapper in fact but the way new style google spreadsheet urls gids translate to worksheet indexes on google json api :-(

More details in: https://github.com/okfn/recline.backend.gdocs/issues/10

(PS: you should definitely created these as logged in because you could do stuff like turn off the map if you didn't want it!)