Register Guidelines E-Books Today's Posts Search

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

Notices

Reply
 
Thread Tools Search this Thread
Old 05-11-2018, 10:43 AM   #151
yonkyunior
Cultivator
yonkyunior doesn't litteryonkyunior doesn't litteryonkyunior doesn't litter
 
yonkyunior's Avatar
 
Posts: 94
Karma: 216
Join Date: Feb 2015
Device: PRST2
Quote:
Originally Posted by DaltonST View Post
Custom Columns in Calibre have a sequential number assigned when table custom_columns is updated for a new CC. Your "Target" metadata.db has none of your CCs, so there is no Target CC for you to copy from Main to Target (yet). After you have totally updated all of your books and their Standard Metadata in the Target, you could copy a book from Main and have Calibre automatically create whichever CCs you wish. Then, they would exist. You would then have to add new SQL that is specific to the CC number in your Main and the CC number in your Target. They will NOT be the same, since the Q&S Target metadata.db comes with a dozen "standard" Q&S "work" CCs.

...............

There are web sites that can teach you SQLite SQL, such as http://www.sqlitetutorial.net/.



DaltonST
yup, thanks for the explanation.
yonkyunior is offline   Reply With Quote
Old 04-15-2019, 04:08 PM   #152
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.104 -15 April 2019

Version 3.6.104 -15 April 2019 Miscellaneous Series Scrubbing's personal BeautifulSoup changed to use Standard Calibre's BeautifulSoup to ensure future compatibility with Calibre.


DaltonST
DaltonST is offline   Reply With Quote
Advert
Old 07-20-2019, 12:06 PM   #153
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.105 Python 3 compatibility; Many performance improvements

Version 3.6.105 - 20 July 2019 Python 3 compatibility; Minimum Calibre Version now 3.41.3; Many performance improvements.




DaltonST
DaltonST is offline   Reply With Quote
Old 08-17-2019, 02:03 PM   #154
jemsoo7
Member
jemsoo7 began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Sep 2014
Device: none
Just to say a very big thank you for all of your continued work... Thanks!
jemsoo7 is offline   Reply With Quote
Old 02-13-2020, 04:02 PM   #155
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.106 - Python 3.8 & Performance Improvements

Version 3.6.106 - 13 February 2020 Q&S has been overhauled, refurbished, refactored and restructured to greatly improve its performance and reliability, and to make it fully Python 3.8 compatible. Retested with both Calibre 4.10.1 (Python 2.16+) and Calibre 4.99.4 (Python 3.8).

Remember to run the menu option near the top of the Q&S menu starting with "After Version Upgrade: Create New SQLite Database Objects"; this should be done after any installation of Q&S, new or upgraded.

Also, hover your mouse over the Q&S main menu to view its blue main menu ToolTips (see the attached).


See the Original Post for more details.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	qs_main_menu_tooltips.jpg
Views:	277
Size:	82.0 KB
ID:	177121  
DaltonST is offline   Reply With Quote
Advert
Old 02-17-2020, 01:04 AM   #156
jemsoo7
Member
jemsoo7 began at the beginning.
 
Posts: 11
Karma: 10
Join Date: Sep 2014
Device: none
Super Great! Take care! God Bless you...
jemsoo7 is offline   Reply With Quote
Old 02-18-2020, 04:13 PM   #157
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.107 Technical changes to Series-level renaming and consolidation

Version 3.6.107 - 18 February 2020 Technical changes to Series-level renaming and consolidation job.


DaltonST
DaltonST is offline   Reply With Quote
Old 03-30-2020, 01:28 PM   #158
iienderii
Member
iienderii began at the beginning.
 
Posts: 10
Karma: 10
Join Date: Apr 2016
Device: PC, Google Pixel 4XL
I apologize if I missed the instructions for this (I did look), but are there actual instrutions for the 'configure Q&S Preferences and Options' steps where you indicate the custom columns for 'derive genres', 'dewey decimal code', and 'LCC'?
iienderii is offline   Reply With Quote
Old 03-30-2020, 03:39 PM   #159
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
The user guide .pdf, page 50.

Personally, I use the Library Codes plugin that I wrote long after Q&S.



DaltonST
DaltonST is offline   Reply With Quote
Old 05-16-2020, 02:08 PM   #160
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.108 Technical changes in Author-level scrubbing & Series consolidation

Version 3.6.108 - 16 May 2020 Technical changes in Author-level scrubbing and Series-level consolidation and renaming.



DaltonST
DaltonST is offline   Reply With Quote
Old 06-03-2020, 01:19 PM   #161
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.109 Technical changes in: "Download Work Series/Titles/Indexes from Web

Version 3.6.109 - 03 June 2020 Technical changes in: "Download Work Series/Titles/Indexes from Web Source for All Series for a Single Author [Single Author Only]"

Series-scrubbing miscellaneous option "Download Work Series/Titles/Indexes from Web Source for All Series for a Single Author [Single Author Only]" now works as well as or better than it did 5 years ago, plus now it of course is fully Python 3 Calibre 4.99.5 compatible.

"WSSVD" still means "Web Source Series Validation Data", which is accumulated within Q&S for automated series metadata enhancement and validation purposes.


Code:
Starting job: Quarantine And Scrub: Miscellany - Download Work Series/Titles/Indexes from Web Source for All Series for a Single Author 
Library DB: S:/Calibre/QS/QuarantineAndScrub_Test/metadata.db 
Wed Jun  3 10:17:55 2020 
Python: Windows   CPython   2.7.16+ 
SQLite Version: 3031001  [APSW] 
Database is SHARED, not EXCLUSIVE 
  
