Amazing, thanks so much Jeremy.  Big fan of the Tiddlywiki.

-Mike

On Tuesday, March 6, 2018 at 4:32:44 AM UTC-5, Jeremy Ruston wrote:
>
> Hi Mike
>
> Trying to import excel spreadsheet report repetitively to create database 
> of tiddlers.
> In the primary row of the excel sheet, where the column titles are that 
> specify the pointers for the field import specification, I have a couple 
> columns with line breaks (ALT-Enter in Excel)...Not my choice
>
> How do i specify the line break character in the "column" field of the 
> plugin control so that the plugin finds the correct column and 
> corresponding data to put in the field upon import?
>
> Seeing if I have an option here besides manipulating the excel data. I'd 
> rather just import the existing report as-is that is e-mailed to me.
>
>
> Interesting problem! As you’ll have discovered, attempts to copy the line 
> break character from Excel and paste it into the editor of the XSLX plugin 
> don’t work. The reason is that those single line text fields don’t allow 
> control characters.
>
> A possible workaround is to identify the tiddler field(s) that need to 
> have these control characters pasted, and to edit those fields in a scrap 
> tiddler via a textarea:
>
> <$edit-text tiddler="$:/_importspec/Presidents and 
> Justices/States/Main/title" field="import-field-column" tag="textarea"/>
>
> Then you should be able to paste the required line breaks into the fields.
>
> The problem you’ll then likely run into is that control characters are 
> removed from tiddler fields when you save and reload as a standalone HTML 
> file. A quick and dirty workaround would be to save the wiki in JSON format 
> (via the export button).
>
> Best wishes
>
> Jeremy
>
>
> Thanks!
>
> -Mike
>
>
>
> -- 
> 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 <javascript:>.
> To post to this group, send email to tiddl...@googlegroups.com 
> <javascript:>.
> 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/376094f7-e825-469f-90ec-7d3bf83b7d27%40googlegroups.com
>  
> <https://groups.google.com/d/msgid/tiddlywiki/376094f7-e825-469f-90ec-7d3bf83b7d27%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 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/9a525f7c-603a-45a9-a03d-06f8aef94512%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to