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

[Len Reed]

OK, this works fine now.  Thanks for those who helped.  I did the following:

1. Upgraded to latest SVN.  0.18.2. didn't work well with the HD5000 for 
me.  In particular, the channel scanner didn't find anything.
2. Ran the myth channel scanner, which found the channels and named them 
things like "99#1" and "100#2".  That populated the dtv_multiplex table. 
  (Actually, it failed to find one of my channels for who knows what 
reason.  I knew its frequency and serviceid from the dvb utilties, though.)
3. Used mysql to edit the channel entries that I really want to use (the 
ones corresponding to the lineups from zap2it).  I changed the mplexid 
and serviceid in the channel table.
4. Used mysql to delete the now-superflous rows ("99#1", etc.) from the 
channel table.

Now if I could just get 1080i out of my video card I'd be 100% happy. 
I'm watching 1080i video that mythtv converts to 720p and then my TV 
makes 1080p.  Well, it looks way better than NTSC, so I'll continue 
fighting that battle another day....


Len Reed wrote:
> Thanks, Michael.
> 
> I'm not sure what you mean by my having PSIP data, though.  The channel 
> line I quoted was one I cobbled together using the dvb utilities.  I 
> started with a list of the cable frequencies and ran azap.  Taking the 
> frequencies it found, I then ran it and dvbtraffic to snoop things. 
> That gave me the PIDs.  I plugged those back into my channel file and 
> finally was able to run "azap -r" and cat combined video+audio from the 
> device, and play that back with mplayer.  Oh, I changed the first column 
> to "CBS" using "vi". :)
> 
> CBS:669000000:QAM_256:2176:2177:1
> 
> Any way, I never was able to get mythbackend to record DVB using 0.18.2. 
>   Today I ungraded to the latest SVN.  myth-setup's channel scanner then 
> found my channels, calling them things like "99#1".  I still have to use 
> a bit of mysql to clean that up and tie the channels to zap2it 
> schedules, but that I know to be straightforward.
> 
> Cheers,
> Len
> 
> 
> Michael Freeman wrote:
> 
>>for instance, my fox affiliate is on 675 MHz as service 1 according to 
>>PID 0x0000...which is mplexid 274, serviceid 1 for digital channel 168 
>>in my channels db
>>
>>On 1/15/06, * Michael Freeman* <mlfreeman at gmail.com 
>><mailto:mlfreeman at gmail.com>> wrote:
>>
>>    you don't need to enter the PIDs.  you need the service ID from PID
>>    0x0000 for each channel.
>>    if you set the mplexid and the serviceid, myth will find the rest
>>    automatically (as a crapcast subscriber, i'm envious that you have
>>    actual PSIP data for your channels)
>>
>>
>>
>>    On 1/15/06, *Len Reed* < crunchyfrog at charter.net
>>    <mailto:crunchyfrog at charter.net>> wrote:
>>
>>        I'm using 0.18.2....
>>
>>        There have been a number of posting on the DVB channel tables,
>>        but it
>>        still isn't clear to me.  I've also looked at
>>
>>        http://www.cuymedia.com/doxygen-dev-docs/html/group__db__schema.html
>>
>>        Maybe with an example someone can clear it up.
>>
>>        I have an HD5000 card connected to cable.  Here is a sample
>>        channel, as
>>        seen by azap.  Using this information, I can use the DVB utils to
>>        capture the signal and play it via mplayer. The following
>>        example is for
>>        my local (Atlanta) FOX affiliate on Gwinnett Charter cable, for what
>>        it's worth:
>>
>>        FOX:669000000:QAM_256:2048:2049:2
>>
>>        So, my dtv_multiplex table has an entry with
>>        mplexid=4, frequency=669000000, sourceid=qam_256, etc.
>>
>>        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.
>>
>>        I further guess that the channel table should get the serviceid
>>        (last
>>        column of the azap line, "2"):
>>
>>        update channel set serviceid = 2 where chanid = 3785;
>>
>>        Where do I encode the video and audio pids (2048 and 2049 in
>>        hex, 8264
>>        and 8265 in decimal)?
>>
>>        Now, assuming that I can get this all working, do I then need an
>>        additional rows in dtv_multiplex for the other channel on 669 MHz?
>>
>>        CBS:669000000:QAM_256:2176:2177:1
>>
>>        Thanks for the help,
>>        Len