The feature definitely works, many CSV's are imported every day but let me check out your file here and let you know what I find out.

Ok, so the fix for reading your list is going live now. The CSV you were trying to import had an encoding that wasn't compatible, so the CSV parser couldn't read any of the text.

If you try now, you'll see that we can read it, but we're not able to detect the list type. Funny thing is, we don't support importing our own exported format. Let me spend a few more minutes and get that added. It's fairly simple obviously, because it's our own, but no one has ever wanted to do this before. You're the very first I've heard from.

@travisbell said: The CSV you were trying to import had an encoding that wasn't compatible, so the CSV parser couldn't read any of the text.

Was it related to national symbols in titles of movies? I'm sure that both CSV (exported and edited one) are UTF-8 with LF. And looks like LibreOffice Calc (used by me) don't change its format/encoding.

I bet, there should be users who want to backup their ratings and be able to import them back (e.g, make new account, if the old one is lost; batch edit in own software; compare with old exported lists; etc.). Maybe they are just shy to ask or not born yet :) But it will be a great opportunity for the future.

P.S. Thanks for the wonderful service.

Alright, give your export a go now. The only thing I'll mention is that I know there is one small issue when items don't have an IMDb ID. This is because the importer started as an IMDb list importer and evolved over time. In this case, it will show as imported but won't show the item (it will be blank). Other than that, you should be able to re-sync your ratings now.

Okay, I tried to import the same CSV https://www.themoviedb.org/settings/import-list/status/5da1f7dba1353300122fe915

Second try (all marked as already imported, so it works) https://www.themoviedb.org/settings/import-list/status/5da1fb4ce860170014ad63d2

But I still see old ratings everythere (already tried to log out and flush browser cache, cookies, local storage, etc.). Do I need to wait more? Maybe some kind of server side cache is interfering.

Example: https://www.themoviedb.org/movie/4953-be-kind-rewind

Still 10/10, must become 9/10

Let me double check that the rating value gets updated on an existing rating. I know I updated the logic last year to support updating the rating date, but maybe I missed updating the actual value.

Ok, try one more time. Ratings along with dates will get updated on subsequent imports.

@travisbell said:

Ok, try one more time. Ratings along with dates will get updated on subsequent imports.

Everything seems to work now, thank you very much!

P.S. Not really a problem, but it just might confuse someone. I changed all dates to 2019-10-15T12:00:00Z in original CSV. The result on the import page looks a little strange — it shows 15/1250 imported (in theory, either all or nothing should have shown imported?), but looks like all 1250 ratings updated as was expected.

https://www.themoviedb.org/settings/import-list/status/5da5fa76e6d3cc0015ab557a

Ya, in this case "imported" means that new data was created. Since the ratings already existed and you were just modifying some values, they don't get marked as imported. There's probably a better way to word that though.

In any case, happy to hear it's working.