MobileRead Forums - View Single Post

DaltonST · 10-24-2014, 02:48 PM

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.

Release 2.0.0 now includes full Tag Scrubber functionality. It provides an end-user SQLite table called "_tag_rules" that allows changes and deletions of Work Tags using vanilla simple matches by tag, or using complex Regular Expressions to match to Work Tags and then to either change them or to delete them.

Example: a regex of /sci.*[f][iy].*/ is pre-provided as a rule to cause any matching Work Tag (e.g. scifi, scify, science fiction, SCI FY, etc.) to be changed to a standardized "Fiction:Science". Since the table rules are maintained by end-users, the rule could easily be changed to output "Science Fiction" (or anything else) instead of "Fiction:Science".

The end-user tool for this table maintenance is QT-based "DB Browser for SQLite" from http://sqlitebrowser.org/ . Free. Easy and efficient to use for routine end-user SQLite table maintenance, and is much easier to use for high-volume end-user table changes than the SQLite Manager tool that is an add-in to Firefox.

Refer to the revised User Instructions both attached to the Original Post and available as a menu item within the plugin itself.

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

DaltonST

10-24-2014, 02:48 PM	#30
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	Q&S Plugin Version 2.0.0 Now With Heavy-Duty Tag Scrubbing Tool 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. Release 2.0.0 now includes full Tag Scrubber functionality. It provides an end-user SQLite table called "_tag_rules" that allows changes and deletions of Work Tags using vanilla simple matches by tag, or using complex Regular Expressions to match to Work Tags and then to either change them or to delete them. Example: a regex of /sci.[f][iy]./ is pre-provided as a rule to cause any matching Work Tag (e.g. scifi, scify, science fiction, SCI FY, etc.) to be changed to a standardized "Fiction:Science". Since the table rules are maintained by end-users, the rule could easily be changed to output "Science Fiction" (or anything else) instead of "Fiction:Science". The end-user tool for this table maintenance is QT-based "DB Browser for SQLite" from http://sqlitebrowser.org/ . Free. Easy and efficient to use for routine end-user SQLite table maintenance, and is much easier to use for high-volume end-user table changes than the SQLite Manager tool that is an add-in to Firefox. Refer to the revised User Instructions both attached to the Original Post and available as a menu item within the plugin itself. Remember to always run the "Update Version" job on the menu after upgrading to any new version of Q&S. DaltonST Last edited by DaltonST; 10-24-2014 at 02:54 PM. Reason: Remember to Run Upgrade Version Job