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, 03: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, 03: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: 24,836
Karma: 4370273
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, 03: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, 05: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: 13,630
Karma: 5126946
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-29-2012, 11:41 PM   #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: 24,836
Karma: 4370273
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 09:58 PM
Odd formatting needs correction and TOC leday Sigil 10 12-01-2010 12:47 PM
How to bulk replace author - book name alophind Calibre 2 11-25-2010 08:25 AM
Unutterably Silly When Automatic Spelling Correction Goes Wrong RickyMaveety Lounge 11 10-01-2010 09:40 AM
Amazon for Blackberry Now App Available! Correction. daffy4u News 3 04-14-2009 09:30 AM


All times are GMT -4. The time now is 04:03 AM.


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