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 [email protected] <javascript:>. > To post to this group, send email to [email protected] > <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 [email protected]. To post to this group, send email to [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/9a525f7c-603a-45a9-a03d-06f8aef94512%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
