MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page Restoring custom columns from opf metadata?

Notices

Reply
 
Thread Tools Search this Thread
Old 08-13-2016, 09:39 PM   #1
moredrowsy
Connoisseur
moredrowsy began at the beginning.
 
Posts: 69
Karma: 10
Join Date: Aug 2016
Device: Kindle Paperwhite 3
Restoring custom columns from opf metadata?
Is there a way to restore the custom column data from the metadata opf files? I know that calibre edits the opf file when changing column data.

I had a column of "Date Read" for my books that I sync with goodreads but I accidentally deleted the Date Read column when I was messing with the column preferences (yikes).

So is there a way to tell calibre to restore the data or is all the data deleted from the opf files when I deleted the custom column?
Last edited by moredrowsy; 08-13-2016 at 09:56 PM.
moredrowsy is offline   Reply With Quote
Old 08-13-2016, 09:55 PM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,957
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by moredrowsy View Post
Is there a way to restore the custom column data from the metadata opf files? I know that calibre edits the opf file when changing column data.

I had a column of "Date Read" for my books that I sync with goodreads but I accidentally deleted the Date Read column when I was messing with the column preferences (yikes).

So is there a way to tell calibre to restore the data?
The problem is:
When you deleted the column, calibre set the 'Dirty Flag' on all the records and queued them in the Library Backup (status). That starts the background task of updating (~3 per sec) that OPF
theducks is offline   Reply With Quote
Advert
Old 08-13-2016, 09:57 PM   #3
moredrowsy
Connoisseur
moredrowsy began at the beginning.
 
Posts: 69
Karma: 10
Join Date: Aug 2016
Device: Kindle Paperwhite 3
Well, damn. That sucks. I guess I'll just have to recreate the column and enter it again. Sighs
moredrowsy is offline   Reply With Quote
Old 08-13-2016, 10:30 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,677
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
@moredrowsyIf you don't have a backup then maybe your OS might have something - e.g. the Windows Restore previous versions, if its enabled, of the metadata.opf files - could be tricky though.

First thing I suggest you do is to get a backup/restore process in place, if you use a process that does incremental backups that should encourage you to use it frequently - like daily.

BR
BetterRed is offline   Reply With Quote
Old 08-14-2016, 12:53 AM   #5
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
@moredrowsy: If the dates are good on Goodreads, you can export the list as a CSV. Then you can use the Import List plugin to import the details and add the read date to each book.
davidfor is offline   Reply With Quote
Advert
Old 08-14-2016, 04:01 AM   #6
moredrowsy
Connoisseur
moredrowsy began at the beginning.
 
Posts: 69
Karma: 10
Join Date: Aug 2016
Device: Kindle Paperwhite 3
Thanks for the replies guys, and especially to davidfor. I forgot about the goodreads sync. That did the job.
moredrowsy is offline   Reply With Quote
Old 08-14-2016, 04:41 AM   #7
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
@moredrowsy: Glad that I helped. But, I'm embarrassed to say I didn't even think of using Goodreads Sync!
davidfor is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
importing metadata into custom columns taleia Library Management 4 10-03-2023 05:56 AM
a curiosity about custom columns and opf ZioNemo Calibre 4 01-30-2014 07:31 AM
Custom Columns and metadata.calibre cryzed Library Management 0 06-04-2013 06:00 PM
Custom columns to call up metadata from epub's opf? eosrose Library Management 1 03-21-2013 04:33 AM
Metadata and custom columns dbolack Development 9 03-05-2012 09:07 AM


All times are GMT -4. The time now is 03:22 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

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