lost a column

catsm · 03-03-2021, 09:19 AM

how can I use calibre.db to get back a lost not-custom column? I had 6000+ books with page numbers entered,,,help,,,,

theducks · 03-03-2021, 09:56 AM

Page numbers would be a Custom Column as it is not a Calibre standard.
2 ways to do it (If you did not Delete it)

1) right-click any column TITLE: Show Column: <choose from list>
2)Preferences: Add your own columns: <put a tick in the right place. Use the green arrowheads to re-order as desired>

catsm · 03-03-2021, 10:14 AM

I think I deleted it... no fix, right?

theducks · 03-03-2021, 11:22 AM

Quote:

Originally Posted by catsm

I think I deleted it... no fix, right?

Not unless you forced embedded the metadata into all the books.
Polish, Modify EPUB or embed.

Backup before you make big changes. Do NOT try and restore just the DB from a backup if you have made any other changes, includig: adding more books. You will create (DB) orphans

JSWolf · 03-03-2021, 12:59 PM

The column might not be gone. You could have hidden it by mistake.

theducks · 03-03-2021, 03:06 PM

Quote:

Originally Posted by JSWolf

The column might not be gone. You could have hidden it by mistake.

The instructions I furnished would have shown that (no tick or show)

catsm · 03-03-2021, 06:10 PM

Found a time consuming fix by thinking through data. i will use calibre to find opf files for authors I know I've read - do searcch to group them, open file on book, pick opf because metadata lists missing column, say ignore all, ok, and 4 clicks and there is the missing column! thanks, your hint on hidden column put my mind working.

davidfor · 03-03-2021, 06:12 PM

@catsm: By "page numbers", do you the number of pages in the book? And if so, how did you populate them?

If it is the page count, then the Page Count plugin can calculate from the books. Or it can download the counts from a couple of different places. It will take time, but, it might be the only way.

theducks · 03-03-2021, 08:24 PM

The MDE can get metadata (from book) and update what is there.
The downside is IF you did not update the book, some or all the metadata may replace otherwise GOOD (Library) metadata.

03-03-2021, 09:19 AM	#1
catsm Junior Member Posts: 3 Karma: 10 Join Date: Mar 2021 Device: none	lost a column how can I use calibre.db to get back a lost not-custom column? I had 6000+ books with page numbers entered,,,help,,,,

03-03-2021, 06:10 PM	#7
catsm Junior Member Posts: 3 Karma: 10 Join Date: Mar 2021 Device: none	missing column fix Found a time consuming fix by thinking through data. i will use calibre to find opf files for authors I know I've read - do searcch to group them, open file on book, pick opf because metadata lists missing column, say ignore all, ok, and 4 clicks and there is the missing column! thanks, your hint on hidden column put my mind working.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Have lost the column for Formats in library view	beckyt	Library Management	3	11-05-2015 10:17 AM
Lost all my Column icon settings	BetterRed	Calibre	2	10-16-2013 03:08 AM
Using "Build column from other column" custom-column type	HFC3	Library Management	3	07-07-2013 03:11 AM
Lost my book details column	jlonghurst	Calibre	5	04-20-2013 05:29 AM
Q: multi-column PDF to single column mobi format converstion	auburn1975	Calibre	7	01-28-2012 06:11 PM

03-03-2021, 09:56 AM	#2
theducks Well trained by Cats Posts: 30,938 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Page numbers would be a Custom Column as it is not a Calibre standard. 2 ways to do it (If you did not Delete it) 1) right-click any column TITLE: Show Column: <choose from list> 2)Preferences: Add your own columns: <put a tick in the right place. Use the green arrowheads to re-order as desired>

03-03-2021, 10:14 AM	#3
catsm Junior Member Posts: 3 Karma: 10 Join Date: Mar 2021 Device: none	I think I deleted it... no fix, right?

03-03-2021, 12:59 PM	#5
JSWolf Resident Curmudgeon Posts: 79,398 Karma: 145491800 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	The column might not be gone. You could have hidden it by mistake.

03-03-2021, 06:12 PM	#8
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	@catsm: By "page numbers", do you the number of pages in the book? And if so, how did you populate them? If it is the page count, then the Page Count plugin can calculate from the books. Or it can download the counts from a couple of different places. It will take time, but, it might be the only way.

03-03-2021, 08:24 PM	#9
theducks Well trained by Cats Posts: 30,938 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	The MDE can get metadata (from book) and update what is there. The downside is IF you did not update the book, some or all the metadata may replace otherwise GOOD (Library) metadata.