MobileRead Forums - View Single Post

tagehring · 02-21-2024, 07:29 PM

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.

There doesn't seem to be a way to correct the author_sort value this way at all.
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.
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.

02-21-2024, 07:29 PM	#598
tagehring Junior Member Posts: 8 Karma: 10 Join Date: Apr 2018 Location: Central Virginia Device: Boox Note Air 3	Can't get CSV import to work 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. There doesn't seem to be a way to correct the author_sort value this way at all. 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. 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. Attached Thumbnails Last edited by tagehring; 02-21-2024 at 07:33 PM. Reason: clarified attachments