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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 05-13-2010, 04:08 PM   #1
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
How to Print?

Is there a way I can print (or create a PDF) a list of all the books I have in Calibre? It would be handy when I go on a used bookstore/thrift store raid to avoid buying duplicates or passing on a book I thought I had but didn't.

Last edited by Lady Fitzgerald; 05-13-2010 at 04:23 PM.
Lady Fitzgerald is offline   Reply With Quote
Old 05-13-2010, 04:25 PM   #2
troymc
Groupie
troymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enough
 
Posts: 161
Karma: 608
Join Date: Aug 2008
Location: Plano, TX
Device: Sony PRS-505 + B&N Nook + Motion LE1700 + Motorola Xoom Wifi
Click the dropdown arrow next to "Convert Ebooks" & select "Create catalog".

This will allow you to create a catalog of all books in your library.



Troy
troymc is offline   Reply With Quote
 
Enthusiast
Old 05-13-2010, 05:26 PM   #3
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Ok, I tried that. The file opened in Excel. Aside from the fact I couldn't figure out how to get the list to print in two columns per page (I created the list with author and title only) the list was only partially sorted by author. How do I fix that? It would also be nice if I could print two columns per page.
Lady Fitzgerald is offline   Reply With Quote
Old 05-13-2010, 05:42 PM   #4
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 4,716
Karma: 800144
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Lady Fitzgerald View Post
It would also be nice if I could print two columns per page.
Often I can make do with making the fonts larger and printing the document 2-up (and usually double-sided as well). Of course, your printing system must support that. Some printers support booklet format, which is often better suited.

Apologies if I am stating the obvious.
chaley is offline   Reply With Quote
Old 05-13-2010, 05:44 PM   #5
troymc
Groupie
troymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enoughtroymc will become famous soon enough
 
Posts: 161
Karma: 608
Join Date: Aug 2008
Location: Plano, TX
Device: Sony PRS-505 + B&N Nook + Motion LE1700 + Motorola Xoom Wifi
The list will be sorted by the book's internal Calibre ID. So that will probably be the order in which the books were added.

But you should be able to sort them anyway you want to in Excel. I think you should be able to click "Data -> Sort" and choose how you want them sorted.


Quote:
Originally Posted by Lady Fitzgerald View Post
I couldn't figure out how to get the list to print in two columns per page (I created the list with author and title only).
I'm not sure what you meant by this. If you mean you want two columns (title, author) per page and you're only getting one, then I think you have a page layout issue. Try clicking File -> Print Preview and then I think you can drag the blue lines to select how much you want to see on a page.

If you meant you want two sets of columns (tile, author, title, author) you will probably need to do that manually.


Troy
troymc is offline   Reply With Quote
Old 05-13-2010, 09:35 PM   #6
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
I've been fooling around with it and have worked out something that works even though it doesn't look great. But it doesn't have to just so long as it is functional (I keep telling myself; I can be so anal).

First, I created an XML file with author and title selected, then open the file with Excel 2007. Then I sorted the title and author columns (in that order), moved column A (title) to column D, Column B to Column C, then deleted columns A & C. That put the author column to the left of the title column (which I want), stablized the sorts, and got rid of the shading (the shading makes reading a bit harder when printed). I set the paper size to A3 and all the margins to 0, then set the print area. Then I was able to print the list as a booklet. Using the larger paper size, even though printing on 8 1/2 x 11, makes the print smaller and fills the page better. The only thing I can't figure out is how to keep the margins even from page to page. Sigh! At least the booklet meets my needs.

