[mythtv-users] Channel 4HD leaving Freesat EPG Tomorrow (UK)

[jksjdevelop]

On 21/02/18 14:01, Mike Bibbings wrote:
> On 21/02/18 13:24, jksj wrote:
>> On 21/02/18 12:50, Andre Newman MythTV wrote:
>>> Hi, seems we will no longer have Channel 4 HD in the Freesat epg 
>>> from tomorrow, the very short notice reeks of a contract dispute to me.
>>>
>>> I heard from a friend there that the transmission will still be FTA, 
>>> unencrypted, I’m also hoping there is some basic eit (now & next) 
>>> still in the stream, that way MythTV may well continue to work well 
>>> enough. There’s always xmltv if there’s no eit or Freeview HD, 
>>> luckily I can get both, I dropped enough hints that they should 
>>> leave some vestigial eit in there but will see when the Freesat epg 
>>> data runs out on Saturday.
>>>
>>> Just a heads up for Freesat people in the UK.
>>>
>>> Andre
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>> MythTV Forums: https://forum.mythtv.org
>>
>> Presumably it is possible to copy the EIT data from the Chanel 4 SD 
>> feed, does anybody have an appropriate bit of SQL?
>
> I don't recommend using sql (too easy to make a mistake!)
>
> There is an old (very old)  for mythtv 0.24  script which may do the 
> job see  https://www.mythtv.org/wiki/Cross-eit.py
>
> It outputs the data from a chanid to an xml file which  can  be read 
> into database via mythfilldatabase --file --xmlfile <your file name> 
> --sourceid <n>
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
ok that works :-)
To clarify
Find the chanid for Channel 4 London on Freesat.

select serviceid,channum,mplexid,sourceid,callsign,chanid from channel 
where serviceid=9211 order by sourceid,mplexid,channum;
+-----------+---------+---------+----------+-----------+--------+
| serviceid | channum | mplexid | sourceid | callsign  | chanid |
+-----------+---------+---------+----------+-----------+--------+
|      9211 | 126     |       1 |        2 | Channel 4 | 11211 |
+-----------+---------+---------+----------+-----------+--------+

Use that number, in this case 11211 as the first parameter in cross-eit.
The second parameter is an arbitrary identifier which cross-eit embeds 
in the output.
/cross-eit.py 11211,"hd.channel4.com"

The identifier must now be entered as the xmltvid field for Channel 4 
HD. This can be done with mythweb without resorting to SQL. Click on the 
settings page, select TV then Channel Info and update the xmltvid field 
for Channel 4 HD. Increase the recpriority to 2 while on the same line 
(to compensate for the entries not being marked as HD). Press save at 
the bottom of the page.

Then call
mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 2 
--xmlfile output.xml
with the correct sourcid for freesat on your system as shown in the 
above table.

So once set up a simple script can be run daily.
~/cross-eit.py 11211,"hd.channel4.com"
mythfilldatabase --refresh-all --verbose xmltv --file --sourceid 2 
--xmlfile output.xml

Many thanks to  Rune Evjen for Coss-eit and Mike Bibbings for the 
suggestion.