Here's another version to try.
This version will ENABLE you to include tags with spaces (which I
wouldn't advise personally...) Separate the tags with commas, but no
spaces or quotes-within-quotes. Like:
title,tags,text,birth,death
"John Smith","English male,Therapist","Explorer, Artist","1900","1981"
In this version, definitely ALL fields (except header) must use double
quotes. Failure to do so will result in truncated data. Probably need
a more fail-safe approach. Later.
Only the field labeled "tags" will get this special treatment. In all
other fields, commas will just be part of the field text.
If you want tags with commas in them ... ask someone else ;-)
Mark
On Thursday, May 12, 2016 at 7:45:28 PM UTC-7, LG wrote:
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] <javascript:>> 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
<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
<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
<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
<https://groups.google.com/d/topic/tiddlywiki/qabE7I41Hos/unsubscribe>.
To unsubscribe from this group and all its topics, send an
email to [email protected] <javascript:>.
To post to this group, send email to [email protected]
<javascript:>.
Visit this group at https://groups.google.com/group/tiddlywiki
<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
<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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[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/54b3bffe-e090-4f92-804e-f3028ea545d9%40googlegroups.com
<https://groups.google.com/d/msgid/tiddlywiki/54b3bffe-e090-4f92-804e-f3028ea545d9%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
