MobileRead Forums - View Single Post - Is renumbering the Calibre #bookid possible?

JohnnyBook · 10-18-2022, 10:18 PM

I have had my library of e-books in Calibre for almost 15 years. In that time I have have deleted many duplicate books entries, or merged entries in different formats, or deleted books I no longer keep in my library.

As a result, my library has (for example) 10,000 book entries, but is currently at #bookid number 15,000.

It really stood out to me recently when I added 8 books, that I did not realize were already in my Library. So I deleted them immediately, but when I added the next new book, the #bookid skipped the deleted book entries and incremented the #bookid past them.

i.e.
I added 8 books, entered library as #bookid 15,001-15,008.
Realized they were dups, and deleted them from Library,
Added a new book, its assigned #bookid 15,009, instead of 15,001.

The OCD in me would like to renumber all the entries in my library to remove the thousands of #bookid gaps.

Is this possible? Or do I just need to close my eyes when I look at that column.

10-18-2022, 10:18 PM	#1
JohnnyBook Addict Posts: 203 Karma: 126824 Join Date: Dec 2008 Location: Out There Device: K3 W/3G (Fixed screen!) & Paperwhite Wifi	Is renumbering the Calibre #bookid possible? I have had my library of e-books in Calibre for almost 15 years. In that time I have have deleted many duplicate books entries, or merged entries in different formats, or deleted books I no longer keep in my library. As a result, my library has (for example) 10,000 book entries, but is currently at #bookid number 15,000. It really stood out to me recently when I added 8 books, that I did not realize were already in my Library. So I deleted them immediately, but when I added the next new book, the #bookid skipped the deleted book entries and incremented the #bookid past them. i.e. I added 8 books, entered library as #bookid 15,001-15,008. Realized they were dups, and deleted them from Library, Added a new book, its assigned #bookid 15,009, instead of 15,001. The OCD in me would like to renumber all the entries in my library to remove the thousands of #bookid gaps. Is this possible? Or do I just need to close my eyes when I look at that column.