Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

['Mark S.' via TiddlyWiki]

The entry with "Monty Pythons Flying Circus" is missing a title (or a 
director, depending on if you meant for MPFC to be director or title).

All fields need to be present, though they can be empty. An empty field 
would represented by empty double quotes. So that particular entry might be 
represented as:

"motion_picture","Monty Pythons Flying Circus","","30 
min","05.10.1969","Neuro,Gestalttheorie,Movie"

(Assuming MPFC was the 'directory').

HTH
Mark

On Sunday, May 15, 2016 at 4:11:46 PM UTC-7, Jan wrote:
>
> Hallo Mark,
> Your Example works fine now, the code does not cause crashes anymore, but 
> it gives me your error-message for this:
>
> type,director,title,length,launch,tags
> "motion_picture","Hans Richter","Ghosts Before Breakfast","6 
> min","14.07.1928","Neuro,Gestalttheorie,Movie"
> "motion_picture","Monty Pythons Flying Circus","30 
> min","05.10.1969","Neuro,Gestalttheorie,Movie"
> "motion_picture","John Mc Tiernan","Predator","107 
> min","12.06.1987","Neuro,Gestalttheorie,Movie"
> "motion_picture","Paul Verhoeven","Robo Cop","102 
> min","17.07.1987","Neuro,Gestalttheorie,Movie"
> "motion_picture","Peter Greenaway","The Draughtsmans Contract","108 
> min","30.06.1983","Neuro,Gestalttheorie,Movie"
> "motion_picture","James Cameron","The Terminator","107 
> min","26.10.1984","Neuro,Gestalttheorie,Movie"
>
> I have no clue why...
>
> Thanks for your endurance, 
> Jan
>
>
>
>
> Am 15.05.2016 um 03:38 schrieb 'Mark S.' via TiddlyWiki:
>
> Although you copied it from the list, when you pasted it in you already 
> had a line in place. Or you selected an extra line feed. So if you check, 
> you'll see that there is one "invisible" line at the bottom of your input 
> tiddler that is choking the program. When/If I do an update, I'll have to 
> add checking code to toss out bad lines.
>
> HTH
> Mark
>
> On Saturday, May 14, 2016 at 6:32:22 PM UTC-7, Jan wrote: 
>>
>> Hi Mark,
>> the last string I tested was:
>>
>> title,tags,text,birth,death
>> "John Smith","English male,Therapist","Explorer, Artist","1900","1981"
>>
>> because I wanted to see it work...
>> This means I copypasted it right from the mail to the field...
>>
>> Yours Jan
>>
>> Am 15.05.2016 um 01:22 schrieb 'Mark S.' via TiddlyWiki:
>>
>> Can you share the lines that crashed it?  I would guess that you either 
>> have an empty field or a blank line somewhere.
>>
>> Mark
>>
>> On Saturday, May 14, 2016 at 3:26:07 PM UTC-7, Jan wrote: 
>>>
>>> Dear Mark,
>>> It crashed when I used 6 arrays with 5 entries...and it still crashed 
>>> when I pasted a single line. 
>>> The errorcode is: TypeError: araLine[j] is undefined
>>>
>>> -- 
>> 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+...@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/d3983c2f-9bfa-4e33-857c-ef7bd16173f6%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+...@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/befa483d-fb31-45c0-9bdf-ad77ede9f395%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/c2c26813-f96a-4200-93ae-a17a8b589a83%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

[Jan]

Hallo Mark,
Your Example works fine now, the code does not cause crashes anymore, 
but it gives me your error-message for this:


type,director,title,length,launch,tags
"motion_picture","Hans Richter","Ghosts Before Breakfast","6 
min","14.07.1928","Neuro,Gestalttheorie,Movie"
"motion_picture","Monty Pythons Flying Circus","30 
min","05.10.1969","Neuro,Gestalttheorie,Movie"
"motion_picture","John Mc Tiernan","Predator","107 
min","12.06.1987","Neuro,Gestalttheorie,Movie"
"motion_picture","Paul Verhoeven","Robo Cop","102 
min","17.07.1987","Neuro,Gestalttheorie,Movie"
"motion_picture","Peter Greenaway","The Draughtsmans Contract","108 
min","30.06.1983","Neuro,Gestalttheorie,Movie"
"motion_picture","James Cameron","The Terminator","107 
min","26.10.1984","Neuro,Gestalttheorie,Movie"


