paste in external table?

[Dave Parker]

Is there a way to copy an external table, say on a website or in a pdf and be able to paste it into a tiddler and keep the table formatting without having to edit with "|"s by hand? Maybe there's a plugin for this?

For example right now I'm reading a pdf from my association on return-to-work required disinfection practices and when I copy paste a table, I get this:

Treatment Surfaces, Tools and Equipment

Surface Action(s) Frequency

Chiropractic table head piece

and thoracic piece

• Use single use paper on

head piece to shield

patient’s face

• During every patient

encounter

• Clean and disinfect,

following product guidelines

on contact time to achieve

proper disinfection

• Disinfect after every patient

encounter

• Clean when soiling is visible

or daily, whichever is more

frequent

Chiropractic table hand pieces • Clean and disinfect,

following product guidelines

• Disinfect after every patient

encounter 

Thanks,

- Dave

[Ton Gerner]

Hi Dave,

For tables from the web or spreadsheets you can use the Table helper from Stephen Kimmel, see http://skplugins.tiddlyspot.com/

I think PDF's will be problematic but you can try.

Cheers,

Ton

[Mat]

If you can access the html code, then you can copy-paste this directly into a tiddler.

<:-) 

[Dave.2]

Thanks Ton, I'll look into that

Mat, in this case it was from a pdf.  Are you  (or anyone) aware of a method to convert that into html prior to pasting into a tiddler?  Surely there's got to be some html involved when a browser renders a pdf?  Or is it just a graphical thing rather than html?

I did a F12 to inspect, but it didn't look like html (although I should have searched for the term "<table" ).  I'll google this and post back if I find a positive answer.

Thanks again,

- Dave

[Peter Buyze]

Ton,

do you have the email address of Stephen? I love his tiddlyspot theme.

27 Apr 2020, 11:49 by ton.g...@gmail.com:

--

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/d8e06858-70db-421f-b804-f7075c1002af%40googlegroups.com.

[Dave.2]

My guess is that if you search "dev fire" and click the search icon for advanced search you'll find $:/palettes/Dev Fire

and I would think if you drag that into yours you should be able to pick it...

edit: Nope, tried it but it didn't work :(

[Mark S.]

The browser uses an internal extension to display the PDF. The PDF is more like a graphic image with a text overlay. It takes dedicated software (like ABBVY) to convert tables into word or html tables. Well, that's my understanding. If there is some to easily turn PDF into html, I'd love to hear it.

[Birthe C]

Peter and Dave2, it works. After dragging the palette to your wiki, remember to change the palette used.

[Ton Gerner]

Hi Peter,

Attached de Dev Fire palette exported as json. You can import that in your wiki.

Cheers,

Ton

On Monday, April 27, 2020 at 7:24:42 PM UTC+2, Peter Buyze wrote:

Ton,

do you have the email address of Stephen? I love his tiddlyspot theme.

27 Apr 2020, 11:49 by ton....@gmail.com:

Hi Dave,

For tables from the web or spreadsheets you can use the Table helper from Stephen Kimmel, see http://skplugins.tiddlyspot.com/

I think PDF's will be problematic but you can try.

Cheers,

Ton

--

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 tiddl...@googlegroups.com.

[Dave.2]

Yes, it works now.  When I tried it before I was doing it over a VNC connection (although I don't see how that should affect anything), but yes its working now :)

Regarding the TableHelper plugin,

it definitely is a good helper, but doesn't actually convert a copy-pasting of a pdf table (at least one with multiple lines in a cell) to the original format.  But it is definitely a time saver to skip steps in the inevitable edit-table-by-hand work you'd have to do to get the table right :)

[A Gloom]

a browser extension (for Chrome, probably there's one for Firefox) to copy a web page's table html code which can be pasted into a tiddler-- html tables have more flexibilty than wikitext tables (using "|")-- don't know if it can handle pdf's viewed in a browser

https://chrome.google.com/webstore/detail/copytables/ekdpkppgmlalfkphpibadldikjimijon?hl=en

you can also view page source (actual left click menu option in most browsers) of a web page to get the html code of a table if you don't want to use an extension and can suffer through going through all the code of web pages these days

to extract tables from pdf's

https://www.labnol.org/software/extract-pdf-tables-into-html-or-excel/8345/

this converts it into Excel xls format which the TW XLSX Utilities Edition will read

[TonyM]

In a similar vein to browser tools to copy html there are tools all over the place and in tiddlywiki for table to csv, csv to tiddlywiki or spreadsheets.

One trick I use is to paste into a spreadsheet, use the appropriate text to columns then export as a csv. 

Other tools such as CSVed on windows at least, allow for sophisticated and simple reworking of csv files.

Regards

Tony

[Peter Buyze]

Thanks Ton.

27 Apr 2020, 21:59 by ton.g...@gmail.com:

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/4a7a858d-6007-40da-a06b-ab24693c9804%40googlegroups.com.

[Peter Buyze]

Thanks Birthe. It works on a TiddlyWiki file, but on a TiddlyBlink file the normal black text is not readable with this palette. I guess the font of TB is not quite the same as the TW font.

27 Apr 2020, 21:42 by strikke...@gmail.com:

--

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/dcea9792-5d46-4b8b-9b4a-0925c5bdce3b%40googlegroups.com.