Beginning Miscellaneous Scrubbing 
Download Work Series/Titles/Indexes from Web Source for All Series for a Single Author [Single Author Only] 
═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════ 
Author Selected Was: Alan Burt Akers 
Web Series for Author: Dray Prescot 
  
  
  
Number of Series Downloaded as WSSVD for Selected Author: 1 
  
  
Number of Series/Book Title Combinations Downloaded as WSSVD for Selected Author: 37 
  
  
This new WSSVD is now available to all Series Level Scrubbing functions. 
  
. 
Alan Burt Akers  Dray Prescot  Transit to Scorpio  1 
Alan Burt Akers  Dray Prescot  Avenger of Antares  10 
Alan Burt Akers  Dray Prescot  Armada of Antares  11 
Alan Burt Akers  Dray Prescot  The Tides of Kregen  12 
Alan Burt Akers  Dray Prescot  Renegade of Kregen  13 
Alan Burt Akers  Dray Prescot  Krozair of Kregen  14 
Alan Burt Akers  Dray Prescot  Secret Scorpio  15 
Alan Burt Akers  Dray Prescot  Savage Scorpio  16 
Alan Burt Akers  Dray Prescot  Captive Scorpio  17 
Alan Burt Akers  Dray Prescot  Golden Scorpio  18 
Alan Burt Akers  Dray Prescot  A Life for Kregen  19 
Alan Burt Akers  Dray Prescot  The Suns of Scorpio  2 
Alan Burt Akers  Dray Prescot  A Sword for Kregen  20 
Alan Burt Akers  Dray Prescot  A Fortune of Kregen  21 
Alan Burt Akers  Dray Prescot  A Victory for Kregen  22 
Alan Burt Akers  Dray Prescot  Beasts of Antares  23 
Alan Burt Akers  Dray Prescot  Rebel of Antares  24 
Alan Burt Akers  Dray Prescot  Legions of Antares  25 
Alan Burt Akers  Dray Prescot  Allies of Antares  26 
Alan Burt Akers  Dray Prescot  Mazes of Scorpio  27 
Alan Burt Akers  Dray Prescot  Delia of Vallia  28 
Alan Burt Akers  Dray Prescot  Fires of Scorpio  29 
Alan Burt Akers  Dray Prescot  Warrior of Scorpio  3 
Alan Burt Akers  Dray Prescot  Talons of Scorpio  30 
Alan Burt Akers  Dray Prescot  Masks of Scorpio  31 
Alan Burt Akers  Dray Prescot  Seg the Bowman  32 
Alan Burt Akers  Dray Prescot  Werewolves of Kregen  33 
Alan Burt Akers  Dray Prescot  Witches of Kregen  34 
Alan Burt Akers  Dray Prescot  Storm Over Valka  35 
Alan Burt Akers  Dray Prescot  Omens of Kregen  36 
Alan Burt Akers  Dray Prescot  Warlord of Antares  37 
Alan Burt Akers  Dray Prescot  Swordships of Scorpio  4 
Alan Burt Akers  Dray Prescot  Prince of Scorpio  5 
Alan Burt Akers  Dray Prescot  Manhounds of Antares  6 
Alan Burt Akers  Dray Prescot  Arena of Antares  7 
Alan Burt Akers  Dray Prescot  Fliers of Antares  8 
Alan Burt Akers  Dray Prescot  Bladesman of Antares  9 
  
The Rename Work Series Name job now will have new WSSVD to use, as will Book Level Scrubbing for Work Title and Work Series Renaming. 
  
   
  
  
============= 
Job complete.


The related menu option "Verify Series Index Using Web Lookup [Selected Books]" is in need of similar technical enhancements, and will be updated in the next release of Q&S.



DaltonST
DaltonST is offline   Reply With Quote
Old 06-08-2020, 03:30 PM   #162
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.110 Technical changes in Series-Scrubbing jobs that create or use WSSVD

Version 3.6.110 - 08 June 2020 Technical changes in several Series-Scrubbing jobs that either create or use WSSVD.

There are a few English punctuation scenarios in WSSVD downloading and use in Series Name renaming and Series Index validation that I am still working on to improve further, but this version's changes are major both technically and functionally, and should be installed immediately.




DaltonST
DaltonST is offline   Reply With Quote
Old 06-09-2020, 02:04 PM   #163
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.111 Technical changes in two Series-Scrubbing jobs that create WSSVD

Version 3.6.111 - 09 June 2020 Technical changes in two Series-Scrubbing jobs that both create and use WSSVD.


Example job log output is combined into a .txt file attached below.




DaltonST
Attached Files
File Type: txt qs_series_scrubbing_job_results_examples_using_wssvd.txt (29.8 KB, 245 views)
DaltonST is offline   Reply With Quote
Old 12-10-2020, 11:02 AM   #164
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.113 Miscellaneous Technical Changes

Version 3.6.113 - 10 December 2020 Miscellaneous Technical Changes

Allow changes to a Q&S Library's library_id UUID to be acceptable. Configuration dialog changes for small displays.



DaltonST
DaltonST is offline   Reply With Quote
Old 12-24-2020, 10:52 AM   #165
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Version 3.6.114 Miscellaneous

Version 3.6.114 - 24 December 2020 Miscellaneous.




DaltonST
DaltonST is offline   Reply With Quote
Reply

Tags
dcc, lcc, metadata, tag management


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 492 10-25-2022 08:13 AM
[GUI Plugin] Marvin XD Philantrop Plugins 126 01-29-2017 12:48 PM
[GUI Plugin] FanFictionDownLoader JimmXinu Plugins 3985 05-08-2015 11:18 PM
[GUI Plugin] Plugin Updater **Deprecated** kiwidude Plugins 159 06-19-2011 12:27 PM


All times are GMT -4. The time now is 11:30 PM.


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