Hi all,
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.
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].
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/fe13e647-fc37-4e68-8ec4-9be2ddc11353%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