I have no clue why...

Thanks for your endurance,
Jan




Am 15.05.2016 um 03:38 schrieb 'Mark S.' via TiddlyWiki:
Although you copied it from the list, when you pasted it in you 
already had a line in place. Or you selected an extra line feed. So if 
you check, you'll see that there is one "invisible" line at the bottom 
of your input tiddler that is choking the program. When/If I do an 
update, I'll have to add checking code to toss out bad lines.


HTH
Mark

On Saturday, May 14, 2016 at 6:32:22 PM UTC-7, Jan wrote:

Hi Mark,
the last string I tested was:

title,tags,text,birth,death
"John Smith","English male,Therapist","Explorer, Artist","1900","1981"

because I wanted to see it work...
This means I copypasted it right from the mail to the field...

Yours Jan

Am 15.05.2016 um 01:22 schrieb 'Mark S.' via TiddlyWiki:

Can you share the lines that crashed it?  I would guess that you
either have an empty field or a blank line somewhere.

Mark

On Saturday, May 14, 2016 at 3:26:07 PM UTC-7, Jan wrote:

Dear Mark,
It crashed when I used 6 arrays with 5 entries...and it still
crashed when I pasted a single line.
The errorcode is: TypeError: araLine[j] is undefined

-- 
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+...@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/d3983c2f-9bfa-4e33-857c-ef7bd16173f6%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/befa483d-fb31-45c0-9bdf-ad77ede9f395%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/57390222.7000104%40googlemail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

[Mal]

Just as another option, I tend to use spreadsheets to create json files 
suitable for importing.  I would load the CSV data into the spreadsheet and 
then use cell formulas to create lines of json text that can be cut and pasted 
into a text editor and saved as a json file.

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/cc2c3bbd-6dd2-423e-af82-a1a4162f023e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

['Mark S.' via TiddlyWiki]

Although you copied it from the list, when you pasted it in you already had 
a line in place. Or you selected an extra line feed. So if you check, 
you'll see that there is one "invisible" line at the bottom of your input 
tiddler that is choking the program. When/If I do an update, I'll have to 
add checking code to toss out bad lines.

HTH
Mark

On Saturday, May 14, 2016 at 6:32:22 PM UTC-7, Jan wrote:
>
> Hi Mark,
> the last string I tested was:
>
> title,tags,text,birth,death
> "John Smith","English male,Therapist","Explorer, Artist","1900","1981"
>
> because I wanted to see it work...
> This means I copypasted it right from the mail to the field...
>
> Yours Jan
>
> Am 15.05.2016 um 01:22 schrieb 'Mark S.' via TiddlyWiki:
>
> Can you share the lines that crashed it?  I would guess that you either 
> have an empty field or a blank line somewhere.
>
> Mark
>
> On Saturday, May 14, 2016 at 3:26:07 PM UTC-7, Jan wrote: 
>>
>> Dear Mark,
>> It crashed when I used 6 arrays with 5 entries...and it still crashed 
>> when I pasted a single line. 
>> The errorcode is: TypeError: araLine[j] is undefined
>>
>> -- 
> 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+...@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/d3983c2f-9bfa-4e33-857c-ef7bd16173f6%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/befa483d-fb31-45c0-9bdf-ad77ede9f395%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

[Jan]

Hi Mark,
the last string I tested was:

title,tags,text,birth,death
"John Smith","English male,Therapist","Explorer, Artist","1900","1981"

because I wanted to see it work...
This means I copypasted it right from the mail to the field...

Yours Jan

Am 15.05.2016 um 01:22 schrieb 'Mark S.' via TiddlyWiki:
Can you share the lines that crashed it?  I would guess that you 
either have an empty field or a blank line somewhere.


Mark

On Saturday, May 14, 2016 at 3:26:07 PM UTC-7, Jan wrote:

Dear Mark,
It crashed when I used 6 arrays with 5 entries...and it still
crashed when I pasted a single line.
The errorcode is: TypeError: araLine[j] is undefined

--
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/d3983c2f-9bfa-4e33-857c-ef7bd16173f6%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/5737D198.5000103%40googlemail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

[progetti]

Jan

