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 05-01-2011, 02:36 PM   #1
TdeV
Enthusiast
TdeV began at the beginning.
 
Posts: 41
Karma: 10
Join Date: Mar 2011
Device: Colour Nook, HP Touchpad
Possible to print a listing of books?

I would like to print out a list or partial list of the books in my calbre system. Is there any way to do this?
TdeV is offline   Reply With Quote
Old 05-01-2011, 03:12 PM   #2
user_none
Sigil & calibre developer
user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.user_none ought to be getting tired of karma fortunes by now.
 
user_none's Avatar
 
Posts: 2,433
Karma: 950001
Join Date: Jan 2009
Location: Florida, USA
Device: Nook STR
Look at the stickies in the catalogs sub forum.
user_none is offline   Reply With Quote
Old 05-01-2011, 04:20 PM   #3
TdeV
Enthusiast
TdeV began at the beginning.
 
Posts: 41
Karma: 10
Join Date: Mar 2011
Device: Colour Nook, HP Touchpad
I'm sorry, but I don't see how either of these two stickies have anything to do with printing the content of the library (to a real printer)
TdeV is offline   Reply With Quote
Old 05-01-2011, 04:28 PM   #4
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: 80446
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Moderator Notice
Moved to catalog forum.

Create a catalog in CSV format. Import to your favourite spreadsheet application (Excel, OO.org Calc, ...). Format to your liking and print.
Manichean is offline   Reply With Quote
Old 05-06-2011, 05:29 PM   #5
jangell2
Addict
jangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tongue
 
jangell2's Avatar
 
Posts: 212
Karma: 22222
Join Date: Aug 2010
Device: Kindle
There is a problem with the export catalog. There's no option to select the Title Sort Field just the Title field. Thus you get a whole bunch of books whose title all begin with "The.".

It's a nit I realize but I'd rather not have my listing sorted by "The".
jangell2 is offline   Reply With Quote
Old 05-06-2011, 05:51 PM   #6
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,770
Karma: 12516053
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by jangell2 View Post
There is a problem with the export catalog. There's no option to select the Title Sort Field just the Title field. Thus you get a whole bunch of books whose title all begin with "The.".

It's a nit I realize but I'd rather not have my listing sorted by "The".
My titles in my catalog do not use the A or The to sort. Check out the Preferences - Tweak area and choose the tweak that allows you to sort so a title like "The Client" sorts under C for Client and not T for The.

I am in the middle of a large conversion so I can't be more specific.
DoctorOhh is online now   Reply With Quote
Old 05-06-2011, 11:41 PM   #7
jangell2
Addict
jangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tongue
 
jangell2's Avatar
 
Posts: 212
Karma: 22222
Join Date: Aug 2010
Device: Kindle
Quote:
Originally Posted by dwanthny View Post
My titles in my catalog do not use the A or The to sort. Check out the Preferences - Tweak area and choose the tweak that allows you to sort so a title like "The Client" sorts under C for Client and not T for The.

I am in the middle of a large conversion so I can't be more specific.
I believe that tweak is "Control Sorting of Titles and series in the library display". I have not changed it and it is set to "library order." When I'm in calibre and looking at the library display, if I click on the Title column it will sort the titles like this: "Client, The". That's good, that's what I want.

I'm trying to create a list of books that are on my kindle. So I first click on the Title column, than I click on the Device Column. At the end of the list are all the titles on my kindle properly sorted. I select them and generate a catalog in csv format using only the title field.

When I open the csv file in excel, the Title field contains data like: "The Client". And the csv list is not in any order. So in excel I sort on the Title column and I end up with all books beginning with "The" together.

The problem is that when selecting what columns to use to create the CSV file, the "Title Sort" field is not offered. The catalog is created with titles containing leading "The's" and the like.
jangell2 is offline   Reply With Quote
Old 05-07-2011, 03:02 AM   #8
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,770
Karma: 12516053
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by jangell2 View Post
The problem is that when selecting what columns to use to create the CSV file, the "Title Sort" field is not offered. The catalog is created with titles containing leading "The's" and the like.
Good point my catalog is a ePub and the titles in the title list sort by title sort.
DoctorOhh is online now   Reply With Quote
Old 05-07-2011, 11:05 AM   #9
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 14,213
Karma: 5495470
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by dwanthny View Post
Good point my catalog is a ePub and the titles in the title list sort by title sort.
The Title_sort field is not available in the Commandline of "calibredb" either
theducks is offline   Reply With Quote
Old 05-07-2011, 11:19 AM   #10
jangell2
Addict
jangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tongue
 
