How do I find out what files are missing from the library

[glenm]

I've written a small utility in C# that will analyze a Caliber Library and list all the books that are in the Caliber metadata database but do not exist on disc.

The source can be found here - https://github.com/glenm80/CaliberMissing

It's written in C# using Visual Studio 2022 Community and the only dependency is on SQLite Core which is obtained from NuGet

The list of books can be exported to a text/csv by Right Clicking the list and exporting the data.

I will put a more comprehensive post in the Related Tools area of this forum.

Edit: Corrected spelling

[desbutes]

hi,
Thanks for work but error 404 even with identification.

[DNSB]

The only repository I see at https://github.com/glenm80/ is IconInfo.

[glenm]

Originally Posted by DNSB

The only repository I see at https://github.com/glenm80/ is IconInfo.

My error, the repository was private - it's now public and you should be able to see it

[PeterT]

Originally Posted by glenm

I've written a small utility in C# that will analyze a Caliber Library and list all the books that are in the Caliber metadata database but do not exist on disc.

The source can be found here - https://github.com/glenm80/CaliberMissing

It's written in C# using Visual Studio 2022 Community and the only dependency is on SQLite Core which is obtained from NuGet

The list of books can be exported to a text/csv by Right Clicking the list and exporting the data.

I will put a more comprehensive post in the Related Tools area of this forum.

Edit: Corrected spelling

FYI. It's calibre NOT caliber

[matmp]

Create a custom column
(find in : [URL=https://www.reddit.com/r/Calibre/comments/s48dzy/how_to_find_entries_that_dont_have_actual_files/[/URL])

Open "Preference" in Calibre, then "create custom column"
Choose "quick start" then "format"

Rename title like "Have Book" (as you want !)
Column type : let by default
Show checkmarks
Description : "Epub exist or miss"
Template model : {#formats:test(yes,no)}
Replace "Text" by "Yes/No"

Ok
Apply
Restart Calibre

You'll see in that new column if the book (epub) exist or miss !

[Sirtel]

Originally Posted by matmp

Create a custom column
(find in : [URL=https://www.reddit.com/r/Calibre/comments/s48dzy/how_to_find_entries_that_dont_have_actual_files/[/URL])

Open "Preference" in Calibre, then "create custom column"
Choose "quick start" then "format"

Rename title like "Have Book" (as you want !)
Column type : let by default
Show checkmarks
Description : "Epub exist or miss"
Template model : {#formats:test(yes,no)}
Replace "Text" by "Yes/No"

Ok
Apply
Restart Calibre

You'll see in that new column if the book (epub) exist or miss !

This does not find the missing formats Calibre doesn't know about, e.g. in the case of database corruption or errors in the library.

[chaley]

Originally Posted by matmp

Create a custom column
(find in : [URL=https://www.reddit.com/r/Calibre/comments/s48dzy/how_to_find_entries_that_dont_have_actual_files/[/URL])

Originally Posted by Sirtel

This does not find the missing formats Calibre doesn't know about, e.g. in the case of database corruption or errors in the library.

Although I can't see why one would want such a column, this template does tell you if formats exist in the database but not on the disk and is appropriate for a custom column. Its performance isn't ideal.

program:
	on_disk = list_re(formats_sizes(), ',', '^(.*):.*$', '\1');
	in_db = approximate_formats();
	list_equals(in_db, ',', on_disk, ',', 'OK', 'Missing some of ' & in_db)

Assuming for some reason I don't want to use Check library, I would use a variant of the above template in a template search. That way I pay the performance penalty only when I want to. This template would work:

program:
	on_disk = list_re(formats_sizes(), ',', '^(.*):.*$', '\1');
	in_db = approximate_formats();
	list_equals(in_db, ',', on_disk, ',', 'OK', 'BAD')

with this template search:

[dwilliamhouston]

There is another way this can happen and now trying to figure out how/why. If you click on a book and then do a Remove book of specific format you can delete all books and it leaves the book with no actual book in it. So is there a way to find out all book records that don't have any book formats associated with it? Also, is this a bug or by design? Thanks.

[Sirtel]

Originally Posted by dwilliamhouston

There is another way this can happen and now trying to figure out how/why. If you click on a book and then do a Remove book of specific format you can delete all books and it leaves the book with no actual book in it. So is there a way to find out all book records that don't have any book formats associated with it? Also, is this a bug or by design? Thanks.

Type formats:false in the search bar. And yes, this is by design.

[theducks]

Remove book: specific format does not check (nor is it supposed to) if it is the ONLY format for that book

I cringe when I hear folk who use some of the built in tools IN BULK without considering all the possibilities.

formats: false will find books that have none (that are registered in the DB). This may be valid depending... I use 'empty book' as a wish list and to document my paperback collection.

[dwilliamhouston]

Thanks.

[Sirtel]

Originally Posted by theducks

formats: false will find books that have none (that are registered in the DB). This may be valid depending... I use 'empty book' as a wish list and to document my paperback collection.

I have a few old ebooks where formatting was so bad that I just deleted the formats, but left the book record. As fixing them would have taken several hours or even days, I just couldn't be bothered, and I would never have read such a mess. Some were later released in newer, properly formatted editions, but not all, and presumably will never be (usually because their publisher has since ceased to exist).