How to clean empty records with only .opf

Paulz · 09-09-2019, 12:54 PM

I have lot of records in my calibre database that have only .opf files an nothing else. I have two questions.

1.How can i search for these records. I tried format:false or formats=false but it doesn't work.
2. What is the reason that caused this so i can avoid this in future ?

Thanks

theducks · 09-09-2019, 02:17 PM

Run Library Maintenance (Right click the Library icon)
Once that is done. formats:false should work

As to why?
That is what is called an 'Empty Book' . Many of us use that feature (add books: empty book: <qty>) to document: 1)paper versions (only) 2)wishlist

If yours was NOT that reason, then someone or something is:
1) going into the Library/Author folder and deleting the format
2)You have merged (copied) different libraries onto each other
3)You have the Library folder on a NAS or Share and or 2 users running calibre at the same time

Paulz · 09-09-2019, 08:00 PM

Thanks that worked fine after i restored the database.

09-09-2019, 12:54 PM	#1
Paulz Junior Member Posts: 5 Karma: 10 Join Date: Aug 2014 Device: Calibre	How to clean empty records with only .opf I have lot of records in my calibre database that have only .opf files an nothing else. I have two questions. 1.How can i search for these records. I tried format:false or formats=false but it doesn't work. 2. What is the reason that caused this so i can avoid this in future ? Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OPF dictionary - "spine is empty" error	encol	Conversion	1	06-22-2017 07:48 AM
Import Empty books as records only	Book Horder	Calibre Companion	2	05-25-2017 01:44 AM
Change opf filename from content.opf to title.opf	northstar7	Sigil	3	09-23-2013 12:44 PM
Short Fiction Martinez, Brian: A Good Clean, A Harsh Clean. v1. 13th Dec 2010	BrianMartinez	Kindle Books	0	12-13-2010 09:25 PM
Short Fiction Martinez, Brian: A Good Clean, A Harsh Clean. v1. 13th Dec 2010	BrianMartinez	ePub Books	0	12-13-2010 09:23 PM

09-09-2019, 02:17 PM	#2
theducks Well trained by Cats Posts: 29,804 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Run Library Maintenance (Right click the Library icon) Once that is done. formats:false should work As to why? That is what is called an 'Empty Book' . Many of us use that feature (add books: empty book: <qty>) to document: 1)paper versions (only) 2)wishlist If yours was NOT that reason, then someone or something is: 1) going into the Library/Author folder and deleting the format 2)You have merged (copied) different libraries onto each other 3)You have the Library folder on a NAS or Share and or 2 users running calibre at the same time

09-09-2019, 08:00 PM	#3
Paulz Junior Member Posts: 5 Karma: 10 Join Date: Aug 2014 Device: Calibre	Thanks that worked fine after i restored the database.