AVS Forum banner
1 - 10 of 10 Posts

·
Registered
Joined
·
2,518 Posts
Discussion Starter · #1 ·
Hi all, first visit to this subforum and apologize if at all off-topic for it.

I use Excel (Win7) to generate my TV recording schedule. For years I fed it from the ZAP2IT custom schedule tool. When they canned it the best new source I could find was TitanTV. Aside from the hassle of having to copy/paste 14 separate days instead of full weeks, it doesn't include episode descriptions. So I'm looking for some help finding a source for TV episode descriptions. I don't want a scraper, just a flat list I can download or copy/paste into Excel. Epguides.com would be OK if it included a description column, even though I would have to do one series at a time.

As a last resort I could create a folder with a dummy file for every episode, use a scraper to construct the 15K-ish XML files, and parse into Excel, but needless to say I'm hoping someone here might be able to suggest a better alternative...

Thanks,
 

·
Registered
Joined
·
2,518 Posts
Discussion Starter · #3 ·
The program you use to play TV should have some options.
Sorry, I should have clarified - I don't want the descriptions as metadata, I need them in my database to confirm the identity of episodes. For example, a while back I started recording CSI NY reruns on TNT. Sometimes the episode that aired at a given time was not the one on my schedule. Having a description handy makes it easier to verify the title as I'm editing the recording...
 

·
Registered
Joined
·
2,518 Posts
Discussion Starter · #6 ·
Thanks but those don't appear to be even as useful as epguides.com (which links to tvrage for individual episode info)

Thanks - this looks more promising, assuming the listing is consistent enough to be parsed (e.g. same number of rows per episode, with ID and desc always in same relative position). It does paste in OK despite the messy html screen image. One line per episode and all seasons in one list would be much easier than one at a time but maybe that's too much to expect...
 

·
Registered
Joined
·
210 Posts
Another option might be TheTVDB's API. You could pull the metadata you need all from one place and have it dump into a CSV or Excel file. I used it back in college for a web design project and it worked well. I had a project where it pulled all the future TV shows by channel/date and sorted them. But, you'll probably need to know PHP and SQL if you're handy with those languages.
http://thetvdb.com/
http://thetvdb.com/wiki/index.php?title=Programmers_API
 

·
Registered
Joined
·
2,518 Posts
Discussion Starter · #10 ·
Another option might be TheTVDB's API. You could pull the metadata you need all from one place and have it dump into a CSV or Excel file. I used it back in college for a web design project and it worked well. I had a project where it pulled all the future TV shows by channel/date and sorted them. But, you'll probably need to know PHP and SQL if you're handy with those languages.
http://thetvdb.com/
http://thetvdb.com/wiki/index.php?title=Programmers_API
Thanks - that looks like another good possibility.

I also found a site episodedata.com that lists all seasons of a show at once. 4 rows per episode plus season headers but looks clean enough to parse. And it selects correctly with A making the copy/paste much easier...
 
1 - 10 of 10 Posts
Top