[Old Thread] Can you print out your Calibre catalog?

chilady1 · 08-08-2009, 11:00 AM

First, sorry if this question has been posed before, sometimes it is hard to search for questions already asked. Hopefully someone can provide me an answer: can you print a list of your Calibre catalog?

Is there some command that prints all of my books out? Thanks in advance for answers!

ilovejedd · 08-08-2009, 11:50 AM

The command line calibredb.exe will do that.
Type:
calibredb.exe list --help
in an MS-DOS/terminal/shell window to get a list of options.

chilady1 · 08-08-2009, 12:05 PM

Where do I type this?

chilady1 · 08-08-2009, 12:10 PM

Sorry, I didn't see command prompt. Did that and there is no command for printing.

ilovejedd · 08-08-2009, 12:36 PM

You mean send to printer? You can do:
calibredb list>>filename.txt

It will output the list into a text file which you can then print from Notepad or Word. It's also possible to import the text file into Excel.

Leep · 08-08-2009, 01:33 PM

If you want a really useful list that you can sort, etc. you open your text file with Excel and parse the information into columns. I use this format to add information on paper books that I have read since Calibre only catalogs ebooks.

cheers

ilovejedd · 08-08-2009, 03:01 PM

Quote:

Originally Posted by Leep

I use this format to add information on paper books that I have read since Calibre only catalogs ebooks.

Not anymore. There's now an option in Calibre 0.6 to add an empty ebook. I'm currently using it as placeholder for paperbooks I'm scanning and OCR'ing.

Naismith · 08-16-2009, 12:26 PM

Hi all,

is there a way to choose the column width? For most of the entries, the authors field seems to need a second row because of a long name or a second author. Even when I import the file into Excel, it would be hard to "repair" this.

calibredb list --fields title,authors,series,rating,publisher --sort-by=authors --separator=; > database.txt

looks like

...
4 ;1634: The Baltic War ;Eric Flint & ;Ring of Fire ;2 ;Baen ;
; ;David Weber ; ; ; ;
346;An oblique approach ;Eric Flint & ;Belisarius ;0 ;Baen ;
; ;David Drake ; ; ; ;
76 ;In the Heart of Darkness ;Eric Flint & ;Belisarius ;0 ;Baen ;
; ;David Drake ; ; ; ;
...

Any suggestions? Thank you!

kovidgoyal · 08-16-2009, 12:33 PM

--line-wdth

Naismith · 08-16-2009, 01:46 PM

Thank you!

calibredb list --fields title,authors,series,series_index,rating --sort-by=authors --separator=; --line-width=500 --ascending > calibre_database.txt

works for me!

Yyzguy · 09-19-2010, 01:06 PM

When I try to do this (I type calibredb list), all I get is one line that says: id title authors

Can someone help me?

Manichean · 09-19-2010, 01:48 PM

Quote:

Originally Posted by Yyzguy

When I try to do this (I type calibredb list), all I get is one line that says: id title authors

Can someone help me?

Works fine here. You do actually have books in your library, do you? Also, which version of Calibre are you using?

You've managed to dig up a thread that's more than a year old, as well. The information here is quite out of date. Nowadays you can just create a CSV catalog of your library (see the dropdown of the conversion button in the main toolbar), import that in Excel or OpenOffice Calc and print that.

Yyzguy · 09-19-2010, 02:31 PM

I am using the latest version. I hunted around in the program for that kind of function but I obviously missed it. Thanks!

kakkalla · 01-31-2011, 02:30 AM

Quote:

Originally Posted by Naismith

Thank you!

calibredb list --fields title,authors,series,series_index,rating --sort-by=authors --separator=; --line-width=500 --ascending > calibre_database.txt

works for me!

What if I wanted a tab as the separator? I don't know how to enter a tab in Terminal after the --separator= command.

Thank you.

Manichean · 01-31-2011, 03:22 AM

Quote:

Originally Posted by kakkalla

What if I wanted a tab as the separator? I don't know how to enter a tab in Terminal after the --separator= command.

Thank you.

Did you try just to, you know, enter a tab?

