07-11-2018, 12:29 AM | #1 |
Enthusiast
Posts: 47
Karma: 12544
Join Date: Jul 2018
Device: None
|
feature request: "tag manager mode"
I found a quick way to fix my snafu is right clicking on the tags that need to be removed... clicking the menu choice to remove that tag
Question: would you please consider a "tag manager mode" that would allow me to check boxes on multiple tags can selected in larger batches and remove? One-at-a-time works -- but if I could check off a bunch of boxes I could finish my remaining 7000 mistakes faster in batches of 10... 20... 50... etc :-D Unless there is a way to search tag fields for that book title (programably for each book) I cannot find anything regex to do this in calibre |
07-11-2018, 12:32 AM | #2 |
creator of calibre
Posts: 43,843
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Select all books, click edit metadata, enter the tags you want removed into the remove tags box, click apply
And if you want to use regex, use the search and replace tab of that dialog |
Advert | |
|
07-11-2018, 03:58 AM | #3 | |
Grand Sorcerer
Posts: 11,734
Karma: 6690881
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
The text of the template is: Code:
program: list_difference(field('tags'), field('title'), ',') |
|
07-11-2018, 07:24 AM | #4 |
Enthusiast
Posts: 47
Karma: 12544
Join Date: Jul 2018
Device: None
|
So maybe my search-and-replace code "kung-foo" isn't as sharp as I wish
Using that search-and-replace window somehow managed to embed the title of the book ... within the tags of the book in most of my library of 7,000 books ==== Honestly, I'm shy about using that window again unless I preface it with a filtering of book selection in the main window ahead of time ==== (full disclosure: I made a copy of the metadata.db file and explored the copy with SQLite Browser... this is my disposable copy) Question for you (kovidgoyal) directly... just curious... what would happen if I manually deleted the rows with title text in the metadata.db/tags table? Would the database see the missing rows and freak out or would there be corrective action -- interpreting the missing rows as negated tags? ~~~~ I figured deleting the rows in "tags" table would be easier than a higher complexity full-on-sql search syntax between the table relationships :-? |
07-11-2018, 07:31 AM | #5 |
Enthusiast
Posts: 47
Karma: 12544
Join Date: Jul 2018
Device: None
|
kovidgoyal -- I have been making nightly backups of my calibre library (hurray for me) however I realized my night backup eventually overwrote my last-unscrewed-up backup because I didn't catch this tag snafu early enough the next day (booo for me)
However I instituted infinite revision backup retention.... on a zfs dedupe volume... 100% dedicated to retaining copies of each previous nights backups. Dedup should help me retain A LOT of nightly backup revisions. My coder "kung-foo" might not be the best in the world But my ability to engineer plans to mitigate the foreseeable end-of-the-calibre-world are still quite formidable *grin* :-D |
Advert | |
|
07-11-2018, 07:37 AM | #6 |
creator of calibre
Posts: 43,843
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Do not manually mess with the database, you will experience data loss. If you want to script database operations use the calibre provided database API, documented in the user manual.
|
07-11-2018, 09:21 AM | #7 |
Grand Sorcerer
Posts: 24,907
Karma: 47303748
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
@wjBLqf-_9: There is actually a "Tag manager". Right click on Tags in the tag browser, select "Tag manager" and it shows all the tags with a count of how many books have the tag. You can select as many tags as you want and delete them.
|
07-11-2018, 06:00 PM | #8 |
Enthusiast
Posts: 47
Karma: 12544
Join Date: Jul 2018
Device: None
|
"DavidFor" By Gosh you hit a bullzeye! The ~Tag Manager~ you pointed me toward was actually called "Category Editor" I never knew that was there. thank you for sharing! This "Category Editor" drastically speeds up my ability to fix my tags... from 100 per night to 400+ per night. Your advice will greatly shorten the total time I will spend fixing tags on all my Library of 7573 books Thank you! |
07-11-2018, 06:32 PM | #9 | |
Bibliophagist
Posts: 35,307
Karma: 145435140
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
|
|
07-11-2018, 07:47 PM | #10 | |
null operator (he/him)
Posts: 20,553
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
If you right click on a Tag value (or Series, Author, etc value) in Book Details (right sidebar) you'll find a Manage "whatever" option If you click on the Configure button at the bottom of the Tag Browser (left sidebar) you'll find a Manage Authors, Tags etc option. If you press Shift+F2 on a Tags cell in the Book List you'll get the Manage Categories (Tags) dialogue - IMO the easiest way to get there. BR Last edited by BetterRed; 07-11-2018 at 11:10 PM. Reason: typo |
|
07-15-2018, 09:43 PM | #11 |
Enthusiast
Posts: 47
Karma: 12544
Join Date: Jul 2018
Device: None
|
Good news: last night I left my "tags/regex nightmare" ... I am 90% back to normal
I am happier sooner than I expected :-) thank you! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calibre Server: 2 Feature Requests/Ideas... "tag cloud"+"word cloud" | wjBLqf-_9 | Server | 13 | 11-11-2019 12:03 PM |
images import "bulk confirmation" feature request | Olivier_Rebiere | Sigil | 4 | 03-23-2017 08:42 AM |
Feature Request: configurable space setting for "Insert blank line" in "Look & Feel" | therealjoeblow | Calibre | 15 | 07-25-2011 03:14 PM |
Feature Request - cover browse in the "Fetch Metadata from server" function | nathander13 | Calibre | 1 | 01-30-2010 02:11 PM |
Feature Request - replace "screensavers" with randomly selected book covers from libr | nathander13 | Calibre | 3 | 12-02-2009 12:21 PM |