CSV import doesn't find accurate TV series

I have a table that goes like this:

watchlisted_at tvdb_id
2024-06-16T16:16:53 359274
2024-06-16T16:16:46 355229
2024-04-08T10:28:54 73838
2024-04-05T08:19:42 332331
2024-02-28T22:03:53 79501
2022-11-24T22:58:48 270915
2022-11-18T20:37:11 371806
2022-10-31T20:56:09 75450
2022-10-31T20:55:09 72023
2022-10-26T12:55:28 324918
2022-09-05T15:14:49 349310
2022-09-05T15:14:38 376122
2022-08-29T22:34:20 74543
2022-08-23T19:37:09 73752
2022-08-23T16:18:06 79488
2022-08-23T16:15:55 193131
2022-07-10T12:03:55 290508
2022-07-08T18:15:13 401922
2022-06-25T17:55:16 333072

After importing this using CSV option, I am end up with completely inaccurate results besides a few correct ones. Every value in tvdb_id is correct, you can check out which show it leads to (usually American, British quality series and not unknown). This is what I get on my account.

I have tried using IMDb values with finding their equivalents, but that method also gives the same weird shows/episodes. How could this be?

Trakt uses TMDB now so try changing the TVDB ids to TMDB ones.

2 Likes

Okay, I have just used this table and still getting all the inaccurate stuff. I just Googled a dozen of TMDB ids from the table and all seem to be correct but not importing accurately.

tmdb_id table
watchlisted_at tmdb_id
2023-03-01T08:02:43 1920
2022-10-31T20:55:09 1406
2022-05-18T21:35:12 1408
2020-08-26T22:18:11 1891
2020-08-26T22:18:11 1972
2023-07-09T09:29:30 888
2022-08-23T19:37:09 35935
2024-04-08T10:28:54 2004
2022-08-29T22:34:20 1940
2020-08-26T22:18:11 1430
2022-10-31T20:56:09 1274
2020-08-26T22:18:11 2382
2023-07-09T09:28:47 4586
2020-08-26T22:18:11 4087
2022-08-23T16:18:06 4608
2024-02-28T22:03:53 1639
2020-08-26T22:18:11 1705
2021-02-18T11:41:16 17035
2020-08-26T22:18:11 1409
2023-01-16T22:12:38 8358
2020-08-26T22:18:11 1621
2020-08-26T22:18:11 18347
2020-08-26T22:18:11 1436
2022-05-18T21:35:31 1426
2022-08-23T16:15:55 33907
2022-12-13T17:32:31 2947
2022-05-18T21:35:41 1407
2020-08-26T22:18:11 47665
2022-05-18T21:35:01 54671
2022-11-24T22:58:48 60574
2023-12-20T21:23:50 56017
2022-11-24T23:11:22 60948
2020-08-26T22:18:11 61746
2021-12-13T19:28:14 62084
2020-08-26T22:18:11 63639
2020-08-26T22:18:11 61222
2021-12-13T19:28:48 63351
2023-07-06T14:03:48 62560
2022-07-10T12:03:55 61859
2020-08-26T22:18:11 65708
2023-03-01T08:03:31 62017
2020-08-26T22:18:11 65494
2022-11-24T23:11:12 66276
2020-08-26T22:18:11 65495
2021-02-18T11:41:58 65817
2020-08-26T22:18:11 69478
2022-05-25T07:10:32 75191
2022-10-26T12:55:28 70541
2022-01-09T16:51:16 72339
2020-08-26T22:18:11 69740
2024-04-05T08:19:42 68421
1 Like

Which series are you importing though, because tvdb id 359274 = Vinland Saga = tmdb id 88803

I don’t see 88803 in your table.

also, you should be able to import with tvdb too, are you importing a csv file? these are the guidelines according to trakt:

Your CSV file should contain the following fields:

id: the ID can be a Trakt ID, IMDB ID or TMDB ID. For TV-shows it can also be a TVDB ID.
    The ID should be prefixed with the service name, i.e. trakt_id, imdb_id, tmdb_id, or tvdb_id.
watched_at: the date and time the item was watched. The format is ISO 8601.
    Can be omitted if only adding to your watchlist.
watchlisted_at: the date and time the item was added to your watchlist. The format is ISO 8601.
    Can be omitted if only marking as watched.
rating: the rating for an item. Needs to be a value from 1 to 10.
    This is an optional field.
rated_at: the date and time the item was rated. The format is ISO 8601.
    This will only be parsed if a rating is also present.

Example:

imdb_id,watched_at,watchlisted_at,rating,rated_at
tt0068646,2024-10-25T20:00:00Z,2024-10-01T10:00:00Z,7,2024-10-25T21:00:00Z
tt15239678,,2024-04-30T11:00:00Z
tt4281724,2024-01-12T02:00:00Z,

It’s weird though, because how does Trakt know whether you’re importing a movie or a tv show, I doubt the ids are unique, or are they.. hmnnn..

Yes, it’s a CSV file. I checked the guidelines and renamed headers and adjusted date formatting. Maybe this thread needs mentioning.

