[mythtv-users] Possible to manually add QAM channel information?

[Byron Poland]

On 7/27/05, Brian Merrill <bmerrill at sfcn.org> wrote:
> Todd Ignasiak wrote:
> 
> >I posted a bit of information on this in the pchdtv.com forum:
> >http://www.pchdtv.com/forum/viewtopic.php?t=882
> >
> >Basically, there are two tables you need to be concerned with,
> >"channel" and "dtv_multiplex".  Channel has the basic channel mapping
> >info, with xmltvid, and refers to an entry in dtv_multiplex.  The
> >dtv_multiplex entry has the actual channel frequency.
> >
> >
> >I modified the channel configuration in mythweb to allow editing of
> >the relevant channel fields.  I will try to create a patch for that
> >tonight, so you can use that if you want.    That would still not
> >address the entry in the dtv_multiplex table, which is normally
> >created when doing the channel scan.
> >
> >
> >On 7/26/05, bmerrill Merrill <bmerrill at sfcn.org> wrote:
> >
> >
> >>I would like to get QAM working with MythTV.  I am able to watch QAM HDTV from my cable provider using a combination of dvb-apps, dvbtraffic and mplayer but scanning for the channels using the latest MythTV cvs doesn't seem to work, i.e. it doesn't detect the channels on the first pass and gets "stuck" on subsequent scanning of existing transports.  My understanding from the few scant threads I've been able to find on the subject seem to indicate that my cable provider is not transmitting certain information that Myth requires.  I have tried calling them and speaking to the engineers but have not been able to make much headway through the red tape, though my limited knowledge on what exactly is missing probably doesn't help either.
> >>
> >>However, I was wondering, if I have collected all the relevant info from dvb-app such as Video PID, Audio PID, etc, would it be fairly straight forward to manually add that information directly into MySQL?  I am certainly no expert with MySQL but I think I could figure  out the relevant commands if someone could point me in the direction of the relevant table(s) that I would need to modify.  But of course if someone knows the actual command that would be very much appreciated as well.  Or is there perhaps an even easier way than modifying MySQL directly?  Or should I not waste my time trying, i.e. a fix is imminent?
> >>
> >>Thank you for any help.
> >>
> >>
> >>
> >>_______________________________________________
> >>mythtv-users mailing list
> >>mythtv-users at mythtv.org
> >>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >>
> >>
> >>
> >>
> >>
> >_______________________________________________
> >mythtv-users mailing list
> >mythtv-users at mythtv.org
> >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> >
> >
> >
> Hey Todd,
> Thanks for the information and your help.  It's been very useful so far
> in helping me to understand what's going on.  If you do get a chance to
> generate a patch for being able to modify that information from mythweb
> that would help me tremendously to not have to constantly dive into
> mysql to fiddle with settings especially since I would have no idea what
> to modify in mythweb or php to achieve the same result.
> 
> Thanks again,
> Brian
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 


When I had to set up my mysql db to merge my OTA HD channel scan with
the channels from zap2it, I used a program called mysqlcc which made
editing the tables, and looking through stuff a breeze.  A while ago I
messed with the QAM stuff, but I think comcast was messing with stuff
at the same time, so I never got anywhere.  best of luck.