Hi Andrew
> I'd be interested in playing around with the Node.js script. Sounds > useful! > I've put the source on GitHub: https://github.com/Jermolene/csv2tiddlers It's not for the faint of heart; you'll need to hack the source code to customise it for your own CSV files. Let me know how you get on, Best wishes Jeremy. > > Thanks, > Andrew > > On Thursday, July 9, 2015 at 8:32:25 AM UTC-7, Jeremy Ruston wrote: >> >> Hi Steve >> >> Funnily enough, I've been working with some CSV files in my dayjob. I've >> got a very noddy little Node.js script that converts CSV files into JSON >> files. It's not very polished - eg one has to edit the JS source to tell it >> which columns to use. >> >> But, if you're comfortable with Node.js it might make a good starting >> point. If you're interested I can post it to GitHub. >> >> Best wishes >> >> Jeremy. >> >> >> On Thu, Jul 9, 2015 at 4:18 PM, stevesuny <[email protected]> wrote: >> >>> >>> Reviving an old thread. Am again interested in importing CSV as separate >>> tiddlers. >>> >>> I use google sheets to generate CSV. >>> >>> I'd like to use http://www.convertcsv.com/csv-to-json.htm to create >>> json, but none of the output formats work - when I use the import, the json >>> file doesn't return any tiddlers available for import. >>> >>> Anyone have suggestions or experience with this? Or, alternatives? >>> >>> Thanks, >>> >>> //steve. >>> >>> >>> On Friday, April 24, 2015 at 11:15:16 AM UTC-4, Jeremy Ruston wrote: >>>> >>>> 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] >>>> >>> >> >> >> -- >> Jeremy Ruston >> mailto:[email protected] >> > -- 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/CAPKKYJbSnnTgvL%2B5U-9Mj3WYzoojiQC5azZvANb%3DiHsXubT1Sg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
