Of course, writing out the problems leads to its solution (at least
partially).
I've discovered that, as promised above, a properly formatted json file, as:
[
{"title":"Tiddler1","text":"This is the text of tiddler 1","tags":"Tag1
Tag2 [[Tag 3]]"},
{"title":"Tiddler2","text":"This is the text of tiddler 2, with a link
to [[Tiddler1]]","tags":"Tag1 Tag4"}
]
saved as, for example, tiddlers.json
can then be imported using the "native" import in TW5, and then click on
import, and all tiddlers get created.
I'm now working on generating json files from spreadsheet. Here is a link
for a script for google sheets:
http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html
It looks reasonable, and I'll work on it today.
As always, once discovered, it seems straightforward. Thanks, Jeremy, for
the file structure that you put in a few years ago which got me headed in
the right direction.
//steve.
On Friday, April 24, 2015 at 9:53:43 AM UTC-4, Måns wrote:
>
> +1
>
> My workflow has been to import csv file to TWc via Eric's
> CreateTiddlersFromCsv and then drop the TWc on a TW5 to import all tiddlers
> at once.
> The tedious part is then to click/accept to convert every imported tiddler
> from TW classic format to a TW5 format.
> It is tedious when you have 300+ tiddlers to convert. I guess it should be
> ok with a few tiddlers...
>
> There is an online csv to JSON converter here:
> http://www.convertcsv.com/csv-to-json.htm I haven't tried it out yet...
>
> If you drag a correctly formated JSON file on to a TW5 it should generate
> tiddlers.... - again I haven't tried it out.
>
> Good luck - and please tell how it goes.
>
> Cheers Måns Mårtensson
>
>
> Den fredag den 24. april 2015 kl. 15.41.55 UTC+2 skrev stevesuny:
>>
>> Resurrecting an old thread, yet again...I have the same challenge (a
>> spreadsheet file where each line becomes a tiddler, with separate column
>> for title, text, tags, etc.. I need to help students import a large number
>> of tiddlers (5 to 200 or more) that they create through spreadsheet
>> manipulation. In TWClassic on tiddlyspace, we use the Tiddlytools plugin
>> http://tiddlytools.com/#CreateTiddlersFromCSV.
>>
>> As I contemplate moving classes from TWClassic to TW5, I need to
>> replicate that functionality, for non-technical users. The responses above
>> reference scripts etc. that are beyond my expertise, and certainly that of
>> my students.
>>
>> How do to this in TW5. Maybe I just don't know how to run the load-file
>> command?
>>
>> Thanks!
>>
>> //steve.
>>
>>
>> On Saturday, November 9, 2013 at 4:56:36 PM UTC-5, Arkady Grudzinsky
>> wrote:
>>>
>>> I have a text file where each line is a list item. I would like to
>>> import this file in my TW5 and create a separate tiddler for each line. I
>>> also would like to specify tags and some fields for each tiddler.
>>>
>>> .tid files do not allow multiple tiddlers in one file.
>>>
>>> I thought, HTML would work with something like this
>>> <div title="Tiddler 1" tags="task" start="201311080800"
>>> priority="5">Tiddler 1 text</div>
>>> <div title="Tiddler 2" tags="task" start="201311080800"
>>> priority="6">Tiddler 2 text</div>
>>> etc.
>>>
>>> But it did not work. I get one tiddler with type="text/html" with file
>>> name as a title and this HTML code inside.
>>>
>>> I could, of course, create a Perl or an awk script to produce one .tid
>>> file per line, but it seems like too much effort.
>>>
>>> Any suggestions?
>>>
>>
--
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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
Visit this group at http://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/54ca5c29-ef5f-40b7-91f2-e749e6bf9078%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
