I have a database of watched movies from 2005 to 2014. In 2014 I started using trakt, and I did not keep my database updated. However, I often find myself checking trakt now to see if or when I have seen a movie in the past, but it’s a bummer that this doesn’t include my history from 2005 to 2014.
Is there any way to import this data, for example as a .csv to my watched history? It’s an SQL database, so shaping the data into the necessary format shouldn’t be too much trouble.
We don’t have a direct import, but the Trakt API can be used to do this if you know how to code. There are also projects like TraktRater that can import certain formatted CSV files.
Sadly my coding capabilities are limited and fairly outdated. I can work my way around PHP (yes I’m that old), R, and a little bit of Python, but so far any scripts I’ve looked at were very overwhelming and I don’t think I’ll have the time to work myself into those.
It would be wonderful if there was some kind of simple script that I can run once to import my stuff, and that gives an example file of how my data needs to be formatted. That’s something I would easily be able to handle.
If it helps, this is the format of the data at the moment with 2 examples (can be adjusted):
title
release_year
watched_on
title_year
Chocolat
2000
2005-03-31 22:22:00
Chocolat (2000)
Låt den rätte komma in
2008
2008-11-08 20:25:17
Låt den rätte komma in (Let the right one in) (2008)
There are 928 movies in this list that I would like to import to my trakt profile.