[mythtvnz] heads up - Listings - C4/Four transition
tortise
tortise at paradise.net.nz
Mon Mar 7 08:40:03 GMT 2011
On 7/03/2011 9:00 p.m., tortise wrote:
> On 11/02/2011 8:06 a.m., Tony Sauri wrote:
>> On Fri, 11 Feb 2011 07:46, Nick Rout wrote:
>>> On Thu, Feb 3, 2011 at 5:34 PM, Steven Ellis<steven at openmedia.co.nz> wrote:
>>>> On 02/03/2011 03:27 PM, Hadley Rich wrote:
>>>>> On Thu, 2011-02-03 at 13:36 +1300, Nick Rout wrote:
>>>>>> As I undertsand things from Sunday C4 becomes Four and a C42 becomes
>>>>>> C4.
>>>>>
>>>>> That's what I've read too.
>>>>>
>>>>>> I use tv_grab_nz-py
>>>>>>
>>>>>> I see no current listings data for c42 (Freeview channel 9) - perhaps
>>>>>> because it is a music station?
>>>>>
>>>>> The official listings to C42 were only ever "C42 Alternative Music
>>>>> Television" so not a lot of point to them
>>>>>
>>>>>> anyway, does anyone know how the data provider at nzepg.org will handle
>>>>>> this?
>>>>>
>>>>> I'm guessing sometime before Sunday the XMLTVIDs will be switched around
>>>>> to four.freeviewnz.tv and c4.freeviewnz.tv so your mythtv database will
>>>>> need to be updated.
>>>
>>> I have the xmltvid for Four(Channel 4) set to four.freeview.nz and
>>> C4(9) to c4.freeviewnz.tv.
>>>
>>> However the C4 listings are identical to the Four listings and stuff
>>> that was supposed to be recorded on Four records on C4, and ends up as
>>> music videos instead of, say, Family Guy.
>>>
>>> Anyone got any ideas what I have done wrong?
>>
>> In the channels table the service id's have also to be swapped. C4 (9) should
>> be serviceid 1303 while Four(4) should be 1301.
>>
>> This field is not availabale in Mythweb so you may have to gert dirty with SQL
>> to fix it.
>>
>
>>
>
> Seems to me (now that I've got around to it) that one only needs to edit
> the names in mythweb settings, ie the above xmltvid's and change C4 to
> Four, and C42 to C4 and it should be good to go.
>
> Check:
>
> mysql> select chanid, channum, freqid, sourceid, name, serviceid,
> mplexid, xmltvid from channel;
> +--------+---------+--------+----------+-------------------+-----------+---------+----------------------------+
> | chanid | channum | freqid | sourceid | name | serviceid |
> mplexid | xmltvid |
> +--------+---------+--------+----------+-------------------+-----------+---------+----------------------------+
> | 1001 | 1 | 48 | 1 | TV ONE | 1200 |
> 1 | tv1.freeviewnz.tv |
> | 1002 | 2 | 48 | 1 | TV2 | 1201 |
> 1 | tv2.freeviewnz.tv |
> | 1006 | 6 | 48 | 1 | TVNZ 6 | 1202 |
> 1 | tvnz6.freeviewnz.tv |
> | 1007 | 7 | 48 | 1 | TVNZ 7 | 1203 |
> 1 | tvnz7.freeviewnz.tv |
> | 1003 | 3 | 50 | 1 | TV3 | 1300 |
> 2 | tv3.freeviewnz.tv |
> | 1004 | 4 | 50 | 1 | Four | 1301 |
> 2 | four.freeviewnz.tv |
> | 1008 | 8 | 50 | 1 | TV3 PLUS1 | 1302 |
> 2 | tv3-plus1.freeviewnz.tv |
> | 1009 | 9 | 50 | 1 | C4 | 1303 |
> 2 | c4.freeviewnz.tv |
> | 1005 | 5 | 59 | 1 | Maori Television | 1400 |
> 3 | maori-tv.freeviewnz.tv |
> | 1022 | 22 | 59 | 1 | Parliament TV | 1401 |
> 3 | parliament.freeviewnz.tv |
> | 1028 | 28 | 59 | 1 | ChineseTV | 1403 |
> 3 | ctv8.freeviewnz.tv |
> | 1010 | 10 | 59 | 1 | PRIME | 1404 |
> 3 | prime.freeviewnz.tv |
> | 1033 | 33 | 59 | 1 | TV33 | 1405 |
> 3 | tv33.freeviewnz.tv |
> | 1030 | 30 | 59 | 1 | tvCentral | 1408 |
> 3 | tvcentral.freeviewnz.tv |
> | 1050 | 50 | 59 | 1 | Radio NZ National | 2000 |
> 3 | rnz-national.freeviewnz.tv |
> | 1051 | 51 | 59 | 1 | Radio NZ Concert | 2001 |
> 3 | rnz-concert.freeviewnz.tv |
> | 1071 | 71 | 59 | 1 | BaseFM | 2002 |
> 3 | base-fm.freeviewnz.tv |
> +--------+---------+--------+----------+-------------------+-----------+---------+----------------------------+
> 17 rows in set (0.00 sec)
>
> Also looks like Stratos is on DVB-T now, 59, 1406, Ch 21. Anyone know
> the SQL to add this?
>
> I also note there is currently an "MHEG IC test chan" (1450, 600) as
> shown in the HDHomerun Config GUI.
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>
Actually there is more:
update channel set icon="/home/mythtv/.mythtv/channels/four.jpg" where
chanid=1004;
update channel set icon="/home/mythtv/.mythtv/channels/c4.jpg" where
chanid=1009;
update channel set default_authority="crid://c4tv.co.nz" where chanid=1009;
mysql> select chanid,channum,callsign,serviceid,icon,default_authority
from channel;
+--------+---------+-------------------+-----------+-----------------------------------------------------+------------------------------+
| chanid | channum | callsign | serviceid | icon
| default_authority |
+--------+---------+-------------------+-----------+-----------------------------------------------------+------------------------------+
| 1001 | 1 | TV ONE | 1200 |
/home/mythtv/.mythtv/channels/one.jpg | crid://tvnz.co.nz
|
| 1002 | 2 | TV2 | 1201 |
/home/mythtv/.mythtv/channels/two.jpg | crid://tvnz.co.nz
|
| 1006 | 6 | TVNZ 6 | 1202 |
/home/mythtv/.mythtv/channels/tvnz6.jpg | crid://tvnz.co.nz
|
| 1007 | 7 | TVNZ 7 | 1203 |
/home/mythtv/.mythtv/channels/tvnz7.jpg | crid://tvnz.co.nz
|
| 1003 | 3 | TV3 | 1300 |
/home/mythtv/.mythtv/channels/tv3.jpg | crid://tv3.co.nz
|
| 1004 | 4 | Four | 1301 |
/home/mythtv/.mythtv/channels/four.jpg | crid://tv4.co.nz
|
| 1008 | 8 | TV3 PLUS1 | 1302 |
/home/mythtv/.mythtv/channels/tv3p1.jpg | crid://tv3.co.nz
|
| 1009 | 9 | C4 | 1303 |
/home/mythtv/.mythtv/channels/c4.jpg | crid://c4tv.co.nz
|
| 1005 | 5 | Maori Television | 1400 |
/home/mythtv/.mythtv/channels/maori.jpg |
crid://maoritelevision.com |
| 1022 | 22 | Parliament TV | 1401 |
/home/mythtv/.mythtv/channels/parliament.jpg |
crid://parliament.nz |
| 1028 | 28 | ChineseTV | 1403 |
/home/mythtv/.mythtv/channels/ctv8.gif |
crid://chinesetv8.co.nz |
| 1010 | 10 | PRIME | 1404 |
/home/mythtv/.mythtv/channels/prime.jpg |
crid://primetv.co.nz |
| 1033 | 33 | TV33 | 1405 |
/home/mythtv/.mythtv/channels/tv33_107x35.jpg | crid://tv33.co.nz
|
| 1030 | 30 | tvCentral | 1408 |
/home/mythtv/.mythtv/channels/tvcentral.jpg |
crid://tvcentral.co.nz |
| 1050 | 50 | Radio NZ National | 2000 |
/home/mythtv/.mythtv/channels/radio_nz_national.jpg |
crid://radionznational.co.nz |
| 1051 | 51 | Radio NZ Concert | 2001 |
/home/mythtv/.mythtv/channels/radio_nz_concert.jpg |
crid://radionzconcert.co.nz |
| 1071 | 71 | BaseFM | 2002 |
/home/mythtv/.mythtv/channels/basefm.jpg |
crid://basefm.co.nz |
+--------+---------+-------------------+-----------+-----------------------------------------------------+------------------------------+
Not sure about this one though for "Four", anyone?
four.co.nz? tv4.co.nz? tv3.co.nz??
update channel set default_authority="crid://?????.co.nz" where chanid=1004;
More information about the mythtvnz
mailing list