[GUI Plugin] Job Spy

[Tanjamuse]

I have copied what's in calibre into the csv which means that it should match exactly?

I changed that specific tag around in the csv file and now it recognizes it in Calibre although they are backwards. I thought they were supposed to be sorted in the same order as Calibre does it? Attached is yet another log-file and csv.

[DaltonST]

I will look at it.

[Tanjamuse]

Thank you so much for all your patience, help and work.

[DaltonST]

Tanjamuse:

Try the attached zip. I ensured that any sorting is done like Calibre, which is to say it ignores case.

Test it using the original "d'Artagnan Romances, Three Musketeers (Books)" and then again with it swapped. Both should work.


DaltonST

[Tanjamuse]

It now works with the original "d'Artagnan Romances, Three Musketeers (Books)", but doesn't work with the swapped version.

Do I still need to have no-space after the comma, because I have space between Hobbit, Homecoming of Beorhtnoth Beorhthelm’s Son as you can see in the csv-file and it still recognizes it in Calibre.

[DaltonST]

[1] Good. I will publish that version, which works the way Calibre works now.

[2] It works because I added code to auto-correct user errors. If you look at the debug log, it prints that it was wrong but fixed it anyway.



DaltonST

[Tanjamuse]

Thank you, then I don't have to double-check every combination I make.

[DaltonST]

Version 1.0.159 - 2019-06-13 Import CSV to Update Metadata technical changes.

If you downloaded the last beta test version, you must update this one manually since it will not appear to Calibre that it is new.


DaltonST

[Tanjamuse]

I don't know if it's because you changed the python coding but I just discovered another little thing. When " are a part of the tag it doesn't change it.

I've attached a Rules test csv and the debug-log

[DaltonST]

Double-quotes are what define a text column in the JS CSV file. If you look at the CSV in a simple text editor, you will see what I mean. DQs can cause parsing errors. I will look at it, but you should avoid DQs; change them to Single Quotes. If you use double quotes in Tags in Calibre, you should search & replace them to single quotes if you want to match them via a CSV upload.

An attachment shows the ToolTips from the Scrub Tags sub-menu within the JS menus. The .xlsx/.ods files have all of the details for the tool and each of its rule table CSV formats.



DaltonST

[DaltonST]

Tanjamuse:

Is this what you wanted to see in the JS Tag Scrubbing Audit Log for table Tag Rules? Test the attached .zip and let me know.

JS Tag Scrubbing Audit Log

Choose Rules to Execute  (Sequence is Important):  Tag Rules  
  
Tag/Tag-Like Column Available to be chosen:   Scrub: All Tags & Tag-Like Custom Columns   
Tag/Tag-Like Column Available to be chosen:   Scrub: Tags   
Tag/Tag-Like Column Available to be chosen:   Scrub: #genre   
Tag/Tag-Like Column Available to be chosen:   Scrub: #lcead   
  
Choose Tag/Tag-Like Column:   Scrub: Tags  
  
.......................................................................................  
Applying ruleset:   Tag Rules    for: tags
Target Tables to be scrubbed:   tags   books_tags_link
Tag/Tag-Like Tags Found:   1107   for table: tags
  
Tag Purge Rules Being Applied to:   tags   books_tags_link
Scrub Tags: Purged:   0   for: tags  
  
Tag Change Rules Being Applied to:   tags   books_tags_link
  
Amidala69's "Turn and Face the Strange" Universe -->Harry Potter       new tag added to: tags
  
 Harry Potter   Inserted newtag to replace oldtag for book: 891 old: Amidala69's "Turn and Face the Strange" Universe  new: Harry Potter
Amidala69's "Turn and Face the Strange" Universe  Deleted oldtag for book: 891 old: Amidala69's "Turn and Face the Strange" Universe
Scrub Tags: Changes completed for:  tags   books_tags_link
..............................................................................................................................................................................

[Tanjamuse]

Sorry it took me so long to test, but yeah, that's exactly what I wanted.

[DaltonST]

Version 1.0.160 - 2019-06-21 Tag Scrubbing: Tag values (only) in CSV upload files with double-quotes now supported; Customize Tag Browser Icons: @User-Category sub-categories will be ignored; Python 3 performance improvements.



DaltonST

[Rellwood]

Hey there!

Was wondering if you could add a feature that could create a copy/paste file with selected column names in the format needed to add to tweaks or other areas where the need for column names in the format of u'#column_name',

The user can select the characters to add before and after the column names.

Makes it easier to fill in plugins, tweaks, and custom columns.

[DaltonST]

Originally Posted by Rellwood

Was wondering if you could add a feature that could create a copy/paste file with selected column names in the format needed to add to tweaks or other areas where the need for column names in the format of u'#column_name',.

You never need to put the Python 2 Unicode prefix u in front of a plugin's tweak. You should not even see that. Users should never be expected to deal with such a thing.

Apparently the recent changes to Calibre for Python 3 have caused some corruption of what a user sees in Preferences > Tweaks > Plugins. Never before did the u exist.

This is what my Calibre 3.44 Plugins > Tweak for "Library Specific Auto-Add Directories" now looks like:

job_spy_auto_add_directory  = {u'CalibreJobSpyTest5': u'x:/auto_add_dir5', u'CalibreJobSpyTest4':  u'x:/auto_add_dir4', u'CalibreJobSpyTest1': u'x:/auto_add_dir1',  u'CalibreJobSpyTest3': u'x:/auto_add_dir3', u'CalibreJobSpyTest2':  u'x:/auto_add_dir2'}

It used to never have the u's. The values were previously implicitly Unicode. For some reason they are now being shown by Calibre as explicitly Unicode. That is fine; they still work. However, users need specify only a simple '#column_name' without the leading explicit Unicode u prefix, then click "Save".



DaltonST