data from google document to fill the timeline

[Dicki Smits]

Hello.

Chap-timeline seems a great timeline.

Is there an easy to follow /howto manual how i can use google docs as source for the data to fill the timeline?

My programskills are not very high. But i saw the example "example11_datasource.html"

That seems to do the trick. But when i fill in my shared google doc into the textbox the dates are not showing up.

Any suggestion?

Thanks in advance

[Jos de Jong]

When you want to use Google Spreadsheet, you have to create three columns with data (start, end, content), without a header. See this example. I'm not sure whether the columns with start and end need to be formatted as dates, could be.

[Dicki Smits]

Hello Jos,

I did find out how to fill an google document, but i did not find out how to refer to the doc in the code.

So is there an code example where i can see how to refer to an shared public google document.

Than i can use the script as i like.

thanks anyway for your input.

greetings from Holland

[Jos de Jong]

yes, you can have a look at the source code of example11_datasource.html which you mentioned. Your google spreadsheet must indeed be publicly accessible.

[Dicki Smits]

But the strange thing is:

I copyied the data from example doc to my own document.
I share my document to the public, i put in the shared link in the Datasource field and click on "Go" button but i don't see any data in the timeline.

I used the link:
https://docs.google.com/spreadsheets/d/1HSFexKtGXJhyvgD2bYGov0DzrXFekE0UWGd6C6zNpkc/edit#gid=0

and i used the link:

https://docs.google.com/spreadsheets/d/1HSFexKtGXJhyvgD2bYGov0DzrXFekE0UWGd6C6zNpkc/edit?usp=sharing

both did not work? Any suggestion?

Please thanks.....



Op 02-09-14 om 11:13 schreef Jos de Jong:

yes, you can have a look at the source code of example11_datasource.html which you mentioned. Your google spreadsheet must indeed be publicly accessible.

--
You received this message because you are subscribed to a topic in the Google Groups "CHAP Links Library" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/chap-links-library/jRTqWNVbMi0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to chap-links-libr...@googlegroups.com.
To post to this group, send email to chap-link...@googlegroups.com.
Visit this group at http://groups.google.com/group/chap-links-library.
For more options, visit https://groups.google.com/d/optout.

[Jos de Jong]

For some weird reason the date 8/28/2010 on row 5 in your version of the document was exported by Google Spreadsheet as null instead of a valid Date. I don't know why. Changing it with a date like 2010-08-28 seems to work and 28/8/2010 too. This is odd. 

[Dicki Smits]

Hello Jos,

I think i find out what is the problem.

But i don't know how to solve.

In the example code "example11_datasource.html" row 42 - 45 is mentioned the code: 

// if the entered url is a google spreadsheet url, replace the part

        // "/ccc?" with "/tq?" in order to retrieve a neat data query result

        if (dataSourceUrl.indexOf("/ccc?")) {

          dataSourceUrl.replace("/ccc?", "/tq?");          

But in the link i have, given by google is no "/ccc?"

the link google give me to share is:

https://docs.google.com/spreadsheets/d/1HSFexKtGXJhyvgD2bYGov0DzrXFekE0UWGd6C6zNpkc/edit?usp=sharing

or

https://docs.google.com/spreadsheets/d/1HSFexKtGXJhyvgD2bYGov0DzrXFekE0UWGd6C6zNpkc/edit#gid=0

I don't know how to get that link with "/ccc?" in it.

May be it is the old way of sharing doc's and do i have the new sharing links?

Can you help me with it?

I hope so.

greetings and thanks in advance.

[Dicki Smits]

Odd is that when i double click on a cell their show up an calendar, but even the value with calender selection is not valid for the timeline :-(

[Jos de Jong]

No, this has not to do with it the /ccc? part (which is apparently redundant nowadays, unlike 4 years ago). 

Your spreadsheet loads without problem in the browser (check your Developer Tools, Network tab). But the received data contains an invalid start date with value null.