@IslomMukhtorov said:
Data import
Hello, I want to transfer my movie viewing data from Trakt TV.
How can I import a JSON file?
Please help.

See here: https://www.themoviedb.org/settings/import-list

@ticao2 said: See here: https://www.themoviedb.org/settings/import-list

This is only for CSV files, which Trakt doesn't even provide. Trakt gives only JSONs

@Karmalakas said:

@ticao2 said: See here: https://www.themoviedb.org/settings/import-list

This is only for CSV files, which Trakt doesn't even provide. Trakt gives only JSONs

On the page I indicated there are two links to download the Trakt templates (v1, v2).
Does Trakt no longer export in these formats?

It's been JSON for as long as I've been using export and backups. At least a few years now 🤔

@Karmalakas said:
It's been JSON for as long as I've been using export and backups. At least a few years now 🤔

If they no longer export in their old models that we have, v1 and v2, then we can't help at the moment.
We'll leave this discussion open for admin Travis Bell to be aware of this change in Trakt.
Eventually, when he can, he'll do some kind of import.

Unless I'm misunderstanding the issue here, Trakt does provide for csv download, but just not from the main settings>data page...which is a FULL download. Instead you need to go to each data type (history, list, ratings, etc) and select the csv download icon for each list item

Screenshot with csv icon circled on right

But having said that, TMDB still says it's not the correct format

EDIT: Sorry I messed up the access for the link. Should be able to see it now.

@les017 said:
Unless I'm misunderstanding the issue here, Trakt does provide for csv download, but just not from the main settings>data page...which is a FULL download.
Instead you need to go to each data type (history, list, ratings, etc) and select the csv download icon for each list item

Screenshot with csv icon circled on right

But having said that, TMDB still says it's not the correct format

EDIT: Sorry I messed up the access for the link. Should be able to see it now.

We have both models of Trakt, v1 and v2.
https://www.themoviedb.org/settings/import-list
It would be necessary to check if they are in fact no longer exported.
Make a comparison with those that are currently exported.
Only one trakt user can do this. Export and compare.
If anyone can make this comparison, please tell the result here.
Sometimes it is a small modification, which can be manually corrected in the file.

So basically only Ratings CSV is suppported after removing the "runtime" column. Favourites and Watchlist are way too different

Oh that's interesting! Fortunately for me all I wanted to do was ratings anyway... both for tmdb data as well as the recommendations.

I'll try this and report back

Thanks for all you do!

I would love to be able to import not only ratings, but all of my lists and watch history too

@les017 said:

Oh that's interesting! Fortunately for me all I wanted to do was ratings anyway... both for tmdb data as well as the recommendations.

I'll try this and report back

Thanks for all you do!

I pulled an export from TMDB (Trakt v2) and compared to Trakt ratings export csv and found that in addition to eliminating the Trakt "run time" column, I also needed to insert 9 columns in the Trakt csv (season_number thru episode_tvdb_id) in between TMDB columns (released and genres)

TMDB still claims wrong format. I've compared column names for Column A thru Column V and can't see any difference

sigh....

@ticao2 said:

@les017 said:
Unless I'm misunderstanding the issue here, Trakt does provide for csv download, but just not from the main settings>data page...which is a FULL download.
Instead you need to go to each data type (history, list, ratings, etc) and select the csv download icon for each list item

Screenshot with csv icon circled on right

But having said that, TMDB still says it's not the correct format

EDIT: Sorry I messed up the access for the link. Should be able to see it now.

We have both models of Trakt, v1 and v2.
https://www.themoviedb.org/settings/import-list
It would be necessary to check if they are in fact no longer exported.
Make a comparison with those that are currently exported.
Only one trakt user can do this. Export and compare.
If anyone can make this comparison, please tell the result here.
Sometimes it is a small modification, which can be manually corrected in the file.

There's definitely been significant changes to the Trakt export format compared to the V1 and V2 templates available here, and hunting around the forums it looks like people have been asking about it for at least a couple of years (May 2021 someone reported that the v1 and v2 templates were outdated).

I'm a data engineer by day so I'm not expecting to have much trouble converting my exports to match one of the import templates, but if you're able to give me some requirements for your current import process I'd be happy to try and make it fit for you guys to take and use.

Turns out it's fairly straight-forward. Shuffle around some columns and get rid of a bunch of superfluous columns to make it match the v2 template and they'll load just fine.