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

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 10-04-2014, 08:08 AM   #1
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
[GUI Plugin] QuarantineAndScrub

[GUI Plugin] QuarantineAndScrub

This plugin is actually a Calibre add-on, not just a plugin. You need this add-on if you frequently add ebooks (especially fiction) with malformed and misplaced author, title, series, series index, and tags, and want them automatically and effortlessly corrected ("scrubbed"). It saves an enormous amount of time and energy correcting trashed out metadata. Refer to the instructions, attached. It is somewhat of a "Swiss Army Knife" metadata tool, although like all knives, it requires proper handling and care.


Main Features:

This add-on holds your ebooks with dirty (i.e., malformed and misplaced) metadata, and then scrubs the author, title, series, series index and tags. Afterwards, you move the scrubbed ebooks to your "Pristine Library". Refer to the User Instructions, which includes a workflow diagram. See the Version History for specifics of functionality additions.

Scrubs normal ebooks, as well as Manga and Graphic Novels.


Installation Notes:

1. Easy to install (but only if you follow the directions). Download the QuarantineAndScrub_official_library_to_extract_ren ame_to_zip.jar file, place it in the parent directory of your Calibre libraries, rename the extension from .jar to .zip, and "Extract (it) Here" automatically into its special Calibre Library subdirectory, QuarantineAndScrub .

Please note: the above .zip file is a compressed Q&S Calibre Library, not a book with a format of .zip! Do not emulate one Einstein who did a drag-and-drop of the official .zip library (containing a metadata.db and a .json file) onto the Calibre GUI, and then complained vociferously that one of his file conversion plugins "broke" after he "installed" Q&S. No, he did not read the User Guide, or even the paragraph just above this one. The moral of this story: Read the User Guide after thoroughly reading this post. Thank you in advance.

The add-on icons will not respond to clicks unless the current Calibre library name begins with this exact phrase:
"QuarantineAndScrub". You can have as many Q&S libraries as you wish, but they all must begin with "QuarantineAndScrub_ ".

The special Q&S library contains the add-on's metadata.db and metadata_db_prefs_backup.json files. Both of these files are specific to this add-on.

The jobs check to ensure that the custom sqlite objects in the Q+S metadata.db are as they should be. The uuid of the library is also confirmed. Any discrepancies result in job termination. You may not use this add-on with any Calibre library other than the one "Extracted Here" from the QuarantineAndScrub_official_library_to_extract_ren ame_to_zip.jar file. That is why this is an add-on. Refer to the User Instructions.

2. Calibre > Preferences > Plugins > Load Plugin from File and load the attached zip file. Save your work and restart Calibre.

3. Calibre > Preferences > Toolbar > Main Menu Toolbar and then add the icon for QuarantineAndScrub. Save your work. Close the window.


Execution Notes:

Refer to the submenu named “Read Q&S Instructions".


Special Notes:

Requires Calibre version 2.05 or later.

This add-on is intended for use only by "Advanced Calibre Users".

The User Instructions must be read prior to using this add-on. It is 66 pages in length for a reason.

The User Guide is your friend and source of support for Q&S.

99.9% of Calibre users do not need Q&S, and should not install it.

Q&S is designed for users who have already been using Calibre for quite some time, so the Q&S User Guide assumes the reader is already familiar with Calibre.

If you have an aversion to following detailed instructions, you should not attempt to install Q&S. "Attempt" because it is impossible to install it properly without following its detailed instructions.

Remember to always run the "After Version Upgrade" job near the top of the menu after upgrading to any new version of Q&S. It adds new tables and views, plus additional Global Authors used for Author validation.

Please do not allow your DB version to fall behind the current version as shown in the Version History, below. Each of your Q&S libraries must be upgraded individually, since each has its own metadata.db file originally downloaded from this thread.

Send suggestions and questions directly to the developer by clicking the submenu icon named "PM Suggestions to Developer". You may also click here. Warning: the developer does not monitor this forum for new posts, nor will he view or respond to any new posts in this thread. This is an anti-trolling measure. Please use PM instead.


Version History:

Spoiler:

Remember to always run the "After Version Upgrade" job on the menu after upgrading to any new release or version of Q&S.

