[mythtvnz] Free to Air BBC World on TV One - best way to 'inject' bbc.co.uk guide data after Freeview EPG update?

[Nick Rout]

On Mon, July 16, 2007 12:21 am, Wade Maxfield wrote:
>>
>>>>     Problem is I'm not aware of any hooks in myth which would enable
>>>> this,
>>>>     or even whether the BBC transmission is live-to-air or
>>>> timeshifted.
>>>>
>>>>
>>>>mythfilldatabase. You don't have to use Myth to grab the EIT data.
>>>>
>>>Right so have some external bash script or similar on a cron job
>>>grabbing data from the various sources and writing to the database?
>>>I was hoping to avoid over-riding the EIT gathering Myth does, just
>>>trigger a post-process operation which 'fills in the gaps' for the
>>>Beeb stuff.
>>
>>
>>Well, if you check out the Sky TV guide on their site, and compare
>>that to what you can actually see on TV One  one evening, and if it
>>looks about right then:
>>Use your dvb-s card, a grab_dvb script, and mythfilldatabase, and
>>massage the program table afterwards.
>>If you only define BBC world (1026.dvb.guide on my system) then when
>>you import, all the other channels data will be ignored. Then do a
>>REPLACE/SELECT from BBC World to TV One for the missing time period.
>>Call mythbackend --resched at the end of it all and you should be set.
>
> Well I was up late and testing something else with livetv, and
> happened to catch some stuff on BBC World/One.  It appears to be the
> same basic schedule on Normal BBC World (via Sky) as on TV One.  This
> was only a single sample, so I may be wrong.  Anyways below is a
> basic shell script/MySQL query, to copy the necessary data from the
> Sky version of BBC World to the TV One lineup.
>
> You'll need to figure out what the chanid for BBC World and TV One
> are in your particular channel table to make this work. Replace XXXX
> with the TV One chanid, and YYYY with the BBC World chanid.  Schedule
> this to run after every mythfilldatabase, and you're set. 8)


Now I guess then i need to be importing the BBC World programme data then=
?
But ignoring it?

Also, won't this fail when TV1 do actually have something on after
midnight (like they did with the maericas cup). The TV1 data won't be
deleted (because title <> "BBC World", but something from the BBC will be
written in there, creating potentially two porgrams on the same channel a=
t
the same time.

Or have I read your script worng?


>
> #!/bin/sh
>
> #
> # MySQL settings
> #
> HOST=3Dyourmythtvhost
> USER=3Dyourmythtvuser
> PASS=3Dyourmythtvpassword
> DB=3Dmythconverg
>
> mysql -u $USER -h $HOST --password=3D$PASS -e "
>
> DELETE FROM program WHERE title=3D"BBC World" AND chanid=3DXXXX;
>
> REPLACE INTO program
> (chanid,starttime,endtime,title,subtitle,description,category,category_=
type,airdate,stars,previouslyshown,title_pronounce,stereo,subtitled,hdtv,=
closecaptioned,partnumber,parttotal,seriesid,originalairdate,showtype,col=
orcode,syndicatedepisodenumber,programid,manualid)
> SELECT
> XXXX,starttime,endtime,title,subtitle,description,category,category_typ=
e,airdate,stars,previouslyshown,title_pronounce,stereo,subtitled,hdtv,clo=
secaptioned,partnumber,parttotal,seriesid,originalairdate,showtype,colorc=
ode,syndicatedepisodenumber,programid,manualid
> FROM program
> WHERE chanid=3DYYYY AND (time(starttime)>=3D"00:00:00" AND
> time(endtime)<=3D"06:00:00");
>
> " $DB
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz@lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>
>


--=20
Nick Rout