Making a list of Series in Calibre

Bermudagirl · 04-01-2019, 05:26 AM

Can anyone tell me if it is possible to make a list of my series that I have set up in Calibre? I have quite a lot. I don't want to list all the books, just have a list of the book series with their authors.
Is this something I can actually do?

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

Bermudagirl · 04-01-2019, 11:27 AM

Thank you! I'll have a look at the Job Spy plugin.

04-01-2019, 05:26 AM	#1
Bermudagirl Connoisseur Posts: 74 Karma: 192164 Join Date: Oct 2010 Location: Scotland Device: iPad Mini 4	Making a list of Series in Calibre Can anyone tell me if it is possible to make a list of my series that I have set up in Calibre? I have quite a lot. I don't want to list all the books, just have a list of the book series with their authors. Is this something I can actually do?

04-01-2019, 10:22 AM	#2
ilovejedd hopeless n00b Posts: 5,111 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making a selection from a drop-down list using the keyboard	HarryT	Calibre	22	02-15-2014 06:39 AM
Making wish list public	TomChiverton	Kobo Reader	3	09-21-2013 07:17 PM
Plugin for making a summary list about your books	equilan1986	Plugins	2	01-08-2013 07:21 AM
help making a plugboard for sorting series?	ousire	Library Management	10	11-26-2012 09:40 AM
making a list in calibre	wimm	Calibre	0	01-13-2010 10:03 AM

04-01-2019, 11:27 AM	#3
Bermudagirl Connoisseur Posts: 74 Karma: 192164 Join Date: Oct 2010 Location: Scotland Device: iPad Mini 4	Thank you! I'll have a look at the Job Spy plugin.