View Single Post
Old 02-22-2024, 08:26 AM   #601
tagehring
Junior Member
tagehring began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Apr 2018
Location: Central Virginia
Device: Boox Note Air 3
Quote:
Originally Posted by tagehring View Post
I have a CSV file with columns for UUID, title, author, and author_sort for each of the books in my library that I've manually corrected in Excel from catalog output. I've tried using Import List to import the corrections via CSV file but have run into a few problems.
  1. There doesn't seem to be a way to correct the author_sort value this way at all.
  2. If the author field has significantly changed, Import List returns an error even if the title is identical. When I use the plugin to match the CSV row to the book, it doesn't overwrite the correct author information from the CSV file.
  3. To solve #2 another way, despite manually matching the "ID" column of my CSV file to the ID:uuid identifier, I cannot get it to index using uuid. Every row returns an error. (See attached.)
I am at my wit's end trying to get this to work. Any help is appreciated.
Adding screenshots of the problem after fixing #2 above. I'm trying to map the author_sort to a user-created Author Sort column, I know it's not the default author_sort metadata tag. But I would prefer overwriting the default author_sort via CSV if possible.
Attached Thumbnails
Click image for larger version

Name:	2024.02.22-081935-Import Book List.jpg
Views:	29
Size:	666.8 KB
ID:	206525   Click image for larger version

Name:	2024.02.22-081947-Import Book List.jpg
Views:	26
Size:	475.9 KB
ID:	206526   Click image for larger version

Name:	2024.02.22-082032-calibre — __ Calibre Library __.jpg
Views:	24
Size:	570.1 KB
ID:	206527  

Last edited by tagehring; 02-22-2024 at 08:29 AM.
tagehring is offline   Reply With Quote