[GUI Plugin] Job Spy

[BetterRed]

@Rellwood - if you want 'any-time, any-where' access to column lookup names, you can get them initially from the first line of a CSV Catalogue - My calibre cheat sheet has the lookup names as copied from csv catalogues for each of my libraries

BR

[DaltonST]

Job Spy > Utilities has tools for showing the custom column configurations for one or all Libraries displayed in a matrix.

[BetterRed]

When I run JS->Utils->Create Matrix.... I get

calibre, version 3.44.0
ERROR: Unhandled exception: <b>UnboundLocalError</b>:local variable 'r' referenced before assignment

calibre 3.44 [64bit]  embedded-python: True is64bit: True
Windows-10-10.0.17763-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.17763')
Python 2.7.15+
Windows: ('10', '10.0.17763', 'SP0', u'Multiprocessor Free')
Interface language: None
Successfully initialized third party plugins: Goodreads (1, 4, 0) && Favourites Menu (1, 0, 4) && GetFileName (0, 0, 13) && Modify ePub (1, 3, 14) && Find Duplicates (1, 6, 3) && Generate Cover (1, 5, 21) && Resize Cover (1, 0, 3) && CalibreSpy (1, 0, 71) && Quality Check (1, 9, 11) && Barnes & Noble (1, 2, 15) && Drop Search Results (1, 0, 9) && Extract ISBN (1, 4, 4) && EpubSplit (2, 7, 0) && Reading List (1, 6, 6) && View Manager (1, 3, 2) && User Category (1, 5, 3) && Job Spy (1, 0, 160) && Count Pages (1, 8, 2)
Traceback (most recent call last):
  File "calibre_plugins.job_spy.ui", line 3465, in create_matrix_custom_columns_by_library
  File "calibre_plugins.job_spy.custom_columns_matrix_by_library_dialog", line 63, in __init__
UnboundLocalError: local variable 'r' referenced before assignment

[DaltonST]

That error can only happen if a Library has no (zero) custom columns. Obviously I never found that in testing. It will be fixed in the next version I upload.


DaltonST

[DaltonST]

Version 1.0.161 - 2019-07-02 Python 3 compatibility; Miscellaneous technical changes. Minimum version of Calibre now 3.44.0. Upgrade Calibre first.



DaltonST

[BetterRed]

Originally Posted by DaltonST

That error can only happen if a Library has no (zero) custom columns. Obviously I never found that in testing. It will be fixed in the next version I upload.

That'd be my Empty library, no customisation, no books ;-)

Added: working fine now

BR

[NightMyst]

Originally Posted by DaltonST

[1] As the ToolTips in JS customizing says, the custom column must be AMPERSAND separated, like "names". Yours is comma separated. See the attached image.

[2] JS was giving you a fatal error message of "Customized Pseudonym 'Real Author' Custom Column Does Not Exist in Library: ", but tried to add the customized name of your Custom Column that did not exist. Otherwise, it would have just shown a fatal error dialog and you would have had to fix your configuration. Job Spy icon > Customize JS > go to the very bottom to specify what your Custom Column #name should be. See [1], above.


Added: remember that CC's are Library-specific. Your customization might have been performed, but the CC you specified was not in the current Library in which you tried to use it.



DaltonST

OK...the custom column dropdown does not contain AMPERSAND separated. How do you get that type for a CC?

[Rellwood]

Originally Posted by DaltonST

Job Spy > Utilities has tools for showing the custom column configurations for one or all Libraries displayed in a matrix.

I have that and use it, thank you for that btw :-)

I think I might have been asking for the ability to select specific columns from that list, and copy just the column names with the formatting needed to the clipboard so that the file would look like this:

'{#custom_column_1}',{#custom_column_2},'{#custom_ column_3}'

or just the {#column_1},{#column_2},{#column_3}

Making it easier to create various composite columns without having to go through the whole list of columns and copy/pasting them in a desired order.

I can picture it in my head what I would think it could look like,

a drop down list of the current columns with check boxes to indicate that the column is desired for the list, and then the ability to move the column name up or down the list. Like creating the csv catalog allows you to move the columns up or down and allows you to only check off the columns you want.

However, once the list has been populated then it gets copied to the clipboard in a way that allows users to just copy and paste it to where ever they need it.

Composite columns, search and replace, plug-boards, tweaks.

An additional and even better feature would be to preset prefixes and various html tags to include.

It's way too much work for one plugin to handle, but I have a lot of copy/search/replace saves that look like the following:

<b>Date Read: </b>{#dateread}<br><br>

and a few that are as long as:

<b>Original File Name: </b>{#original_file_name}<br><br>
<b>Details: </b>{#details}<br><br>
<b>Booksource: </b>{#booksource}<br><br><b>All Sources: </b>{#all_the_book_sources}<br><br>
<br>
<b>Date Added: </b>{#dateadded}<br><br>
<b>Book Style: </b>{#book_style}<br><br><b>GR Average Rating: </b>{#gr1}<br><br>
<b>Pages: </b>{#pages}<br><br>
<b>Word: </b>{#word}<br><br><b>Tags: </b>{tags}<br><br>

These are appended to my comments so I can have a better book jacket or so I can make a better catalog.


Probably a lot of work but it was kind of a "wish"

[DaltonST]

I am currently being consumed changing all 15 of my plugins to be Python 3 compatible. I saved the most complex ones for last (MCS, CALM, Q&S). Once those are changed and regression-tested (the time-consuming part of it) in 3-4 months, I will have time to entertain new JS tools.




DaltonST

[Tanjamuse]

When you've looked at the Python 3-thing, could you look at the possibility for creating a custom column with template for when a book is merged? It doesn't matter if it's a yes/no column or something else.

Thanks so much.

[Rellwood]

Originally Posted by Tanjamuse

When you've looked at the Python 3-thing, could you look at the possibility for creating a custom column with template for when a book is merged? It doesn't matter if it's a yes/no column or something else.

Thanks so much.

Are you hoping that Job Spy will locate merged books and identify them? Or are you looking for Job Spy to automatically update a column after you do the initial merges? If you are looking for a column to keep track, consider configuring epub merge to add the tag "merged". Or you can do what I do and just have a "book style" column with the varios types, merged, catalog, omnibus, novella, short story, etc.

If you set up epub merge to add the tag automatically, you can just create an icon rule where you have a small icon in one of the columns (I use Pages) to indicate a merged book (I use the icon "m") set the rule that if a column has "merged" then add the icon with text to the specific column. Although you won't be able to sort the books using the icon, you can certainly see what books are merged.

Just a suggestion. Hope you don't mind.

[Rellwood]

So I came across this error when trying to get a list of the custom columns in all libraries - I need to see how many different instances I have of specific date columns.


calibre, version 3.44.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such table: custom_columns

calibre 3.44 [64bit] embedded-python: True is64bit: True
Windows-7-6.1.7601-SP1 Windows ('64bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.15+
Windows: ('7', '6.1.7601', 'SP1', u'Multiprocessor Free')
Traceback (most recent call last):
File "calibre_plugins.job_spy.ui", line 3443, in create_matrix_custom_columns_by_library
File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\cursor.c", line 1019, in APSWCursor_execute.sqlite3_prepare
File "c:\t\t\apsw-mc0now\apsw-3.27.2-r1\src\statementcache.c", line 386, in sqlite3_prepare
SQLError: SQLError: no such table: custom_columns


I deleted the bit about the third-party plugins.

[DaltonST]

New version posted.





DaltonST

[Tanjamuse]

Originally Posted by Rellwood

Are you hoping that Job Spy will locate merged books and identify them? Or are you looking for Job Spy to automatically update a column after you do the initial merges? If you are looking for a column to keep track, consider configuring epub merge to add the tag "merged". Or you can do what I do and just have a "book style" column with the varios types, merged, catalog, omnibus, novella, short story, etc.

If you set up epub merge to add the tag automatically, you can just create an icon rule where you have a small icon in one of the columns (I use Pages) to indicate a merged book (I use the icon "m") set the rule that if a column has "merged" then add the icon with text to the specific column. Although you won't be able to sort the books using the icon, you can certainly see what books are merged.

Just a suggestion. Hope you don't mind.

Where is the option for the adding the merged tag and can it be added in another column than the built-in tags column?

[Rellwood]

Originally Posted by Tanjamuse

Where is the option for the adding the merged tag and can it be added in another column than the built-in tags column?

select "configure"

there are two tabs, the first tab it "basic" and there is a line that asks if you want to add a tag. Type in whatever tag you want. Yes, this only works for the tags column. Unless you want to keep data in the books that were merged then the merged book won't contain any values that isn't in the original books. Unless you indicate that the books you merged were in fact merged, then the final output won't have that data.

In the "colums" options it asks what information you want in the custom columns of the final merged book, taking the responses from the individual books. For example if you want to take a "merged" column which is yes/no, to indicate it was a merged book, it needs to be found somewhere i the original books.

So for your purposes I would just create a tag or just make sure that one or more of the books originally merged have something in a desired column indicating "merged"