[mythtv-users] How to map digital channels -> No KPIX DT or KQED-HD

[Brad DerManouelian]

Marc MERLIN wrote:
> On Sun, Apr 06, 2008 at 10:37:42AM -0400, Jesse Burt wrote:
>>>> 2.1 = KTVU/CVS
>>>> 4.2 = KRON/NBC
>>>> 5.1 = KPIX/CBS
>>>> 7.1 = KGO/ABC
>>>> 9.1 = KQED
>>>> 10.1 = KTEH
>>>> 11.1 = NBC 11
>>>>
>>>> vs some numbering which I guess is used on comcast cable boxes (3 digit
>>>> channel numbers, no dots)
>> Marc,
>> Brad is right, the XMLTV IDs are the important part. You very likely may 
>> have to edit those channels by hand (not too hard). I find the easiest 
>> way for me is to go to Live TV, watch each channel and edit them from 
>> there. For example, for your first one, KTVU: watch that channel. Hit 
> 
> Thanks for the details.
> Once I did the mapping, an even quicker way is to use mythweb:
> http://mythtv/mythweb/settings/channels
> 
>> 'E'. Go down to the field that says XMLTV ID (it probably just says 
>> 'Loading...' instead of a number...delete the text). Go to your 
>> SchedulesDirect lineup website and try to find that channel in your 
>> listings (like you said the channel numbers are all wacky). Hover over 
> 
> For some, it was unclear whhich one to take between KQEDDT1,2,3,4,5, until
> I figured out that XXXDT was X.1, and XXXDT2 was X.2 and so forth...
> 
> So, that would make 705 KPIXDT (xml ID 19572), my 5.1 channel, or the HD
> version of KPIX 5.
> This worked for 2/3rds of the channles, but not all (after rerunning
> mythfilldatabase of course)
> http://mythtb/mythweb/tv/list?time=1207590300#anchor2
> now shows channel data for 
> 2.1 KTVUHD, 4.2 KRON-HD, 7.1 KGO-DT, and 11.1 KNTV-HD, but no luck for
> 5.1 KPIX DT (19572), 9.1 KQED-HD (53122) (which I both care about), and
> other channels like 36.1 KICU-HD
> 
> Now, for 5.1 KPIX DT, I think I can cheat, give it the same XMLID as 5 KPIX
> and use tuner input preference to have myth record from the HD version
> (although I don't see why schedules direct doesn't have data for KPIX HD)

I happen to be in SF, so I can tell you these xmltvid's:
5.1 19572
9.1 24344
9.2 30507
9.3 35278
9.4 34168
9.5 34116

I get guide data for all of these. Make sure they are in fact selected 
in your schedules direct lineup.

> 
> But 9.1 KQED-HD is not the same as 9 KQED, so how do I get data for that?
> 
> As a bonus question, what is my quickest way to delete channels 84#0 to
> 119#9 without having to click on all of them one per one in
> http://mythtv/mythweb/settings/channels
> (maybe there is a quicker command line way, or some web trick that will let
> me select over a hundred delete buttons in the page above?)

1. BACK UP YOUR DATABASE
2. mysql> DELETE FROM channel WHERE channum BETWEEN 84.0 AND 119.9;

This comes with all the usual warnings of not messing with your database 
manually and not taking advice to do it because you might screw 
something else up, etc, etc.