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 02-17-2016, 03:50 PM   #61
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Full-Text Search of Books with TXT Formats using Regular Expressions

Version 1.0.45 - 17 February 2016 New: Full-Text Search of Books with TXT Formats using Regular Expressions.

Considers the text of TXT formats as a 'virtual column', so performs 'full-text' searches of that text. The other 'standard' MCS options, 'Final Filters' and 'All Authors' Books', are also available.

See the attached image.



Daltonst
Attached Thumbnails
Click image for larger version

Name:	mcs_txt_format_full_text_search_tab.JPG
Views:	117
Size:	69.2 KB
ID:	146434  
DaltonST is offline   Reply With Quote
Advert
Old 03-01-2016, 01:44 PM   #62
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
New: Queries Using a 'Word-Book Index' Within Calibre

Version 1.0.50 - 01 March 2016 New: Word Queries using a book-word index; Revised User Instructions.

The ToolTips of the 'Word Queries' Tab within MCS provide extensive detail about the use of each widget. To read the ToolTips, it must of course be installed.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_word_book_index_queries_tab.JPG
Views:	119
Size:	130.9 KB
ID:	146809  
DaltonST is offline   Reply With Quote
Old 03-02-2016, 09:21 AM   #63
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I've just installed the newest edition, but I can't get it to run.

I keep getting the following error:

Code:
calibre, version 2.52.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such table: _mcs_word_book_index

calibre 2.52 [64bit]  embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: User Category && Modify ePub && Find Duplicates && Reading List && Generate Cover && FanFicFare && MultiColumnSearch && Count Pages
Traceback (most recent call last):
  File "calibre_plugins.multi_column_search.ui", line 313, in search_request_dialog
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 154, in __init__
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 4954, in __init__
  File "calibre_plugins.multi_column_search.mcs_search_dialog", line 5225, in count_records_in_index
  File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 990, in APSWCursor_execute.sqlite3_prepare
  File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\statementcache.c", line 386, in sqlite3_prepare
SQLError: SQLError: no such table: _mcs_word_book_index
Tanjamuse is offline   Reply With Quote
Old 03-02-2016, 09:35 AM   #64
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Got it. I'll upload the fix shortly, but in the meantime it likely is a timing issue. The table will automatically be created, so try restarting Calibre and then clicking the icon. Regardless, I will upload a new version soon.

DaltonST
DaltonST is offline   Reply With Quote
Old 03-02-2016, 09:36 AM   #65
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I'll just wait for a fix Thanks for the quick reply
Tanjamuse is offline   Reply With Quote
Advert
Old 03-02-2016, 09:57 AM   #66
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Version 1.0.51 Released

Version 1.0.51 - 02 March 2016 Technical changes when switching among libraries to ensure the Word-Book Index gets created in the 'new' library.



DaltonST
DaltonST is offline   Reply With Quote
Old 03-02-2016, 12:04 PM   #67
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I've downloaded the guide, but I'm not sure I understand how to get the plugin to show me the columns where the metadata is not the same.

Thanks
Tanjamuse is offline   Reply With Quote
Old 03-02-2016, 12:08 PM   #68
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
ToolTips

Quote:
Originally Posted by Tanjamuse View Post
I've downloaded the guide, but I'm not sure I understand how to get the plugin to show me the columns where the metadata is not the same.

Thanks
@Tanjamuse:

Could you be more specific about what type of query you want?

If you hover your mouse over the various widgets and places in MCS, the ToolTips will appear and explain what you can do.

DaltonST
DaltonST is offline   Reply With Quote
Old 03-02-2016, 12:19 PM   #69
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I would like to compare the original authors column in calibre with one I've created myself and see which stories they are different in.
Tanjamuse is offline   Reply With Quote
Old 03-02-2016, 12:26 PM   #70
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Simple 'intra-book' query

Quote:
Originally Posted by Tanjamuse View Post
I would like to compare the original authors column in calibre with one I've created myself and see which stories they are different in.
@Tanjamuse:

Easy. Sounds like a simple 'intra-book' query using the very first Tab. See the attachment.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_simple_intra_book_query.JPG
Views:	119
Size:	88.6 KB
ID:	146833  
DaltonST is offline   Reply With Quote
Old 03-02-2016, 12:38 PM   #71
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Nothing happens. In the bottom of Calibre it writes:

Quote:
MCS cannot use the path you selected the place where my library is/metadata.db - CantOpenError:unable to open database file
I've tried to make it the same as the screenshot you posted.
Tanjamuse is offline   Reply With Quote
Old 03-02-2016, 12:45 PM   #72
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
Originally Posted by Tanjamuse View Post
Nothing happens. In the bottom of Calibre it writes: I've tried to make it the same as the screenshot you posted.
@Tanjamuse:

You clicked "Execute Search [All Books]" ?



DaltonST
DaltonST is offline   Reply With Quote
Old 03-02-2016, 12:55 PM   #73
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Yes, but I've been having trouble with that database before.

I've tried with another library and it works.

Thank you for the help.
Tanjamuse is offline   Reply With Quote
Old 03-06-2016, 11:36 AM   #74
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 915
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
I've just discovered something. All the libraries that are on my external harddrive doesn't work with MCS.

It just gives me the same error as I've posted in #71.

Quote:
MCS cannot use the path you selected the place where my library is/metadata.db - CantOpenError:unable to open database file
Tanjamuse is offline   Reply With Quote
Old 03-06-2016, 12:13 PM   #75
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 981
Karma: 71480
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Environment Variables for Temporary Files

@Tanjamuse:

Implement the suggestions in the Original Post regarding environment variables for temporary file directories.



DaltonST
DaltonST is offline   Reply With Quote
Reply

Tags
columns, search

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Search the Internet kiwidude Plugins 283 06-28-2017 06:54 PM
[GUI Plugin] Walk Search History kiwidude Plugins 12 01-01-2017 11:31 AM
[GUI Plugin] Recoll Full Text Search Satas Plugins 16 08-05-2016 04:54 AM
[GUI Plugin] Full Text Search (SOLR) peterpisljar Plugins 2 08-09-2015 09:16 AM
[GUI Plugin] Clipboard Search kiwidude Plugins 9 08-12-2014 04:36 AM


All times are GMT -4. The time now is 12:21 AM.


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