Managing the calibre database

[Student1]

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!

[kovidgoyal]

format:pdf and format:lrf

[Student1]

Originally Posted by kovidgoyal

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?

[kovidgoyal]

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

[Student1]

Originally Posted by kovidgoyal

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!!

[Xenophon]

Originally Posted by kovidgoyal

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

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

[kovidgoyal]

not format:lrf

no format

not format:lrf and not format:epub and so on

[Xenophon]

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

[kovidgoyal]

fixed.