jangell2's Avatar
 
Posts: 212
Karma: 22222
Join Date: Aug 2010
Device: Kindle
Quote:
Originally Posted by dwanthny View Post
Good point my catalog is a ePub and the titles in the title list sort by title sort.
I just took a peek at creating an epub catalog and the options or more extensive than for CSV. I wonder why the options are so restrictive for csv? Without the title sort field, you can't produce a true alpha sorted listing of books.

Oh well, the listing I got is good enough for my purposes.

Edit: Calibre is still one great piece of software. One of the most useful applications I have ever used.
jangell2 is offline   Reply With Quote
Old 05-07-2011, 01:13 PM   #11
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,497
Karma: 424627
Join Date: Mar 2009
Device: iPad
Patch submitted enabling output of title_sort in CSV/XML in both CLI and GUI, will be in next release.

G
GRiker is offline   Reply With Quote
Old 05-07-2011, 01:41 PM   #12
jangell2
Addict
jangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tongue
 
jangell2's Avatar
 
Posts: 212
Karma: 22222
Join Date: Aug 2010
Device: Kindle
Quote:
Originally Posted by GRiker View Post
Patch submitted enabling output of title_sort in CSV/XML in both CLI and GUI, will be in next release.

G
Excellent. That will be nice to have.
jangell2 is offline   Reply With Quote
Old 06-11-2011, 04:29 AM   #13
transmitthis
Addict
transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.transmitthis ought to be getting tired of karma fortunes by now.
 
transmitthis's Avatar
 
Posts: 285
Karma: 1003542
Join Date: May 2011
Device: Google Nexus 7 16GB
Quote:
Originally Posted by jangell2 View Post
There is a problem with the export catalog. There's no option to select the Title Sort Field just the Title field. Thus you get a whole bunch of books whose title all begin with "The.".

It's a nit I realize but I'd rather not have my listing sorted by "The".
Weird, as I specifically make sure all my titles are correct as the author intended, in the sortfield to, it would be just weird to not have the "the's and "A's" it wouldn't sound right in my head... lol.
Is this something you do with music albums too?, not being rude just intrested
transmitthis is offline   Reply With Quote
Old 06-17-2011, 10:12 AM   #14
jangell2
Addict
jangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tonguejangell2 can tie a knot in a cherry stem with his or her tongue
 
jangell2's Avatar
 
Posts: 212
Karma: 22222
Join Date: Aug 2010
Device: Kindle
Quote:
Originally Posted by transmitthis View Post
Weird, as I specifically make sure all my titles are correct as the author intended, in the sortfield to, it would be just weird to not have the "the's and "A's" it wouldn't sound right in my head... lol.
Is this something you do with music albums too?, not being rude just intrested
It's cool asking, and it's an example of how people think differently. It just makes sense to me not to sort by "the", at the very least. I think if you go to a library you will find Jeffery Deaver's "The Coffin Dancer" under "Coffin Dancer, The" or Arthur C. Clarke's "The Ghost from the Grand Banks" under "Ghost from the Grand Banks, The". A book store would be the same. If you're looking in the mystery section, do you really want to find all the "the's" bunched together?

However, I would expect to find Harper Lee's "To Kill a Mockingbird" filed just that way.
jangell2 is offline   Reply With Quote
Reply

Tags
printer

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre not listing books on Kindle 3 softshell Devices 1 03-13-2011 05:28 AM
print a list of my books? StickMaker Amazon Kindle 11 03-04-2011 10:34 AM
Listing books in Library anselmo Calibre 2 01-14-2010 09:03 AM
Print List of Books In Library? Jeff Gittens Sony Reader 4 10-25-2009 05:12 PM
Releasing Out of Print Books? KindleKid Reading Recommendations 6 12-05-2008 03:24 PM


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


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