So, how can I correctly get TMDB ids for these series?

TVDB_id table
tv_show_name tvdb_id
Twin Peaks 70533
Deadwood 72023
House 73255
Rome 73508
Battlestar Galactica (2003) 73545
Spider-Man: The Animated Series 73750
Berserk 73752
Malcolm in the Middle 73838
Entourage 74543
Cosmos 74995
Six Feet Under 75450
Freaks and Geeks 76321
Gilmore Girls 76568
The X-Files 77398
30 Rock 79488
Heroes 79501
Fringe 82066
Generation Kill 82109
Sons of Anarchy 82696
Lie to Me 83602
Boardwalk Empire 84947
Community 94571
Justified 134241
Luther 159591
Downton Abbey 193131
Veep 237831
Homeland 247897
Black Sails 262407
Penny Dreadful 265766
Peaky Blinders 270915
Shtisel 271347
12 Monkeys 272644
Inside No. 9 276840
Poldark (2015) 280582
The Expanse 280619
BoJack Horseman 282254
Narcos 282670
Mr. Robot 289590
The Night Manager 290508
Taboo (2017) 292157
The Man in the High Castle 295829
The Crown 305574
The Night Of 310516
Atlanta 313999
The Deuce 317728
The Handmaid’s Tale 321239
The Terror 322191
Maximilian 324918
Happy! 328361
Ozark 329089
Altered Carbon 332331
Barry 333072
You 336924
Patrick Melrose 338946
Killing Eve 340959
Yellowstone (2018) 341164
Bodyguard (2018) 349310
DAVE 354905
Our Planet (2019) 355229
Doom Patrol 355622
For All Mankind 356202
Modern Love 357222
Seven Worlds, One Planet 359251
Vinland Saga 359274
Hostile Planet 361385
Dickinson 361566
The Dropout 363024
Greatest Events of World War II In Colour 364731
Pachinko 368124
The Great 369301
Mushoku Tensei: Jobless Reincarnation 371310
Normal People 371806
Slow Horses 372264
Unorthodox 376122
Ted Lasso 383203
Poker Face (2023) 398822
BEEF 399838
A Very British Scandal 401922
Silo 403245
ted 404604
Shrinking 411364
Oni: Thunder God’s Tale 419975
Scavengers Reign 421287
Copenhagen Cowboy 422702

It’s a long shot, but I think what if the tvdb_ids should map to episodes?

could you try importing just one line, with tvdb_id 7152184?
That maps to the first episode of Vinland Saga.
https://www.thetvdb.com/series/vinland-saga/episodes/7152184

Then the “mistake” is trying to import at series level instead of episode level.

though I still wonder how Trakt can tell if you want to import a movie or a series for tmdb, or is each ID unique… questions of life hahahah

Oh, that’s it. It tries to find episode id for every row, not whole series id.

1 Like

I suggest just looking up the series on Trakt and manually add them to your watchlist if that’s your goal! :slight_smile:

watchlist = your plan to watch list basically, if you add a series to it, and watch the first episode, it auto gets removed from your watchlist. And it will be in the Progress/Up Next (on your dashboard) instead.

Well, that’s what I was trying not to do since it’s 85 series. I could use 3rd party tools but import feature needs improvement. No one would import episodes as watch lists.

You can also try one import line with the tmdb 88803 for Vinland Saga I mentioned earlier, if the listin your second posts with the tmdb ids was complete, you didn’t get the right ID.

But if you have to look up the tmdb ids for series since I suppose you don’t have an export csv from there watch your watchlisted entries… It’ll be easier to just look up the series name on trakt (instead of themoviedb) and hit the green tick button to add to watchlist.
You could even change your settings so you don’t get the popup thingy to select which list you want to add it to, and you just press it and it instantly adds to watchlist.
:see_no_evil_monkey:

You can add a series to a list right from the search results~!

you can also import with the imdb ids btw, if your source has that maybe, but same there, if you have to look those up, you’re better off search on trakt and adding to watchlist manually.

Thanks a lot for recommendations. I did try with IMDb ids but I suppose with those it still tries finding episode ids leading to inaccurate importing.

Yeah, if it in both cases only matched episodes, than I think it indeed only works for episode ids on all database ids, along with movies.

Good luck and (I think) welcome to Trakt, since you’re importing! :waving_hand:

Oh thanks! I have been using it for couple years now. I had imported my data from another service through GDPR and third party script back in the day, but it didn’t support watch listed series so after learning official import feature thought I should try it out.

Hi there, as a test I tried exporting my watch history from one trakt account into another, using csv, and various combinations of IMDB ID, TraktID, and TMDB, it should be flawless, but I got the same results as you - thousands of watches of stuff I’ve never heard of, mixed in with some real data, I tried splitting out my shows/episodes from movies and it still went wrong - Either the import tool or the data export from Trakt is seriously flawed.
My interest in this is as I’m backing up my trakt data, I want to be confident that a recovery actually will work - as is I’m not.

1 Like