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: