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 03-25-2009, 08:29 PM   #1
Student1
Groupie
Student1 doesn't litterStudent1 doesn't litter
 
Posts: 159
Karma: 170
Join Date: Feb 2009
Device: PRS-505
Managing the calibre database

Hi,

i'm trying to get some ideas on how to best do a full cleanup of my pdfs files.

Here is the problem :


I have many pdf's i want to replace with lrf files of the same title. Now not all pdf's will be replaced so i can't just do a search for all pdf and delete them.

What i need to do is find an easy way to search for all the lrf's i have in pdf format and delete them from the caliber db.

I thought creating a list of the titles by outputing the list of the directory to a .txt Then all i have to do is remove the .rlf portion of it and i have a full listing of all the titles in txt format.

Now is there a way to ask caliber to search for all those files now that i have a txt list of it. Or is there a way to import and remove the same title files from the db.

Any tips would be helpfull as it seems really too long to do by hand.

thanks!

Last edited by Student1; 03-25-2009 at 08:32 PM.
Student1 is offline   Reply With Quote
Old 03-25-2009, 09:13 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,422
Karma: 4961459
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Code:
format:pdf and format:lrf
kovidgoyal is offline   Reply With Quote
 
Enthusiast
Old 03-25-2009, 09:21 PM   #3
Student1
Groupie
Student1 doesn't litterStudent1 doesn't litter
 
Posts: 159
Karma: 170
Join Date: Feb 2009
Device: PRS-505
Quote:
Originally Posted by kovidgoyal View Post
Code:
format:pdf and format:lrf
Thanks but that would be perfect if both of these were already in the data base, the lrf have not yet been ported. So i have lets say 500 books in pdf inside the database and 1000 lrf i want to port in the db. Now a lot of the lrf have pdf equivalents in the db and i want to remove those pdfs... thats my main problem.

If i do import them will the lrf be included in the same dir as the pdf? And will then format:lrf format pdf be able to see both of them... hmm makes me think i could import and then sort it all out. What do you think?

Edit: or if not is the search for all books having 2 entries under the same title?

Last edited by Student1; 03-25-2009 at 09:24 PM.
Student1 is offline   Reply With Quote
Old 03-25-2009, 09:40 PM   #4
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,422
Karma: 4961459
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
calibre will create duplicate entries, so your best bet is to write a simple shell script to add the LRF files to the database using calibredb
kovidgoyal is offline   Reply With Quote
Old 03-25-2009, 09:53 PM   #5
Student1
Groupie
Student1 doesn't litterStudent1 doesn't litter
 
Posts: 159
Karma: 170
Join Date: Feb 2009
Device: PRS-505
Quote:
Originally Posted by kovidgoyal View Post
calibre will create duplicate entries, so your best bet is to write a simple shell script to add the LRF files to the database using calibredb
Yes now this seems like the way to go thanks!!
Student1 is offline   Reply With Quote
Old 03-28-2009, 08:33 PM   #6
Xenophon
curmudgeon
Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.
 
Xenophon's Avatar
 
Posts: 1,453
Karma: 5657812
Join Date: Jun 2006
Location: Pittsburgh, PA USA
Device: Kobo Aura (soon), (soon-to-be-ex)nook, (ex)PRS-700, (ex)PRS-500
Quote:
Originally Posted by kovidgoyal View Post
Code:
format:pdf and format:lrf
Way back in this thread, you posted this clue for finding books by format. How do I find all the books that do not have an lrf format available? Even more specifically, how do I find books with no formats available at all?

I tried putting
Code:
format:lrf
in the "but don't show entries that have any of these unwanted words" box in the advanced search dialogue, but to no avail. The result was all the files that DO have lrf format available.

This is an issue because 29 of the 900 books in my wife's library don't have LRF format available... and her reader is a prs500, which really prefers LRF.

Xenophon
Xenophon is offline   Reply With Quote
Old 03-28-2009, 08:40 PM   #7
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,422
Karma: 4961459
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
not format:lrf

no format

not format:lrf and not format:epub and so on
kovidgoyal is offline   Reply With Quote
Old 03-28-2009, 08:52 PM   #8
Xenophon
curmudgeon
Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.Xenophon ought to be getting tired of karma fortunes by now.
 
Xenophon's Avatar
 
Posts: 1,453
Karma: 5657812
Join Date: Jun 2006
Location: Pittsburgh, PA USA
Device: Kobo Aura (soon), (soon-to-be-ex)nook, (ex)PRS-700, (ex)PRS-500
Thanks!

I figured out the "not format:lrf" part shortly after posting, but was stumped by how to do "no format". Although it makes perfect sense when you point it out.

I believe, however, that the advanced search window has a small bug -- typing "format:lrf" in the exclude box and making no other entries should give the same result as searching for "not format:lrf" in the main search box. Instead, it gives the same result as searching for "format:lrf" <<<<note missing "not"!!!

Xenophon
Xenophon is offline   Reply With Quote
Old 03-28-2009, 09:06 PM   #9
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,422
Karma: 4961459
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
fixed.
kovidgoyal 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
Calibre and Kobo database crowez Calibre 1 10-15-2010 08:24 PM
PRS-300 Managing Collection using Calibre sakoni2001 Sony Reader 5 09-28-2010 01:21 PM
Calibre: Database question edembowski Calibre 23 01-26-2010 07:02 AM
Reference Database in Calibre? nnxbtz Calibre 5 09-27-2009 06:16 PM
Possible to get tags from the calibre database? GRiker Calibre 4 05-04-2009 02:30 PM


All times are GMT -4. The time now is 04:51 PM.


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