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

Monkey Pet monkeypet at gmail.com
Wed Jun 26 03:07:48 UTC 2013


On Tue, Jun 25, 2013 at 7:49 PM, Monkey Pet <monkeypet at gmail.com> wrote:

> 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.
>
> qam256 79-1 11.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 was wrong when I stated that scte65scan gave me the wrong channels.
Actually scte65scan did give the right info, the mysql update cmd (update
dtv_multiplex set frequency=129000000 where mplexid=1015) worked.
 scte65scan gave me the right channel 703 which is KNTVDT.  I am happy that
I didn't mess anything else up.


>
> 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/9c102d2e/attachment.html>


More information about the mythtv-users mailing list