[mythtv-users] Easiest way to find NBC on Comcast QAM

Monkey Pet monkeypet at gmail.com
Wed Jun 26 02:49:38 UTC 2013


Thanks for the tip guys. I want to know how I translate the channel number
into a frequency.  I went to
http://www.silicondust.com/hdhomerun/lineup_web/US:95035#sidebyside found
my missing channel.  My question is how do I convert 79-1 to a frequency??
 Thanks.

qam25679-111.1KNTVDT

I tried scte65scan, I changed dtv_multiplex and channel to match what I see
after the scte65scan, but it seems to be wrong and when I tune into 703 or
711 it I get a different channel.

I am looking for channel 11.1 (KNTVDT)

[fa at mythtv scte65scan-0.3]$ cat /tmp/vct.sql |grep 1015
INSERT INTO dtv_multiplex SET
sistandard='atsc',mplexid=1015,frequency=129000000,modulation='qam_256',sourceid=1;
INSERT INTO channel SET
mplexid=1097,serviceid=2,freqid=15,chanid=1015,sourceid=1,channum='15',callsign='Government
Access';
INSERT INTO channel SET
mplexid=1015,serviceid=2,freqid=186,chanid=1186,sourceid=1,channum='186',callsign='KNTVW';
INSERT INTO channel SET
mplexid=1015,serviceid=1,freqid=703,chanid=1703,sourceid=1,channum='703',callsign='DKNTV';
INSERT INTO channel SET
mplexid=1015,serviceid=6,freqid=711,chanid=1711,sourceid=1,channum='711',callsign='KKPX
HD';

My db looks like this after my change:

mysql> update dtv_multiplex set frequency=129000000 where mplexid=1015;

mysql> select * from dtv_multiplex where mplexid=1015;
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+
| mplexid | sourceid | transportid | networkid | frequency | inversion |
symbolrate | fec  | polarity | modulation | bandwidth | lp_code_rate |
transmission_mode | guard_interval | visible | constellation | hierarchy |
hp_code_rate | mod_sys | rolloff | sistandard | serviceversion |
updatetimestamp     | default_authority |
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+
|    1015 |        1 |        NULL |      NULL | 129000000 | a         |
    NULL | auto | NULL     | qam_256    | a         | auto         | a
            | auto           |       0 | auto          | auto      | auto
      | NULL    | NULL    | atsc       |             33 | 2013-04-29
22:51:48 |                   |
+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+
1 row in set (0.00 sec)

mysql> select * from channel where mplexid=1015;;
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
| chanid | channum | freqid | sourceid | callsign | name               |
icon | finetune | videofilters | xmltvid | recpriority | contrast |
brightness | colour | hue   | tvformat | visible | outputfilters |
useonairguide | mplexid | serviceid | tmoffset | atsc_major_chan |
atsc_minor_chan | last_record         | default_authority | commmethod |
iptvid |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
|   1186 | 186     | 186    |        1 | KNTVW    | KNTVDT2 (KNTV-DT2) |
none |        0 |              | 36151   |           0 |    32768 |
 32768 |  32768 | 32768 | Default  |       0 |               |
0 |    1015 |         2 |        0 |               0 |               0 |
0000-00-00 00:00:00 |                   |         -1 |   NULL |
|   1703 | 703     | 703    |        1 | DKNTV    | KNTVDT(KNTV-DT)    |
none |        0 |              | 21785   |           0 |    32768 |
 32768 |  32768 | 32768 | Default  |       0 |               |
0 |    1015 |         1 |        0 |               0 |               0 |
0000-00-00 00:00:00 |                   |         -1 |   NULL |
|   1711 | 711     | 711    |        1 | KKPX HD  | KKPXDT (KKPX-DT)   |
none |        0 |              | 35375   |           0 |    32768 |
 32768 |  32768 | 32768 | Default  |       0 |               |
0 |    1015 |         6 |        0 |               0 |               0 |
0000-00-00 00:00:00 |                   |         -1 |   NULL |
+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+
3 rows in set (0.00 sec)




On Tue, Jun 25, 2013 at 6:32 AM, Joseph Fry <joe at thefrys.com> wrote:

>
> Hi all, I am hooked up to Comcast Cable using a HD Homerun Tuner and
>> scanning using QAM.  I have the channel lineup that I want.  The only thing
>> is that I want to find one specific channel.  The channel is NBC (11.1).
>>  Unfortunately, the first time I scanned NBC wasn't available.  Now a few
>> months later, Comcast changed the lineup, so that NBC is now available.  My
>> other TVs are now getting NBC.  I only want to find this new channel
>> without resetting my channel lineup.  How do that the easiest/fastest way?
>>
>> My thoughts:
>> 1. Nuke the channel lineup, rescan and repopulate the channel lineup
>> along with redoing the xml matching etc.  This is the most work and would
>> truly suck.
>>
>> 2. Use the sctescan utility and attempt to rescan finding the channel,
>> then manually insert into the db.
>>
>> 3. Undo my invisible channels and manually walk through all the channels
>> and find the missing station.  This would suck since there are many many
>> channels.
>>
>
> Umm... last time I checked, you could scan for channels and tell it to
> only add new channels without overwriting what's in the table already.
>
> Try doing a scan from Mythtv-Setup... it won't make any changes until
> after it has fully scanned, and it will show you what it wants to do before
> you accept the changes.... I think you might be pleasantly surprised.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130625/db1f6590/attachment.html>


More information about the mythtv-users mailing list