Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-02-2022, 06:24 AM   #16
glenm
Member
glenm began at the beginning.
 
glenm's Avatar
 
Posts: 15
Karma: 10
Join Date: Jul 2011
Location: Adelaide Australia
Device: Windows
Finding Missing EBook files

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

Last edited by glenm; 02-02-2022 at 06:26 AM.
glenm is offline   Reply With Quote
Old 02-13-2022, 09:12 AM   #17
desbutes
Junior Member
desbutes began at the beginning.
 
Posts: 1
Karma: 10
Join Date: May 2014
Device: asus memopad 102a
hi,
Thanks for work but error 404 even with identification.
desbutes is offline   Reply With Quote
Advert
Old 02-13-2022, 04:39 PM   #18
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: 23,427
Karma: 105098357
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos
The only repository I see at https://github.com/glenm80/ is IconInfo.
DNSB is offline   Reply With Quote
Old 02-14-2022, 05:24 AM   #19
glenm
Member
glenm began at the beginning.
 
glenm's Avatar
 
Posts: 15
Karma: 10
Join Date: Jul 2011
Location: Adelaide Australia
Device: Windows
Quote:
Originally Posted by DNSB View Post
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
glenm is offline   Reply With Quote
Old 02-14-2022, 08:37 AM   #20
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,026
Karma: 71684510
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
Quote:
Originally Posted by glenm View Post
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
PeterT is offline   Reply With Quote
Advert
Old 09-23-2022, 09:54 AM   #21
matmp
Junior Member
matmp began at the beginning.
 
Posts: 1
Karma: 10
Join Date: Sep 2022
Device: Nook
Missing epub : solution in Calibre

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 !
matmp is offline   Reply With Quote
Old 09-23-2022, 11:38 AM   #22
Sirtel
Grand Sorcerer
Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.Sirtel ought to be getting tired of karma fortunes by now.
 
Sirtel's Avatar
 
Posts: 6,947
Karma: 206031614
Join Date: Jan 2014
Location: Estonia
Device: Kobo Sage & Libra 2
Quote:
Originally Posted by matmp View Post
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.
Sirtel is offline   Reply With Quote
Old 09-23-2022, 12:05 PM   #23
chaley
Grumpy old git
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
chaley's Avatar
 
Posts: 10,901
Karma: 4839799
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by matmp View Post
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])
Quote:
Originally Posted by Sirtel View Post
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.
Code:
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:
Code:
program:
	on_disk = list_re(formats_sizes(), ',', '^(.*):.*$', '\1');
	in_db = approximate_formats();
	list_equals(in_db, ',', on_disk, ',', 'OK', 'BAD')
with this template search:
Attached Thumbnails
Click image for larger version

Name:	Clipboard01.jpg
Views:	19
Size:	69.1 KB
ID:	196734  
chaley is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
find missing classes kcarscadden Editor 4 12-10-2019 09:16 PM
Find and remove un-indexed files from library folder eater Library Management 2 06-20-2019 12:31 PM
Library now missing all .mobi, pdf, epub files ChipAHoy Library Management 2 06-27-2017 07:36 PM
Can't Find Calibre News Files in Kindle Library Bobomo Devices 3 05-21-2016 01:04 AM
How to find books with missing metadata? kaufman Library Management 1 01-04-2014 01:32 AM


All times are GMT -4. The time now is 09:57 AM.


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