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 04-08-2011, 11:00 AM   #1
MWIL
Junior Member
MWIL began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Jan 2010
Device: Kindle 2
Export a list of books for printing or a spreadsheet?

Is there a way to get Calibre to export a list of my book. I'd love to be able to export it...or at least just print a list.
MWIL is offline   Reply With Quote
Old 04-08-2011, 11:07 AM   #2
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,848
Karma: 5654321
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by MWIL View Post
Is there a way to get Calibre to export a list of my book. I'd love to be able to export it...or at least just print a list.
CSV is one of the Catalog output options
The little arrow on the Convert Icon.
Make your settings there, then proceed.

Other option is the command line tools: calibredb --list
I will leave the RTFM exercise to you if you choose that way (easy if you do CL stuff)
theducks is offline   Reply With Quote
Old 04-08-2011, 11:23 AM   #3
MWIL
Junior Member
MWIL began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Jan 2010
Device: Kindle 2
Thanks! That did it. Much appreciated.
MWIL is offline   Reply With Quote
Old 10-13-2011, 09:13 AM   #4
Noughty
Addict
Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.Noughty is cognizant of many things which escape those who dream only by night.
 
Posts: 352
Karma: 103850
Join Date: Apr 2011
Device: Kindle NT
I wanted to ask about the same, but I would like to separate columns. I know how to do it only with copying data to txt file and opening it in excel and then separating columns.
I tried using comma and quotes as separator but the problem is with first column.
If I choose " I get first column with a comma at the end which I clearly don't need.
If I choose comma I get a complete mess since the first values aren't in quotes and they do have a few values in them separated by comma so they all end up in separate columns.

So how to make csv file which is easily spread into neat columns? Is it possible to force it to add quotes to ALL columns including first one?

Or maybe it possible to choose columns order. Now it adds it alphabetically which makes complete mess again if you choose tags, title, author, series, formats. You end up with title at the end etc. I could choose first the column which wouldn't cause any problems being without quotes.

As a final resort I am thinking of making a bunch of new columns to add quotes to all values but I already have way too many columns... And this looks a little extreme.

SOLVED: I managed to make a column which gives the spreadsheet if I create catalog (csv) from only that one column. Took me awhile to create the template but it works great since I have one neat column in result already correctly formated and can print it, copy it in word or any other program etc.

Last edited by Noughty; 10-14-2011 at 02:54 AM. Reason: solved
Noughty 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
Printing List of Books on my Kobo Beak Library Management 6 02-26-2011 11:02 AM
Printing a list of books Dottiejk Library Management 1 02-08-2011 12:25 PM
Spreadsheet from file list? Catlady General Discussions 16 02-08-2011 04:38 AM
List printing Linda Sony Reader 6 05-28-2008 06:17 PM
Printing the library list of books 505 Cyndall Sony Reader 4 01-18-2008 10:58 AM


All times are GMT -4. The time now is 12:43 PM.


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