Last edited by Lady Fitzgerald; 05-14-2010 at 12:28 AM.
Lady Fitzgerald is offline   Reply With Quote
Old 05-13-2010, 10:03 PM   #7
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,201
Karma: 23680496
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Steps for 2 column printout in excel 2007 (calibre CSV catalogue)
  1. Delete columns C-O by clicking on C in top row and then holding shift key scroll over and click on O
  2. Right Click in selection and click delete
  3. Do same for last 4 columns(now D-G) and then first column A
  4. Click on the 1 by authors and delete row
  5. Click small box by A to select all (if you don't select all it will only sort one column and then everything is mixed up)
  6. Click data in top toolbar and then click sort
  7. Sort by column A

You should have a reasonable 2 column printout at this point.
Of course excel has all kinds of printing options as well so you can make it pretty if you wish
Hope this helps

Last edited by speakingtohe; 05-13-2010 at 10:06 PM.
speakingtohe is offline   Reply With Quote
Old 05-14-2010, 12:53 AM   #8
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Hi, Speakingtohe! I tried what you suggested and not only did everything go horribly wrong, Excel and printer just sat there and laughed at me. Thanks anyway.

I did some more fooling around (get your minds out of the gutter; at my age, the only action I get any more is when the prunes kick in) and found that converting the Excel file from the Acrobat tab then printing worked out much better. These are the revised steps:

1. Save Library (author, not author sort, and title only) as an XML file.
2. Open the XML in Excel (2007). There will be three columns: A (title), B (sort), C (author).
3. Sort columns A & C, in that order.
4. Delete column B.
5. Select and drag column A to column D.
6. Select and drag column B to column C.
7. Delete columns A & B.
8. Set page size to 11" X 17".
9. Set left margin to 0.7" and rest to 0".
10. Drag columns to correct width.
11. Set print area.
12. Click on Adobe tab.
13. Click on Create PDF.
14. Click on Convert to PDF in pop-up.
15. Click on Yes in next pop-up.
16. In the next pop-up, fill in file name and destination, then click on Save.
17. Click on Save again in the next pop-up.
18. Print booklet from Adobe.

All of the inside margins are now the same. The outside margin is a bit wide but the booklet would need trimming anyway after stapling so that isn't a problem. Once trimmed, all margins will be even.

This seems like a lot of steps, but it goes faster than it looks. I won't be doing this very often anyway.
Lady Fitzgerald is offline   Reply With Quote
Old 05-14-2010, 02:55 AM   #9
speakingtohe
Wizard
speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.speakingtohe ought to be getting tired of karma fortunes by now.
 
Posts: 4,201
Karma: 23680496
Join Date: Apr 2010
Device: sony PRS-T1 and T3, Kobo Mini and Aura HD, Tablet
Too funny
speakingtohe is offline   Reply With Quote
Old 05-14-2010, 11:49 AM   #10
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,589
Karma: 12369683
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by Lady Fitzgerald View Post
I did some more fooling around (get your minds out of the gutter; at my age, the only action I get any more is when the prunes kick in)
MMmmm... prunes!

Last edited by DoctorOhh; 05-14-2010 at 11:51 AM.
DoctorOhh is offline   Reply With Quote
Old 05-14-2010, 03:58 PM   #11
Lady Fitzgerald
Wizard
Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.Lady Fitzgerald ought to be getting tired of karma fortunes by now.
 
Lady Fitzgerald's Avatar
 
Posts: 2,013
Karma: 251649
Join Date: Apr 2010
Location: Tempe, AZ, USA, Earth
Device: JetBook Lite (away from home) + 1 spare, 32" TV (at home)
Btw, thank you, Troy, for setting me on my convoluted path to what I needed. And thanks to Chaly for the booklet idea.
Lady Fitzgerald 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
Print vs Pixel: retailers experiment with print/ebook bundles DMcCunney General Discussions 42 09-15-2010 11:29 AM
Print to PDF homerj EPUBReader 3 02-15-2010 06:08 PM
How can I print an Epub jimjam ePub 4 11-27-2009 11:41 AM
iTunes for print? mores News 15 10-07-2009 11:11 AM
Print to LRF shivster01 Sony Reader 9 12-03-2007 12:39 AM


All times are GMT -4. The time now is 01:26 AM.


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