View Single Post
Old 05-01-2019, 06:49 PM   #4
Rellwood
Library Breeder (She/Her)
Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.Rellwood ought to be getting tired of karma fortunes by now.
 
Rellwood's Avatar
 
Posts: 1,278
Karma: 1937891
Join Date: Apr 2015
Location: Fullerton, California
Device: Paperwhite 2015 (2), PW 2024 (12 GEN), PW 2023 (11 GEN), Scribe (1st)
Quote:
Originally Posted by DaltonST View Post
You use Job Spy already, so try its new "Import CSV File to Update Metadata" tool instead of the other tool you are using in order to test whether it is your .csv encoding or your screen display font or the tool you used.

"Import CSV File to Update Metadata" is fully Unicode UTF8 compliant. See the images from when it was last enhanced, which include its tooltip user guide.

BTW, I will be upgrading all 61 JS tools for Python 3 and future Calibre 3.42+ compatibility in May.


DaltonSTShow Tooltip
Yes I use Job Spy, and I have tried to use the import csv, but it is too complicated and will not import unless each column has a defined column name.

Most of the csv files I import are broken down pieces of a single file. I use CSV chunker to break up 3500 to 5000 line files into pieces of 100 lines. Only the first page contains the headers. With the list import plugin, I just set up the columns once and each subsequent import doesn't need to be updated.

Plus, I am not sure how to import multiple columns at once. It looks like I can only import one named column at a time. Let me try it again, see if I am doing something wrong. Regardless, unless I can import files without the headers, then it won't work for my needs.

The GUI for import list is much easier than the GUI for import csv file on Job Spy.

I wish I knew how to use it better. It seems to offer a lot more than simple list importing. However, with the import list plugin I just match up columns in my library with the columns (or column number if there are no headers) with the csv and then I match up books in my library and select exactly which columns in my library to update with the data in the csv. It seems like your import list doesn't allow for that kind of choice. If I am reading the instructions right I am to match up only a single column, and then the import feature matches it to the books in the library and automatically makes the changes. I want more control over which books get changed with what metadata.

Most of my .csv files contain titles, series, series indexes, bookshelves, dates (added, read, updated, goodreads), genres, tags, etc. I need to be able to manually choose what books are being matched and manually select which columns to update.

Last edited by Rellwood; 05-01-2019 at 06:58 PM. Reason: more explainations
Rellwood is offline   Reply With Quote