TV metadata source? - AVS | Home Theater Discussions And Reviews
Baselworld is only a few weeks away. Getting the latest news is easy, Click Here for info on how to join the Watchuseek.com newsletter list. Follow our team for updates featuring event coverage, new product unveilings, watch industry news & more!


Forum Jump: 
Thread Tools
post #1 of 10 Old Yesterday, 06:23 AM - Thread Starter
Advanced Member
 
cc_in_oh's Avatar
 
Join Date: Apr 2009
Location: NE OH
Posts: 554
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 90 Post(s)
Liked: 22
TV metadata source?

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,

CC

Who knew "flammable" and "inflammable" mean the same thing???
cc_in_oh is online now  
Sponsored Links
Advertisement
 
post #2 of 10 Unread Yesterday, 06:37 AM
AVS Special Member
 
jriver's Avatar
 
Join Date: Nov 2001
Location: Minneapolis
Posts: 1,512
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 65 Post(s)
Liked: 42
The program you use to play TV should have some options.

Jim Hillegass / JRiver Media Center
jriver.com or Owners Thread at AVSForum
jriver is offline  
post #3 of 10 Unread Yesterday, 06:53 AM - Thread Starter
Advanced Member
 
cc_in_oh's Avatar
 
Join Date: Apr 2009
Location: NE OH
Posts: 554
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 90 Post(s)
Liked: 22
Quote:
Originally Posted by jriver View Post
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...

CC

Who knew "flammable" and "inflammable" mean the same thing???
cc_in_oh is online now  
post #4 of 10 Unread Yesterday, 12:28 PM
Member
 
w1retap's Avatar
 
Join Date: Oct 2011
Location: Michigan
Posts: 182
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 43 Post(s)
Liked: 37
w1retap is offline  
post #5 of 10 Unread Yesterday, 12:41 PM
AVS Special Member
 
LastButNotLeast's Avatar
 
Join Date: Feb 2007
Location: 08077
Posts: 5,513
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 564 Post(s)
Liked: 415
http://www.imdb.com/title/tt0395843/?ref_=fn_al_tt_1
?

Did you really need to quote that entire post in your reply?
Downloadable FREE demo discs: Demonstration Blu-Ray Discs (Independently Authored)
fixed: Welcome to AVS - Get out while you still can!
LastButNotLeast is offline  
post #6 of 10 Unread Yesterday, 01:01 PM - Thread Starter
Advanced Member
 
cc_in_oh's Avatar
 
Join Date: Apr 2009
Location: NE OH
Posts: 554
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 90 Post(s)
Liked: 22
Quote:
Originally Posted by w1retap View Post
Thanks but those don't appear to be even as useful as epguides.com (which links to tvrage for individual episode info)

Quote:
Originally Posted by LastButNotLeast View Post
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...

CC

Who knew "flammable" and "inflammable" mean the same thing???
cc_in_oh is online now  
post #7 of 10 Unread Today, 09:34 AM
Member
 
w1retap's Avatar
 
Join Date: Oct 2011
Location: Michigan
Posts: 182
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 43 Post(s)
Liked: 37
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
w1retap is offline  
post #8 of 10 Unread Today, 12:21 PM
AVS Special Member
 
LastButNotLeast's Avatar
 
Join Date: Feb 2007
Location: 08077
Posts: 5,513
Mentioned: 4 Post(s)
Tagged: 0 Thread(s)
Quoted: 564 Post(s)
Liked: 415
Quote:
Originally Posted by cc_in_oh View Post
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...
Is this all you need?
https://en.wikipedia.org/wiki/List_of_CSI:_NY_episodes

Did you really need to quote that entire post in your reply?
Downloadable FREE demo discs: Demonstration Blu-Ray Discs (Independently Authored)
fixed: Welcome to AVS - Get out while you still can!
LastButNotLeast is offline  
post #9 of 10 Unread Today, 12:40 PM - Thread Starter
Advanced Member
 
cc_in_oh's Avatar
 
Join Date: Apr 2009
Location: NE OH
Posts: 554
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 90 Post(s)
Liked: 22
Quote:
Originally Posted by LastButNotLeast View Post
Thanks but no descriptions as far as I can see.

Epguides gives me a cleaner episode list - the problem is having to drill down one by one to see descriptions.

CC

Who knew "flammable" and "inflammable" mean the same thing???
cc_in_oh is online now  
post #10 of 10 Unread Today, 06:18 PM - Thread Starter
Advanced Member
 
cc_in_oh's Avatar
 
Join Date: Apr 2009
Location: NE OH
Posts: 554
Mentioned: 1 Post(s)
Tagged: 0 Thread(s)
Quoted: 90 Post(s)
Liked: 22
Quote:
Originally Posted by w1retap View Post
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 <ctrl>A making the copy/paste much easier...

CC

Who knew "flammable" and "inflammable" mean the same thing???
cc_in_oh is online now  
Sponsored Links
Advertisement
 
Reply Home Theater Computers



Forum Jump: 

Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off