Skip to content

CSV Import of 'Read' books drops rating and notes #150

Description

@novy06

Title: CSV and Goodreads import silently drops rating and notes, no error shown

Summary: Importing books via the native CSV format or the Goodreads-format CSV import successfully creates books with all fields except rating and notes — those two are silently dropped with no error, even though they're part of the documented import format.

Steps to reproduce:

Add a book manually via the UI, giving it a star rating and a note.
Export your library to CSV (Settings → Export). Confirm the exported row has the rating and note populated correctly.
Delete that book.
Re-import that exact same exported CSV row.
Check the book — rating and notes are both empty. The import reports success ("Imported 1/1 books.") with no error or warning.

Also reproduces via Goodreads-format import, using an equivalent CSV built from Goodreads' own column format (My Rating, Private Notes, Exclusive Shelf), confirming this isn't a native-CSV-format-only issue — both import code paths appear to skip these two fields.

Expected behavior: Rating and notes should be written on import, matching what's documented at /docs/Features/Import-export-books, and matching what export produces.

Actual behavior: Both fields are silently ignored; no error surfaces in the UI or in docker logs booklogr-api.

Additional notes:

Verified this isn't a CSV formatting/quoting issue — the exact file the app itself exported fails to reimport correctly.
Verified via direct DB inspection (psql) that rating is stored as NULL and no rows are created in the notes table for affected books.
The lack of any error message or partial-import count (just a flat "import failed" with no detail) made this hard to diagnose — better per-row error reporting would help future users hit this same issue.

export_260727_aJUNz6QX.csv

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions