Bulk author correction

rpresser · 05-29-2012, 03:33 PM

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?

kovidgoyal · 05-29-2012, 03:35 PM

calibredb.exe set_metadata

or search replace metadata in the bulk metadata edit dialog in the gui.

rpresser · 05-29-2012, 03:49 PM

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.

theducks · 05-29-2012, 05:52 PM

Quote:

Originally Posted by rpresser

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

kovidgoyal · 05-29-2012, 11:41 PM

Quote:

Originally Posted by rpresser

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

05-29-2012, 03:33 PM	#1
rpresser Member Posts: 18 Karma: 84 Join Date: Mar 2008 Device: Ebookwise1150, Treo 600	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?

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

05-29-2012, 03:35 PM	#2
kovidgoyal creator of calibre Posts: 45,604 Karma: 28548974 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.

05-29-2012, 03:49 PM	#3
rpresser Member Posts: 18 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.

Advert

Advert