Retrieving custom column after reinstall?

tools44 · 03-07-2011, 09:03 PM

ok, sorry if this has been covered; 1st post and I've searched the forums and haven't seen an answer.

i recently had to do clean reinstall of OS, and subsequently calibre. i was able to successfully import my collection w/metadata, however the custom column i had created is missing.

i "assume" the info i entered in the column is in the metadata still. i have over 1200 books in there, so it's definitely not something i would want to redo.

is there a way to retrieve the original structure with custom columns on a reinstall? the only thing i can think of is that maybe i had to 'save to disk' at some point and that might save the structure somewhere?

please advise. thanks.

kovidgoyal · 03-07-2011, 09:04 PM

See http://calibre-ebook.com/user_manual...ter-to-another

tools44 · 03-07-2011, 09:17 PM

thanks for your quick response.

yes, i've seen that before (i looked there before posting). that's actually how i restored my database in the first place.

however, there is no database integrity check button on my calibre (latest version). only 'debug device detection' and 'open calibre configuration directory'. i'm not sure if that is the missing ingredient that i need to fix this, but it's not there where you show it in the FAQs.

theducks · 03-07-2011, 09:21 PM

Quote:

Originally Posted by tools44

thanks for your quick response.

yes, i've seen that before (i looked there before posting). that's actually how i restored my database in the first place.

however, there is no database integrity check button on my calibre (latest version). only 'debug device detection' and 'open calibre configuration directory'. i'm not sure if that is the missing ingredient that i need to fix this, but it's not there where you show it in the FAQs.

It Moved (and got Better)

It is now on the little arrow on the 'library' icon

kovidgoyal · 03-07-2011, 09:24 PM

You probably just need to unhide the column. Right click on the column headers to unhide hidden columns.

tools44 · 03-07-2011, 09:45 PM

theducks: yep, saw that too. ran both 'check library' and 'restore database'. nothing.

kovidgoyal: tried that as well. there is no unhide hidden column selection. there IS if i choose to hide a column first. even if i go to 'add your own columns'. the column that i created prior isn't showing again.

so i go back to my original theory: would i have had to save the 'layout', if you will, at some point, with my custom column?

kovidgoyal · 03-07-2011, 09:52 PM

custom column information is stored in the database. If you correctly migrated the database as outlined in the link I posted before, the custom columns *will* still be there.

tools44 · 03-07-2011, 10:45 PM

ahhh. got it to work finally. i believe, since my calibre library was on a d: drive (in case i needed to do a clean reinstall, which i did) that after i made the switch i moved a copy of that library to an additional drive for redundancy, and then restored the database off of the copy. not sure why that wouldn't have worked, since it kept everything else. but once i added the original library back in the column was restored.

03-07-2011, 09:03 PM	#1
tools44 Member Posts: 11 Karma: 10 Join Date: Mar 2011 Device: kindle 3rd gen	Retrieving custom column after reinstall? ok, sorry if this has been covered; 1st post and I've searched the forums and haven't seen an answer. i recently had to do clean reinstall of OS, and subsequently calibre. i was able to successfully import my collection w/metadata, however the custom column i had created is missing. i "assume" the info i entered in the column is in the metadata still. i have over 1200 books in there, so it's definitely not something i would want to redo. is there a way to retrieve the original structure with custom columns on a reinstall? the only thing i can think of is that maybe i had to 'save to disk' at some point and that might save the structure somewhere? please advise. thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can custom book data be displayed in a custom column?	kiwidude	Development	9	03-02-2011 05:35 AM
Need help with this custom Column.	Rie142	Library Management	2	02-20-2011 09:51 AM
Custom Column Format	aceflor	Calibre	5	12-10-2010 10:28 AM
custom column i need a little help	shinken	Calibre	3	09-15-2010 03:41 AM
custom column not searchable	SkyDream	Calibre	5	07-26-2010 05:38 AM

03-07-2011, 09:04 PM	#2
kovidgoyal creator of calibre Posts: 45,304 Karma: 27111242 Join Date: Oct 2006 Location: Mumbai, India Device: Various	See http://calibre-ebook.com/user_manual...ter-to-another

03-07-2011, 09:17 PM	#3
tools44 Member Posts: 11 Karma: 10 Join Date: Mar 2011 Device: kindle 3rd gen	thanks for your quick response. yes, i've seen that before (i looked there before posting). that's actually how i restored my database in the first place. however, there is no database integrity check button on my calibre (latest version). only 'debug device detection' and 'open calibre configuration directory'. i'm not sure if that is the missing ingredient that i need to fix this, but it's not there where you show it in the FAQs.

03-07-2011, 09:24 PM	#5
kovidgoyal creator of calibre Posts: 45,304 Karma: 27111242 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You probably just need to unhide the column. Right click on the column headers to unhide hidden columns.

03-07-2011, 09:45 PM	#6
tools44 Member Posts: 11 Karma: 10 Join Date: Mar 2011 Device: kindle 3rd gen	theducks: yep, saw that too. ran both 'check library' and 'restore database'. nothing. kovidgoyal: tried that as well. there is no unhide hidden column selection. there IS if i choose to hide a column first. even if i go to 'add your own columns'. the column that i created prior isn't showing again. so i go back to my original theory: would i have had to save the 'layout', if you will, at some point, with my custom column?

03-07-2011, 09:52 PM	#7
kovidgoyal creator of calibre Posts: 45,304 Karma: 27111242 Join Date: Oct 2006 Location: Mumbai, India Device: Various	custom column information is stored in the database. If you correctly migrated the database as outlined in the link I posted before, the custom columns will still be there.

03-07-2011, 10:45 PM	#8
tools44 Member Posts: 11 Karma: 10 Join Date: Mar 2011 Device: kindle 3rd gen	ahhh. got it to work finally. i believe, since my calibre library was on a d: drive (in case i needed to do a clean reinstall, which i did) that after i made the switch i moved a copy of that library to an additional drive for redundancy, and then restored the database off of the copy. not sure why that wouldn't have worked, since it kept everything else. but once i added the original library back in the column was restored.

Advert

Advert