Version 3.6.68 -22 April 2015 New Book Awards and Other Miscellaneous.
Version 3.6.67 -19 April 2015 Miscellany.
Version 3.6.66 -13 April 2015 Miscellany.
Version 3.6.65
-12 April 2015 Miscellany.
Version 3.6.64 -07 April 2015 Transient DB-locked error in one of the Series-Level Scrubbing jobs resolved. If it reoccurs (usually after switching among multiple Q&S libraries quickly, then running the aforementioned job immediately upon arrival), simply exit from Calibre, then restart it.
Version 3.6.63
-03 April 2015 ~100 New Book Awards; New Title Scrubbing Rules.
Version 3.6.62 -01 April 2015 Propagation of Work Tags to/from Books with Identical Work Series: changed to not propagate Work Tags derived from the Book Awards Table, as they are specific to a particular Book, not the Work Series it belongs to.
Version 3.6.61 -30 March 2015 ~331 New Book Awards; ~85 New Global Authors; Enhanced Automatic Reformatting of Initials of Global Authors, Pristine Authors and Authors in the Book Awards Table.
Version 3.6.60 -29 March 2015 New Title Scrubbing Rules; Improved Scrubbing of Publishers from Title.
Version 3.6.59 -28 March 2015 New Customization Option for Book Tag Minimization to ignore all Book Awards previously created as new Work Tags by Book Level Scrubbing or Standalone Tag Scrubbing.
Version 3.6.58 -27 March 2015 New Title Scrubbing Rules; Miscellaneous enhancements.
Version 3.6.57
-27 March 2015 ~450 new Book Awards Table entries added; Revised User Guide.
Version 3.6.56 -26 March 2015 New:Book Awards Table Preloaded with ~2,700 Books with Author and Awards; New Work Tags are created for books with a matching entry in the Book Awards Table; ~1,000 New Global Authors Added. Total Global Authors now: ~19,050; New DB Version 4.96.0. Revised Title Scrubbing Rules.
Version 3.6.54 -25 March 2015 Miscellany.
Version 3.6.53 -24 March 2015 New Menu Item for Series Level Scrubbing: Download Web Series/Titles/Indexes from Web Source for All Fiction Series for a Single Real Author (Regardless of Work Series, if any); Revised User Guide.
Version 3.6.52 -22 March 2015 Miscellany; Revised User Guide.
Version 3.6.51 -21 March 2015 Many New Title Scrubbing Rules, Especially for CBZ/CBR Types of Titles.
Version 3.6.50 -20 March 2015 New: Automatic Graphic Novel Book-Level Scrubbing for Formats CBZ/CBR (or Other Formats with a Tag of "Graphic Novel"); New Title Rules and Series Rules for Capitalizing Common CB Words; ~1000 New Global Authors Added. Total Global Authors now: ~18,100+
Version 3.6.49 -19 March 2015 Derive Genres (Q&S Version): Miscellaneous enhancements.
Version 3.6.48 -19 March 2015 ~350 New Global Authors Added. Total Global Authors now: 17,000+.
Version 3.6.47 -18 March 2015 ISSN now supported along with ISBN for retrieving DDC and/or LCC with OCLC-OWI. If a book has both, the ISBN takes priority.
Version 3.6.46 -17 March 2015 New: Author Mapping Table (User Maintained) to Change an Author's Name to Another Name (e.g. Pseudonym to Real Name or to Another Pseudonym); Revised User Guide.
Version 3.6.44 -16 March 2015 Miscellaneous enhancements; Revised User Guide.
Version 3.6.43 -14 March 2015 New: The OCLC OWI identifier is now added whenever DCC or LCC are updated; Revised User Guide.
Version 3.6.42 -13 March 2015 New Menu Item: Dewey Decimal Classification and Library of Congress Classification - See Page 63 of the Revised User Guide.
Version 3.6.41 -11 March 2015 All Q&S Menus are now "Tear-Off"; Revised User Guide; Miscellaneous Enhancements.
Version 3.6.40 -09 March 2015 Author Level Scrubbing refinement; New Global Authors; Miscellaneous Enhancements.
Version 3.6.39 -08 March 2015 New Title Scrubbing Rules; New Global Authors; Enhancement to automate (otherwise manual) certain table Tag Priorities maintenance tasks.
Version 3.6.38 -07 March 2015 New Title Scrubbing Rules; New Global Authors; Bug Fix in Copy Rules etc. from/to Best to/from Target Q&S Libraries.
Version 3.6.37 -06 March 2015 Author Level Scrubbing changes.
Version 3.6.36 -06 March 2015 Miscellaneous improvements.
Version 3.6.35 -05 March 2015 New Author Level and Book Level Scrubbing Rules; Revised User Guide.
Version 3.6.34 -04 March 2015 New Menu Item: "Swap Work Title and Work Series" (Under "[Menu] Q&S Special Tools"); Many New Title Scrubbing Rules; Pristine Authors Now Copied Back from "Target" Q&S Libraries to "Best" Q&S Library.
Version 3.6.33 -03 March 2015 New Author Level Scrubbing rules.
Version 3.6.32 -02 March 2015 Changes to Author Level Scrubbing
Version 3.6.31 -02 March 2015 New Title Scrubbing Rules; New Series Scrubbing Rules; Enhanced Author Level Scrubbing.
Version 3.6.30 -01 March 2015 Many New Title Scrubbing Rules; Enhanced Author Level Scrubbing; New DB Version 4.95.
Version 3.6.29 -28 February 2015 New: Derivation of User Custom Columns from Title (see Page 62 of the User Guide); Revised User Guide; New DB Version 4.94.0.
Version 3.6.28 -26 February 2015 Miscellaneous enhancements.
Version 3.6.27 -25 February 2015 New DB Version 4.93.0; Miscellaneous enhancements to Author Level Scrubbing, Series Consolidation/Renaming, and Validation of Work Series Using Web Series Data; Revised User Guide.
Version 3.6.25 -24 February 2015 Job Speed Increased for Work Series Consolidation/Renaming; New Dialog Box for Selecting Work Series Consolidation/Renaming Series Name Source Priority Sequence; New DB Version 4.92.0.
Version 3.6.24 -23 February 2015 New Dialog Box for Selecting Table Maintenance of Tags by Comments Candidates and then Tags by Comments.
Version 3.6.23 -22 February 2015 Global Authors Table updated with more permutations of their names and initials to increase Author Level Scrubbing accuracy; Ditto for Pristine Authors Table; Series Level Renaming of Work Series Name per Validated Web Series Name enhanced to include the new functionality added in Version 3.6.22 for Book Level Scrubbing.
Version 3.6.22 -21 February 2015 Book Level Scrubbing enhanced to add a missing Work Series if that Web Series for the same Work Author exists already in the Historically Cumulative Web Series Detail downloaded previously as part of the validation of Work Series and Work Series Index (See Page 16 of the Revised User Guide for an example); Miscellaneous enhancements to Author Level Scrubbing.
Version 3.6.21 -20 February 2015 Miscellaneous Enhancements and Job Speed Improvements.
Version 3.6.20 -19 February 2015 Author Level Scrubbing Enhanced; New Work Title Scrubbing Rules; Jobnames Improved; New DB Version 4.91.0.
Version 3.6.19 -16 February 2015 Many New Work Title Scrubbing Rules; Improved Author Level Scrubbing; Revised User Guide; New DB Version 4.9.0.
Version 3.6.18 -14 February 2015 Many New Work Title Scrubbing Rules.
Version 3.6.17 -14 February 2015 New Menu Item: Copy (just) Real Series to Work Series (i.e., standalone); User Guide Revised; After Version Upgrade Job: No Longer Inception-to-Date Capable. If you have not kept your Q&S Libraries up to the current major version (4.), as of this release you will not be able to do so. Only totally new or newly changed tables and views will be delivered starting now. As previously forewarned in the OP in the "use it or lose it" comment, if your DB Version is currently less than 4.0.0, you will have to redownload the "official library", extract it, and move your books from your non-current Q&S library to the new up-to-date one. And keep it current.
Version 3.6.16 -10 February 2015 New DB Version 4.8.0; Tags by Comments Candidates Creation: Speed Improvement.
Version 3.6.15 -10 February 2015 Revised User Guide.
Version 3.6.14 -07 February 2015 New Global Authors added.
Version 3.6.13 -06 February 2015 Author Level Scrubbing: Improvements; Book Level Scrubbing: New Title Scrubbing Rules.
Version 3.6.12 -03 February 2015 New DB Version 4.7.0; Increase in performance of Series Consolidation/Renaming
Version 3.6.11 -02 February 2015 Miscellany; Revised User Guide.
Version 3.6.10 -31 January 2015 Miscellaneous enhancements.
Version 3.6.9 -30 January 2015 Miscellany; Revised User Guide; New DB Version 4.6.0; New "Manga Awareness".
Version 3.6.8 -28 January 2015 New "Tag String Replacement Rules" table, which is user maintained; Revised User Guide; New DB Version 4.5.0.
Version 3.6.7 -27 January 2015 New "Tag Capitalization Rules" table, which is user maintained; Revised User Guide; New DB Version 4.4.0.
Version 3.6.6 -26 January 2015 New Database Version 4.3.0
Version 3.6.5 -25 January 2015 New Scrubbing Rules for Work Title.
Version 3.6.4 -24 January 2015 Miscellany.
Version 3.6.3 -22 January 2015 Menu System Enhanced.
Version 3.6.2 -20 January 2015 New Global Authors for Validation; Miscellaneous enhancements; Revised User Guide.
Version 3.6.1 -19 January 2015 New Database Version 4.2.0; Miscellaneous enhancements.
Version 3.6.0 -18 January 2015 New "Tag Combinations Rule Table", which Tag Scrubbing uses to derive new Work Tags based on combinations of up to three Work Tag Keywords per Rule; Revised User Guide.
Version 3.5.10-17 January 2015 Major enhancements to Author Level Scrubbing; New Book Level Scrubbing Rules for Title and Author; New Database Version 4.1.0.
Version 3.5.9- 16 January 2015 Enhanced Book Level Scrubbing and Book Level Tag Scrubbing to automatically insert missing Work Tags into table Tag Priorities so that table can be fully maintained prior to executing Minimize Tags Using Tag Priorities; enhanced Auto-Populate Tags-by-Comment Rule Table; Revised User Guide.
Version 3.5.8- 15 January 2015 New Menu Item: Auto-Populate Tags-by-Comment Rule Table using Tag Rules Table plus Comments of All Books; Revised User Guide.
Version 3.5.7- 15 January 2015 Book Level Scrubbing db lock at end of job: fixed; Author Level Scrubbing: enhancement.
Version 3.5.6- 14 January 2015 Standalone Book Level Tag Scrubber: Enhanced to include derivation of new Work Tags from Comments (table _tags_by_comment), just like Book Level Scrubbing already has; this obviates the need to run BL Scrubbing just for that purpose. Enhanced inter-library rules cloning within the Q&S ecosystem.
Version 3.5.5- 13 January 2015 Validate Work Series from Web Source: improvements; Propagation of Tags by Series: bug fix.
Version 3.5.4- 13 January 2015 New database version 3.9.0
Version 3.5.3- 13 January 2015 Enhancements to Q&S Derive Genres; New Q&S Derive Genres User Guide; Q&S User Guide revised.
Version 3.5.2- 12 January 2015 Miscellaneous Enhancements; Revised User Guide.
Version 3.5.1- 11 January 2015 Enhancements to Q&S Derive Genres, especially in validating/correcting user errors made while maintaining Boolean Tag Rules in the Q&S DG Rules tables; Integration of Q&S DG rules tables into Q&S inter-library rules copying added.
Version 3.5.0- 10 January 2015 New: Derive Genres core functionality has been integrated with Q&S, using Q&S database tables instead of any .csv files like the generic Derive Genres plugin uses. User Guide has been revised.
Version 3.4.2- 09 January 2015 New User-Maintained "Tags by Comment Table" to derive Work Tags from Book Comments; Revised User Guide.
Version 3.4.1- 08 January 2015 New Scrubbing Rules and Work Series Validation tweaks.
Version 3.4.0- 07 January 2015 New User-Maintained "Series Rules Table" that uses regular expressions to change/delete words in Work Series (analogous to the Title Rules Table); Revised User Instructions.
Version 3.3.9- 06 January 2015 New Scrubbing Rules for Work Title and Work Series; Speed optimization of Default Work Tag by Author.
Version 3.3.8- 04 January 2015 New Scrubbing Rules for Work Title, Work Series and Work Tags; UTF8 bug fixes.
Version 3.3.7- 03 January 2015 UTF8 bug fix in Book Level Scrubbing.
Version 3.3.6- 01 January 2015 New Scrubbing Rules for Work Title, Work Series and Work Tags; Some menu icons revised for clarity of purpose.
Version 3.3.5- 30 December 2014 Database Table and View Changes; Revised User Guide; Official Q&S Database to Download [for new users only] Upgraded to DB Version 3.5.0.
Version 3.3.4- 27 December 2014 New Menu Item: "Change Default Tag of 'Real' Author to Selected Work Tag [Selected Books]"; Revised User Guide.
Version 3.3.3- 26 December 2014 "Change Selected Work Tags to Default Tag of 'Real' Author [Selected Books]": improvements.
Version 3.3.2 - 25 December 2014 New Scrubbing Rules for Title and Series.
Version 3.3.1 - 23 December 2014 Bug fix.
Version 3.3.0 - 22 December 2014 New Menu Item: "Change Selected Work Tags to Default Tag of 'Real' Author [Selected Books]"; Revised User Guide; New user-maintained table: _tags_by_author_default .
Version 3.2.10-21 December 2014 Tag Minimizer: tweaks to improve performance.
Version 3.2.9 -20 December 2014 "Easy-Add Tags-to-Purge": new column added to specify whether /regex/ should be used for new Tag Purge Rules (previously always did); Miscellaneous Enhancements; Revised User Instructions.
Version 3.2.8 -19 December 2014 "Easy-Add Tags-to-NEWTAG Mappings": new column added to specify whether /regex/ should be used for new Tag Rules (previously always did); Miscellaneous Enhancements.
Version 3.2.7 -18 December 2014 Speed optimizations; Changes to SQLite Tables and Views to improve functionality and performance; Book Work Title Renaming per Web Source Web Title enhancements.
Version 3.2.6 -16 December 2014 Major enhancements to the "Rename Work Series" job; now all historically cumulative Web Source Series Data downloaded to validate Work Series/Title/Index (from anywhere in the Q&S Library ecosystem at any time in the past) is available for renaming Work Series/Title/Index in any Q&S Library. Download once, then use the results anywhere in any Q&S Library at anytime in the future.
Version 3.2.5 -15 December 2014 Bug created in version 3.1.9 fixed.
Version 3.2.4 -15 December 2014 This Version does for Work Tags and Web Source Series/Title/Index Data what the prior version did for Real Tags. The User Guide has been revised to reflect all of the new functionality.
Version 3.2.3 -14 December 2014 Real Tags from all Q&S Libraries now consolidated into the Best Q&S Library and made available as choices in the "Easy-Add Real-Tags-to-Purge" menu option used to easily add new "purge rules" to the Tag Rules table. See Version 3.2.0 below.
Version 3.2.2 -13 December 2014 New Scrubbing Rules; Miscellaneous Enhancements.
Version 3.2.1 -12 December 2014 Miscellaneous Enhancements.
Version 3.2.0 -11 December 2014 New Menu Item: Automatically Copy Tag & Title Rules From/To Multiple Q&S Libraries; New Customization Items; Revised User Guide.
Version 3.1.9 -10 December 2014 Changed From "All Books" to "Selected Books": Validate Work Series, Work Titles & Work Indexes Via Web Source [Fiction Series of Selected Books]
Version 3.1.8 -10 December 2014 Menu Changes for Clarity plus User Guide Improvements.
Version 3.1.7 -09 December 2014 Changed From "All Books" to "Selected Books": Tag Scrubber (standalone) & Tag Minimizer.
Version 3.1.6 -08 December 2014 New Scrubbing Rules
Version 3.1.5 -08 December 2014 Miscellaneous Enhancements.
Version 3.1.4 -07 December 2014 New Menu item added: "Purge All Work Data [Selected Books Only]"; Other Enhancements.
Version 3.1.3 -07 December 2014 Miscellaneous speed optimizations.
Version 3.1.2 -06 December 2014 Job "Copy Q&S All Dirty Data to Work Data [All Books]" optimized for large libraries.
Version 3.1.1 -06 December 2014 "Copy Q&S All Dirty Data to Work Data [Selected Books (Max=100)]" Menu item added.
Version 3.1.0 -06 December 2014 Q&S DB Version 3.1.0
Version 3.0.9 -05 December 2014 "Easy-Add Tags-to-NEWTAG Mappings": tweaks.
Version 3.0.8 -03 December 2014 Miscellaneous Enhancements.
Version 3.0.7 -02 December 2014 Copying Work Tags to Real Tags: UTF8 bug fix.
Version 3.0.6 -01 December 2014 Miscellaneous Enhancements; Revised User Instructions.
Version 3.0.5 -30 November 2014 Web Source Series Detail Retrieval in Validation of Work Series: HTML Parsing Change.
Version 3.0.4 -28 November 2014 Improvement in ISBN Derivation from Title, Author, and Tags.
Version 3.0.3 -28 November 2014 New Scrubbing Rules.
Version 3.0.2 -25 November 2014 Q&S Automatically Converts Valid ISBN10s to ISBN13s, Removes ISBN13 Dashes & Prefixes, and Deletes Garbage Posing as ISBNs.
Version 3.0.1 -23 November 2014 Enhancement to "Minimize Work Tags Using Tag Priorities" for Work Tags having no priorities.
Version 3.0.0 -22 November 2014 New Tool to Minimize Work Tags Using Tag Priorities [New Table: _tag_priorities]; Revised User Instructions;
Version 2.9.9 -21 November 2014 New Menu Option to Copy Only Real Tags to Work Tags [e.g. Prior to Standalone Tag Scrubber for Pristine Books Copied Backwards to Q&S just to Scrub Their Tags with No Other Scrubbing].
Version 2.9.8 -20 November 2014 Unicode in Work Tag Scrubbing: Bug Fix.
Version 2.9.7 -20 November 2014 Propagation of Work Tags by Series Improvements, including BISAC format capitalization.
Version 2.9.6 -20 November 2014 DB Upgraded to Version 2.9.6
Version 2.9.5 -20 November 2014 New Series Derivation from Title Rules; Copying Work to Real improvements; bug fixes.
Version 2.9.3 -19 November 2014 Enhancements to Easy-Add Work Tags to NEWTAG Mappings to Tag Rules Table
Version 2.9.2 -18 November 2014 Miscellaneous Enhancements.
Version 2.9.1 -18 November 2014 Miscellaneous Enhancements.
Version 2.9.0 -17 November 2014 New User-Maintained "Title Rules Table" that uses regular expressions to change/delete words in titles; Revised User Instructions.
Version 2.8.2 -16 November 2014 Revised User Instructions [within the .zip]
Version 2.8.1 -16 November 2014 Miscellaneous Functionality Improvements; bug fixes.
Version 2.8.0 -15 November 2014 New "Easy-Add Tags-to-NEWTAG Mappings" to Tag Rules Table feature; Revised User Instructions.
Version 2.7.1 -14 November 2014 New Book Level Scrubbing Rules
Version 2.7.0 -13 November 2014 New Feature: "Easy-Add Tags to Purge" to the Tag Rules Table; Revised User Instructions.
Version 2.6.1 -12 November 2014 Miscellaneous Functionality Enhancements
Version 2.6.0 -12 November 2014 Expanded Functionality for Renaming Work Series/Titles/Indexes to Web Source Names/Values; Revised User Instructions.
Version 2.5.9 -12 November 2014 Bug Fixes.
Version 2.5.8 -11 November 2014 New Series Derivation Rules; Revised User Instructions.
Version 2.5.7 -11 November 2014 New Tool: Rename Work Title to Similar Web Title for Identical Series/Index.
Version 2.5.6 -11 November 2014 Miscellaneous Functionality Enhancements.
Version 2.5.5 -10 November 2014 Miscellaneous Functionality Enhancements.
Version 2.5.4 - 9 November 2014 Series Deriver & Web Validation of Work Series: Enhancements.
Version 2.5.3 - 8 November 2014 Miscellaneous Functionality Enhancements.
Version 2.5.2 - 7 November 2014 Miscellaneous Functionality Enhancements.
Version 2.5.1 - 7 November 2014 Bug fix.
Version 2.5.0 - 6 November 2014 New Scrubbing Option: Rename Work Series Name to Web Series Name [Previously Verified Fiction Series Only]; Revised Instructions; and bug fixes.
Version 2.4.2 - 5 November 2014 Enhancements to Verify Work Series Index Using Web Lookup
Version 2.4.1 - 5 November 2014 Minor tweaks.
Version 2.4.0 - 4 November 2014 New Miscellaneous Scrubing Option: Verify Work Series Index Using Web Lookup; Revised Instructions; and bug fixes.
Version 2.3.2 - 31 October 2014 New Standalone Purge Pristine Authors/Series Job[Use if Pristine Library isn't so pristine]; Enhancements to Author Level Scrubbing for libraries with a huge number [>10K] of Pristine Authors; Revised Instructions; and bug fixes.
Version 2.3.1 - 30 October 2014 Booklevel Tag Scrubber Now Available as Standalone Job; Revised Instructions; and bug fixes.
Version 2.3.0 - 29 October 2014 New Tag Propagator by Series; and Revised Instructions.
Version 2.2.0 - 28 October 2014 Enhancements to Series Consolidator/Renamer
Version 2.1.2 - 28 October 2014 Enhanced Scrubbing Rules for Series derivation from Title
Version 2.1.1 - 27 October 2014 Tag Scrubber now removes Author, Title and Series found in Tags; New Scrubbing Rules; and Revised Instructions.
Version 2.1.0 - 26 October 2014 New Series Scrubber/Consolidator/Renamer and Revised Instructions.
Version 2.0.0 - 24 October 2014 New User-Maintained (via a GUI) "Tag Rules Table" that can use regex to scrub (change or delete) tags. GUI is by http://sqlitebrowser.org/ that is designed for frequent end-user table maintenance.
Version 1.6.5 - 22 October 2014 New Work Tag Derivation Rules and bug fixes.
Version 1.6.4 - 22 October 2014 Additional Global Authors; Improvements in Copying Work Tags to Real Tags; and bug fixes.
Version 1.6.3 - 20 October 2014 New Scrubbing Rules; Revised Instructions; and bug fixes.
Version 1.6.2 - 18 October 2014 New Scrubbing Rules; New Global Authors for Validation
Version 1.6.1 - 17 October 2014 New Scrubbing Rules
Version 1.6.0 - 15 October 2014 New "Tags To Purge When Found" Table; Revised Instructions; New Scrubbing Rules
Version 1.5.9 - 14 October 2014 New Scrubbing Rules
Version 1.5.8 - 13 October 2014 New Scrubbing Rules
Version 1.5.7 - 13 October 2014 New Scrubbing Rules
Version 1.5.6 - 12 October 2014 New Functions and Features; New Scrubbing Rules
Version 1.5.5 - 11 October 2014 New Scrubbing Rules
Version 1.5.4 - 11 October 2014 New Scrubbing Rules;New Job to Upgrade Q+S DB; Revised Instructions; and bug fixes.
Version 1.5.3 - 10 October 2014 New Job to Purge Work Data;New Scrubbing Rules; bug fixes.
Version 1.5.2 - 10 October 2014 Create new SQLite table not in Version 1.0.0
Version 1.5.0 - 9 October 2014 New Scrubbing Rules and Revised Instructions.
Version 1.4.0 - 8 October 2014 New Scrubbing Rules, enhancements, bug fixes.
Version 1.3.0 - 7 October 2014 Prevention of DB Locking Errors.
Version 1.2.0 - 7 October 2014 New Scrubbing Rules; bug fixes.
Version 1.1.0 - 6 October 2014 New functions and features.
Version 1.0.0 - 4 October 2014 Initial release.
Attached Thumbnails
Click image for larger version

Name:	qs_all_tearoff_menus_at_once.JPG
Views:	84
Size:	249.3 KB
ID:	136342   Click image for larger version

Name:	qs_customization_example.JPG
Views:	63
Size:	71.9 KB
ID:	136538  
Attached Files
File Type: jar _dg_genre_author_rules_rename_to_zip.jar (115.5 KB, 326 views)
File Type: pdf qs_derive_genres_instructions.pdf (766.9 KB, 195 views)
File Type: pdf series_derivation_sample_patterns_for_manual_usage.pdf (451.5 KB, 120 views)
File Type: pdf qs_basic_functionality_overview.pdf (455.7 KB, 132 views)
File Type: pdf quarantine_instructions.pdf (7.36 MB, 75 views)
File Type: jar QuarantineAndScrub_official_library_to_extract_db_v496a_rename_to_zip.jar (1.83 MB, 11 views)
File Type: zip quarantineandscrub.zip (7.79 MB, 169 views)

Last edited by DaltonST; 04-22-2015 at 09:47 AM. Reason: Version 3.6.68 Remember to always run the "After Version Upgrade" job on the menu after upgrading to any new release of Q&S.
DaltonST is offline   Reply With Quote
Old 10-04-2014, 08:09 AM   #2
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
for future use.

Last edited by DaltonST; 10-29-2014 at 05:42 PM. Reason: for future use
DaltonST is offline   Reply With Quote
 
Advertisement
Old 10-04-2014, 08:10 AM   #3
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
This is reserved for future use.
DaltonST is offline   Reply With Quote
Old 10-04-2014, 08:11 AM   #4
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Reserved for future use for this plugin.
DaltonST is offline   Reply With Quote
Old 10-07-2014, 10:47 AM   #5
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Version 1.2.0 - 7 October 2014 New Scrubbing Rules; bug fixes.

New release: Version 1.2.0 - 7 October 2014 New Scrubbing Rules; bug fixes.

New users (only) must download the file at http://www.mobileread.com/forums/att...7&d=1412424298 . Refer to the original post for details.

Last edited by DaltonST; 10-07-2014 at 10:50 AM.
DaltonST is offline   Reply With Quote
Old 10-07-2014, 01:16 PM   #6
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
New release: Version 1.3.0 - 7 October 2014 Prevention of DB Locking Errors.

New release: Version 1.3.0 - 7 October 2014 Prevention of DB Locking Errors.



New users (only) must download the file at http://www.mobileread.com/forums/att...7&d=1412424298 . Refer to the original post for details.
DaltonST is offline   Reply With Quote
Old 10-08-2014, 06:34 PM   #7
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
New Release: Version 1.4.0 - 8 October 2014

New Release: Version 1.4.0 - 8 October 2014. New Scrubbing Rules, enhancements, bug fixes.
DaltonST is offline   Reply With Quote
Old 10-09-2014, 09:30 PM   #8
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
New Release: Version 1.5.0 - 9 October 2014

New Release: Version 1.5.0 - 9 October 2014 . New Scrubbing Rules; Revised Instructions; bug fixes.



New users (only) must download the file at http://www.mobileread.com/forums/att...7&d=1412424298 . Refer to the original post for details.

Last edited by DaltonST; 10-10-2014 at 11:04 AM.
DaltonST is offline   Reply With Quote
Old 10-10-2014, 12:06 PM   #9
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Version 1.5.1 - 10 October 2014 Create new SQLite table not in Version 1.0.0

New Release: Version 1.5.1 - 10 October 2014 Create new SQLite table not in Version 1.0.0

The Booklevel Scrubbing Job requires this new table, and will fail without it.

Please use the very latest release, which is not 1.5.1.

Last edited by DaltonST; 10-10-2014 at 12:49 PM. Reason: Use 1.5.2, Not 1.5.1
DaltonST is offline   Reply With Quote
Old 10-10-2014, 12:39 PM   #10
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Version 1.5.2 - 10 October 2014

Version 1.5.2 - 10 October 2014 Create new SQLite table not in Version 1.0.0

New Release: Version 1.5.2 - 10 October 2014 Create new SQLite table not in Version 1.0.0

The Booklevel Scrubbing Job will fail without this patch.

This new version is required.
DaltonST is offline   Reply With Quote
Old 10-10-2014, 04:04 PM   #11
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
New Release: Version 1.5.3 - 10 October 2014

The latest release is: Version 1.5.3 - 10 October 2014 New Purge Work Data Job; New Scrubbing Rules; bug fixes

IMPORTANT: The Index that Calibre uses to determine if your installed plugin has an update may lag by a long time between the time I upload the latest release and it gets updated. The Index process is tedious and burdonsome on the Admins and not at all designed for frequent updates. So, ALWAYS check this thread to determine if there is a newer release available than you have. If so, please download it manually.

In summary, do not trust what Calibre says about what the latest release of QuarantineAndScrub is. Always check the OP.

This plugin gets tested thoroughly prior to uploading on a Dell Laptop (Windows 7) with a test library of 600+ books with mostly malformed and misplaced metadata, and a Dell Touch-Screen 23" all-in-one (Windows 8.1) with a test library of 200+ of both clean and unclean books. However, you-know-what happens; when it does, I fix it immediately and upload the newest version as soon as it is tested.

The menu has a "PM the Developer" submenu option, so I hear about issues as fast as they are PM'd to me. Please continue to use that submenu option to communicate with me.

Please always check this thread prior to using this plugin. I am actively developing new functions and features every day.

Thanks for your understanding.


DaltonST

Last edited by DaltonST; 10-10-2014 at 04:10 PM.
DaltonST is offline   Reply With Quote
Old 10-10-2014, 08:43 PM   #12
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: 6,827
Karma: 6677573
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo: Touch, Glo, Aura H2O
DaltonST: If you update the plugin, you don't need to update the index thread. That is used by the server to get the list of plugins. Once a plugin is in the index, the server checks the plugin thread for any changes once an hour. That happens at about half past the hour.
davidfor is online now   Reply With Quote
Old 10-11-2014, 12:50 PM   #13
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
New Release of Q+S: Version 1.5.4 -11 October 2014

Version 1.5.4 -11 October 2014 New Scrubbing Rules;New Job to Upgrade Q+S DB; Revised Instructions; and bug fixes.



New users (only) must download the additional .jar file (which is really a .zip) in the OP, and follow the instructions.


DaltonST
DaltonST is offline   Reply With Quote
Old 10-11-2014, 01:34 PM   #14
DaltonST
Developer
DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.DaltonST shines like a glazed doughnut.
 
DaltonST's Avatar
 
Posts: 202
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Dirty Metadata Snips or Lists for New Scrubbing Rules

I am always hunting for malformed and/or misplaced metadata to use as templates for new Scrubbing Rules. I am running low, and I could use your help.

If you have any that Q+S is not already fixing, please Private Message me after attaching a screen snip of any book’s GUI row in Calibre that is not being scrubbed properly by this plugin. If many books have the identical problem, just send the most complex sample. If you can create a .txt file via "calibredb.exe list --fields=all ...", that would be better than screen snips, since I could copy&paste it into Calibre into a new fake book just for testing.

All of my test books are fake, no covers, .txt format, with just x's and spaces to read in the .txt book file, and obviously 100% copyright free. Metadata is just data about data, and hence cannot be copyrighted (just ask a John Smith).

If you have “dirty tags” that always need deleting or changing, and the plugin is not already scrubbing them, Private Message me a single snip or a simple text list of those too via "calibredb.exe list --fields=tags ..."


For help on calibredb.exe: calibredb.exe --help > "an_output_file.txt" or
http://manual.calibre-ebook.com/cli/...calibredb-list



Thank you.


DaltonST
DaltonST is offline   Reply With Quote
Old 10-11-2014, 01:48 PM   #15
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 8,058
Karma: 50766665
Join Date: Nov 2007
Location: Toronto
Device: Wife: Touch, Arc, Vox Me: Nexus 7, Glo
I'm confused by the insistence that support requests go via PMs to you. What ever happened to community involvement and for others to learn from the other experience of fellow users.
PeterT is offline   Reply With Quote
Reply

Tags
metadata

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Marvin XD Philantrop Plugins 84 Yesterday 02:54 PM
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 317 04-21-2015 09:45 PM
[GUI Plugin] FanFictionDownLoader JimmXinu Plugins 3979 04-18-2015 10:29 AM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 12:27 PM


All times are GMT -4. The time now is 07:52 PM.


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