[GUI Plugin] Job Spy

[DaltonST]

The next release will have a new option: If tag-like, merge CSV tags with existing Custom Column tags? Otherwise, the CSV tags will replace any existing CC tags.


You need to post an example csv row and what the corresponding book's CC looks like, and explain how the csv cell should be matched to the book's CC value.

[DaltonST]

Version 1.0.146 - 2019-03-08 Changes to "Import CSV File to Update Metadata" for tag-like Custom Columns.

That new Tool is still in BETA TEST.

Next version: enhancement to update only books that have been manually Selected but were also just automatically Marked by the tool.




DaltonST

[Tanjamuse]

Could you do the same to the scrubbing tools? Only scrub either marked or selected books?

Thank you so much for all the work.

[DaltonST]

Version 1.0.147 - 2019-03-09 Changes to "Import CSV File to Update Metadata": Add new option to additionally specify that only currently selected matching books should be updated.

This single tool is still in Beta Testing.


DaltonST

[DaltonST]

Version 1.0.148 - 2019-03-14 Changes to "Import CSV File to Update Metadata": Add new option to additionally specify that only books matching a user-defined SQL snippet should be updated.

See the attached image.


DaltonST

[DaltonST]

Version 1.0.150 - 2019-03-18 Enhancements to "Import CSV File to Update Metadata" to add ability to update the Standard Columns of Comments, Identifiers, Publisher and Tags.

The documentation for this Tool is contained in its ToolTips, which have been revised to reflect new functionality and CSV File value format requirements for Identifiers, etc. Reading the ToolTips is a prerequisite for using this Tool.

Tip: Calibre has a very useful "Create Catalog in CSV File Format" ability to create a CSV File using your personal metadata. Caution: do not select any numeric columns for export, since the resulting CSV File Format will be corrupted with non-text values. Text-only. Caution: 'Yes/No' (boolean) columns are exported as integers (0 or 1 or blank), not "True" or "False" or "". This tool requires Text. Create a brand-new CSV File that is empty in your spreadsheet editor, then copy-and-paste specific columns from the Create Catalog CSV File into your fresh CSV File to avoid any problems. Never import into this tool an original Create Catalog CSV File, since it will likely cause corruption and failure in this tool.

Tip: To match a CSV File row on a Book ID basis, simply create a temporary Custom Column of type "short text" (not Integer), and use Search & Replace (Source = template {id}) to populate it. A CSV File bootstrapped from Create Catalog then could have ID as a column, which would have to be turned into Text (not Numeric) in your Spreadsheet editor for it. This Tool only handles text that is properly double-quoted. You could then "match" each row of the CSV file to each Book ID using the temporary textual ID Custom Column as its proxy. That may be useful for updating Identifiers en masse. Afterwards, delete the temporary Custom Column, then compress/defragment your Library as normal.


DaltonST

[Tanjamuse]

I've come across a couple of errors in the Update Metadata plugin, which I hadn't noticed before.

First of all, there's a difference between ' when I write it in calc and how it's written in Calibre, which means it doesn't recognize those tags.

A tag with only numbers like 24 aren't picked up by the update metadata.

And if the case doesn't match what's in the csv for updating metadata it doesn't recognize it.

Example:

In Calibre it's:

A Song Of Ice And Fire

in the CSV it's:

A Song of Ice and Fire

[DaltonST]

24 is a number, not text. Calc automatically makes it an integer. You have to either use '24 to force it to text, or to manually format all of your cells as text. Or both to be sure. However, you cannot leave any cell empty, since Calc defaults to a number (it is a spreadsheet app after all). Put a blank space in empty cells to force it to text.

Each and every cell must be double-quoted text. If you open your csv file in Notepad, look for any double commas ,, since that means there is at least one numeric column. You should see only ","",""," and never ",,,".

I am preparing a major enhancement to the tool for release very soon, and one of the things I have enhanced is its ToolTips that explain the above.

The tool does not change any capitalization. Remember that a pre-existing Tag's capitalization is retained when you add the identical Tag with differing capitalization to another Book. That behavior is standard Calibre.

[Tanjamuse]

Originally Posted by DaltonST

The tool does not change any capitalization. Remember that a pre-existing Tag's capitalization is retained when you add the identical Tag with differing capitalization to another Book. That behavior is standard Calibre.

In the MATCH_VALUE I have:

A Song of Ice and Fire

shouldn't that match to the book in calibre whoose tag is:

A Song Of Ice And Fire?

if the capitalization is irrelevant?

Also, do you have a solution to the problem with apostrophe and the diffence between writing it in calibre and in calc?

Example:

In Calibre it's: A Knight's Tale

In Calc it's: A Knight’s Tale

[DaltonST]

[1] Search in Calibre to see what happens when you search on one and then the other, and whether both capitalizations always appear together.

[2] There are simple quotes and there are fancy quotes. They are totally different characters. I would do a search & replace of your Tags to replace all fancy quotes with simple quotes so you return some sanity to your Tags.

For example: https://www.cl.cam.ac.uk/~mgk25/ucs/quotes.html

[DaltonST]

Version 1.0.151 - 2019-03-23 Enhancements to "Import CSV File to Update Metadata" to add: Standard Columns identifiers, date-added, pubdate,series,series index,title; and to add Custom Column datatypes datetime, yes/no, series-like.

See the attached image.

The ToolTips are critical to using this Tool. Please read them by hovering your mouse over every different text and widget location. They tell you how to format the values to be uploaded based on their Standard Column or Custom Column, among many other important instructions.



DaltonST

[DaltonST]

Version 1.0.152 - 2019-03-25 Enhancements to "Import CSV File to Update Metadata" to add option to specify whether matching should be case-sensitive or case-insensitive for the three matching expressions (equals, contains, is contained in).


DaltonST

[Tanjamuse]

Thanks for the new case-sensitivity. Unfortunately I can't test it becaues the window is too big for me to press either preview or actually update. Could you create a scroll so it's possible to get to the bottom of the window?

[DaltonST]

The window is not tall. Perhaps "move" the top down, then resize from a corner...

[DaltonST]

Version 1.0.153 - 2019-03-25 Enhancements to "Import CSV File to Update Metadata" - font made smaller and blank lines removed to compress window size.


Remember that ToolTips are required reading to use this tool.




DaltonST