Hi Steve You'll probably have seen the current built-in support for CSV files in TW5: dragging or importing a file results in a single tiddler containing the entire CSV file. There's a special parser for text/csv tiddlers so that the content gets displayed as a nicely formatted HTML table.
The approach I favour for making the CSV importing more flexible is actually to add facilities for accessing and manipulating the content of CSV tiddlers, rather than extending the import process itself. I like the idea of maintaining CSV as a native format, not just an import format - we could integrate a JavaScript spreadsheet engine like SocialCalc (see http://tiddlywiki.com/rboue's%20plugins%20for%20TiddlyWiki)/ Adding basic support for referencing rows and cells in CSV tiddlers would be fairly straightforward - it would largely mirror the existing implementation for access to property indexes within data tiddlers (aka JSON tiddlers). I'd be happy to guide anyone interested in working on a pull request. Best wishes Jeremy. On Fri, Apr 24, 2015 at 3:01 PM, stevesuny <[email protected]> wrote: > 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 [email protected]. > To post to this group, send email to [email protected]. > 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 > <https://groups.google.com/d/msgid/tiddlywiki/54ca5c29-ef5f-40b7-91f2-e749e6bf9078%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Jeremy Ruston mailto:[email protected] -- 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 http://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/CAPKKYJYsnuN0_vD1A_ETVnDqt3Yb9jyqL_fG79Ui_JgNkun9Qw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
