Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 07-11-2018, 12:29 AM   #1
wjBLqf-_9
Enthusiast
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
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
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 12: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: 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
kovidgoyal is offline   Reply With Quote
Advert
Old 07-11-2018, 03:58 AM   #3
chaley
Grand Sorcerer
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: 11,734
Karma: 6690881
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
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:	154
Size:	69.3 KB
ID:	164982  
chaley is offline   Reply With Quote
Old 07-11-2018, 07:24 AM   #4
wjBLqf-_9
Enthusiast
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
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 :-?
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 07:31 AM   #5
wjBLqf-_9
Enthusiast
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
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
wjBLqf-_9 is offline   Reply With Quote
Advert
Old 07-11-2018, 07: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: 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.
kovidgoyal is offline   Reply With Quote
Old 07-11-2018, 09: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: 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.
davidfor is offline   Reply With Quote
Old 07-11-2018, 06:00 PM   #8
wjBLqf-_9
Enthusiast
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
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!
wjBLqf-_9 is offline   Reply With Quote
Old 07-11-2018, 06: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: 35,307
Karma: 145435140
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, 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, 07:47 PM   #10
BetterRed
null operator (he/him)
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: 20,553
Karma: 26954694
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-11-2018 at 11:10 PM. Reason: typo
BetterRed is offline   Reply With Quote
Old 07-15-2018, 09:43 PM   #11
wjBLqf-_9
Enthusiast
wjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterwjBLqf-_9 can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
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!
wjBLqf-_9 is offline   Reply With Quote
Reply


Forum Jump

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


All times are GMT -4. The time now is 04:20 PM.


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