MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page How? Delete db entries without actual book file

Notices

Reply
 
Thread Tools Search this Thread
Old 08-26-2024, 04:33 PM   #1
Fidelis1970
Junior Member
Fidelis1970 began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Aug 2024
Device: Kobo Libra Colour
How? Delete db entries without actual book file
Hello,

How can I automatically delete all Calibre db entries for which I have metadata, a cover but no actual book file?

Before asking the question here:

(1) I saw this but do not know how to actually do it: Delete empty books -> Search: formats:false -> Select all -> Remove books

(2) I saw what looks like a command line but have no idea how and where to do this: https://gist.github.com/EnigmaCurry/728652

(3) I searched here in this forum but might be using wrong keywords... Can't believe I'm the only one with this issue...

(4) and yes I have read the FAQ before asking here

(5) I even tried working with ChatGPT to build me a Python script (I'm not a programmer) and the resulting script erased all my book folders intead of just book folders without book files

Hence I'm here... Thanks for your help
Fidelis1970 is offline   Reply With Quote
Old 08-26-2024, 04:40 PM   #2
Karellen
Wizard
Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.Karellen ought to be getting tired of karma fortunes by now.
 
Karellen's Avatar
 
Posts: 1,362
Karma: 6794938
Join Date: Sep 2021
Location: Australia
Device: Kobo Libra 2
Quote:
Originally Posted by Fidelis1970 View Post
(1) I saw this but do not know how to actually do it: Delete empty books -> Search: formats:false -> Select all -> Remove books
See image below...
Attached Thumbnails
Click image for larger version Name: formatsfalse.jpg Views: 61 Size: 312.7 KB ID: 210417  
Karellen is online now   Reply With Quote
Advert
Old 08-26-2024, 05:15 PM   #3
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 40,599
Karma: 157444382
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
In the calibre search bar, type 'formats:false' without the quotes. This will return a list of all books without a valid book format in the database when you click on Search. If you see Filter between Search and Saved Searches, click on it to change to Highlight so only the selected books will be shown. Then select all the books shown and delete them.
Attached Thumbnails
Click image for larger version Name: Screenshot 2024-08-26 131223.png Views: 39 Size: 30.2 KB ID: 210418  
Last edited by DNSB; 08-26-2024 at 05:17 PM.
DNSB is offline   Reply With Quote
Old 08-26-2024, 06:20 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,006
Karma: 27620706
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by DNSB View Post
In the calibre search bar, type 'formats:false' without the quotes. This will return a list of all books without a valid book format in the database when you click on Search. If you see Filter between Search and Saved Searches, click on it to change to Highlight so only the selected books will be shown. Then select all the books shown and delete them.
That button will only be seen in the Search bar if the "Show a quick toggle button to switch between highlighting and restricting results next to the Search bar" is checked in Preferences->Searching… the default is unchecked.

BR
BetterRed is offline   Reply With Quote
Old 08-26-2024, 06:29 PM   #5
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 40,599
Karma: 157444382
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Been so long since I checked that option, that I had forgotten that it could be unchecked.
DNSB is offline   Reply With Quote
Advert
Old 08-28-2024, 12:47 PM   #6
Fidelis1970
Junior Member
Fidelis1970 began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Aug 2024
Device: Kobo Libra Colour
Thank you!
Thank you this worked!! ))
Fidelis1970 is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display the actual file storage path of the current ePub book? lysakowski Calibre 6 11-10-2022 06:48 AM
How to delete entries for deleted sideloaded books? jlemonde Kobo Reader 1 08-19-2019 09:01 PM
actual epub file from ascm file through built in browser? marp68 Kobo Reader 6 05-28-2016 09:26 AM
Delete defective entries OBoyle Calibre 8 03-04-2013 03:12 PM
PRS-T1 How to delete database-entries ? Schussel Sony Reader 3 09-08-2012 12:39 PM


All times are GMT -4. The time now is 08:46 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

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