MobileRead Forums - View Single Post

ilovejedd · 04-01-2019, 10:22 AM

The Job Spy plugin allows you to export a list of all your series.

I don't know of an easy way to get a series-author list short of doing so on a per-book basis. Create catalog or command-line calibredb list will show the info but does so per book, iirc. Mind, you could always export to CSV and deduplicate the generated list using OpenOffice, LibreOffice, Excel or similar.

Only way I can think of to get the series-authors list directly is if you open a copy of metadata.db with SQLiteBrowser or something and execute a SQL query. Note, emphasis on copy. You don't want to be messing around with and risk corrupting your actual Calibre metadata.db file.

Code:

SELECT DISTINCT series.name AS series, authors.name AS authors 
FROM series, authors, books_authors_link, books_series_link 
WHERE books_authors_link.book=books_series_link.book AND authors.id=books_authors_link.author AND series.id=books_series_link.series 
ORDER BY authors.name, series.name

04-01-2019, 10:22 AM	#2
ilovejedd hopeless n00b Posts: 5,110 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	The Job Spy plugin allows you to export a list of all your series. I don't know of an easy way to get a series-author list short of doing so on a per-book basis. Create catalog or command-line calibredb list will show the info but does so per book, iirc. Mind, you could always export to CSV and deduplicate the generated list using OpenOffice, LibreOffice, Excel or similar. Only way I can think of to get the series-authors list directly is if you open a copy of metadata.db with SQLiteBrowser or something and execute a SQL query. Note, emphasis on copy. You don't want to be messing around with and risk corrupting your actual Calibre metadata.db file. Code: SELECT DISTINCT series.name AS series, authors.name AS authors FROM series, authors, books_authors_link, books_series_link WHERE books_authors_link.book=books_series_link.book AND authors.id=books_authors_link.author AND series.id=books_series_link.series ORDER BY authors.name, series.name Last edited by ilovejedd; 04-01-2019 at 10:30 AM.