Exportable E-book catalog

toomanybooks · 06-05-2009, 07:53 PM

Is there a way to export a list of your Calibre ebooks into word or excel to create a list of ebooks that you own by title and author?

I find myself redownloading ebooks all the time when I am at my computer w/o Calibre and would love to have a list that I can consult.

Sabardeyn · 06-05-2009, 08:44 PM

Okay, I cannot answer directly, but I know that calibre is (with some minor editing) portable and it doesn't actually require the books to be present in order to maintain a database. So... what does that mean?

I think it should be completely possible for you to create a copy of your library, install calibre, delete all of the books in the library. In that manner you effectively have a fully working copy of calibre and your library database on this other computer.

Try these links: Moving Ebooks... and Calibre Portable.

kovidgoyal · 06-05-2009, 09:26 PM

In a terminal run

calibredb list > books.txt

toomanybooks · 06-05-2009, 09:41 PM

Thank you. Now what is a terminal run?

wallcraft · 06-05-2009, 09:55 PM

Quote:

Originally Posted by toomanybooks

Now what is a terminal run?

Calibre has "command line" utilities as well as its GUI interface that you are familiar with. For how to open a command window (a terminal), see Command Prompt Vista/XP/Mac. The command kovidgoyal gave you isn't quite right (list, not --list). What I actually did under Windows XP is:

Code:

cd C:\Documents and Settings\alan\My Documents\My eBooks\Calibre
calibredb list > books.txt

Note that the calibredb command will run from anywhere, but the "cd" command put me in the directory I wanted (which will be different in your case, just copy it from the Adress bar of a standard file window and paste it after typing cd in a command window).

The list of ebooks will then be in books.txt.

toomanybooks · 06-05-2009, 10:19 PM

I am so not computer literate. When I run the full line cd.....books.txt, the terminal run won't work. When I run just calibredb list > books.txt, a black screen comes up and cycles through the titles, but I can't find the actual books.txt file after the black screen disappears. I tried searching for *.txt files and it didn't come up.

Sabardeyn · 06-06-2009, 02:54 AM

Toomanybooks,

Try using "cd C:\Documents and Settings\<username>\My Documents". You will need to change the <username> to whatever name you are using on that computer. If you don't have to sign onto that computer, you can find out the name by looking at the top of the Start Menu. Oh, don't use the brackets < > they are just a way to show that you need to fill in that part.

With that command you are setting the path to save the book list into the My Documents folder. So after typing the second command that is where the book list should be found.

sirbruce · 06-06-2009, 03:23 PM

Toomanybooks,

You need to first "run" the program "cmd", which will bring up a window. Then you use that window to type in the other commands people are telling you.

hannah · 06-07-2009, 11:04 AM

I finally understood how to run a command line

and now I have a beautiful list with all my books

Now I have to try and understand the other command line features from calibre

toomanybooks · 06-07-2009, 02:24 PM

I have made a list of my books. Thank you to everyone for all of your help.

CribQuilter · 06-18-2009, 09:04 PM

Ok I did this in March and got a pretty little list just great. I even wrote down how to do this on that list. Now that I have added more books to it I decided to do it again and now I am getting this terrible error code. I can see the file listed on my desktop, but it is blank. Can someone give me a clue as to what is going on?

C:\Users\xds2sw>calibredb list>books.txt
Traceback (most recent call last):
File "cli.py", line 553, in <module>
File "cli.py", line 550, in main
File "cli.py", line 228, in command_list
File "cli.py", line 125, in do_list
File "calibre\library\database2.pyo", line 1350, in get_data_as_dict
TypeError: %o format: a number is required, not unicode

kovidgoyal · 06-18-2009, 09:25 PM

That's a strange error. Wait a couple of weeks for calibre 0.6 and try it with that and if it still doesn't work, let me know.

CribQuilter · 06-18-2009, 09:31 PM

Thank you Kovidgoyal. I will wait. I am just glad to know I was not doing something wrong.

peaceridge · 06-19-2009, 08:26 AM

Works great. Is there any way of sorting it in title or author order instead of id order? I tried copying it into exel, but it didn't copy into columns.

peaceridge

kovidgoyal · 06-19-2009, 10:15 AM

calibredb list --help

06-05-2009, 07:53 PM	#1
toomanybooks Addict Posts: 302 Karma: 1039424 Join Date: Apr 2009 Device: Ipad, Ipod Touch, KIndle Fire	Exportable E-book catalog Is there a way to export a list of your Calibre ebooks into word or excel to create a list of ebooks that you own by title and author? I find myself redownloading ebooks all the time when I am at my computer w/o Calibre and would love to have a list that I can consult.

06-05-2009, 08:44 PM	#2
Sabardeyn Guru Posts: 644 Karma: 1242364 Join Date: May 2009 Location: The Right Coast Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)	Okay, I cannot answer directly, but I know that calibre is (with some minor editing) portable and it doesn't actually require the books to be present in order to maintain a database. So... what does that mean? I think it should be completely possible for you to create a copy of your library, install calibre, delete all of the books in the library. In that manner you effectively have a fully working copy of calibre and your library database on this other computer. Try these links: Moving Ebooks... and Calibre Portable. Last edited by Sabardeyn; 06-05-2009 at 08:47 PM. Reason: Added links.

