08-20-2018, 04:58 AM | #1 |
Age improves with wine.
Posts: 558
Karma: 95229
Join Date: Nov 2014
Device: Kindle Oasis, Kobo Libra II
|
[GUI plugin] Extract tables of contents
This plugin extracts the tables of contents from selected ePub files to generate a CSV file with columns for the book title, authors, series, series index and ToC entry. It is primarily intended to make it easier to create a list of the short stories in a collection of anthologies.
It incorporates a copy of https://pypi.org/project/Unidecode/ which is used to flatten all strings to ASCII, since Microsoft Excel seems to be allergic to UTF-8. The authors, titles, series and ToC entry are all converted to title case to make it easier to sort the output file. The icon used is the one from the demo plugin, since I do not have the artistic skill to create a new icon. I also have no time to maintain this, but I'm posting it here in the hope that others besides me will find it useful. |
08-20-2018, 11:44 AM | #2 |
Wizard
Posts: 1,161
Karma: 1404241
Join Date: Nov 2010
Location: Germany
Device: Sony PRS-650
|
One remark to Unicode as I use it very often with Excel:
Don't open CSV directly with Excel. It shouldn't be a problem if you choose the correct coding when importing CSV via Data ->Get external data ->From Text. Select as File origin 65001: Unicode (UTF8) Then everything works fine and no one will have problems with non ASCII setups |
Advert | |
|
08-20-2018, 06:39 PM | #3 |
null operator (he/him)
Posts: 20,628
Karma: 26960534
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Another alternative is to open them with LibreOffice Calc, pretty sure it will handle UTF-8 directly.
But, I would probably open the CSV with Nirsoft's CSVFileView program, it doesn't have the mathematical functions of Excel, but it has enough for simple table operations, and it has a neat save as HTML feature. BR |
02-11-2024, 07:47 AM | #4 |
Member
Posts: 22
Karma: 10
Join Date: Sep 2020
Device: Kindle Paperwhite
|
You had a great idea, since I am now doing it manually.
It is missing that the data to be exported can be configured and it would be very interesting if the data were shown in a window and to be able to export it or paste them directly into the comments field instead of saving them to a file. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Extract ISBN | kiwidude | Plugins | 532 | 04-07-2024 11:01 AM |
[GUI Plugin] Save Virtual Libraries To Column (GUI) | chaley | Plugins | 14 | 04-04-2021 05:25 AM |
Three Tables of Contents? | SigilBear | ePub | 13 | 02-13-2017 04:49 PM |
Tables of Contents | carogray | General Discussions | 17 | 10-23-2013 04:45 PM |
Extract table of contents from mobi file | oecherprinte | Kindle Formats | 7 | 04-16-2012 12:10 PM |