![]() |
#1 |
Junior Member
![]() 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 ![]() |
![]() |
![]() |
![]() |
#2 |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 1,277
Karma: 6700678
Join Date: Sep 2021
Location: Australia
Device: Kobo Libra 2
|
See image below...
|
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 38,814
Karma: 153006036
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.
Last edited by DNSB; 08-26-2024 at 04:17 PM. |
![]() |
![]() |
![]() |
#4 | |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 20,829
Karma: 27620684
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
![]() |
![]() |
![]() |
#5 |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 38,814
Karma: 153006036
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.
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Junior Member
![]() Posts: 2
Karma: 10
Join Date: Aug 2024
Device: Kobo Libra Colour
|
Thank you!
Thank you this worked!!
![]() |
![]() |
![]() |
![]() |
|
![]() |
||||
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 05:48 AM |
How to delete entries for deleted sideloaded books? | jlemonde | Kobo Reader | 1 | 08-19-2019 08:01 PM |
actual epub file from ascm file through built in browser? | marp68 | Kobo Reader | 6 | 05-28-2016 08:26 AM |
Delete defective entries | OBoyle | Calibre | 8 | 03-04-2013 02:12 PM |
PRS-T1 How to delete database-entries ? | Schussel | Sony Reader | 3 | 09-08-2012 11:39 AM |