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

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 09-27-2010, 02:17 AM   #1
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
metadata interfering with title

Hi all,

I have just started taming my ebook collection, and after adding many many books to calibre, i am now going over all the books and manually fixing those with no metadata. Generally its a speller/missing apostrophe causing it but sometimes it can be more stubborn.

First thing: When i get it to fetch metadata (often after giving it a isbn) it will change the title to include the series in brackets or following a colon. Is there any way to either prevent this or go through all entries and then remove the extra bit?

I find the easiest way to get all data on a book is to google (or amazon/isbndb) the isbn and then let calibre run with that to get all the info on the book. To emphasise - this is for books that calibre wouldn't do natively based on bad title/author/something.

Thanks!
commentator8 is offline   Reply With Quote
Old 09-27-2010, 02:45 AM   #2
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,737
Karma: 12488297
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by commentator8 View Post
First thing: When i get it to fetch metadata (often after giving it a isbn) it will change the title to include the series in brackets or following a colon. Is there any way to either prevent this or go through all entries and then remove the extra bit?
Go to Preferences - Behavior and Uncheck Overwrite author and title, see attached.
Attached Thumbnails
Click image for larger version

Name:	Preferencs-overwrite-author.jpg
Views:	57
Size:	41.3 KB
ID:	58899  
DoctorOhh is offline   Reply With Quote
Old 09-27-2010, 03:21 AM   #3
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
Thanks, did the trick.

Any ideas on the other two things (fixing already changed titles, isbn lookup from title, not opposite)?
commentator8 is offline   Reply With Quote
Old 09-27-2010, 04:29 AM   #4
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,737
Karma: 12488297
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by commentator8 View Post
fixing already changed titles
Now I'm confused. You mean besides manually editing the title in the edit metadata window or double clicking in the library list and changing the Title?

Quote:
Originally Posted by commentator8 View Post
isbn lookup from title, not opposite)?
I always use download metadata to get the isbn, rarely the other way around. If the ISBN you have doesn't retrieve the correct title, remove any ISBN in the edit metadata and fetch metadata based on title and author. Then select the returned metadata entry that suits you or your book. See attached.
Attached Thumbnails
Click image for larger version

Name:	remove_isbn.jpg
Views:	47
Size:	178.3 KB
ID:	58903   Click image for larger version

Name:	title_matches.jpg
Views:	47
Size:	169.8 KB
ID:	58904  

Last edited by DoctorOhh; 09-27-2010 at 04:31 AM.
DoctorOhh is offline   Reply With Quote
Old 09-27-2010, 04:51 AM   #5
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
Re the first point, i had already mangled quite a few names by doing a mass ctrl-d on my books. So i was wondering if there is the ability to fix this by playing with the raw data, or by some regex option to play with the fields.

Guess not. Although if you know where the database is stored (if it is in an accessible form) i may try and play with it like that.

As to point two, i have quite a few books that wont find metadata, and i hadn't really paid attention to the fact that they only now pick up the one book to update to because of the dodgy isbn that the first update gave them. So yes - if i delete it it inevitable gives me more options, and while a slow painful process, it gets there.

Thanks for the help.
commentator8 is offline   Reply With Quote
Old 09-27-2010, 04:57 AM   #6
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,737
Karma: 12488297
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by commentator8 View Post
Re the first point, i had already mangled quite a few names by doing a mass ctrl-d on my books. So i was wondering if there is the ability to fix this by playing with the raw data, or by some regex option to play with the fields.
If you select multiple books then go to the bulk edit metadata window there is a tab that allows for regex search and replace (use at your own risk). I'm not sure how this would help you but it is available and I thought I would point it out.
Attached Thumbnails
Click image for larger version

Name:	search and replace.jpg
Views:	48
Size:	150.5 KB
ID:	58905  
DoctorOhh is offline   Reply With Quote
Old 09-27-2010, 05:01 AM   #7
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
That looks promising. I was thinking of removing anything post colon or in brackets...

I'll let you know if it works.
commentator8 is offline   Reply With Quote
Old 09-27-2010, 06:01 AM   #8
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
I've found that these will work:
\(.+?\) - anything in brackets
(:+.+) - anything after :

Is there anyway to combine them (and make them safer - to any regex guys out there)?
commentator8 is offline   Reply With Quote
Old 09-27-2010, 06:23 AM   #9
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
There's an introduction into regular expressions that might help you.
Manichean is offline   Reply With Quote
Old 09-27-2010, 10:29 AM   #10
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
Quote:
Originally Posted by Manichean View Post
There's an introduction into regular expressions that might help you.
Great job there, its a world better than most of the stuff i found on the net (although there is still room for the regex testing grounds).

Thanks
commentator8 is offline   Reply With Quote
Old 09-27-2010, 10:42 AM   #11
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 commentator8 View Post
Great job there, its a world better than most of the stuff i found on the net (although there is still room for the regex testing grounds).
Thanks. But what do you mean by the parenthesised (sp?) remark?
Manichean is offline   Reply With Quote
Old 09-27-2010, 11:00 AM   #12
commentator8
Junior Member
commentator8 began at the beginning.
 
Posts: 9
Karma: 10
Join Date: Aug 2010
Device: nook
I was referring to sites like
http://rejex.heroku.com/
http://gskinner.com/RegExr/
which let you play around and see the results.
commentator8 is offline   Reply With Quote
Old 09-27-2010, 11:09 AM   #13
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
I see. I didn't include such sites on purpose, as Calibre has excellent testing facilities in all places that regexpes are used.
Manichean 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
Metadata in Title/filename mezme Calibre 0 08-18-2010 03:08 AM
Old title appearing in metadata Lexi Revellian Workshop 1 08-05-2010 08:52 AM
PDF Filenames vs Metadata Title clintbradford Calibre 0 07-12-2010 11:50 PM
Save template for title metadata? Bob Butler Calibre 10 03-15-2010 01:05 PM
Metadata extract from Title 507Tuli Calibre 14 05-29-2009 03:13 AM


All times are GMT -4. The time now is 05:10 AM.


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