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)
找不到电影或节目?登录并创建它吧。
Travis Bell 的回复
于 2020 年 09 月 25 日 1:44下午
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.
moki 的回复
于 2020 年 09 月 25 日 9:11下午
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.
moki 的回复
于 2020 年 09 月 25 日 10:56下午
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.
moki 的回复
于 2020 年 10 月 03 日 2:32下午
Travis?
moki 的回复
于 2020 年 10 月 09 日 11:35上午
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.