Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-24-2011, 07:53 AM   #1
Feanor
Member
Feanor began at the beginning.
 
Posts: 10
Karma: 10
Join Date: Jan 2011
Device: Kindle 3
Question Series in Title

I own a Kindle 3, and used a metadata plugboard to add the series and number to the title on the Kindle, in the format Series - [00] - Title, when adding from Calibre.

I recently had a HDD failure and lost my calibre install - being left with the books on the Kindle from which to recover. I have connected the Kindle and added the books from there to the library on a fresh install of Calibre, but all the books are added with the titles being as above, and with the series and number fields unpopulated.

Is there a way to extract this information from the title field (removing it in the process) and add it to the series and number fields in a bulk fashion?

Any advice is greatly appreciated - I would rather not have to do this by hand on 100s of books. I am also well aware that in future I should back up my Calibre install elsewhere.

Last edited by Feanor; 05-24-2011 at 08:05 AM. Reason: Clarification
Feanor is offline   Reply With Quote
Old 05-24-2011, 01:28 PM   #2
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80446
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
In the bulk edit metadata screen, there's a search & replace option. What you want is possible using the regular expression search mode. You'll need to do two passes: In the first one, place 'series_name [index]' in the series field. This will set the series_name and series_index of the books. In the second, remove everything you don't want from the title field.
There's a tutorial on regular expressions available, should you need it.
Manichean is offline   Reply With Quote
Old 05-24-2011, 02:53 PM   #3
Feanor
Member
Feanor began at the beginning.
 
Posts: 10
Karma: 10
Join Date: Jan 2011
Device: Kindle 3
That's great - I've read the guide on Regular Expressions too (which, by the way, is very well written), but I still can't quite get it to work.

Choosing Search Mode = Regular expression
Choosing Search Field = Title
Inputting series_name [index] in the search for field
Leaving replace with blank
Choosing Destination Field = series

Results in the series field being populated with the whole title as it is (Series [index] - Title), and not setting the series number field.

I must be being a bit dim, but where am I going wrong?

Thank you for your help.
Feanor is offline   Reply With Quote
Old 05-25-2011, 02:14 AM   #4
Manichean
Wizard
Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!Manichean My eyes! My eyes! The light is just too bright!
 
Manichean's Avatar
 
Posts: 3,130
Karma: 80446
Join Date: Feb 2008
Location: Germany
Device: Cybook Gen3
Quote:
Originally Posted by Feanor View Post
Inputting series_name [index] in the search for field
Leaving replace with blank
Choosing Destination Field = series
This won't work for several reasons:
  1. You'll need to input a regular expression into the search field. While, of course, the string you gave is a regular expression, it doesn't do what you think it does- that would imply Calibre understanding the semantics of what the fields contain, which it doesn't. I'll try to work out an example later, I don't have the time now, but for the moment, as a hint: You'll want to use backreferences and use the dashes as delimiting characters.
  2. Replacing with a blank text effectively deletes the information from the field. This is what you want to do for the second pass. In the first pass, you'll want to fill the series field with some information. See backreferences above
Manichean is offline   Reply With Quote
Old 08-15-2012, 08:45 AM   #5
Rob557
Enthusiast
Rob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-booksRob557 has learned how to read e-books
 
Posts: 45
Karma: 810
Join Date: Jul 2012
Device: Kobo
Quote:
Originally Posted by Feanor View Post
... I still can't quite get it to work. ...
I had come across this unresolved posting, as one of the few postings on this issue, when trying to resolve the same issue of removing the series info from the title. The following link identifies a new thread that provides an effective alternative where theducks helped me resolve the problem by instead taking a pragmatic structural approach: http://www.mobileread.com/forums/sho...d.php?t=187951
Rob557 is offline   Reply With Quote
Old 08-15-2012, 09:25 AM   #6
theducks
Grand Sorcerer
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: 14,281
Karma: 5495472
Join Date: Aug 2009
Location: The (original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by Rob557 View Post
I had come across this unresolved posting, as one of the few postings on this issue, when trying to resolve the same issue of removing the series info from the title. The following link identifies a new thread that provides an effective alternative where theducks helped me resolve the problem by instead taking a pragmatic structural approach: http://www.mobileread.com/forums/sho...d.php?t=187951
Manichean is the one who managed to beat REGEX understanding in to my thick skull
theducks is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Epub series in Title problem Fuzzyluzzi Library Management 4 03-20-2011 12:20 PM
Series Number in Book title (Kindle) cityzen Library Management 7 03-20-2011 12:11 AM
Adding Series and Number to Title. Cerepol Calibre 17 09-01-2010 06:50 PM
Save to Disk altering Title and Series RichieTheK Calibre 9 08-21-2010 05:19 PM
series data in the title capelord Calibre 2 12-13-2009 11:23 AM


All times are GMT -4. The time now is 05:54 PM.


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