View Full Version : 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


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
At a command prompt


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
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
If you ran that command it should be in whatever current directory you were in.

BOb

Thank you.