Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 03-08-2019, 02:38 PM   #421
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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.
DaltonST is offline   Reply With Quote
Old 03-08-2019, 04:50 PM   #422
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
Old 03-09-2019, 02:34 AM   #423
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,136
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.
Tanjamuse is offline   Reply With Quote
Old 03-09-2019, 01:20 PM   #424
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
Old 03-14-2019, 04:08 PM   #425
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
Attached Thumbnails
Click image for larger version

Name:	js_import_csv_tool_version_10148.jpg
Views:	24
Size:	1.21 MB
ID:	170224  
DaltonST is offline   Reply With Quote
Old 03-18-2019, 05:40 PM   #426
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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})
DaltonST is offline   Reply With Quote
Old 03-22-2019, 05:52 AM   #427
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,136
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
Tanjamuse is offline   Reply With Quote
Old 03-22-2019, 09:30 AM   #428
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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.
DaltonST is offline   Reply With Quote
Old 03-22-2019, 09:52 AM   #429
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,136
Karma: 5306
Join Date: Jan 2014
Device: none
Quote:
Originally Posted by DaltonST View Post
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
Tanjamuse is offline   Reply With Quote
Old 03-22-2019, 06:31 PM   #430
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
[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 is offline   Reply With Quote
Old 03-23-2019, 02:13 PM   #431
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
Attached Thumbnails
Click image for larger version

Name:	js_import_csv_to_update_metadata_version10151.jpg
Views:	9
Size:	228.2 KB
ID:	170354  

Last edited by DaltonST; 03-23-2019 at 02:15 PM.
DaltonST is offline   Reply With Quote
Old Yesterday, 09:31 AM   #432
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
DaltonST is offline   Reply With Quote
Old Yesterday, 12:48 PM   #433
Tanjamuse
Wizard
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 1,136
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?
Tanjamuse is offline   Reply With Quote
Old Yesterday, 01:09 PM   #434
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
The window is not tall. Perhaps "move" the top down, then resize from a corner...
DaltonST is offline   Reply With Quote
Old Yesterday, 01:29 PM   #435
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,396
Karma: 101268
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
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
Attached Thumbnails
Click image for larger version

Name:	2019-03-25 12_34_13-JS+ GUI Tool_  Import CSV File to Update Metadata.jpg
Views:	5
Size:	182.8 KB
ID:	170387  

Last edited by DaltonST; Yesterday at 01:42 PM.
DaltonST is offline   Reply With Quote
Reply

Tags
colors, toolbag, toolbox, tools

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] KindleUnpack - The Plugin DiapDealer Plugins 412 04-24-2018 06:07 PM
[GUI Plugin] Ex Libris AlPe Plugins 75 09-13-2017 04:28 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


All times are GMT -4. The time now is 10:59 PM.


MobileRead.com is a privately owned, operated and funded community.