Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 07-11-2018, 01:29 AM   #1
wjBLqf-_9
Member
wjBLqf-_9 began at the beginning.
 
Posts: 15
Karma: 10
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
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 01:32 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 33,613
Karma: 10209576
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
kovidgoyal is offline   Reply With Quote
Advert
Old 07-11-2018, 04:58 AM   #3
chaley
CC Android & calibre dev
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 8,778
Karma: 2692874
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by wjBLqf-_9 View Post
Unless there is a way to search tag fields for that book title (programably for each book)
Use bulk metadata edit search and replace in template mode. The following will remove any tag that equals the title as long as the title does not contain a comma. If the title *does* contain commas then the results will be incorrect and quite possibly bad. Hint: search for books that don't have a comma in the title and apply this S/R to those.

The text of the template is:
Code:
program: list_difference(field('tags'), field('title'), ',')
Attached Thumbnails
Click image for larger version

Name:	Clipboard02.jpg
Views:	105
Size:	69.3 KB
ID:	164982  
chaley is offline   Reply With Quote
Old 07-11-2018, 08:24 AM   #4
wjBLqf-_9
Member
wjBLqf-_9 began at the beginning.
 
Posts: 15
Karma: 10
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 :-?
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 08:31 AM   #5
wjBLqf-_9
Member
wjBLqf-_9 began at the beginning.
 
Posts: 15
Karma: 10
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
wjBLqf-_9 is offline   Reply With Quote
Advert
Old 07-11-2018, 08:37 AM   #6
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 33,613
Karma: 10209576
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.
kovidgoyal is offline   Reply With Quote
Old 07-11-2018, 10:21 AM   #7
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 15,477
Karma: 25810738
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo,Aura H2O,Glo HD,Aura ONE,Clara HD,Forma;tolino epos
@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.
davidfor is offline   Reply With Quote
Old 07-11-2018, 07:00 PM   #8
wjBLqf-_9
Member
wjBLqf-_9 began at the beginning.
 
Posts: 15
Karma: 10
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!
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 07:32 PM   #9
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 5,129
Karma: 21886264
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Aura One, Aura H2O, Aura HD, Nexus 7 HD, iPad Air, Tolino epos
Quote:
Originally Posted by wjBLqf-_9 View Post

"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!
Category editor is a generic term -- right click on Series and then Manage series and the popup window is labelled Category editor (Series). Ditto for Publisher.
DNSB is offline   Reply With Quote
Old 07-11-2018, 08:47 PM   #10
BetterRed
null operator
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 11,298
Karma: 10578436
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by davidfor View Post
@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.
Annnnnd....

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-12-2018 at 12:10 AM. Reason: typo
BetterRed is offline   Reply With Quote
Old 07-15-2018, 10:43 PM   #11
wjBLqf-_9
Member
wjBLqf-_9 began at the beginning.
 
Posts: 15
Karma: 10
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!
wjBLqf-_9 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre Server: 2 Feature Requests/Ideas... "tag cloud"+"word cloud" wjBLqf-_9 Server 8 09-18-2018 11:24 PM
images import "bulk confirmation" feature request Olivier_Rebiere Sigil 4 03-23-2017 09:42 AM
Feature Request: configurable space setting for "Insert blank line" in "Look & Feel" therealjoeblow Calibre 15 07-25-2011 04:14 PM
Feature Request - cover browse in the "Fetch Metadata from server" function nathander13 Calibre 1 01-30-2010 03:11 PM
Feature Request - replace "screensavers" with randomly selected book covers from libr nathander13 Calibre 3 12-02-2009 01:21 PM


All times are GMT -4. The time now is 05:25 PM.


MobileRead.com is a privately owned, operated and funded community.