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

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


Thread Tools Search this Thread
Old 12-29-2011, 05:47 PM   #1
captpete began at the beginning.
Posts: 17
Karma: 10
Join Date: Aug 2010
Location: Florida
Device: Ectaco jetBook Lite, Le Pan TC-970 Tablet, Samsung Galaxy Tab 2 7.0
Question Problem w/author adding iBook collection

I am trying to add an iBook (about a 1000 non-DRM EPUB) collection to Calibre. There are a couple of problems.

1) When I add the books using metadata I get the author as "ln, fn" in the author field (author is listed correctly as "ln, fn" in the author_sort field). I want "fn ln" in the author field. I can't add using the filename as a lot of them are truncated.

2) The series and series number are added as the first part of the title field, separated from the title by "- " (mostly, I can handle the odd ones manually). I want the series and series number to populate the series field correctly.

Here's an example of a filename:
"A Series of Unfortunate Events 1- The Ba - Snicket_ Lemony.epub"

and here's what it looks like in Calibre:
Title | Author | ... |Series
A Series of Unfortunate Events 1- The Bad Beginning | Snicket, Lemony | ... |{empty}|

Any possibilities of correctly adding these books? I am really not looking forward to editing 1000 books by hand [Grin]. I could deal with the series stuff as not all are part of a series but there are several hundreds of authors.
captpete is offline   Reply With Quote
Old 01-08-2012, 01:15 PM   #2
dog ear
lairdb began at the beginning.
Posts: 30
Karma: 12
Join Date: Jan 2012
Device: lots
All these can be solved using the edit metadata/in bulk/search and replace, and some careful work with regular expressions.

For example, "Lname, Fname" in the author field can be reversed with
search field: authors
search for: (.*), (.*)
replace with: \2 \1

Watch out for those occasional authors whose names genuinely contain commas, e.g. "Alexandre Dumas, pere".

A similar (but more complex) recipe can move the correct chunks out of the title into the series field, and then a second pass to fixup the title.
lairdb is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help with dictionary problem in iBook 1.2.2 thienphu91 Calibre 5 05-13-2011 04:28 PM
Adding a feed to a collection Lev667 Amazon Kindle 2 03-05-2011 10:14 PM
ibook on the iphone margin problem gandor62 Calibre 0 10-08-2010 11:41 PM
Adding existing collection of ebooks to calibre Chris_147 Calibre 2 09-30-2010 09:35 AM
6.11 problem with adding large book collection acekyoto Calibre 25 10-01-2009 01:25 PM

All times are GMT -4. The time now is 01:39 AM. is a privately owned, operated and funded community.