<div dir="ltr">On Tue, Jun 25, 2013 at 7:49 PM, Monkey Pet <span dir="ltr"><<a href="mailto:monkeypet@gmail.com" target="_blank">monkeypet@gmail.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Thanks for the tip guys. I want to know how I translate the channel number into a frequency. I went to <a href="http://www.silicondust.com/hdhomerun/lineup_web/US:95035#sidebyside" target="_blank">http://www.silicondust.com/hdhomerun/lineup_web/US:95035#sidebyside</a> found my missing channel. My question is how do I convert 79-1 to a frequency?? Thanks.<div>
<br><div><table style="vertical-align:top;border-collapse:collapse;font-size:medium;white-space:nowrap;font-family:arial,helvetica,sans-serif;display:inline-block;table-layout:fixed;empty-cells:show">
<tbody><tr><td style="text-align:center;border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);padding:0px 1em;background-color:rgb(176,192,208)">qam256</td><td style="text-align:center;border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);padding:0px 1em;background-color:rgb(255,255,204)">
<a title="Frequency: 555MHz" style>79-1</a></td><td style="text-align:center;border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);padding:0px 1em;background-color:rgb(255,255,204)">
11.1</td><td style="text-align:center;border-bottom-width:1px;border-bottom-style:dashed;border-bottom-color:rgb(204,204,204);padding:0px 1em;background-color:rgb(255,255,204)"><a title="" style>KNTVDT</a></td>
</tr></tbody></table></div></div><div class="gmail_extra"><br></div><div class="gmail_extra">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.</div>
</div></blockquote><div><br></div><div>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.</div>
<div> <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">
<div class="gmail_extra"><br></div><div class="gmail_extra">I am looking for channel 11.1 (KNTVDT)</div><div class="gmail_extra"><br></div><div class="gmail_extra"><div class="gmail_extra">[fa@mythtv scte65scan-0.3]$ cat /tmp/vct.sql |grep 1015<br>
</div><div class="gmail_extra"><span style="background-color:rgb(255,255,0)">INSERT INTO dtv_multiplex SET sistandard='atsc',mplexid=1015,frequency=129000000,modulation='qam_256',sourceid=1;</span></div><div class="gmail_extra">
INSERT INTO channel SET mplexid=1097,serviceid=2,freqid=15,chanid=1015,sourceid=1,channum='15',callsign='Government Access';</div><div class="gmail_extra">INSERT INTO channel SET mplexid=1015,serviceid=2,freqid=186,chanid=1186,sourceid=1,channum='186',callsign='KNTVW';</div>
<div class="gmail_extra">INSERT INTO channel SET mplexid=1015,serviceid=1,freqid=703,chanid=1703,sourceid=1,channum='703',callsign='DKNTV';</div><div class="gmail_extra">INSERT INTO channel SET mplexid=1015,serviceid=6,freqid=711,chanid=1711,sourceid=1,channum='711',callsign='KKPX HD';</div>
<div><br></div><div>My db looks like this after my change:</div><div><br></div><div>mysql> update dtv_multiplex set frequency=129000000 where mplexid=1015;<br></div><div><br></div><div><div>mysql> select * from dtv_multiplex where mplexid=1015;</div>
<div>+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+</div>
<div>| 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 |</div>
<div>+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+</div>
<div>| 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 | |</div>
<div>+---------+----------+-------------+-----------+-----------+-----------+------------+------+----------+------------+-----------+--------------+-------------------+----------------+---------+---------------+-----------+--------------+---------+---------+------------+----------------+---------------------+-------------------+</div>
<div>1 row in set (0.00 sec)</div><div><br></div><div>mysql> select * from channel where mplexid=1015;;</div><div>+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+</div>
<div>| 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 |</div>
<div>+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+</div>
<div>| 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 |</div>
<div>| 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 |</div>
<div>| 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 |</div>
<div>+--------+---------+--------+----------+----------+--------------------+------+----------+--------------+---------+-------------+----------+------------+--------+-------+----------+---------+---------------+---------------+---------+-----------+----------+-----------------+-----------------+---------------------+-------------------+------------+--------+</div>
<div>3 rows in set (0.00 sec)</div></div><div><br></div><div><br></div><div><br></div><br><div class="gmail_quote"><div><div class="h5">On Tue, Jun 25, 2013 at 6:32 AM, Joseph Fry <span dir="ltr"><<a href="mailto:joe@thefrys.com" target="_blank">joe@thefrys.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><br><div class="gmail_extra">
<div class="gmail_quote">
<div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">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?<div>
<br></div><div>My thoughts:</div><div>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.</div><div><br></div><div>2. Use the sctescan utility and attempt to rescan finding the channel, then manually insert into the db.</div>
<div><br></div><div>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.</div></div></blockquote><div><br></div></div>
</div><div>
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.</div><div><br></div><div>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. </div>
</div></div></div>
<br></div></div><div class="im">_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></div></blockquote></div><br></div></div>
</blockquote></div><br></div></div>