Hello all,
Reviving an old thread:
Has anyone been able to import a google sheet as tiddlers, one tiddler per
row, with columns for title, text, tags, etc? (essentially, replicating the
functionality of Eric Shulman's
http://www.tiddlytools.com/#CreateTiddlersFromCSV for TW5?)? This thread
Hi Danielo,
My experience with trying to do that was that google sheets couldn't cope
with exporting given the number of rows in my sheets and would keep falling
over half-way through, which forced me to use apple-Numbers instead.
Regards,
Richard
--
You received this message because you are
Hello Mans,
Yes, it is possible to have a script that reads the sheet and creates a Json
output. I don't know the best way to export that data: giving you the option
to copy it? As a file in your drive folder? As am extra cell in some other
sheet?
The easiest way to process the shet would
How many rows are we talking about? If there are so many I don't think TW can
handle it neither.
--
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
Hi Richard
Thank you very much for taking your time to show how you do it :-)
Very helpfull!
Now I will need to do some experiments.
Is it also possible to create a master JSON tiddler/file which will be
imported as a single tiddler where all defined tiddlers will exist/behave
like shadow
Sounds good to me :)
I hope you'll share if you get it working - very interesting
Regards,
Richard
--
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
Mans, if you are interested and you are using Google spreadsheet it is not
difficulttto write an script to export the data of a sheet as Json or tiddler
format.
--
You received this message because you are subscribed to the Google Groups
TiddlyWiki group.
To unsubscribe from this group and
Hi Danielo
Of course I'm interested :-)
However I'm totally blank when it comes to writing a script to use with a
Google spreadsheet.
I was thinking of having two seperate scripts one for creating a JSON file
to import/create a lot of tiddlers at once - as Richard proposed - and
another
From what I remember it was around n=1200 rows - some sort of bug I
suppose, perhaps it is fixed now? - batches of less than n worked fine.
Regards,
Richard
--
You received this message because you are subscribed to the Google Groups
TiddlyWiki group.
To unsubscribe from this group and stop
Hi Mans,
Starting with a spreadsheet - data in colums, no headers - put a blank
column inbetween each, starting at the beginning and, in the top cell, add
little snippets like this...
{ text:
so that, as a whole, a single line of the spreadsheet reads as a valid json
entry, with a comma
Hi Richard
If you would like to create a lot of tiddlers from a spreadsheet, there's a
simple method - put 'dummy' columns between your actual columns and fill
them with the right json delimiters, paste the whole sheet as text into a
file and save it and then drag it into TW. I can show you
On Thursday, May 21, 2015 at 11:26:51 AM UTC-7, Mark S. wrote:
I would like to create a bunch of new tiddlers (preferably not in draft
mode) from a list contained in a separate tiddler (it could be an existing
data tiddler if necessary).
In other words, can I iterate through a list,
On Thursday, May 21, 2015 at 1:12:31 PM UTC-7, Måns wrote:
I can't help thinking that this sort of magic might allow for a little
more complex things like converting a csv list of tiddler names, tags,
standard and custom fields into tiddlers, simply by writing a simple macro
with variables
It's still great :-)
Den torsdag den 21. maj 2015 kl. 22.27.09 UTC+2 skrev Eric Shulman:
On Thursday, May 21, 2015 at 1:12:31 PM UTC-7, Måns wrote:
I can't help thinking that this sort of magic might allow for a little
more complex things like converting a csv list of tiddler names, tags,
Hi Eric
GREAT :-)
Thank you very much for showing this simple solution for creating a lot of
tiddlers from a simple list!
I can't help thinking that this sort of magic might allow for a little more
complex things like converting a csv list of tiddler names, tags, standard
and custom fields
Hi Mans,
If you would like to create a lot of tiddlers from a spreadsheet, there's a
simple method - put 'dummy' columns between your actual columns and fill
them with the right json delimiters, paste the whole sheet as text into a
file and save it and then drag it into TW. I can show you an
16 matches
Mail list logo