Generic CSV import

[umbilicalbungee]

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.

[damienhaynes]

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]

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.

[umbilicalbungee]

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.

[damienhaynes]

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]

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.

[umbilicalbungee]

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?

[co5mo]

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

tt0100150
tt0120863
tt0238380
tt0181288

[glenngr]

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

[co5mo]

is the generic csv import in latest exe rls please?

[tehniemer]

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?

[damienhaynes]

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?

[tehniemer]

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

[co5mo]

what format is supported when using name and year?

[husk007]

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