TraktRater icon indicating copy to clipboard operation
TraktRater copied to clipboard

Generic CSV import

Open umbilicalbungee opened this issue 11 years ago • 14 comments

Would it be very hard to add an option to upload from a local csv file? I have copied my Netflix ratings into a file with Title, Year, and 5 Star Rating and would like to upload them. I found this tool https://code.google.com/p/trakt-tv-list-importer/ , but it doesn't do ratings!

Thanks.

umbilicalbungee avatar Feb 05 '14 04:02 umbilicalbungee

The tool does support local csv file, but only in IMDb's format.

You could setup an account on IMDb, rate a few movies and then download the CSV file so you know the format. After that you can adjust it to your custom one from netflix. One obvious thing you will need to do is ensure you have the rating doubled as Trakt/IMDb is 10scale.

damienhaynes avatar Feb 05 '14 04:02 damienhaynes

I could add an option for Netflix if it has support for export to CSV or an online API where I can get all the information required.

damienhaynes avatar Feb 05 '14 04:02 damienhaynes

Netflix doesn't seem to have any kind of API that allows exporting, so I just copied out the data by hand.

Ok sorry, now I see the csv import! So I used an IMBD rating file as a template, multiplied my ratings by 2 and pasted them in with the title and year (all I could get off the Netflix screen scrape).

The importer says "IMDB: object reference not set to an instance of an object" in red and then says complete, but looks like my tract.tv account is still empty. Does it require IMDB IDs or anything like that? Is there anyway to get a log file form the import to see which ones were imported (assuming any were) and which might have failed?

Thanks for your help.

umbilicalbungee avatar Feb 05 '14 04:02 umbilicalbungee

No logging yet :(

I'm not at home right now, but from memory I think it expects to have an IMDb ID also since its coming from IMDb.

damienhaynes avatar Feb 05 '14 04:02 damienhaynes

If adding IMDb IDs are not that simple and defeats the purpose I can look at just creating a generic importer for CSV which can rely on IMDb or TITLE+YEAR.

damienhaynes avatar Feb 05 '14 04:02 damienhaynes

That would be awesome! I successfully imported a huge list with https://code.google.com/p/trakt-tv-list-importer/ using Title and Year, but like I said it doesn't do ratings, or mark as watched! It did report a small list of titles that didn't import. I don't know if it would help to look at or use some of his code. I wish I knew more coding and could help. I'd be happy to to testing though.

While I'm at it, it would be great to have a tool that would export lists in IMDB format from trakt. I've been looking and looking, and their API seems to allow it, but I can't understand why no one seems to have made such a tool. Any Ideas?

umbilicalbungee avatar Feb 05 '14 05:02 umbilicalbungee

it would be great if we could import simple csv format like this... imdb ids separated by enter or anything

tt0100150 tt0120863 tt0238380 tt0181288

co5mo avatar Apr 06 '15 20:04 co5mo

I have added support for generic csv import where only ImdbIds are used. It is available here.

I can make a Pull Request when @damienhaynes has looked at PR #69

glenngr avatar Oct 16 '17 19:10 glenngr

is the generic csv import in latest exe rls please?

co5mo avatar Sep 02 '18 17:09 co5mo

Netflix lets you export your watch history in .csv format. the column headers are Title and Date is that enough for you to work with?

tehniemer avatar Aug 21 '19 01:08 tehniemer

Its not ideal, but yes it can work as long as the Title and Year matches Trakt data. Have you got an example CSV you can attach here?

damienhaynes avatar Aug 21 '19 01:08 damienhaynes

Here's a snippet of my history, looks like the date is the date watched, not the release year. NetflixViewingHistorySnippet.zip

tehniemer avatar Aug 21 '19 01:08 tehniemer

what format is supported when using name and year?

co5mo avatar Sep 02 '19 14:09 co5mo

Hi, is there any way to import these csv files with TrakRater into Trakt.tv? What I have to do? How should they be modified? These are exports from filmweb.pl. ratings_whatchlist.zip

husk007 avatar Nov 10 '20 14:11 husk007