[tw] Re: TW5: How to use CreateTiddlersFromCSV

[LG]

Dear Mark, 

Using the version you sent the other day, Project_CSV2JSON_v0-2.json, and 
v0-3, I can report that it works. Things to note: 

   - tags have to be written with no spaces between them like so, 
   "English,Explorer,Adventurer",
   - Each field defined in the first line needs to be present in each line 
   afterwards. Otherwise, it throws errors

This is an amazing piece of work. Thank you. 

Best, 

LG 

On Sunday, May 15, 2016 at 2:11:47 PM UTC-4, Mark S. wrote:
>
> This version of csv2json adds some error handling, giving you a message 
> when it can't make sense of the input lines. Hopefully this will reduce the 
> instances when the TW error handler will be invoked.
>
> 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 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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/f1949e8b-6112-46f7-b2ad-7f1edf57ba29%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

['Mark S.' via TiddlyWiki]

This version of csv2json adds some error handling, giving you a message 
when it can't make sense of the input lines. Hopefully this will reduce the 
instances when the TW error handler will be invoked.

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 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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/b288a48a-8a6a-401e-9a16-fe83f09a5fe8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Project_CSV2JSON_v0-3.json
Description: application/json

Re: [tw] Re: TW5: How to use CreateTiddlersFromCSV - Thanks!!!

[Jan]

Hi Mark,
How, did you guess my needs.
This is great, thanks a lot
Jan


Am 13.05.2016 um 06:40 schrieb 'Mark S.' via TiddlyWiki:

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
> 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
 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
  

Re: [tw] Re: TW5: How to use CreateTiddlersFromCSV

['Mark S.' via TiddlyWiki]

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 <
> tiddl...@googlegroups.com > 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 <
>>> tiddl...@googlegroups.com> 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 t

Re: [tw] Re: TW5: How to use CreateTiddlersFromCSV

[Amanda L. Goodman]

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 <
tiddlywiki@googlegroups.com> 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 <
>> tiddl...@googlegroups.com> 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
>>> tiddlywiki+...@googlegroups.com.
>>> To post to this group, send email to tiddl...@googlegroups.com.
>>> 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
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
> You received thi

Re: [tw] Re: TW5: How to use CreateTiddlersFromCSV

['Mark S.' via TiddlyWiki]

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 <
> tiddl...@googlegroups.com > 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 
>> tiddlywiki+...@googlegroups.com .
>> To post to this group, send email to tiddl...@googlegroups.com 
>> .
>> 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
>>  
>> 
>> .
>> 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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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.
For more options, visit https://groups.google.com/d/optout.


Project_CSV2JSON_v0-1.json
Description: application/json

Re: [tw] Re: TW5: How to use CreateTiddlersFromCSV

[Amanda L. Goodman]

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 <
tiddlywiki@googlegroups.com> 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
> tiddlywiki+unsubscr...@googlegroups.com.
> To post to this group, send email to tiddlywiki@googlegroups.com.
> 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
> 
> .
> 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 tiddlywiki+unsubscr...@googlegroups.com.
To post to this group, send email to tiddlywiki@googlegroups.com.
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/CAFWQ5Z6OME4KSV5BkMKGRKYbhGR%2BxTy4e2wEePdtF4%2BPAwr6ZQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

['Mark S.' via TiddlyWiki]

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 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 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.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

[LG]

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 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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/999bcec9-fd8f-4447-b420-cc517dfa9e45%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

[LG]

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 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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/6f5622ca-c7b0-4edc-8304-43bc9a09e0c1%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

['Mark S.' via TiddlyWiki]

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 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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/503d2e83-8f09-4f90-a240-f4bbddae2118%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Project_CSV2JSON_v0.json
Description: application/json

[tw] Re: TW5: How to use CreateTiddlersFromCSV

[LG]

Mal, 

Thank you for the update. I've been waiting on TW5 to get to where it is 
now for the past few years, so I definitely have snagged the empty.htm from 
the right site!

Best, 

LG 

On Sunday, May 8, 2016 at 1:31:01 AM UTC-4, Mal wrote:
>
> LG,
>
> Someone more knowledgeable than me might chime in here, but I think 
> CreateTiddlersFromCSV was a tool for Tiddlywiki Classic and is not 
> available for TW5.  As far as I am aware, there is no native facility for 
> importing CSV tiddlers into TW5.
>
> Are you sure you are using TW5?
>
> Regards,
>
> Mal
>
>

-- 
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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/5991d035-afc8-4976-921c-3409a2e69d8f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: TW5: How to use CreateTiddlersFromCSV

[Mal]

LG,

Someone more knowledgeable than me might chime in here, but I think 
CreateTiddlersFromCSV was a tool for Tiddlywiki Classic and is not 
available for TW5.  As far as I am aware, there is no native facility for 
importing CSV tiddlers into TW5.

Are you sure you are using TW5?

Regards,

Mal

-- 
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 https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tiddlywiki/d8267490-9ba1-4d03-b233-aac2e22293d8%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.