03-08-2019, 02:38 PM | #421 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
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. Last edited by DaltonST; 03-08-2019 at 02:40 PM. |
03-08-2019, 04:50 PM | #422 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.146
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 |
03-09-2019, 02:34 AM | #423 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Could you do the same to the scrubbing tools? Only scrub either marked or selected books?
Thank you so much for all the work. |
03-09-2019, 01:20 PM | #424 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.147 Changes to "Import CSV File to Update Metadata"
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 |
03-14-2019, 04:08 PM | #425 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.148 "Import CSV File to Update Metadata"
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 |
03-18-2019, 05:40 PM | #426 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.150 Upload Standard Columns: Comments, Identifiers, Publisher and Tags
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 Last edited by DaltonST; 03-20-2019 at 12:38 PM. Reason: (Source = template {id}) |
03-22-2019, 05:52 AM | #427 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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 |
03-22-2019, 09:30 AM | #428 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
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. |
03-22-2019, 09:52 AM | #429 | |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Quote:
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 |
|
03-22-2019, 06:31 PM | #430 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
[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 |
03-23-2019, 02:13 PM | #431 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.151 Enhancements to "Import CSV File to Update Metadata"
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 Last edited by DaltonST; 03-23-2019 at 02:15 PM. |
03-25-2019, 09:31 AM | #432 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.152 Enhancements to "Import CSV File to Update Metadata"
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 |
03-25-2019, 12:48 PM | #433 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
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?
|
03-25-2019, 01:09 PM | #434 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
The window is not tall. Perhaps "move" the top down, then resize from a corner...
|
03-25-2019, 01:29 PM | #435 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.153
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 Last edited by DaltonST; 03-25-2019 at 01:42 PM. |
Tags |
author aka, author pen name, colors, toolbag, toolbox, tools |
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] KindleUnpack - The Plugin | DiapDealer | Plugins | 492 | 10-25-2022 08:13 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 |