Thanks for the kind words Joshua and for the wonderful plugin and not to
forget the tips you have just provided.
As I am the only user for this and I dont mind those settings appearing on
the table infact I quite like them. That said someone else might not want
to show those and so if I can I will try adding that option.
Once again thanks for the jasonmangler plugin - I absolutely love it.
On Sat, 1 Aug 2020, 00:02 Joshua Fontany, <joshua.font...@gmail.com> wrote:
> Well done!
>
> Each transclusion of an 'application/csv' tiddler gets its own UNIQUE
> state tiddler (all of the options that you can under the first
> double-chevron).
> This means that you can set each transclusion of a CSV to have its own
> "lines per page", "preview or show all" etc.
>
> IF you want to, you wan wrap the transclusion in a classed Div, like so:
>
> ```
> <div class="hide-csv-controls">
> {{CSVTIDDLERS/DATA12345}}
> </div>
> ```
>
> Then, by adding and removing the tag `$:/tags/Stylsheet` from a tiddler
> with the following text:
> ```
>
> .hide-csv-controls .tc-csv-options { display: none; }
>
> .hide-csv-controls .tc-csv-controls { display: none; }
> ```
> You can hide the controls on those transclusions (thus not bothering the
> reader with things they don't need to see).
>
> OR split that CSS up into two tiddlers and just hide the Options (keeping
> the page controls visible). OR change the class name so you can customize
> what is shown or hidden.
>
> Best,
> Joshua Fontany
>
> On Wednesday, July 29, 2020 at 9:39:52 AM UTC-7 mr.anki...@gmail.com
> wrote:
>
>> Hi Stephen,
>>
>> First thanks for creating the ever so helpful tool. It is very useful
>> indeed.
>>
>> I was however hell bent on making a button that makes use of the
>> "jsonmangler" plugin and I did actually manage to create one this
>> afternoon. It's nowhere near as polished as what you have created but it
>> works.
>>
>> In case anyone is interest, I have included the 4 tld files here that can
>> simply be loaded on to the demo site for jsonmangler
>> <https://joshuafontany.github.io/TW5-JsonMangler/> and then to test
>> follow these steps:
>>
>> 1. Create a new tiddler
>> 2. Copy some excel data
>> 3. Paste data in new tiddler
>> 4. Select the pasted data
>> 5. Click on spiral button that appears on the editor buttons.
>> 6. Give a name to this table
>> 7. Save the tiddler to see the table created.
>>
>> above steps in pictures:
>> [image: exceltbl_20200729-173233.png]
>> [image: exceltbl_20200729-173326.png]
>> [image: exceltbl_20200729-173519.png]
>> [image: exceltbl_20200729-173723.png]
>>
>> To use it on a local wiki ofcourse one will have to install
>> jsonmangler plugin. It however does not beat the lightweight simplicity of
>> http://skplugins.tiddlyspot.com/#TableHelper
>> <http://skplugins.tiddlyspot.com/#TableHelper>
>>
>> Thanks a lot for all the help guys. You are all so very kind. :)
>>
>>
>> On Wed, 29 Jul 2020 at 16:01, 'Stephen Kimmel' via TiddlyWiki <
>> tiddl...@googlegroups.com> wrote:
>>
>>> Ankit,
>>>
>>> When I first developed Tablehelper
>>> http://skplugins.tiddlyspot.com/#TableHelper (which predated the XLSX
>>> and the regex abilities in TW) I was copying a selected area in an Excel
>>> file and pasting it into a tiddler. That data came across as lines with
>>> tabs separating the individual cells. What I wanted a TW table and not just
>>> something that looked like a table in TW. I later added the ability to
>>> convert CSV files which are comma separated cells rather than tab separated
>>> cells so I added that capability to my routine. As Eric points out, though,
>>> some cells contain commas and other things that can trip up simple regex
>>> statements. I ultimately decided that the result wasn't going to be
>>> perfect, just easier to finish converting manually. So I added the option
>>> to do only tab separated fields which it sounds like what you need.
>>>
>>> One point to remember, if you are altering a javascript routine, you
>>> have to save and refresh the wiki for the change to take effect.
>>>
>>> Stephen
>>>
>>> On Wednesday, July 29, 2020 at 2:41:32 AM UTC-5, Ankit Mittal wrote:
>>>>
>>>> Thanks chaps, for this discussion... helps me understand a few things.
>>>>
>>>> Although I still dont understand that when i change the comma in the
>>>> underlying javascript of the parser why it does not honor the change...
>>>>
>>>> For my problem of excel workflow, what i need is just the simple
>>>> requirement to parse data that is tab separated rather than comma
>>>> separated. The work done by Joshua already does the heavy lifting so i am
>>>> going to try and create a editor button that opens a modal asking for user
>>>> input and then create a tiddler of type application/csv using that user
>>>> input and transclude it on current tiddler... something like excise but
>>>> with ability to provide application type can do that too... just not sure
>>>> if i am setting a goal too high.
>>>>
>>>> Would either of you gentleman kindly point me to the code behind excise
>>>> button please?
>>>>
>>>> Regards,
>>>> Ankit
>>>>
>>>>
>>>> --
>>> 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 view this discussion on the web visit
>>> https://groups.google.com/d/msgid/tiddlywiki/4874fef6-a93d-4a93-80b0-31c1ea38ebf7o%40googlegroups.com
>>> <https://groups.google.com/d/msgid/tiddlywiki/4874fef6-a93d-4a93-80b0-31c1ea38ebf7o%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> 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 view this discussion on the web visit
> https://groups.google.com/d/msgid/tiddlywiki/83d0b67c-437a-428f-8a66-f6ceb49290afn%40googlegroups.com
> <https://groups.google.com/d/msgid/tiddlywiki/83d0b67c-437a-428f-8a66-f6ceb49290afn%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/CAAgqyEUHx77p5QnNr3Sv376fhuxxZ_UkfnyXLk1P1BC1tHuPjQ%40mail.gmail.com.
