List of Books

patetc · 09-08-2020, 03:56 PM

I would like a list of all of the books in Calibre. Authors too if possible. Is there a way to do this in Calibre?

DNSB · 09-08-2020, 04:14 PM

Quote:

Originally Posted by patetc

I would like a list of all of the books in Calibre. Authors too if possible. Is there a way to do this in Calibre?

Have you tried the Create a catalog of the books in your calibre library option? For some reason only known to Kovid Goyal, it lives under Convert books on the book context menu. Right click on a book in the library view, hover on Convert books and click on the Create a catalog... item.

theducks · 09-08-2020, 04:16 PM

Right click the Convert Icon: Catalog: CSV (recognized by most spreadsheets)
OR
Use the CLI:calibredb -- )list (Go to the Calibre Help site fo Commandline Tools documentation

BetterRed · 09-08-2020, 07:21 PM

Quote:

Originally Posted by DNSB

For some reason only known to Kovid Goyal, it lives under Convert books on the book context menu.

the "Create catalogue" tool is available as a discrete item that can be added to any toolbar or menu in the normal way

Click image for larger version

Name: Annotation 2020-09-09 091250.jpg
Views: 168
Size: 117.5 KB
ID: 181838

BR

patetc · 09-08-2020, 08:11 PM

I was able to create a catalog but the options don't allow me to get it in the right format. For some reason the first author was "Woods" in spite of the fact that I wanted it alphabetical.

Oh well, I'll try something else.

Pat

DNSB · 09-08-2020, 11:52 PM

Quote:

Originally Posted by patetc

I was able to create a catalog but the options don't allow me to get it in the right format. For some reason the first author was "Woods" in spite of the fact that I wanted it alphabetical.

Oh well, I'll try something else.

Pat

Export the catalog as a CSV file, import it into a spreadsheet program, sort the entries how you want. Save the modified file and use calibre to convert it to whatever ebook format you happen to want.

DNSB · 09-08-2020, 11:53 PM

Quote:

Originally Posted by BetterRed

the "Create catalogue" tool is available as a discrete item that can be added to any toolbar or menu in the normal way

The question for me is why Create catalog is part of the Convert books context menu. Not the most intuitive location, IMNSHO.

BetterRed · 09-09-2020, 02:58 AM

Quote:

Originally Posted by DNSB

The question for me is why Create catalog is part of the Convert books context menu. Not the most intuitive location, IMNSHO.

Probably seemed a good idea at the time for reasons no longer apparent.

BR

kovidgoyal · 09-09-2020, 04:21 AM

Because there is limited real estate for icons on the toolbar, there can be only so many in the default configuration.

skb · 09-09-2020, 05:50 PM

Quote:

Originally Posted by patetc

I was able to create a catalog but the options don't allow me to get it in the right format. For some reason the first author was "Woods" in spite of the fact that I wanted it alphabetical.

Oh well, I'll try something else.

Pat

Just open the CSV with a spreadsheet, highlight all and use Data/Sort and sort by Columns how you want.
Also, it may have used the "Author sort" column to sort initially. I don't use that column so unchecked it when generating the file.

rracoon01 · 01-08-2021, 01:01 PM

I just finally got caught up to the new python version updating to 9.0 today. I am now having trouble with the Calibredb list command performing differently than before. I you do a list on the command line the output looks just fine with a header line and then the single book qualified in the search argument. But if the output is redirected to a file or even if you view the output in a log file the book comes first and then the header line. This is screwing up a batch file of mine that directs the list output to a file and then parses the file with the batch command "for" to retrieve the id number of the book searched for. I have tried the --ascending option but no help there. This worked correctly in the pre Python 3 versions.

calibredb list --search="title:Allen's eBook Shelf" --limit=1 >list.tmp

type list.tmp
365 Allen's eBook Shelf Allen Williams
id title authors

kovidgoyal · 01-08-2021, 07:40 PM

https://github.com/kovidgoyal/calibr...9f1cbdf870074d

rracoon01 · 01-09-2021, 01:37 PM

I have Calibre 9.0. But I use the command line interface to automate some tasks like rebuilding catalogs rather than having to do it by hand in the GUI. this has broken one of those batch files.

Please advise.

georgemk · 01-09-2021, 01:59 PM

@rracoon01
Kovid's note means that a fix will appear in the next version released. It just missed out on v5.9.0 which was released on the 8th January. The release schedule is normally every 2 weeks.

DNSB · 01-09-2021, 08:07 PM

@rracoon01: Also note the latest calibre release is 5.9.0 not 9.0.

09-08-2020, 03:56 PM	#1
patetc Member Posts: 22 Karma: 10 Join Date: Jan 2012 Device: Kindle Fire	List of Books I would like a list of all of the books in Calibre. Authors too if possible. Is there a way to do this in Calibre?

01-08-2021, 01:01 PM	#11
rracoon01 Connoisseur Posts: 88 Karma: 10 Join Date: Nov 2013 Device: android tablets	Calibredb List command output problem I just finally got caught up to the new python version updating to 9.0 today. I am now having trouble with the Calibredb list command performing differently than before. I you do a list on the command line the output looks just fine with a header line and then the single book qualified in the search argument. But if the output is redirected to a file or even if you view the output in a log file the book comes first and then the header line. This is screwing up a batch file of mine that directs the list output to a file and then parses the file with the batch command "for" to retrieve the id number of the book searched for. I have tried the --ascending option but no help there. This worked correctly in the pre Python 3 versions. calibredb list --search="title:Allen's eBook Shelf" --limit=1 >list.tmp type list.tmp 365 Allen's eBook Shelf Allen Williams id title authors

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hiding or deleting books in Paperwhite that are in the cloud list or "All" list	Acousticvillage	Amazon Kindle	6	02-19-2019 10:07 AM
List of bought books	brudigia	Kobo Reader	4	10-05-2016 08:54 PM
List of books	Magic-Ian	Library Management	11	04-22-2013 07:35 AM
Exporting a List of Books?	Cheezweasel	Calibre	2	01-05-2012 02:09 PM
Any here list books/eBooks on Google Books?	1611mac	Writers' Corner	6	12-20-2011 09:15 PM

09-08-2020, 04:16 PM	#3
theducks Well trained by Cats Posts: 29,804 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Right click the Convert Icon: Catalog: CSV (recognized by most spreadsheets) OR Use the CLI:calibredb -- )list (Go to the Calibre Help site fo Commandline Tools documentation

09-08-2020, 08:11 PM	#5
patetc Member Posts: 22 Karma: 10 Join Date: Jan 2012 Device: Kindle Fire	I was able to create a catalog but the options don't allow me to get it in the right format. For some reason the first author was "Woods" in spite of the fact that I wanted it alphabetical. Oh well, I'll try something else. Pat

09-09-2020, 04:21 AM	#9
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Because there is limited real estate for icons on the toolbar, there can be only so many in the default configuration.

01-08-2021, 07:40 PM	#12
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	https://github.com/kovidgoyal/calibr...9f1cbdf870074d

01-09-2021, 01:37 PM	#13
rracoon01 Connoisseur Posts: 88 Karma: 10 Join Date: Nov 2013 Device: android tablets	I have Calibre 9.0. But I use the command line interface to automate some tasks like rebuilding catalogs rather than having to do it by hand in the GUI. this has broken one of those batch files. Please advise.

01-09-2021, 01:59 PM	#14
georgemk Addict Posts: 234 Karma: 291844 Join Date: Oct 2019 Device: Kobo Nia	@rracoon01 Kovid's note means that a fix will appear in the next version released. It just missed out on v5.9.0 which was released on the 8th January. The release schedule is normally every 2 weeks.

01-09-2021, 08:07 PM	#15
DNSB Bibliophagist Posts: 35,428 Karma: 145525534 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos	@rracoon01: Also note the latest calibre release is 5.9.0 not 9.0.