The Movie Database atbalsts
Atbalsts → Tīmekļvietnes atbalsts
Import Rotten Tomatoes csv
posted by mokiSTAFFMOD on septembris 25, 2020 at 9:02 AM
Hi, thanks to rotten-tomatoes-letterboxd I have finally been able to export my rottentomatoes.com-ratings to an csv. Sad to see that TMDB is not able to handle the csv so far. Could you pleas have a look into it? Here's my csv: wi. to/ 06ed09dc375b99a5
(sorry that you have to get the puzzle out of the url thanks to the spam detector here)
Atbilde no Travis Bell
on septembris 25, 2020 at 1:44 PM
Hey @moki, that export doesn't contain any IMDb or TMDb IDs, which makes it impossible for us to support as a format. Without an external ID, we have nothing to map the items to. This has always been the case with Letterboxd exports, and has been asked for by a number of users over the years.
If you can get an external ID added to the export (IMDB ID or TMDb ID) then I can add support for it.
Atbilde no moki
on septembris 25, 2020 at 9:11 PM
Thanks for your support so far. I understand the point - maybe it will be possible to use a database that has done that job before? I wrote a mail to Mike Fox who created flickmetrix - they have both the letterboxd-links and IMDB-ids for the movies in their database - Parasite for example.
Maybe you can get in touch with him and get the issue done together? Cinematics by 'kkings' and Movie Mate do the same job, it looks like its the same app under different names.
Atbilde no moki
on septembris 25, 2020 at 10:56 PM
Great news, we're close to get it solved. I installed TraktRater, imported the csv from rotten-tomatoes-letterboxd and so my Rotten Tomatoe list is now available both at Trakt and Letterboxd. Only TMDB is still missing ;)
TraktRater created a should-be-Trakt-csv, but the TMDB-importer can't handle it. Here it is.
Atbilde no moki
on oktobris 3, 2020 at 2:32 PM
Travis?
Atbilde no moki
on oktobris 9, 2020 at 11:35 AM
Well, at least after all it is possible to do this manually.
Warning: rotten-tomatoes-letterboxd isn't able to grab the exact date of watching. If you have watched X-Men 3 years ago, you'll find it as watched 3 years ago from today.
To those who get here: Download/use LibreOffice Calc to open the rated_movies.csv that you created using TraktRater. Now you have to fix the column-names as you see them in the Trakt v2 TMDB-example (e. g. TmdbId > tmdb_id), remove the 'Slug' column, create a 'type' column and fill it ('movies' in each and every column). Sort the columns as seen in the example by tmdb. Or do it the other way around: Empty the data within the template by TMDB and paste your data from the TraktRater-csv into it.
Now here comes the only step that I actually know that it is definitely necessary: Copy the data of the 'rating'-column to the 'trakt_rating'-column.
Save the .csv, go to import list at TMDB, select your .csv and grab a Snickers. In my case it worked for 100% of the movies.