Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 08-08-2009, 12:00 PM   #1
chilady1
I devour books!
chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.
 
chilady1's Avatar
 
Posts: 772
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!
chilady1 is offline   Reply With Quote
Old 08-08-2009, 12:50 PM   #2
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 2,312
Karma: 5761596
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PRS-350, Nexus S, Galaxy S, Nook Color, iPhone4, iPT4, iPad 2012
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.
ilovejedd is offline   Reply With Quote
 
Advertisement
Old 08-08-2009, 01:05 PM   #3
chilady1
I devour books!
chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.
 
chilady1's Avatar
 
Posts: 772
Karma: 1285226
Join Date: Mar 2009
Device: iPad Air, Kindle 3/Kobo Aura HD, iPhone 6
Thanks!

Where do I type this?
chilady1 is offline   Reply With Quote
Old 08-08-2009, 01:10 PM   #4
chilady1
I devour books!
chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.chilady1 ought to be getting tired of karma fortunes by now.
 
chilady1's Avatar
 
Posts: 772
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.
chilady1 is offline   Reply With Quote
Old 08-08-2009, 01:36 PM   #5
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 2,312
Karma: 5761596
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PRS-350, Nexus S, Galaxy S, Nook Color, iPhone4, iPT4, iPad 2012
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.
ilovejedd is offline   Reply With Quote
Old 08-08-2009, 02:33 PM   #6
Leep
Guru
Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.Leep ought to be getting tired of karma fortunes by now.
 
Leep's Avatar
 
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
Leep is offline   Reply With Quote
Old 08-08-2009, 04:01 PM   #7
ilovejedd
hopeless n00b
ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.ilovejedd ought to be getting tired of karma fortunes by now.
 
ilovejedd's Avatar
 
Posts: 2,312
Karma: 5761596
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PRS-350, Nexus S, Galaxy S, Nook Color, iPhone4, iPT4, iPad 2012
Quote:
Originally Posted by Leep View Post
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.
ilovejedd is offline   Reply With Quote
Old 08-16-2009, 01:26 PM   #8
Naismith
Junior Member
Naismith began at the beginning.
 
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!
Naismith is offline   Reply With Quote
Old 08-16-2009, 01:33 PM   #9
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,436
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
--line-wdth
kovidgoyal is offline   Reply With Quote
Old 08-16-2009, 02:46 PM   #10
Naismith
Junior Member
Naismith began at the beginning.
 
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!
Naismith is offline   Reply With Quote
Old 09-19-2010, 02:06 PM   #11
Yyzguy
Member
Yyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of light
 
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?
Yyzguy is offline   Reply With Quote
Old 09-19-2010, 02:48 PM   #12
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by Yyzguy View Post
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.
Manichean is offline   Reply With Quote
Old 09-19-2010, 03:31 PM   #13
Yyzguy
Member
Yyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of lightYyzguy is a glorious beacon of light
 
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!
Yyzguy is offline   Reply With Quote
Old 01-31-2011, 03:30 AM   #14
kakkalla
Connoisseur
kakkalla doesn't litterkakkalla doesn't litter
 
kakkalla's Avatar
 
Posts: 89
Karma: 194
Join Date: Jun 2010
Location: Melbourne
Device: iPad
Quote:
Originally Posted by Naismith View Post
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.
kakkalla is offline   Reply With Quote
Old 01-31-2011, 04:22 AM   #15
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80520
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by kakkalla View Post
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?
Manichean is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 06:55 AM.


MobileRead.com is a privately owned, operated and funded community.