Export from full text search?

feuille · 03-03-2023, 08:17 AM

Full-text search is a great tool for exploring my libraries and I use it extensively. I would often find it useful to be able to export the hit list (with some meta data, like author, title, pub date, ...) to other programs (e.g. in CSV format).

DaltonST · 03-03-2023, 09:52 AM

Easy if you use the Multi-Column Search plugin's FTS tool. It can use the Calibre FTS db, then shows the matching books. Then, Create Catalog for the resulting books, specifying the columns to export to a csv file.

Another approach would be to use the EPOM plugin, which is pure FTS, update a custom column with a tag that relates somehow to the specific search criteria used, then when convenient creating a Catalog as above.

MCS has much simpler functonality for updating custom columns with search results from FTS, which is why I wrote EPOM. Still, MCS might be enough for you.

DaltonST

kovidgoyal · 03-03-2023, 11:52 AM

Do the search. Click the mark all books button at the button and choose select all books in the library. Then in the library view right click the convert books button and choose create a catalog and generate a CSV catalog of the selected books.

feuille · 03-12-2023, 10:44 AM

Quote:

Originally Posted by DaltonST

Easy if you use the Multi-Column Search plugin's FTS tool.
DaltonST

Thanks for the hint! Since I had never worked with MCS before, I had to search a while (the PDF manual still lacks a reference to FTS). A very flexible tool!

Bey’m Himmel, dieſes Programm iſt ſchön!
:-)

feuille · 03-12-2023, 10:46 AM

Quote:

Originally Posted by kovidgoyal

Do the search. Click the mark all books button at the button and choose select all books in the library. Then in the library view right click the convert books button and choose create a catalog and generate a CSV catalog of the selected books.

Very handy! The only thing I'm missing is the context around the search term displayed in the FTS window.

03-03-2023, 08:17 AM	#1
feuille Connoisseur Posts: 62 Karma: 666 Join Date: May 2020 Location: Germany Device: android smartphone + tablet	Export from full text search? Full-text search is a great tool for exploring my libraries and I use it extensively. I would often find it useful to be able to export the hit list (with some meta data, like author, title, pub date, ...) to other programs (e.g. in CSV format).

03-03-2023, 09:52 AM	#2
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Easy if you use the Multi-Column Search plugin's FTS tool. It can use the Calibre FTS db, then shows the matching books. Then, Create Catalog for the resulting books, specifying the columns to export to a csv file. Another approach would be to use the EPOM plugin, which is pure FTS, update a custom column with a tag that relates somehow to the specific search criteria used, then when convenient creating a Catalog as above. MCS has much simpler functonality for updating custom columns with search results from FTS, which is why I wrote EPOM. Still, MCS might be enough for you. DaltonST Last edited by DaltonST; 03-03-2023 at 11:42 AM. Reason: new paragraph

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Full text search	Steve0412	Library Management	3	11-12-2022 08:20 PM
Full-text search not really full-text	secasa	Library Management	5	10-01-2022 10:11 PM
Full text search?	excaliber	Library Management	3	08-07-2017 06:09 AM
Full Text Search?	silentguy	Calibre	4	02-22-2012 03:03 PM
Google Book Search to search full-text books online	Bob Russell	Deals and Resources (No Self-Promotion or Affiliate Links)	1	08-19-2006 12:13 PM

03-03-2023, 11:52 AM	#3
kovidgoyal creator of calibre Posts: 45,347 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Do the search. Click the mark all books button at the button and choose select all books in the library. Then in the library view right click the convert books button and choose create a catalog and generate a CSV catalog of the selected books.

Advert

Advert