RE: http://zz9.dnsq.org

["James Hoye" <james.hoye@xxxxxxx>]

> > So how does the TV Guide work?
>
> Ah yes, I was just about to reply to your e-mail, but I may as well do
it
> here.
>
> Basically, I have a bit of code which simply does a screen-scrape of a
TV
> Listings web site (anything will do, Yahoo, Digiguide, anything
> like that).
> I schedule a script to run every couple of days to pickup the latest
> listings, and then import them into a SQL Server database.
>
> The nice thing about having them in a database is that once I have TV
> listings in there, I can do pretty much anything with them... the
"Now and
> next" page on the site just does a DB query - It also means that
I can use
> the scheduling in Homeseer to automatically set-up voice
> reminders to remind
> me a few minutes before a program starts (Homeseer basically reads the
> database, speaks the reminder, then checks for the next thing on
> my "things
> to watch" list, and creates an event for the next one). 
Digiguide will do
> that, but not as flexibly (for example, "The house" knows
when I'm out, or
> asleep, so won't bother announcing programs then).

Now that IS a neat feature :)  Something I will DEFINITELY be looking at
once my ADSL is in place :)

> from missing Eastenders... If only I had a Tivo... :-)

I'm beginning to think that with the TiVo Ethernet port upgrade, TiVo
webserver giving you control via a browser (don't know exactly how much)
and
a TV guide in a SQL database, the TiVo subscription becomes a little bit
more redundant ;)

Technology how it should be - useful :)

Any chance of the ASP to scrape the TV listings?  I might convert it to
Cold
Fusion as I like it better than ASP!

James H