How to export database info, not files ?

Banintz · 08-14-2008, 02:19 PM

Hi,

I want to export the info of my calibre database of books to another software, say excel or just a text file. I only want the info of the main calibre page, just the title of book, writer, size and collection not the files.

Usually I would do just a selection of all books, copy and paste on excel but I cant do that on calibre. What is the easiest way to get that info?

Thanks on advance

kovidgoyal · 08-14-2008, 02:24 PM

At a command prompt

Code:

calibredb list --fields title,authors,series,rating,publisher > database.txt

The file database.txt will contain all that data

Banintz · 08-14-2008, 02:32 PM

Thx a lot for you very good software and your REALLY fast answer.

PD: Clearly we are in Olimpic time

Elnino · 11-08-2008, 10:31 AM

How would I get the series book number to appear also?

Thanks in advance.

kovidgoyal · 11-08-2008, 11:43 AM

--fields series,series_index

Elnino · 11-09-2008, 05:56 AM

Thanks mate for the prompt response.

wolfelric · 12-14-2008, 02:22 PM

How would you export isbn's
Thanks

kovidgoyal · 12-14-2008, 05:37 PM

calibredb list --help

daesdaemar · 12-18-2008, 10:03 AM

Quote:

Originally Posted by kovidgoyal

At a command prompt

Code:

calibredb list --fields title,authors,series,rating,publisher > database.txt

The file database.txt will contain all that data

Sorry for the stupid question: where is the database.txt file? I can't find it.

pilotbob · 12-18-2008, 10:39 AM

Quote:

Originally Posted by daesdaemar

Sorry for the stupid question: where is the database.txt file? I can't find it.

If you ran that command it should be in whatever current directory you were in.

BOb

itimpi · 12-18-2008, 10:44 AM

The command given will generate the database.txt file. The '>' part of the command redirects output to the file following it (creating it).

daesdaemar · 12-18-2008, 11:29 AM

Quote:

Originally Posted by pilotbob

If you ran that command it should be in whatever current directory you were in.

BOb

Thank you.

08-14-2008, 02:19 PM	#1
Banintz Junior Member Posts: 8 Karma: 10 Join Date: Aug 2008 Device: Sony 505	How to export database info, not files ? Hi, I want to export the info of my calibre database of books to another software, say excel or just a text file. I only want the info of the main calibre page, just the title of book, writer, size and collection not the files. Usually I would do just a selection of all books, copy and paste on excel but I cant do that on calibre. What is the easiest way to get that info? Thanks on advance

08-14-2008, 02:24 PM	#2
kovidgoyal creator of calibre Posts: 43,853 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	At a command prompt Code: calibredb list --fields title,authors,series,rating,publisher > database.txt The file database.txt will contain all that data

12-14-2008, 02:22 PM	#7
wolfelric Junior Member Posts: 5 Karma: 10 Join Date: Dec 2008 Device: sony reader 505	Isbn How would you export isbn's Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to export metadata and rename files?	argonaut	Calibre	11	06-24-2010 08:30 AM
How to keep author and title info when dragging-and-dropping RTF files	alexmobile	Sony Reader	2	10-19-2009 04:57 PM
Editing title/author info on lit files	bones_708	Reading and Management	8	01-31-2008 12:09 PM
Warning: accessing CF card through iLiad export can corrupt files	nekokami	iRex	0	11-28-2007 08:09 PM
Duplicate database files	Zach	Reading and Management	2	05-31-2005 05:47 AM

08-14-2008, 02:32 PM	#3
Banintz Junior Member Posts: 8 Karma: 10 Join Date: Aug 2008 Device: Sony 505	Thx a lot for you very good software and your REALLY fast answer. PD: Clearly we are in Olimpic time

11-08-2008, 10:31 AM	#4
Elnino Junior Member Posts: 8 Karma: 10 Join Date: Jul 2008 Device: Sony PRS-505	How would I get the series book number to appear also? Thanks in advance.

11-08-2008, 11:43 AM	#5
kovidgoyal creator of calibre Posts: 43,853 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	--fields series,series_index

11-09-2008, 05:56 AM	#6
Elnino Junior Member Posts: 8 Karma: 10 Join Date: Jul 2008 Device: Sony PRS-505	Thanks mate for the prompt response.

12-14-2008, 05:37 PM	#8
kovidgoyal creator of calibre Posts: 43,853 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	calibredb list --help

12-18-2008, 10:44 AM	#11
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	The command given will generate the database.txt file. The '>' part of the command redirects output to the file following it (creating it).