05-29-2012, 03:33 PM | #1 |
Member
Posts: 17
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?
|
05-29-2012, 03:35 PM | #2 |
creator of calibre
Posts: 43,744
Karma: 22446736
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. |
Advert | |
|
05-29-2012, 03:49 PM | #3 |
Member
Posts: 17
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. |
05-29-2012, 05:52 PM | #4 | |
Well trained by Cats
Posts: 29,659
Karma: 54369090
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
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 |
|
05-29-2012, 11:41 PM | #5 |
creator of calibre
Posts: 43,744
Karma: 22446736
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
|
Advert | |
|
Tags |
author renaming, calibre, catalog, metadata |
Thread Tools | Search this Thread |
|
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 |