03-22-2010, 08:59 PM | #1 |
Enthusiast
Posts: 38
Karma: 10
Join Date: Aug 2008
Device: PRS505
|
How to remove all tags at once?
Hi! Is there any way to remove all tags from a selection of books without going through them all manually? In the metadata edit window, I can remove specific tags from a selection, but how about ALL tags (but without affecting the non-selected books)? The downloaded metadata usually has too many tags.
|
03-22-2010, 09:05 PM | #2 | |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
|
|
Advert | |
|
03-22-2010, 10:20 PM | #3 |
Stone Tablet Reader
Posts: 7
Karma: 10
Join Date: Mar 2010
Location: USA
Device: iPhone
|
I've been asking the same question.
I also would like to be able to "bulk" delete all tags from my Calibre database, whether by a direct database update or by going through the GUI. What I'm finding is that Stanza does not actually make use (apparently) of the series and sequence information within the Calibre database, but the tags field is imported into stanza and used as a sortable subject field. If there were a simple way to eliminate all the existing garbage in the Tags fields, then I'd use that field to hold series/sequence information instead. Unfortunately, there doesn't appear to be a way to "bulk" delete except by specific Tag - and there's got to be at least several hundred unique tags in my db. I've currently got in excess of 2000 ebooks loaded into Calibre, and the cleanup is going to be a pain. Is there an interactive SQL interface for the db engine?
|
03-22-2010, 10:48 PM | #4 | |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
1. Highlight all books you want to eliminate tags from. 2. Then click edit meta information. 3. Now type "a" in the remove tags bar. A list of all of the tags starting with "a" will be shown. Selcet the top tag. Now do it again and select the next "a" tag until all the "a" tags are listed. Continue to "b", "c", "d" etc... 4. Do a couple of letters at a time click OK then go back into the edit meta information and do e, f, g... 5. Wash, rinse and repeat. In a short spell all tags will be gone with less then the effort to search here for a better solution. Last edited by DoctorOhh; 03-22-2010 at 10:52 PM. |
|
03-22-2010, 10:52 PM | #5 |
Wizard
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
|
Not interactive, but you can get Calibre to execute SQL scripts that should do what you want.
I haven't got time to go into details, but see if a search will pull up a post I wrote that had SQL code for the guy who wanted all duplicate titles in his database. It may get you started. There's also a post by Kovid that got me started, although his post had a typo in the code. |
Advert | |
|
03-22-2010, 10:58 PM | #6 |
Stone Tablet Reader
Posts: 7
Karma: 10
Join Date: Mar 2010
Location: USA
Device: iPhone
|
Thanks, but not really feasible
Walt -
Not a bad idea, but not really practical for the volume of information that has to be removed. I tried your suggestion, selecting a block of 50 ebooks to test with. When I typed "a", I was presented with 117 individual unique tags that begin with "a". You can't select the entire block of them, either. I'd have to go through the entire list, one at a time, to get rid of all tags that begin with "a". Then "b", "c", "d", ad nauseum. I would estimate that if I wanted to follow this model, doing all 2000+ ebooks in a single block group so that I only have to go through it once, it would take just about 2 days. This should be a fairly simple sql update, if there's a command interface for the db. Michael |
03-22-2010, 11:17 PM | #7 | |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
I am fortunate since I stopped downloading en-mass all of the tags, almost as soon as the option to do it was available. I'm sure many folks could benefit from a solution. If you come up with an alternative solution please share. You might also want to request as a feature/enhancement to be able to eliminate all tags at once. Good Luck and keep us posted. |
|
03-22-2010, 11:18 PM | #8 |
Comparer of the Ephemeris
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
|
If your tags are a complete mess, and you simply want to start over by removing all tags from your database:
G |
03-22-2010, 11:30 PM | #9 |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
|
03-26-2010, 01:39 AM | #10 |
Curmudgeon
Posts: 3,085
Karma: 722357
Join Date: Feb 2010
Device: PRS-505
|
Just hopping on the bandwagon here ... personally, I really think a remove-all-tags function that works like all of the other metadata-changing options in bulk edit would be an extremely useful feature. There are times when you don't want to strip all tags from all books in your library, just a range of them, and when deleting every possible tag from a-z individually would take forever. It shouldn't be too complicated to build this into the existing bulk edit feature, and I've seen several people asking about it. How about it, ye who are wise in the ways of The Code?
|
04-09-2010, 10:24 AM | #11 |
Member
Posts: 19
Karma: 10
Join Date: May 2008
Device: Amazon Kindle, Apple iPad
|
I agree with WorldWalker. Would like an option to remove all tags (or replace all tags with nothing, if you prefer). That said, GRiker's process worked fine on 300+ books.
|
04-09-2010, 11:51 AM | #12 | |
Connoisseur
Posts: 56
Karma: 64
Join Date: Nov 2007
Device: Kindle
|
This worked for me:
Quote:
|
|
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove all BUT certain tags? | eric11210 | Calibre | 32 | 08-10-2010 10:34 AM |
Remove Tags from all books | silverraven | Calibre | 3 | 08-03-2010 09:43 AM |
Remove spacing between paragraphs - what about div tags ? | NASCARaddicted | Calibre | 5 | 11-07-2009 05:47 AM |
RFE: Remove remove tags in bulk edit | magphil | Calibre | 0 | 08-11-2009 10:37 AM |
Remove <p> tags? | sideburnt | Calibre | 3 | 06-11-2009 12:22 PM |