Add lists to .csv

Hi! Is it possible to add a column to the .csv export with all the lists the movie/show/episode is on?

Good idea.
I have many lists and would be good to see any Film/Show that is duplicated in different lists.
The only way I can do that now (that I know of) is download each list and then combine them and sort through them manually to find any duplicates.

I fell it would need to be shown as 1 column per list it is on, rather than 1 row per list as that would be a nightmare to sort out "duplicate film/show titles.

Big bump, this is a great idea.

Not a bad idea, but it’s kind of weird to have a one to many relationship in a flat CSV file. We wouldn’t want the have a different number of columns since that would make it tough to do anything programmatically.

What specific CSV file are you requesting this data for? It will also depend on performance.

Hi, I was hoping for this in the Watchlist CSV export.

Goodreads has a similar column in their CSV export for bookshelves (basically lists). I have an example if you want me to send it. I can’t upload .csv files to the forum.

Yes, please attach it to a support ticket so I can take look and see if we can do something similar.

Ticket #23127

Thank you, I’ll take a look.

I looked into this, and unfortunately the performance isn’t good enough to do it. It requires making a complex query for each item on the list, so the performance gets worse the more items on the list.

This would really need to be done on you side with some programming. Each list CSV could be parsed and a large data set could be created all the list items. The Trakt API should ideally be used instead of CSV files since that could be fully automated with the right script.

2 Likes

Thanks for taking a look into this. I really appreciate everything you do.

I have a spreadsheet that I use to manage all of my media (Trakt & Goodreads do most of the hard work), and other than sticking the CSV in there, it’s automated.

Really, thank you so much.