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: 102
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 normal plugin. You need this plugin only if you frequently add ebooks with extremely malformed and misplaced author, title, and series. Do not install this plugin and its supporting database unless you are sure you need it. Refer to the instructions, attached.


Main Features:

This add-on quarantines 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 instructions, which include a workflow diagram. See the Version History for specifics of functionality changes.


Installation Notes:

1. 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 to the following very specific subdirectory: QuarantineAndScrub . The plugin icons will not respond to clicks unless the current Calibre library is exactly "QuarantineAndScrub". That library contains the add-on's metadata.db and metadata_db_prefs_backup.json files. Both of these files are extremely 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 plugin with any Calibre library other than the one extracted from the QuarantineAndScrub_official_library_to_extract_ren ame_to_zip.jar file. That is why this plugin is also an add-on. Refer to the 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 Instructions".


Special Notes:

Requires Calibre version 2.5 or later.

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

Send suggestions and questions directly to the developer by clicking the submenu icon named "PM Suggestions to Developer". You may also click here.


PayPal Donations:
If you find this or any of my other plugins useful please feel free to show your appreciation. I have spent many hundreds of unpaid hours in their development and support so any encouragement for me to continue is appreciated! Donate

Version History:

Spoiler:

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 Files
File Type: jar QuarantineAndScrub_official_library_to_extract_rename_to_zip.jar (2.18 MB, 47 views)
File Type: pdf quarantine_instructions.pdf (539.9 KB, 5 views)
File Type: zip quaratineandscrub.zip (811.9 KB, 49 views)

Last edited by DaltonST; Yesterday at 02:54 PM. Reason: Version 2.0.0 - 24 October 2014 Major New Release
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: 102
Karma: 8524
Join Date: Aug 2013
Location: Texas
Device: Nexus 7
Current Version is: Version 2.0.0 - 24 October 2014

The current version will always appear in the title.

Last edited by DaltonST; Yesterday at 02:31 PM. Reason: Version 2.0.0 - 24 October 2014
DaltonST is offline   Reply With Quote
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: 102
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: 102
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: 102
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: 102
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: 102
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: 102
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: 102
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: 102
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: 102
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: 5,684
Karma: 5656630
Join Date: Jul 2011
Location: Australia
Device: Kobo Touch, Kobo Glo
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 offline   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: 102
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: 102
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
Taking a break; Fed up
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: 6,989
Karma: 44005669
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 online now   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] FanFictionDownLoader JimmXinu Plugins 3421 Today 08:56 AM
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 264 Yesterday 09:59 PM
[GUI Plugin] Marvin XD Philantrop Plugins 45 10-22-2014 06:56 AM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 12:27 PM


All times are GMT -4. The time now is 02:00 PM.


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