Data not loading to timemapper

[sgrinsch]

I'm unable to load this spreadsheet to timemapper: https://docs.google.com/spreadsheet/ccc?key=1PFSonYyIlzA5p_OTx6Ss192wz7GUdlmUQVWKzcbiocg#gid=0 (I've changed the url according to previous issues. In the new google spreadsheets the share URL dos not seem to work in timemapper)

Timemapper is able to access the above spreadsheet because it automatically retrieves the title. But after publishing the timeline, the system hangs while loading data.

(https://cloud.githubusercontent.com/assets/3063310/2725175/9044617e-c5aa-11e3-85a6-50deebd8ccaf.png)

[rufuspollock]

OK, this should be fixed. It was due to new google docs spreadsheet urls being different from old ones - see https://github.com/okfn/recline.backend.gdocs/issues/9

Please re-open if the problem persists for you :-)

[sgrinsch]

Thanks for your help. Now the default share url from google spreadsheets works in timemapper.

But I still can't get the timeline to work. The system hangs in the "loading data screen"

Maybe it has to do with how the spreadsheet's data itself?

[rufuspollock]

Could you provide the link to the timemapper page that is not working - that way we can debug better.

[sgrinsch]

Sure: That's the spreadsheets I'd like to use https://docs.google.com/spreadsheets/d/1PFSonYyIlzA5p_OTx6Ss192wz7GUdlmUQVWKzcbiocg/edit?usp=sharing That's the url that ´keeps loading data": http://timemapper.okfnlabs.org/anon/zfpz5b-timemapper_projects

In the url http://timemapper.okfnlabs.org/create I chose Timemap, dd/mm/yyyy, first event

[rufuspollock]

OK issue is that you needed to have used URL

https://docs.google.com/a/okfn.org/spreadsheets/d/1PFSonYyIlzA5p_OTx6Ss192wz7GUdlmUQVWKzcbiocg/edit#gid=910481729

The problem with your url is the missing gid stuff ...

I'd also really recommend getting an account (just signin via twitter) as you can then edit your url and settings after you create the timemap (if you need to).

[the-glove]

I changed the url of my spreadsheet just as you did here and now it works. Is there a way to have it work so that you don't have to manually change the url each time? (see issue #133) https://github.com/okfn/timemapper/issues/133

[rufuspollock]

@the-glove if you just copied and pasted the spreadsheet url from the location bar it should be fine I think. Unfortunately due to changes google have made recently just copying without the gid will no longer work :-(