06-05-2009, 09:26 PM	#3
kovidgoyal creator of calibre Posts: 43,971 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	In a terminal run calibredb list > books.txt Last edited by kovidgoyal; 06-05-2009 at 10:02 PM.

06-07-2009, 11:04 AM	#9
hannah Zealot Posts: 113 Karma: 1012700 Join Date: Jan 2009 Location: Belgium Device: Kobo H20, Bebook mini	I finally understood how to run a command line and now I have a beautiful list with all my books Now I have to try and understand the other command line features from calibre Last edited by hannah; 06-07-2009 at 11:05 AM. Reason: too many happy smiley faces ;-)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need Help with Book Catalog	swaneelee	Amazon Kindle	2	05-16-2010 11:46 AM
Smashwords Catalog	josepinto	EPUBReader	6	02-04-2010 01:41 PM
Thanks for book catalog 0.6.36 update!	theducks	Library Management	7	01-26-2010 05:06 PM
Thanks for book catalog 0.6.35 update!	poshm	Calibre	11	01-24-2010 12:14 PM
Book Catalog	Mitchll	Sony Reader	2	03-29-2007 11:21 AM

06-05-2009, 09:41 PM	#4
toomanybooks Addict Posts: 302 Karma: 1039424 Join Date: Apr 2009 Device: Ipad, Ipod Touch, KIndle Fire	Thank you. Now what is a terminal run?

06-05-2009, 10:19 PM	#6
toomanybooks Addict Posts: 302 Karma: 1039424 Join Date: Apr 2009 Device: Ipad, Ipod Touch, KIndle Fire	I am so not computer literate. When I run the full line cd.....books.txt, the terminal run won't work. When I run just calibredb list > books.txt, a black screen comes up and cycles through the titles, but I can't find the actual books.txt file after the black screen disappears. I tried searching for *.txt files and it didn't come up.

06-06-2009, 02:54 AM	#7
Sabardeyn Guru Posts: 644 Karma: 1242364 Join Date: May 2009 Location: The Right Coast Device: PC (Calibre), Nexus 7 2013 (Moon+ Pro), HTC HD2/Leo (Freda)	Toomanybooks, Try using "cd C:\Documents and Settings\<username>\My Documents". You will need to change the <username> to whatever name you are using on that computer. If you don't have to sign onto that computer, you can find out the name by looking at the top of the Start Menu. Oh, don't use the brackets < > they are just a way to show that you need to fill in that part. With that command you are setting the path to save the book list into the My Documents folder. So after typing the second command that is where the book list should be found.

06-06-2009, 03:23 PM	#8
sirbruce Provocateur Posts: 1,859 Karma: 505847 Join Date: Feb 2009 Location: Columbus, OH Device: Kindle Touch, Kindle 2, Kindle DX, iPhone 3GS	Toomanybooks, You need to first "run" the program "cmd", which will bring up a window. Then you use that window to type in the other commands people are telling you.

06-07-2009, 02:24 PM	#10
toomanybooks Addict Posts: 302 Karma: 1039424 Join Date: Apr 2009 Device: Ipad, Ipod Touch, KIndle Fire	I have made a list of my books. Thank you to everyone for all of your help.

06-18-2009, 09:04 PM	#11
CribQuilter Enthusiast Posts: 46 Karma: 306 Join Date: Dec 2008 Device: Sony PRS-505	Ok I did this in March and got a pretty little list just great. I even wrote down how to do this on that list. Now that I have added more books to it I decided to do it again and now I am getting this terrible error code. I can see the file listed on my desktop, but it is blank. Can someone give me a clue as to what is going on? C:\Users\xds2sw>calibredb list>books.txt Traceback (most recent call last): File "cli.py", line 553, in <module> File "cli.py", line 550, in main File "cli.py", line 228, in command_list File "cli.py", line 125, in do_list File "calibre\library\database2.pyo", line 1350, in get_data_as_dict TypeError: %o format: a number is required, not unicode

06-18-2009, 09:25 PM	#12
kovidgoyal creator of calibre Posts: 43,971 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	That's a strange error. Wait a couple of weeks for calibre 0.6 and try it with that and if it still doesn't work, let me know.

06-18-2009, 09:31 PM	#13
CribQuilter Enthusiast Posts: 46 Karma: 306 Join Date: Dec 2008 Device: Sony PRS-505	Thank you Kovidgoyal. I will wait. I am just glad to know I was not doing something wrong.

06-19-2009, 08:26 AM	#14
peaceridge Guru Posts: 995 Karma: 4407864 Join Date: Feb 2009 Location: North Carolina Device: Kobo Aura1, Nexus7.2, Galaxy Tab A 8.4, Ipad Air & Mini 6	Works great. Is there any way of sorting it in title or author order instead of id order? I tried copying it into exel, but it didn't copy into columns. peaceridge

06-19-2009, 10:15 AM	#15
kovidgoyal creator of calibre Posts: 43,971 Karma: 22669822 Join Date: Oct 2006 Location: Mumbai, India Device: Various	calibredb list --help

Advert

Advert