tfonteyn/NeverTooManyBooks

[Feature Request] Goodreads csv compatibility

Closed this issue · 7 comments

Currently, the csv exported from Goodreads has a different format than NeverTooManyBooks, so when importing into NeverTooManyBooks, the information fields are not fully imported.

Is there a solution/script to make Goodreads csv format compatible with NeverTooManyBooks?

theoretically it's just a matter of changing (or adding) a header line with the correct field names.

I need to document the format/names really :-(

I've not looked at a goodreads csv file yet, but will do when I get some time.

It was raining a lot today... so I ended up implementing this.

Basic tests are importing fine, but my test data from Goodreads is limited to some 20 books I uploaded in the past.
Their own sample file from the their Import/Export is hopelessly out-of-date missing lots of columns👎

If you have a longer list and wish to share it, please upload it here and I'll test.

It's not finished yet though, it will take some more time - I need to figure out how to do updates.
Right now I can only import "New books only" (Skip existing) or "All books" (Overwrite).

I have an export from Goodreads and when I import it, the author information field is missing, with comment information field too. I also just tested the sample file in your cmt. Same issue.
Or perhaps I'll research a bit on json's structure of NeverTooManyBooks to see if it's possible to convert csv to json that compatible.

don't bother - that's what I wrote code to do for yesterday :-)
Converting the fields as was easy to add to my CSV importer.

The only thing really missing in the GR export file is a field with "last-updated" date. Without such a field it's not possible to do only updates to books. It's only possible to either skip or overwrite.

But now I need to improve on the first iteration of yesterdays work.

ok, functionality is now as complete as possible (but see last comment on "last-updated" date).
This feature will be in the next release.

I presume some (broken or weird) book data might give an issues, but I'll need to tackle those as-and-when they happen.
Importing from CSV is always a risk.

The only thing really missing in the GR export file is a field with "last-updated" date. Without such a field it's not possible to do only updates to books.

Anyway, when importing, i have to add a cover and make other small mod, so just set the last update date to the import time, please!

Here you go ... 6.0.0 apk

I've tested with current Goodreads CSV exports only - I just don't have older one. But should you come across any problems, then of course just log an issue and I'll look into it.