[mythtv-users] XmlTV

[Chris Hembrow]

After putting my original post together, I put together an SQL script
which I run via a cron job after mythfilldatabase has finished. This
script copies this programs from 1 channel into another, adding an
hour. It references the channels from the freqid (which is my sky
channel number). I've attached the script for anyone it might help.
This script is run using:
mysql -u mythtv -pmythtv -D mythconverg < plus1.sql

Joe, If I'm reading this right, this is a post-processing operation,
for after mythfilldatabase has occured? What sort of assistance would
you be looking for? Would you just want me to test your code? To be
honest, I am loathe to upgrade at the moment, as I have a stable
0.18.1 release running on 1 backend and 3 frontends. My wife would be
VERY unhappy if I broke this. However, I should be able to set up an
old box as a completely separate backend if necessary, but this will
not be for a few weeks, due to decorating commitments :(

Thanks
Chris

On 4/8/06, Joe Votour <joevph at yahoo.com> wrote:
>
>
> --- Chris Hembrow <chris.hembrow at pixelseventy2.net>
> wrote:
>
> > Hi
> >
> > my xmltv gets it's feed from the radiotimes site.
> > Unfortunately, when
> > Sky add a plus-1 hour-late repeat channel, the
> > radiotimes don't always
> > add them to their feed. This happened a while ago
> > with Paramount
> > Comedy, and a not long ago with the Sci-Fi channel.
> >
> > Is there anyway to make xmltv pick up a regular
> > channel, but change the times?
> >
> > thanks
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> >
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
> If you're saying that the channel data is correct, but
> all shows are offset by a certain time (i.e. one
> hour), then there might be some hope.
>
> Committed about two weeks ago to SVN was a patch that
> I did for DataDirect sources that fixes this issue.
> The listings for my cable provider on some channels
> are three hours off, but are fine on half of the
> channels.
>
> Unfortunately, I could only do this for DataDirect
> listings because I couldn't get any XMLTV grabbers
> working for testing data.  However, if you are willing
> to assist me (in a mostly non-coding manner, unless
> you want to code), then I might be able to finish it
> for XMLTV sources as well (the code path is
> different).
>
> Note that the fix won't take data, clone it, modify
> the times and put it in the database, it just modifies
> existing times downloaded.  That means that the
> channel/data must already exist.  (The Trac entry for
> reference is 713.)
>
> -- Joe
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: plus1.sql
Type: text/x-sql
Size: 1311 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060409/60f3c7ae/attachment.bin