Looks my project is putting up quite the fight! That bit didn't help it either. :-)
title,tags,text,birth,death "John Smith","English male","Explorer, Artist","1900","1981" The final tiddler output: Title: "John Smith" Tags: "English, male" <--- notice that the comma separates two tags. Each kept one part of the quotes Text: "Explorer birth: Artist" death: "1900 I hope you don't mind me sending you feedback on what I see. Best, LG On Thu, May 12, 2016 at 6:50 PM, 'Mark S.' via TiddlyWiki < [email protected]> wrote: > > Ok, here's a slightly different version. Now it's really important that > all the data lines have their fields enclosed with quotes. So your first > two lines would look something like: > > name,category,relationship,DOB,DOD > "Frank Hudson","English male","husband of Sarah Owens, father of > Nancy","1802","1860" > > HTH > Mark > > On Thursday, May 12, 2016 at 3:39:34 PM UTC-7, LG wrote: >> >> Here's a sample line: >> >> Frank Hudson,English male,"husband of Sarah Owens, father of >> Nancy",1802,1860 >> >> On Thu, May 12, 2016 at 12:01 AM, 'Mark S.' via TiddlyWiki < >> [email protected]> wrote: >> >>> Are all your fields surrounded in quotes? I forgot to mention that in my >>> rush. Each data field should be surrounded with quotes and separated with >>> commas with no space between. If that doesn't work, then some more hacking >>> might be in order. >>> >>> Mark >>> >>> On Wednesday, May 11, 2016 at 8:48:37 PM UTC-7, LG wrote: >>>> >>>> Btw, do you have any tips on how to keep the text field from splitting? >>>> I was looking at TiddlyTools which said to write text which has a comma in >>>> it like so: "Here is some text, here is more." When I toss that in using >>>> your code, I get: >>>> >>>> "Here is some text <--- body >>>> here is more <--- custom field >>>> >>>> I then tried writing it as ""Here is some text, here is more."" just to >>>> see if that produced a different response. Nope. >>>> >>>> Best, >>>> >>>> LG >>>> >>>> On Monday, May 9, 2016 at 10:03:05 PM UTC-4, LG wrote: >>>>> >>>>> Hello, Mark! >>>>> >>>>> I can confirm that this works. The first attempt failed. But I >>>>> realized the issue was that I forgot to reload after importing then >>>>> saving. >>>>> Then it worked smoothly. >>>>> >>>>> I'm going to stress test it a bit more to see what else I can do. >>>>> >>>>> Thank you! >>>>> >>>>> LG >>>>> >>>>> On Monday, May 9, 2016 at 12:10:48 AM UTC-4, Mark S. wrote: >>>>>> >>>>>> Here's a brand new, experimental tool to help you import CSV data. BE >>>>>> SURE TO BACKUP YOUR TW FILE BEFORE TRYING THIS!! >>>>>> >>>>>> Unfortunately it is not a 100% automatic. That's why I refer to it as >>>>>> a helper. Someone who knows the innards of TW5 could probably fix up the >>>>>> code so that it does everything at once. >>>>>> >>>>>> Drag and drop the attached json file into your TW. Save and reload >>>>>> your TW. >>>>>> >>>>>> Follow the instructions in "How to use the CSV to TW/JSON helper". >>>>>> Basically you create a tiddler with your CSV data. The first row of the >>>>>> CSV >>>>>> data must have your field headers, and the field "title" is mandatory. If >>>>>> you want "created" or "modified" you will have to add your own date >>>>>> stamps >>>>>> at this point. >>>>>> >>>>>> If the converter tiddler is successfully, your CSV data will appear >>>>>> below. You can copy and paste the converted JSON code into a separate >>>>>> file >>>>>> with a JSON extension, and then drag and drop it back into your TW to >>>>>> convert. This is the part that could use some more automation. >>>>>> >>>>>> Good luck, >>>>>> Mark >>>>>> >>>>>> >>>>>> On Saturday, May 7, 2016 at 8:18:23 PM UTC-7, LG wrote: >>>>>>> >>>>>>> Hi! I've been desperately googling for half an hour and I *cannot >>>>>>> *figure >>>>>>> out how to use CreateTiddlersFromCSV. I copy data in and then it tells >>>>>>> me I >>>>>>> need to save. I cannot find a save button. I've tried dragging the URL >>>>>>> into >>>>>>> my TiddlyWiki, but the page just reloads and goes to that site. >>>>>>> >>>>>>> How do I do this? >>>>>>> >>>>>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "TiddlyWiki" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/tiddlywiki/qabE7I41Hos/unsubscribe. >>> To unsubscribe from this group and all its topics, 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/5748c255-9a84-4e54-a95d-8736551f12d8%40googlegroups.com >>> <https://groups.google.com/d/msgid/tiddlywiki/5748c255-9a84-4e54-a95d-8736551f12d8%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "TiddlyWiki" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/tiddlywiki/qabE7I41Hos/unsubscribe. > To unsubscribe from this group and all its topics, 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/8d8d1190-2366-4238-a2d5-2c5126ff0ac6%40googlegroups.com > <https://groups.google.com/d/msgid/tiddlywiki/8d8d1190-2366-4238-a2d5-2c5126ff0ac6%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAFWQ5Z5Xu0kxAHHyenKqCXp01pq1tCtY8SQSqiUJUbxzHHNZ9w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
