Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com)
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi
Tinderbox Users >> Moving to Tinderbox 6 >> Tab-delimited text import and line breaks
http://www.eastgate.com/Tinderbox/forum//YaBB.cgi?num=1402416669

Message started by troubledworkflow on Jun 10th, 2014, 12:11pm

Title: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 12:11pm

Hi,
I'm having some trouble with the new version and line breaks in imports. When the text below is pasted in Tinderbox, the text after line break is not recognized as part of $Text. If there are more rows/notes, these don't get imported at all. The import works in Tinderbox 5, so I guess something has changed? Any solution?

Name      Text
Name      "Note text before line break.

Note text after line break."

Title: Re: Tab-delimited text import and line breaks
Post by Mark Anderson on Jun 10th, 2014, 12:25pm

Imports from what? It not totally clear, but it sounds like line breaks inside CSV or tab-delimited tabular data. As raw text, your example works for me, like so:



Could you clarify your context? We may each only use one or two input methods but in aggregate there are many options.  :)

Title: Re: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 1:11pm

Yes, it is line breaks inside tab-delimited tabular data. Copying from my post strips the tabs it seems. To see the behavior, replace the spaces between Name and Text with tabs.

Title: Re: Tab-delimited text import and line breaks
Post by Mark Anderson on Jun 10th, 2014, 1:37pm

OK, tried that and it works here:



Text used (copied/pasted from TextEdit):

Name\TabText\LineBreak
Name\Tab"Note text before line break.\LineBreak
\LineBreak
Note text after line break."

Title: Re: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 1:50pm

But that screenshot doesn't show the imported spreadsheet? I want to import each row to individual notes with attributes specified by the first line. When I paste, the note is imported in a container "imported spreadsheet".

This: http://www.acrobatfaq.com/atbref5/index/ImportExportFormatting/SpreadsheetTab-Delimited.html

Title: Re: Tab-delimited text import and line breaks
Post by Mark Anderson on Jun 10th, 2014, 2:42pm

Thanks, this is why context matters. Which of these are you trying to do:
  • Drop a tab-delim file onto a main view.
  • Paste tab-delim data from anywhere(?) into a main view.
I'm trying to check your scenario as described but it keeps being subtly redefined!  :)

Title: Re: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 2:46pm

Sorry. I'm using a slightly modified version of the script in link below to paste data from DEVONthink. It worked perfectly in Tinderbox 5.

http://www.eastgate.com/Tinderbox/forum//YaBB.pl?num=1346268662/21#21

Title: Re: Tab-delimited text import and line breaks
Post by Mark Anderson on Jun 10th, 2014, 2:51pm

OK, I added you're specimen info to Excel 2011:



I then selected/copied the 4 cells with data and blind pasted that data into a v6 left pane:



Lastly, I exported the file as a tab-delimited text file which I than drag/dropped onto v6:



Could you paste a URL to a (failing) example text file of data so i can try it here. Given the above tests I suspect there are other characters - possible non-priting/invisible in your source text that may be creating issues.  

Title: Re: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 3:06pm

Strange...
https://dl.dropboxusercontent.com/u/1287177/import.txt
This text imported from devonthink using the script above imports to one note withText "More text." and an other note with name "Extra more text.".

Title: Re: Tab-delimited text import and line breaks
Post by Mark Anderson on Jun 10th, 2014, 3:34pm

OK, I now see where the issue is occurring. I've passed in a report. I believe the v6 behaviour is not correct - it should work as in v5.

Title: Re: Tab-delimited text import and line breaks
Post by troubledworkflow on Jun 10th, 2014, 3:49pm

Good to know. thanks.

Tinderbox User-to-User Forum (for formal tech support please email: info@eastgate.com) » Powered by YaBB 2.2.1!
YaBB © 2000-2008. All Rights Reserved.