![]() |
#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.
|
![]() |
![]() |
![]() |
#2 | |
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
|
|
![]() |
![]() |
Advert | |
|
![]() |
#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?
|
![]() |
![]() |
![]() |
#4 | |
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
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. |
|
![]() |
![]() |
![]() |
#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 | |
|
![]() |
#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 |
![]() |
![]() |
![]() |
#7 | |
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
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. |
|
![]() |
![]() |
![]() |
#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 |
![]() |
![]() |
![]() |
#9 |
US Navy, Retired
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 9,865
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
|
![]() |
![]() |
![]() |
#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?
|
![]() |
![]() |
![]() |
#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.
|
![]() |
![]() |
![]() |
#12 | |
Connoisseur
![]() Posts: 56
Karma: 64
Join Date: Nov 2007
Device: Kindle
|
This worked for me:
Quote:
|
|
![]() |
![]() |
![]() |
#13 | |
Enthusiast
![]() Posts: 33
Karma: 10
Join Date: Mar 2023
Device: Kindle Oasis, Tolino Vision Color
|
Quote:
in 2024 this is the correct answer. But doing it on one book is enough to clear the tags from every book. |
|
![]() |
![]() |
![]() |
#14 | |
Well trained by Cats
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 30,000
Karma: 57259778
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
That does NOT affect those that have been embeded into the book. (adding that book to a new Library, will result in the Tag reappearing on the list . You can also rename variations and it will consolidate (not double) into existing usage |
|
![]() |
![]() |
![]() |
#15 | |
Enthusiast
![]() Posts: 33
Karma: 10
Join Date: Mar 2023
Device: Kindle Oasis, Tolino Vision Color
|
Quote:
|
|
![]() |
![]() |
![]() |
|
![]() |
||||
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 |