[GUI Plugin] Job Spy

[DaltonST]

Originally Posted by gstock97

I have searched till my fingers bled. I am trying to figure out how to simply import my list of identifiers into my library. I am using a custom column (#shorttitle) as the match column. This is working correctly, however cannot seem to format my CSV in any manner in which I can import my amazon and ff identifiers. Here is a sample line from the CSV.

Any help with the formatting would be gratefully appreciated.

G

See the attached image ToolTips from the JS Thread.

Apparently, you are trying to add multiple Identifiers within a single CSV row cell. Check the CSV double quotes for that column. Also, your column header appears wrong; ID is the Calibre Book ID, an integer. You are trying to update Identifiers. See the image ToolTips. Also, you appear to be mixing single quotes and double quotes in the same CSV row. Be careful how you save your Calc spreadsheet with options re: always double-quote text cells. All cells should be double-quoted to separate them from the other cells in the same row. The single quotes of the data are entirely different. See the csv.txt file attached below.

I hope your are not manually editing your CSV file in a text editor; if so, switch to Calc/Excel to gain uniformity in your CSV.

The matching is working properly because that match column is the only column with proper syntax.

The lower right corner of the image, plus the original posts about this Tool, state that there is an example CSV file located in /../calibre/plugins/job spy/resources. That CSV is attached below.



DaltonST

[gstock97]

I've read the tooltips and I thought I followed the as specified, however I still can't get the syntax.

As for the identifier column. The tooltip specifies: 'type':'value' So I interpret it to mean 'amazon':'B012KKDI88'. Am I interpreting this incorrectly.

Another question, is the identifier column a text column?

As for editing, I've tried both, neither seem to work for me. (Using EditPlus and saving as UTF-8)

You mentioned single quotes and double quotes in the same CSV row. Could give me an example of how I would do my scenario and how it would look like in either Excel or text.?

[gstock97]

I've used your example and still can't get it to work. Attached is my Excel created CSV with a header row and 1 data row with 2 columns.

No matter what I do it kicks the error anyway.

I know I'm getting old and so is this, but not that old.

Thanks

[DaltonST]

Originally Posted by gstock97

I've used your example and still can't get it to work. Attached is my Excel created CSV with a header row and 1 data row with 2 columns.

No matter what I do it kicks the error anyway.

I know I'm getting old and so is this, but not that old.

Thanks

Your csv still is not saved from Excel with all cells double-quoted.

I guess you didn't compare your csv.txt to my attached example csv.txt.

I have given you the solution, but you have to apply it.


DaltonST

[gstock97]

Well I have tried to do as you requested. I even opened your csv in Excel and slightly modified it as a test and still no go. However when I save and look at the file in any text editor, I don't see the double quotes like you specify. I even tried externally modifying them to achieve the desired results, no go.

Excel offers 4 options for CSV's. I tried all except the macintosh version and none save them with double quotes on my PC natively. I can send you the files if you think it will help.

I even edited your original CSV in Excel and only modified the two columns values that I think I required as specified. So for you to think I haven't done as instructed or followed your guidance, then I guess I just chalk it up as a non-functioning feature for me.

Thanks for your effort.

[jmurphy]

Originally Posted by DaltonST

Your csv still is not saved from Excel with all cells double-quoted.
DaltonST

In his defense, the screen-shot you included (that had all the tooltips) CLEARLY shows that identifiers should be single-quoted.

[jmurphy]

Try this:


"#shorttitle","identifiers"
"William W JohnstoneBetter Off Dead","'amazon':'B012KKDI88','ff':'j/william-w-johnstone/better-off-dead'"

[gstock97]

@jmurphy

Thanks for the assist, but still no go. Below is the error output from yours.
CSV

"#shorttitle","identifiers"
"William W JohnstoneBetter Off Dead","'amazon':'B012KKDI88','ff':'j/william-w-johnstone/better-off-dead'"

Error Log

calibre, version 6.22.0
ERROR: JS+ GUI Tool: Identifiers: Format Error-invalid syntax. Perhaps you forgot a comma? (<unknown>, line 1) Value: {amazon':'B012KKDI88','ff':'j/william-w-johnstone/better-off-dead} --- identifiers must be in the format 'type':'val' (including the single quotes)

Tried to modify and remove the ff: identifier
CSV

"#shorttitle","identifiers"
"William W JohnstoneBetter Off Dead","'amazon':'B012KKDI88'"

Error Log

calibre, version 6.22.0
ERROR: JS+ GUI Tool: Identifiers: Format Error (') Value: amazon':'B012KKDI88 --- identifiers must be in the format 'type':'val' (including the single quotes)

Back to the original error. Again thanks for the assist.

gstock97

[DaltonST]

Originally Posted by jmurphy

In his defense, the screen-shot you included (that had all the tooltips) CLEARLY shows that identifiers should be single-quoted.

In your defense, clearly you are ignorant of CSV file-save options, and do not know how to view a CSV file in a Text Viewer to see the 'real' CSV data.

The double-quotes are for the CSV cells, not the data, as I stated. The double-quotes are inserted by Calc/Excel during the save-as file save option which I referenced. The ToolTips are about what you "see" in Calc/Excel.

Open a CSV file in a Text Viewer to see what the CSV file really looks like without being manipulated by Calc/Excel.

From the .../calibre/plugins/job spy/resources/ example CSV file, as viewed by NotePad. Note the Identifier column. Example cell: ,"'zmyid':'0123456789'",

Calc automatically added the double-quotes per the Save-As > Edit Filter options as shown in the attached image.


I added the single quotes in Calc, as shown in the ToolTips.

"#bookid","added","title ","publisher ","pubdate","comments","tags","identifiers","series","#genre","#myyesno","#myserieslike","#mycomments","#mytaglike"
"25489","2019-01-01","Title1","DaltonST","1960-01-01","These are comments with many commas , and ,, and ,,, and here too ,.","Fiction:Science-Classic,Fiction:Science-Space Opera","'zmyid':'0123456789'","Kzin[1]","Fiction:Science","true","MySeries[1]","These are my comments.","Factual:Autobiography"
"26100","2019-01-01","Title2","DaltonST","1960-01-01","These are comments with no commas but with "double-quotes".","Factual:Biography","'zmyid':'0123456789'","Kzin[0]","Factual:Biography","false","MySeries[2]","These are also my comments","Fiction:Romance"

All of the above has been previously described over the years. Nothing new here.



DaltonST

[ownedbycats]

Would it be much effort to show composite text columns in 'visualize metadata'? I would like to compare my read-status column.

[Comfy.n]

Hi, today I noticed this in my calibre-debug log:

Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? True
Last time daemon started: never
Last time daemon failed: never
Total daemon starts inception_to_date: 0
Total daemon failures inception-to-date: 0
JS: ===>>> change_gui_alternating_row_colors()
wildcard specified in Job Spy last-viewed tool active library names, which includes: mylib
>>>[2] update_last_viewed_custom_column_automatically_con trol with source: initialization_complete 'method' object is not connected
Job Spy has finished initialization...

Probably harmless, but I thought I should report. Only JS feature I use regularly is the last-viewed tool.

[Comfy.n]

Originally Posted by ownedbycats

Would it be much effort to show composite text columns in 'visualize metadata'? I would like to compare my read-status column.

I like to check the timestamp visualization, from time to time. There's a noticeable spike in my books adding from May to August every year, not sure why.

[Rellwood]

Is there any way you can offer a feature that would allow laymans terms for other plugins. The plugins that have .json files such as Goodreads Sync, or Tag Mapper. It's hard to see all the rules for each plugin but it there was a copy or something that I could read off line and outside the plugin its easier to see what there is, especially if I could see them in human read form. Does this make sense?

[jtmart]

Hi Dalton,

Your plugin works fantastically well, thank you for this!

My only longstanding issue is that when I click on the "Change the GUI text and Alternating row colors" nothing happens and the dialog box does not open (see image below). The other panes do open upon click, so the issue pertains to that menu entry only. The Calibre debug logs do not indicate anything problematic (see image).

This issue has been persistent for me for many years (five-six), on many versions of your plugin, both on Linux (Arch) and Windows (10/11) machines.

Do you have an idea on how to fix this?

Thanks for all your work,

Jean-Thomas

[BetterRed]

Moderator Notice

@jtmart - regarding image sizes, see ==>> Guideline #9

BR