[GUI Plugin] Job Spy

[davidfor]

Originally Posted by mirikbb

Any chance to get feature which populates/updates custom column by number of book formats for particular ebook?

You can do that with a custom column. Use the template:

{:'count(approximate_formats(),',')'}

[eater]

I just noticed the Last Viewed tool in JS, which I love. I wonder if there'd be a way to query the filesystem to populate a custom column with the last date the file was opened, whether it was opened via Calibre or some other tool?

(on my Linux command line, I can use the stat tool and the relatime option to get this info, for instance)

[DaltonST]

Windows does not have the equivalent built-in command-line tools, which means that I cannot develop a new JS GUI Tool that does what you suggest.

However, in Linux, you could write a Python script executed by calibredb that accumulates that data by book and writes to a .csv text file. Then, use the Job Spy plugin's Tool "Import CSV to Update Metadata" to update your chosen custom columns. Or, you could also use calibredb to update your custom columns: calibredb.exe set_custom [options] columnlabel bookid value

See the user guide for calibredb for all of its CLI options.

[gers1978]

Will this help me look up ASINs for books automatically?

[DaltonST]

Originally Posted by gers1978

Will this help me look up ASINs for books automatically?

No. The OP lists its tools.



Show Tooltip

[eater]

Originally Posted by DaltonST

you could write a Python script executed by calibredb that accumulates that data by book and writes to a .csv text file. Then, use the Job Spy plugin's Tool "Import CSV to Update Metadata" to update your chosen custom columns. Or, you could also use calibredb to update your custom columns: calibredb.exe set_custom [options] columnlabel bookid value.

Perfect, thanks for steering me in the right direction! I'm doing the latter.

[Rellwood]

An idea for a utility would be to include individual library information instead of just custom columns for every library.

I imagine being able to select a library and get the columns, book count, and maybe the earliest or latest timestamp. The databases have the ability to show a lot of information, and it would be great to be able to access it through the utility.

I use the custom column list to standardize all my libraries, but it would be nice if I could select a library and have a list of columns that are disimilar to the ones in that library listed, or choose which libraries to check instead of all of them.

As it is I have to export it to excel and highlight the desired template library and sort according to name/label to see differences. It' would be nice if the differences were the only thing to see instead of having to wade through all of them.

It could be set so that either columns that don't match or columns that aren't listed can be shown.

Just an idea.

[Tanjamuse]

I've gone over this now 3 times, and I can't see what I've done wrong:

I've placed checkmark in Tweak for Per-Library: 'Save Metadata in OPF-file' and written this in the plugin-tweaks:

Job_spy_save_metadata_in_opf_file = {'@ Arkiv FFN Intake': 'False', '@ Arkiv AO3 Intake': 'False'}

and then I got this error everytime:

calibre, version 4.8.0
JS+ GUI Tool: Tweak job_spy_save_metadata_in_opf_file: Error in the Tweak 'job_spy_save_metadata_in_opf_file' in Your Preferences > Tweaks > Plugin Tweaks.<br><br><b>Activated in JS but Tweak is missing.</b><br><br>You should recustomize Job Spy Tweaks and Preferences for this GUI Tool before proceeding.

[DaltonST]

Job_spy_save_metadata_in_opf_file is not all lower case.

[Tanjamuse]

[DaltonST]

Version 1.0.184 -2020-07-26 Qt tweaks in Customizing so that Job Spy customizing within Linux (at least Debian-KDE Plasma within Chrome OS, anyway) looks essentially the same as Job Spy customizing does under Windows 10.


DaltonST

[ownedbycats]

Is the book-identifier matrix meant to be read-only? I tried editing an id with it but it didn't save. (And if so, what's the 'cancel' button for?) I know of 'edit identifiers' but that only seems to work on one book at a time.

[DaltonST]

See the attached JS Tear-Off Menus Reference Sheet.




DaltonST

[jbacelar]

Windows 10 64 bit
I have been using this tool for quite some time without any problem, although I don't remember which version of Calibre I used it for the last time.
Now simply when trying to select a category, the tool and the Calibre itself hangs.

[DaltonST]

Originally Posted by jbacelar

Windows 10 64 bit
I have been using this tool for quite some time without any problem, although I don't remember which version of Calibre I used it for the last time.
Now simply when trying to select a category, the tool and the Calibre itself hangs.

Changes in Tag Browser and/or Category changes in Calibre 5.2 must have broken that tool. Deactivate it and quit using it for now.


Added: I cannot reproduce your error. I need your details.

Run in DEBUG mode, recreate your error(s), and then post your debug log back to your original prior post.



Also, post some screen-prints of your Tag Browser with the Categories expanded, and indicate what other Category-related plugins you are using.



Also indicate what you were doing (exactly) when the error(s) occurred.




DaltonST