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 04-24-2010, 06:19 AM   #1
iceman00
Member
iceman00 began at the beginning.
 
Posts: 17
Karma: 10
Join Date: Mar 2010
Device: Ipad
File Path

Hello

Can anyone tell me whether you can add an extra column to Calibre?

In the interface menu there is clearly space to add more columns when needed. What I'm looking for is a column called Path which details where the book is located within the library folder e.g.

C:\\Users\Mike\My Documents\Library\BookName.pdf.

I would then be able to sort by this and remove the files I need to.

Any help would be appreciated.

Thanks
iceman00 is offline   Reply With Quote
Old 04-24-2010, 07:50 AM   #2
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,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
You cannot do this (at the moment at least).

However you should never be removing files manually from the Calibre library as then you will end up with a mismatch between the file system and the metadata database. Books should always be removed from Calibre using Calibre itself.
itimpi is offline   Reply With Quote
Old 04-24-2010, 08:12 AM   #3
iceman00
Member
iceman00 began at the beginning.
 
Posts: 17
Karma: 10
Join Date: Mar 2010
Device: Ipad
Oops. Too late. I've got some many duplicates I couldn't think of any other way to get rid of them.

Where is the metadata file? Is it one file? I thought the metadata for each book was stored within the book?

Maybe I need a little education if someone could help please?
iceman00 is offline   Reply With Quote
Old 04-24-2010, 09:45 AM   #4
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,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
There a file called metadata.db at the root of the Calibre Library folder. It hold the full metadata for each book. Individual books can hold the sub-set of metadata that is supported by a particular book format. The metadata database has pointers to the files stored within the Calibre library. If you delete book files manually then you end up with orphan entries in the Calibre database.

If you have duplicates then both copies will show up from the Calibre GUI. Removing books via the Calibre GUI will delete the files, but will also remove the relevant entries from the metadata database.

If you have already deleted book files, then I think if you use the option to run the Calibre database integrity check (from Preferences->Advanced) it might correct these orphan entries.
itimpi is offline   Reply With Quote
Old 04-24-2010, 10:53 AM   #5
iceman00
Member
iceman00 began at the beginning.
 
Posts: 17
Karma: 10
Join Date: Mar 2010
Device: Ipad
Thanks for that. I'll give the integrity check a try. Just out of curiosity can you open the metadata.db in a database program like Access? My DB is 20meg.

Thanks again
iceman00 is offline   Reply With Quote
Old 04-24-2010, 11:02 AM   #6
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by iceman00 View Post
Thanks for that. I'll give the integrity check a try. Just out of curiosity can you open the metadata.db in a database program like Access? My DB is 20meg.

Thanks again
It's SQL. You can open it in an SQL browser like SQLiteSpy. It's got triggers that connect to the Python code, so you can't (and shouldn't) change things, but you can do searches, etc.
Starson17 is offline   Reply With Quote
Old 04-24-2010, 04:35 PM   #7
iceman00
Member
iceman00 began at the beginning.
 
Posts: 17
Karma: 10
Join Date: Mar 2010
Device: Ipad
thanks I'll have a look, but won't change anything.
iceman00 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
Illegal character in path in ePub file Guido Henkel Calibre 2 05-27-2010 10:10 AM
DR1000 DR1000S: How to create file shortcuts using a full path? godel10 iRex 12 03-20-2010 12:12 AM
Save to Disk now saving file with full path? Mnementh Calibre 3 09-14-2009 01:24 AM
Greetings from THE DARK PATH Luke Romyn Introduce Yourself 5 03-10-2009 08:51 PM
Remove file path from PDF file DuckDodgers PDF 1 08-13-2006 09:23 AM


All times are GMT -4. The time now is 06:36 PM.


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