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-29-2012, 04:33 PM   #1
rpresser
Junior Member
rpresser has learned how to buy an e-book online
 
Posts: 9
Karma: 84
Join Date: Mar 2008
Device: Ebookwise1150, Treo 600
Question Bulk author correction

I have about a hundred books in the catalog with multiple authors separated by semicolons. e.g. "Larry Niven; Jean Marie Stine". I want to correct these to ampersands; e.g. "Larry Niven & Jean Marie Stine". I can do them one by one in the GUI, obviously. And it appears that if I fiddle with it I can do it to the file itself with ebook-metadata.exe . But is there a way to do it to the database AND the metadata simultaneously, the way the GUI will?
rpresser is offline   Reply With Quote
Old 05-29-2012, 04:35 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,312
Karma: 5382313
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
calibredb.exe set_metadata

or search replace metadata in the bulk metadata edit dialog in the gui.
kovidgoyal is online now   Reply With Quote
Old 05-29-2012, 04:49 PM   #3
rpresser
Junior Member
rpresser has learned how to buy an e-book online
 
Posts: 9
Karma: 84
Join Date: Mar 2008
Device: Ebookwise1150, Treo 600
calibredb.exe set metadata will require me to have a complete OPF file ready; not just changing the author.

search-replace tab looks like what I want. Thanks.
rpresser is offline   Reply With Quote
Old 05-29-2012, 06:52 PM   #4
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: 15,054
Karma: 5936659
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by rpresser View Post
I have about a hundred books in the catalog with multiple authors separated by semicolons. e.g. "Larry Niven; Jean Marie Stine". I want to correct these to ampersands; e.g. "Larry Niven & Jean Marie Stine". I can do them one by one in the GUI, obviously. And it appears that if I fiddle with it I can do it to the file itself with ebook-metadata.exe . But is there a way to do it to the database AND the metadata simultaneously, the way the GUI will?
How many Different combinations?
Open the Tag Browser (wide-ish )

click once (book display)
(Be careful)
now Rigkt-click on thee name (in the Tag Browser): Select rename: Ctrl-C (copy): tap the ESC key
Now select All Books (Ctrl-A or the little box above the row numbers): E for Bulk Edit
Paste the names you copied earlier int o the Authors Box: Edit the semicolons into &, tick the Auto set Author sort box.



BTW if your REGEX foo is up to it, you might be able to use the Bulk Search and replace on a group of multi authors, remembering that some search characters need to be escaped with a backslash
BE careful and get it correct. you can trash a goodly amount of names fast
theducks is offline   Reply With Quote
Old 05-30-2012, 12:41 AM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,312
Karma: 5382313
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Quote:
Originally Posted by rpresser View Post
calibredb.exe set metadata will require me to have a complete OPF file ready; not just changing the author.
calibredb show_metadata --as-opf
calibredb set_metada
kovidgoyal is online now   Reply With Quote
Reply

Tags
author renaming, calibre, catalog, metadata

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible to change author name format when bulk adding or importing? himitsuhieki Library Management 6 08-19-2011 10:58 PM
Odd formatting needs correction and TOC leday Sigil 10 12-01-2010 01:47 PM
How to bulk replace author - book name alophind Calibre 2 11-25-2010 09:25 AM
Unutterably Silly When Automatic Spelling Correction Goes Wrong RickyMaveety Lounge 11 10-01-2010 10:40 AM
Amazon for Blackberry Now App Available! Correction. daffy4u News 3 04-14-2009 10:30 AM


All times are GMT -4. The time now is 10:38 PM.


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