I feel for you. One of the limitations with TW is when things fail is its 
quite difficult to pin-down why. The interface gives virtually no feedback. 

JSON is a much better format IMO because its not ambiguous in the way CSV 
can be. But I don't think I can help you on specifics because I  use a GREP 
engine (https://www.powergrep.com/) that requires understanding how to use 
complex Regular Expressions to prep text into JSON form.

Maybe I can help a bit if you can show me a fragment of what a native JSON 
the program makes looks like?

It may be that Mark S. is in the right direction on CSV. Its difficult to 
be sure. Anyway, I will happily look at any JSON file if you want.

Best wishes
Josiah

On Sunday, 15 May 2016 00:26:07 UTC+2, Jan wrote:
>
> Dear Mark,
> It crashed when I used 6 arrays with 5 entries...and it still crashed when 
> I pasted a single line. 
> The errorcode is: TypeError: araLine[j] is undefined
> Dear Josiah,
> I tried out various programms to convert csv to json. Both formats are to 
> be quite vulnerable if you have to convert them manually...If you got a 
> nice 'n stable solution I' d be thankfull. 
> I'd be glad if i coud avoid the detour vía json.
> I wrote an xml to make Zotero export csv-compatible strings. I attached it 
> though it is not yet perfect for all subjects (The Template for websites 
> and articles in journals are not ready yet... )
> Just pull it on firefox or Zotero to install  (and do not mind the error 
> message)...btw: Zotero can be found on https://www.zotero.org/ and is 
> very practical for scientific work. 
>
> The quotations look like this: 
>
> "*motion_picture*","Peter Greenaway", *"A Zed & Two Noughts",* "115 min", 
> "25.05.1990"
>
> "*motion_picture*","Steven Spielberg", *"E.T. the Extra-Terrestrial",* 
> "115 min", "11.06.1982"
>
> "*motion_picture*","Terry Gilliam", *"Fear and Loathing in Las Vegas",* 
> "118 min", "22.05.1998"
>
> "*book*","John Howard Lawson", *"Film: the creative process: the search 
> for an audio-visual language and structure",* "New York", "1964"
>
> "*book*","Felicity Colman", *"Deleuze and cinema: the film concepts",* 
> "Oxford", "2011"
>
> I would like to create templates like
> "director", "title", "length", "date"   for the type motion_picture
> to parse the strings and create the tiddlers and fields directly out of 
> them.
>
> I guess this way is safer and easier than vía json...
>
> Jan
>
>
>
>
>
>
>
>
>
> Am 14.05.2016 um 19:09 schrieb prog...@assays.tv :
>
> Ciao Mark & Jan
>
> This is an interesting issue. Personally I found that creating simple 
> JSON's using GREP tools, rather than relying on a programme's own routines, 
> is more successful for importable files. i dont know that particular 
> application. What i do know is that we should not expect Tiddlywiki to 
> natively cope with too much complexity. The simpler and more "flat-file" 
> the import the better in my experience.
>
> Best wishes
> Josiah
>
> On Saturday, 14 May 2016 17:37:27 UTC+2, Mark S. wrote: 
>>
>> So how did the csv2json crash? I imagine if you try to convert too much 
>> at once there will be problems.
>>
>> A quick look online suggests that the zotero RDF format may have more 
>> fields than the json export. RDF is (usually) just a text format (XML) so 
>> you could browse it and see if it contains everything you want. 
>>
>> If you have your data in the form of a table, what some people have done 
>> is to load it into a spreadsheet. Then add columns and rows to "decorate" 
>> the data so that it looks like a JSON file. Then copy the whole thing as 
>> text (usually need "copy as" functionality) and then paste into a text file 
>> to create your json file to import.
>>
>> HTH
>> Mark
>>
>>
>> On Friday, May 13, 2016 at 5:17:18 PM UTC-7, Jan wrote: 
>>>
>>> Hallo,
>>> has anyone discovered a workflow of exporting entries from a 
>>> Zotero-Library and reimporting them as Tiddlers.
>>> Although Zotero is able to create a json file, this is not packing the 
>>> interesting Data like autor and year, but useless information.
>>> I had big trouble importing the CSVs, but finally the render as Tables.
>>> Unfortunately they crash the MAS/csv2json.js 
>>> 
>>> -plugin...
>>>
>>> -Is there a way of generating tiddlers from a table within a tiddler?
>>> -Should i use a different format than json and csv to start with?
>>> -Has anyone experience with the Zotero  xul-editor to produce a better 
>>> .json-export?
>>> Jan
>>>
>>> -- 
> 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+...@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://

Re: [tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

['Mark S.' via TiddlyWiki]

Can you share the lines that crashed it?  I would guess that you either 
have an empty field or a blank line somewhere.

Mark

On Saturday, May 14, 2016 at 3:26:07 PM UTC-7, Jan wrote:
>
> Dear Mark,
> It crashed when I used 6 arrays with 5 entries...and it still crashed when 
> I pasted a single line. 
> The errorcode is: TypeError: araLine[j] is undefined
>
>

-- 
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/d3983c2f-9bfa-4e33-857c-ef7bd16173f6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

[progetti]

Ciao Mark & Jan

This is an interesting issue. Personally I found that creating simple 
JSON's using GREP tools, rather than relying on a programme's own routines, 
is more successful for importable files. i dont know that particular 
application. What i do know is that we should not expect Tiddlywiki to 
natively cope with too much complexity. The simpler and more "flat-file" 
the import the better in my experience.

Best wishes
Josiah

On Saturday, 14 May 2016 17:37:27 UTC+2, Mark S. wrote:
>
> So how did the csv2json crash? I imagine if you try to convert too much at 
> once there will be problems.
>
> A quick look online suggests that the zotero RDF format may have more 
> fields than the json export. RDF is (usually) just a text format (XML) so 
> you could browse it and see if it contains everything you want. 
>
> If you have your data in the form of a table, what some people have done 
> is to load it into a spreadsheet. Then add columns and rows to "decorate" 
> the data so that it looks like a JSON file. Then copy the whole thing as 
> text (usually need "copy as" functionality) and then paste into a text file 
> to create your json file to import.
>
> HTH
> Mark
>
>
> On Friday, May 13, 2016 at 5:17:18 PM UTC-7, Jan wrote:
>>
>> Hallo,
>> has anyone discovered a workflow of exporting entries from a 
>> Zotero-Library and reimporting them as Tiddlers.
>> Although Zotero is able to create a json file, this is not packing the 
>> interesting Data like autor and year, but useless information.
>> I had big trouble importing the CSVs, but finally the render as Tables.
>> Unfortunately they crash the MAS/csv2json.js 
>> 
>> -plugin...
>>
>> -Is there a way of generating tiddlers from a table within a tiddler?
>> -Should i use a different format than json and csv to start with?
>> -Has anyone experience with the Zotero  xul-editor to produce a better 
>> .json-export?
>> Jan
>>
>>

-- 
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/f6b9987d-40d0-49c5-9830-78bcb35fdfb3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[tw] Re: Importing Entries (csv/json) from the Zotero Bibliography Tool.

['Mark S.' via TiddlyWiki]

So how did the csv2json crash? I imagine if you try to convert too much at 
once there will be problems.

A quick look online suggests that the zotero RDF format may have more 
fields than the json export. RDF is (usually) just a text format (XML) so 
you could browse it and see if it contains everything you want. 

If you have your data in the form of a table, what some people have done is 
to load it into a spreadsheet. Then add columns and rows to "decorate" the 
data so that it looks like a JSON file. Then copy the whole thing as text 
(usually need "copy as" functionality) and then paste into a text file to 
create your json file to import.

HTH
Mark


On Friday, May 13, 2016 at 5:17:18 PM UTC-7, Jan wrote:
>
> Hallo,
> has anyone discovered a workflow of exporting entries from a 
> Zotero-Library and reimporting them as Tiddlers.
> Although Zotero is able to create a json file, this is not packing the 
> interesting Data like autor and year, but useless information.
> I had big trouble importing the CSVs, but finally the render as Tables.
> Unfortunately they crash the MAS/csv2json.js 
> 
> -plugin...
>
> -Is there a way of generating tiddlers from a table within a tiddler?
> -Should i use a different format than json and csv to start with?
> -Has anyone experience with the Zotero  xul-editor to produce a better 
> .json-export?
> Jan
>
>

-- 
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/93ea35bb-7d6b-4e0d-adfb-f1136c7cd569%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.