[mythtv-users] Entering USA Cable channels into the DVB tables

[Len Reed]

Brad Fuller wrote:
> On 01/16/2006 01:55 PM R. G. Newbury wrote:
>>  >In the database, Fox digital is my chanid 3785. So I assume I should
>>  >>
>>  >>update channel set freqid = 4 where chanid = 3785;
>>  >>
>>  >>where '4' is the mplexid from the dtv_multiplex table for 669Mhz.
>>  >>
>>  >>
>>  >>
>>
>>  In my setup, the freqid is the same as the channum, that is, the number
>>  in the EPG which you 'call' for the channel you want.
> 
> How do you do that when you can have the same freqid for a channel with 
> several subchannels.
> For instance, in my area channel 11 is freqid 207000000 and it has to 
> subchannels.
> atscsrcid 1 and 2 (for 11-1 and 11-2)
> 
> Plus, the freqid is really big. Do you just truncate it to 207?

Don't confuse freqid with frequency.

Mine's all working now (see other detailed posting).

The channel table has freqid set to the cable channel my provider and 
zap2it schedules use.  For example, Fox digital (WAGADT) is chanid 3785, 
channum 785, and freqid 785.  I don't think the freqid maters, though, 
for digital channels.  (For analog channels, freqid are standard 
broadcast or cable channel numbers.) For WAGADT, mplexid is 4 and the 
serviceid is 2.  The atscsrcid is 0 on all my digital channels.

Over in the dtv_multiplex table, the first column is the mplexid.  The 
one with '4' as mplexid has the right frequency (669000000).

So, when I want to tune WAGADT, which my provider calls channel 785, 
mythbackend pick adapter 3 and channel 785 to get chanid 3785.  It looks 
that up in the channel table to get the mplexid (4) and serviceid (2). 
It goes to the drv_multiplex table and looks up 4 to get the frequency 
(669000000 Hz).  Finally, it tunes the card giving it the frequency and 
the serviceid.

None of this worked until I upgraded to the latest SVN and scanned the 
channels.  I'm guess that the dtv_multiplex table's transportid and 
networkid needed that step to get set properly; it's not clear to me
what those fields do.  If that's right, then those fields are involved 
in tuning or filtering somehow.