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 08-14-2008, 02:19 PM   #1
Banintz
Junior Member
Banintz began at the beginning.
 
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
Banintz is offline   Reply With Quote
Old 08-14-2008, 02:24 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 25,908
Karma: 5035037
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
kovidgoyal is offline   Reply With Quote
 
Enthusiast
Old 08-14-2008, 02:32 PM   #3
Banintz
Junior Member
Banintz began at the beginning.
 
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
Banintz is offline   Reply With Quote
Old 11-08-2008, 10:31 AM   #4
Elnino
Junior Member
Elnino began at the beginning.
 
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.
Elnino is offline   Reply With Quote
Old 11-08-2008, 11:43 AM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 25,908
Karma: 5035037
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
--fields series,series_index
kovidgoyal is offline   Reply With Quote
Old 11-09-2008, 05:56 AM   #6
Elnino
Junior Member
Elnino began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Jul 2008
Device: Sony PRS-505
Thanks mate for the prompt response.
Elnino is offline   Reply With Quote
Old 12-14-2008, 02:22 PM   #7
wolfelric
Junior Member
wolfelric began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2008
Device: sony reader 505
Isbn

How would you export isbn's
Thanks
wolfelric is offline   Reply With Quote
Old 12-14-2008, 05:37 PM   #8
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 25,908
Karma: 5035037
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
calibredb list --help
kovidgoyal is offline   Reply With Quote
Old 12-18-2008, 10:03 AM   #9
daesdaemar
Addict
daesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura about
 
Posts: 210
Karma: 4282
Join Date: Oct 2008
Location: Florida
Device: Sony 505, Kindle 3, iPad 3
Quote:
Originally Posted by kovidgoyal View Post
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.
daesdaemar is offline   Reply With Quote
Old 12-18-2008, 10:39 AM   #10
pilotbob
Grand Sorcerer
pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.
 
pilotbob's Avatar
 
Posts: 19,555
Karma: 11337367
Join Date: Jan 2007
Location: Tampa, FL USA
Device: Kindle Touch
Quote:
Originally Posted by daesdaemar View Post
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
pilotbob is offline   Reply With Quote
Old 12-18-2008, 10:44 AM   #11
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,051
Karma: 777825
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).
itimpi is offline   Reply With Quote
Old 12-18-2008, 11:29 AM   #12
daesdaemar
Addict
daesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura aboutdaesdaemar has a spectacular aura about
 
Posts: 210
Karma: 4282
Join Date: Oct 2008
Location: Florida
Device: Sony 505, Kindle 3, iPad 3
Quote:
Originally Posted by pilotbob View Post
If you ran that command it should be in whatever current directory you were in.

BOb
Thank you.
daesdaemar 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
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


All times are GMT -4. The time now is 03:38 PM.


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