Hi Hegart
> Professor Schneider at {{DesignWrite}} has recently shared a link to this
> blog post <https://ctrlq.org/code/20004-google-spreadsheets-json>, which
> suggests it is possible to access the information in a Google Sheet as a JSON
> file, by using jQuery. This looks very promising for my semester project, but
> I have no idea how to implement it, as I am a total n00b at Javascript.
Interesting. I checked it out, creating a simple public spreadsheet. The
sharing works as advertised, except that the JSON format used is pretty
complex, but parseable.
My sample spreadsheet looks like this:
The resulting JSON is attached below. Weirdly, it doesn’t even place the cells
of the spreadsheet in separate entries; they’re merged together with colons.
Anyhow, I’m sure with a bit of research one could figure out the format and get
something useful out of it, but it feels a bit Google-specific compared to the
general utility of extending TW with the CSV import facilities you need,
Best wishes
Jeremy.
{
"version": "1.0",
"encoding": "UTF-8",
"feed": {
"xmlns": "http:\/\/www.w3.org\/2005\/Atom",
"xmlns$openSearch": "http:\/\/a9.com\/-\/spec\/opensearchrss\/1.0\/",
"xmlns$gsx": "http:\/\/schemas.google.com\/spreadsheets\/2006\/extended",
"id": {
"$t":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic"
},
"updated": {
"$t": "2016-04-03T19:02:55.541Z"
},
"category": [
{
"scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006",
"term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list"
}
],
"title": {
"type": "text",
"$t": "Sheet1"
},
"link": [
{
"rel": "alternate",
"type": "application\/atom+xml",
"href":
"https:\/\/docs.google.com\/spreadsheets\/d\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/pubhtml"
},
{
"rel": "http:\/\/schemas.google.com\/g\/2005#feed",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic"
},
{
"rel": "http:\/\/schemas.google.com\/g\/2005#post",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic"
},
{
"rel": "self",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic?alt=json"
}
],
"author": [
{
"name": {
"$t": "jeremy.ruston"
},
"email": {
"$t": "[email protected]"
}
}
],
"openSearch$totalResults": {
"$t": "3"
},
"openSearch$startIndex": {
"$t": "1"
},
"entry": [
{
"id": {
"$t":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cokwr"
},
"updated": {
"$t": "2016-04-03T19:02:55.541Z"
},
"category": [
{
"scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006",
"term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list"
}
],
"title": {
"type": "text",
"$t": "Once I"
},
"content": {
"type": "text",
"$t": "two: caught a , three: fish, four: alive"
},
"link": [
{
"rel": "self",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cokwr"
}
]
},
{
"id": {
"$t":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cpzh4"
},
"updated": {
"$t": "2016-04-03T19:02:55.541Z"
},
"category": [
{
"scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006",
"term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list"
}
],
"title": {
"type": "text",
"$t": "Six"
},
"content": {
"type": "text",
"$t": "two: Seven, three: Eight, four: Nine, five: Ten"
},
"link": [
{
"rel": "self",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cpzh4"
}
]
},
{
"id": {
"$t":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cre1l"
},
"updated": {
"$t": "2016-04-03T19:02:55.541Z"
},
"category": [
{
"scheme": "http:\/\/schemas.google.com\/spreadsheets\/2006",
"term": "http:\/\/schemas.google.com\/spreadsheets\/2006#list"
}
],
"title": {
"type": "text",
"$t": "Then I"
},
"content": {
"type": "text",
"$t": "two: put it, three: in, four: again"
},
"link": [
{
"rel": "self",
"type": "application\/atom+xml",
"href":
"https:\/\/spreadsheets.google.com\/feeds\/list\/1Uxon1ZBYVxTVlw5AhEFY8b6SMlrG_wAHt1mf1pXtEd4\/od6\/public\/basic\/cre1l"
}
]
}
]
}
}
>
> What I was thinking for this, is perhaps synchronising a set of tiddlers of
> type JSON data from my Google Sheets <http://bit.do/TiddlyCRM-sampledata>.
> Many of my worksheets in Google are already formatted in such a way that they
> will generate TiddlyWiki tiddlers, with just the relevant column headings as
> expected by TiddlyWiki, and rows for each tiddler. I currently export these
> manually to CSV, then convert them to JSON. This new idea would save on those
> extra steps. Once I have them as JSON data tiddlers full of JSON tiddlers, I
> should then be able to bulk import the tiddlers into my wiki space from the
> JSON data tiddlers fairly easily.
>
> This solution would be used initially to replace my cumbersome procedure for
> working with the SampleData which I'm generating for testing the TiddlyCRM
> project. This sample data gets imported and purged often. However, it may
> also have application later for the live data, if the end user wants to
> bulk-import their legacy information into TiddlyCRM.
>
> Any advice on how to implement this would be greatly appreciated.
>
> Kind regards,
>
> Hegart.
>
> --
> You received this message because you are subscribed to the Google Groups
> "TiddlyWiki" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected]
> <mailto:[email protected]>.
> To post to this group, send email to [email protected]
> <mailto:[email protected]>.
> Visit this group at https://groups.google.com/group/tiddlywiki
> <https://groups.google.com/group/tiddlywiki>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/tiddlywiki/fe13e647-fc37-4e68-8ec4-9be2ddc11353%40googlegroups.com
>
> <https://groups.google.com/d/msgid/tiddlywiki/fe13e647-fc37-4e68-8ec4-9be2ddc11353%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout
> <https://groups.google.com/d/optout>.
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/8FA4EEF2-841A-43FE-83FC-6EB76095706E%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