08-08-2009, 11:00 AM	#1
chilady1 I devour books! Posts: 789 Karma: 1285226 Join Date: Mar 2009 Device: iPad Air, Kindle 3/Kobo Aura HD, iPhone 6	[Old Thread] Can you print out your Calibre catalog? First, sorry if this question has been posed before, sometimes it is hard to search for questions already asked. Hopefully someone can provide me an answer: can you print a list of your Calibre catalog? Is there some command that prints all of my books out? Thanks in advance for answers!

08-08-2009, 12:05 PM	#3
chilady1 I devour books! Posts: 789 Karma: 1285226 Join Date: Mar 2009 Device: iPad Air, Kindle 3/Kobo Aura HD, iPhone 6	Thanks! Where do I type this?

08-16-2009, 01:46 PM	#10
Naismith Junior Member Posts: 3 Karma: 10 Join Date: Aug 2009 Device: BeBook	thank you Thank you! calibredb list --fields title,authors,series,series_index,rating --sort-by=authors --separator=; --line-width=500 --ascending > calibre_database.txt works for me!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Calibre to catalog journal articles?	RobinB	Calibre	6	08-12-2017 07:42 PM
Calibre catalog format	skipray	Library Management	1	02-17-2011 01:10 AM
Calibre as Catalog?	jekkii	Library Management	11	01-08-2011 12:15 PM
Problem with Catalog in Calibre	clockmaker	Library Management	1	10-05-2010 06:27 AM
Classic Trook Catalog and Calibre	jhempel24	Nook Developer's Corner	2	09-06-2010 11:56 PM

08-08-2009, 11:50 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 command line calibredb.exe will do that. Type: calibredb.exe list --help in an MS-DOS/terminal/shell window to get a list of options.

08-08-2009, 12:10 PM	#4
chilady1 I devour books! Posts: 789 Karma: 1285226 Join Date: Mar 2009 Device: iPad Air, Kindle 3/Kobo Aura HD, iPhone 6	Sorry, I didn't see command prompt. Did that and there is no command for printing.

08-08-2009, 12:36 PM	#5
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	You mean send to printer? You can do: calibredb list>>filename.txt It will output the list into a text file which you can then print from Notepad or Word. It's also possible to import the text file into Excel.

08-08-2009, 01:33 PM	#6
Leep Guru Posts: 739 Karma: 1018859 Join Date: Jun 2008 Location: Near Seattle Device: kindle1, K3, K3G (thanks MR), iTouch, Kindle Touch	If you want a really useful list that you can sort, etc. you open your text file with Excel and parse the information into columns. I use this format to add information on paper books that I have read since Calibre only catalogs ebooks. cheers

08-16-2009, 12:26 PM	#8
Naismith Junior Member Posts: 3 Karma: 10 Join Date: Aug 2009 Device: BeBook	Hi all, is there a way to choose the column width? For most of the entries, the authors field seems to need a second row because of a long name or a second author. Even when I import the file into Excel, it would be hard to "repair" this. calibredb list --fields title,authors,series,rating,publisher --sort-by=authors --separator=; > database.txt looks like ... 4 ;1634: The Baltic War ;Eric Flint & ;Ring of Fire ;2 ;Baen ; ; ;David Weber ; ; ; ; 346;An oblique approach ;Eric Flint & ;Belisarius ;0 ;Baen ; ; ;David Drake ; ; ; ; 76 ;In the Heart of Darkness ;Eric Flint & ;Belisarius ;0 ;Baen ; ; ;David Drake ; ; ; ; ... Any suggestions? Thank you!

08-16-2009, 12:33 PM	#9
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	--line-wdth

09-19-2010, 01:06 PM	#11
Yyzguy Member Posts: 11 Karma: 12028 Join Date: May 2010 Device: iPad	When I try to do this (I type calibredb list), all I get is one line that says: id title authors Can someone help me?

09-19-2010, 02:31 PM	#13
Yyzguy Member Posts: 11 Karma: 12028 Join Date: May 2010 Device: iPad	I am using the latest version. I hunted around in the program for that kind of function but I obviously missed it. Thanks!