[mythtvnz] heads up - Listings - C4/Four transition

[tortise]

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.