07-01-2023, 03:45 PM | #1096 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
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 Last edited by DaltonST; 07-01-2023 at 04:05 PM. Reason: Corrections. New attachment from calibre/plugins/jobspy/resources |
|
07-01-2023, 04:11 PM | #1097 |
Member
Posts: 14
Karma: 10
Join Date: Sep 2015
Device: Kindle Oasis
|
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.? |
Advert | |
|
07-01-2023, 04:37 PM | #1098 |
Member
Posts: 14
Karma: 10
Join Date: Sep 2015
Device: Kindle Oasis
|
Still lost
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 |
07-01-2023, 05:10 PM | #1099 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
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 |
|
07-01-2023, 07:53 PM | #1100 |
Member
Posts: 14
Karma: 10
Join Date: Sep 2015
Device: Kindle Oasis
|
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. |
Advert | |
|
07-01-2023, 10:56 PM | #1101 |
Zealot
Posts: 100
Karma: 1133068
Join Date: Sep 2007
Device: ipaq
|
|
07-01-2023, 11:27 PM | #1102 |
Zealot
Posts: 100
Karma: 1133068
Join Date: Sep 2007
Device: ipaq
|
Try this:
"#shorttitle","identifiers" "William W JohnstoneBetter Off Dead","'amazon':'B012KKDI88','ff':'j/william-w-johnstone/better-off-dead'" |
07-02-2023, 07:41 PM | #1103 | ||||
Member
Posts: 14
Karma: 10
Join Date: Sep 2015
Device: Kindle Oasis
|
@jmurphy
Thanks for the assist, but still no go. Below is the error output from yours. CSV Quote:
Quote:
CSV Quote:
Quote:
gstock97 |
||||
07-04-2023, 12:32 PM | #1104 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Open a CSV file in a Text Viewer to see what the CSV file really looks like
Quote:
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. Code:
"#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" DaltonST |
|
07-18-2023, 06:18 PM | #1105 |
Custom User Title
Posts: 8,848
Karma: 62032373
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Would it be much effort to show composite text columns in 'visualize metadata'? I would like to compare my read-status column.
|
07-18-2023, 06:58 PM | #1106 |
want to learn what I want
Posts: 1,051
Karma: 6422750
Join Date: Sep 2020
Device: Calibre E-book viewer
|
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. |
07-18-2023, 07:25 PM | #1107 |
want to learn what I want
Posts: 1,051
Karma: 6422750
Join Date: Sep 2020
Device: Calibre E-book viewer
|
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.
|
07-24-2023, 06:53 PM | #1108 |
Library Breeder (She/Her)
Posts: 1,171
Karma: 1900479
Join Date: Apr 2015
Location: Fullerton, California
Device: Kobo Aura HD (1) PW3 (4) PW3 2019 new edition (1)
|
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?
|
08-29-2023, 03:49 AM | #1109 |
Junior Member
Posts: 3
Karma: 10
Join Date: Jul 2021
Device: Boox Note Air
|
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 Last edited by BetterRed; 08-29-2023 at 05:56 AM. Reason: screenshot image too big |
08-29-2023, 06:01 AM | #1110 |
null operator (he/him)
Posts: 20,686
Karma: 26966376
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
|
Tags |
author aka, author pen name, colors, toolbag, toolbox, tools |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] KindleUnpack - The Plugin | DiapDealer | Plugins | 494 | 05-18-2024 02:34 AM |
[GUI Plugin] Ex Libris | AlPe | Plugins | 87 | 10-10-2020 03:10 PM |
[GUI Plugin] Marvin XD | Philantrop | Plugins | 126 | 01-29-2017 12:48 PM |
Ubuntu/Linux : Command to schedule a job with Calibre.( No GUI ) | DurgaPrasad | Calibre | 0 | 10-16-2013 06:50 AM |
[GUI Plugin] Plugin Updater **Deprecated** | kiwidude | Plugins | 159 | 06-19-2011 12:27 PM |